maybeyonasterra_passive_daily
Updated 2022-05-08
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
›
⌄
with
anchor_reg as (
select
block_timestamp,
tx_id,
value::string as passive_user,
'onchain storage' as type,
'registration' as subtype
from terra.msgs m,
lateral flatten(input => m.msg_value:execute_msg:register_anchor_users)
where msg_value:execute_msg:register_anchor_users is not null
),
recievers as (
select
block_timestamp,
tx_id,
msg_value:to_address::string as passive_user,
'native token recievers' as type,
'recieve native' as subtype
from terra.msgs
-- where tx_id = '544F32B3F78998508BC075B7D8F81F64712845DB4F903D601BAE614E7A66B14F'
where msg_type = 'bank/MsgSend'
),
multi_recievers as (
select
block_timestamp,
tx_id,
value:address::string as passive_user,
'native token recievers' as type,
'multisend' as subtype
from terra.msgs m,
lateral flatten(input => m.msg_value:outputs)
where msg_type = 'bank/MsgMultiSend'
),
whitelist as (
select
Run a query to Download Data