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