greyswanSHITCOIN BUYERS
    Updated 2024-04-02
    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