anduriltimediff stuff
Updated 2022-06-07
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
select datediff(hour, '2022-05-17 14:56:50.000','2022-04-20 18:48:38.000')
--SA Claims
with sa_claims as (
select
date(block_timestamp) as date,
block_timestamp,
--instruction:programId as program,
--inner_instruction:instructions[0]:parsed:info:source as program,
tx_id,
inner_instruction:instructions[0]:parsed:info:authority as sender,
instruction:accounts[0] as reciever,
inner_instruction:instructions[0]:parsed:info:amount/POW(10,8) as amount
--pretokenbalances,posttokenba4-lances
from solana.fact_events
where
date(block_timestamp) > '2022-04-01' and
sender = '2ahn5m4zeujE56qKMuEeyX2jktEuJPH5UzoznHKmUMka'
--tx_id = '2YLzYHCEhCjTcTKfoQd1xJpGPh8PTWx6RAeTb51ZCSmH29RvD7RGYCoApKrRBEgqoAHthp8ewjCZ6WywfiXkGMUC' --test transaction
and reciever = '4SADJSjMCc6QhbV6otRrbgDakU7zFnRByfMmUa5kiGQM'
order by date asc
) ,
--all txs
other_txs as (
select signers[0] as wallet,tx_id as next_tx,block_timestamp
from solana.fact_transactions
where
date(block_timestamp) > '2022-04-01' and
signers[0] = '4SADJSjMCc6QhbV6otRrbgDakU7zFnRByfMmUa5kiGQM'
Run a query to Download Data