flipside

    Amount (and number) of GST transactions
    SocioCryptoAmount (and number) of GST transactions
    Updated 2022-02-28
    SELECT date_trunc('day', a.block_timestamp) as date,
    sum(b.amount)/1000 as amount,
    count(distinct a.tx_id)*500 as countX500
    FROM solana.transactions a
    JOIN solana.transfers b
    on a.tx_id = b.tx_id
    WHERE (a.pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' or a.post_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')
    AND a.succeeded = 'TRUE'
    AND date_trunc('day', a.block_timestamp) between '2022-01-01' and CURRENT_DATE-1
    GROUP BY date

    Run a query to Download Data