nitsUSDC pools before hack
    Updated 2022-02-17

    SELECT date(block_timestamp) as day, sum(amt)/pow(10,9) as amt_in_K, avg(amt)/pow(10,9) as avg_amt_in_K, COUNT(*) as total_txs
    from
    (SELECT *,(posttokenbalances[0]:uiTokenAmount:amount - pretokenbalances[0]:uiTokenAmount:amount) as amt
    from solana.events
    where tx_id in (
    SELECT tx_id from solana.transactions
    where block_timestamp <
    (SELECT block_timestamp as accident_time from solana.TRANSACTIONs
    where tx_id ilike '2zCz2GgSoSS68eNJENWrYB48dMM1zmH8SZkgYneVDv2G4gRsVfwu5rNXtK5BKFxn7fSqX9BvrBc1rdPAeBEcD6Es') and program_id = 'wormDTUJ6AWPNvk59vGQbDvGJmqbDTdgWgAqcLBCgUb' and block_timestamp > '2022-02-01'
    )
    and pretokenbalances[0]:mint = 'FCqfQSujuPxy6V42UvafBhsysWtEq1vhjfMN1PUbgaxA')
    GROUP by 1



    Run a query to Download Data