glass_blossomsamount of transactions
Updated 2022-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc('day', block_timestamp) as day,
posttokenbalances[0]:owner as wallet,
(inner_instruction:instructions[2]:parsed:info:amount)/pow(10,9) as amount
from solana.events
WHERE block_timestamp::date >= '2022-02-01'
--AND tx_id = '5ptLnEaEAjC45QRKGS8RLDFp3UwdzarWSuN65yT2inV1WuFha7HE8bvREHzs1KTSyrSLRHhJG7darVj6dav4Lrow'
and inner_instruction:instructions[2]:parsed:info:mint = 'monKYjV2bHTjbJVWCCcwhxE8C96sdTKR2HUNUHCjh4z'
and inner_instruction:instructions[2]:parsed:info:mintAuthority = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr'
and inner_instruction:index = 4
and succeeded = TRUE
Run a query to Download Data