barbodAccording to the question form StepN Growth - the amount of GST has been transacted per day since January 1st
    Updated 2022-03-01
    with tx_ids as ( select tx_id
    from solana.transactions
    where block_timestamp::date >= '2022-01-01'
    and succeeded =true
    and (pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' or post_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' )
    and transfer_tx_flag=true
    group by 1
    )
    select block_timestamp::date as date, sum(ZEROIFNULL(instruction:parsed:info:amount/1e9)) as GST_amount
    from solana.events join tx_ids
    on tx_ids.tx_id =solana.events.tx_id
    where block_timestamp::date >= '2022-01-01'
    group by 1
    Run a query to Download Data