Pmisha-bmlMdxfrac.4
Updated 2022-03-16
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT block_timestamp,
(inner_instruction:instructions[0]:parsed:info:amount/1e2) as amount_with
from solana.events
WHERE block_timestamp >='2022-01-01'
and inner_instruction:instructions[0]:parsed:info:source ='CaFv3tcD26c3jre9kVJaWfHm3ccLcWVbQGPU2ostLLjL'
and (PRETOKENBALANCES[0]:mint='CzXF8oUJSsB9ADKV99WAi2TgytqAyKvQw6EihwiL9em4' or posttokenbalances[0]:mint='CzXF8oUJSsB9ADKV99WAi2TgytqAyKvQw6EihwiL9em4')
and succeeded = 'TRUE'
group by 1,2 order by 2 desc limit 5
Run a query to Download Data