LTirrellBONK Buyers vs Sellers copy
    Updated 2024-04-03
    --DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263


    select
    date(block_timestamp) as date,
    count(distinct swapper) as unique_wallets,
    count(distinct tx_id) as txs,
    sum(swap_to_amount) as bonk_amount,
    'Buy' as type
    from solana.defi.fact_swaps
    where
    date between '2022-12-23' and current_date()-1
    and
    swap_to_mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    group by 1

    union


    select
    date(block_timestamp) as date,
    count(distinct swapper) as unique_wallets,
    count(distinct tx_id) as txs,
    sum(swap_from_amount) as bonk_amount,
    'Sell' as type
    from solana.defi.fact_swaps
    where
    date between '2022-12-23' and current_date()-1
    and
    swap_from_mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    group by 1

    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived