nitsUSDC pools before hack
Updated 2022-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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