LTirrell2AQdpH Daily Share of Sol Transfers copy copy
    Updated 2022-12-30
    SELECT block_timestamp::date AS date
    , CASE WHEN tx_from = '2AQdpHJ2JpcEgPiATUXjQxA8QmafFegfQwSLWSprPicm' THEN 'from_2AQdpH'
    WHEN tx_to = '2AQdpHJ2JpcEgPiATUXjQxA8QmafFegfQwSLWSprPicm' THEN 'to_2AQdpH'
    ELSE 'Other Tx' END AS tx_type
    , ROUND(SUM(amount)) AS amt
    , COUNT(1) AS n_tx
    FROM solana.core.fact_transfers t
    WHERE block_timestamp >= '2022-09-01'
    AND mint = 'So11111111111111111111111111111111111111112'
    GROUP BY 1, 2
    ORDER BY 1, 2, 3
    Run a query to Download Data