Pmisha-bmlMdxKatana.ETH
Updated 2022-03-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with t1 as(select
date_trunc('day',block_timestamp) as dt1,
sum(INNER_INSTRUCTION:instructions[0]:parsed:info:amount/1e9) as ETHDep
from solana.fact_events
where block_timestamp>='2022-02-01'
and PROGRAM_ID='1349iiGjWC7ZTbu6otFmJwztms122jEEnShKgpVnNewy'
and INNER_INSTRUCTION:instructions[0]:parsed:info:destination='2qFUu5YDGuzhdTS87rWpwUbqytMsEb2RTyFzpiV3duDV'
group by 1 order by 1),
t2 as (select
date_trunc('day',block_timestamp) as dt2,
sum(INNER_INSTRUCTION:instructions[0]:parsed:info:amount/1e9) as ETHWith
from solana.fact_events
where block_timestamp>='2022-02-01'
--and index=2
and PROGRAM_ID='1349iiGjWC7ZTbu6otFmJwztms122jEEnShKgpVnNewy'
and INNER_INSTRUCTION:instructions[0]:parsed:info:source='2qFUu5YDGuzhdTS87rWpwUbqytMsEb2RTyFzpiV3duDV' --withdraw
group by 1 order by 1)
select
t1.dt1 as dt,
ETHDep,
ETHWith
from t1
full outer join t2 on t1.dt1=t2.dt2
Run a query to Download Data