greyswanSHITCOIN BUYERS
Updated 2024-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
date_trunc('day', block_timestamp) as day,
swap_to_mint as token,
count(distinct swapper) as buyers
from
solana.defi.fact_swaps
where
swap_to_mint in (
'inLbkByUvP9WGsLfMy1w9QX5pvaab5mkvLcz48DbkmF',
'bobaM3u8QmqZhY1HwAtnvze9DLXvkgKYk3td3t8MLva',
'MEW1gQWJ3nEXg2qgERiKu7FAFj79PHvQVREQUzScPP5',
'7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr'
) and BLOCK_TIMESTAMP >= current_date - 50
group by date_trunc('day', block_timestamp), swap_to_mint
order by date_trunc('day', block_timestamp) desc
QueryRunArchived: QueryRun has been archived