strawbettyGST transferred per day
    Updated 2022-03-10
    with base as (select tx_id
    from solana.transactions
    where (pre_mint ilike 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
    or post_mint ilike 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')
    and succeeded = 'TRUE'
    and block_timestamp >= '2022-01-01'
    and block_timestamp <= '2022-02-28')
    --group by 1)
    select date_trunc('day', block_timestamp) as day,
    sum(a.instruction:parsed:info:amount/1e9) as GST_transferred
    from solana.transfers a
    join base b
    on a.tx_id = b.tx_id
    where succeeded = 'TRUE'
    and block_timestamp >= '2022-01-01'
    and block_timestamp <= '2022-02-28'
    and instruction:parsed:info:amount is not null
    group by 1
    limit 100
    Run a query to Download Data