AntonidasLast 7 Days Active Recievers
Updated 2023-11-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
-- forked from Last 7 Days Active Wallets @ https://flipsidecrypto.xyz/edit/queries/8f72f67c-30a2-42bc-aa47-7798b043db00
-- forked from Last 7 Days of Transactions @ https://flipsidecrypto.xyz/edit/queries/8da0c01f-a79e-49a7-8ce9-490d27debdf5
select distinct attribute_value from terra.core.fact_msg_attributes_standard
where block_timestamp > CURRENT_DATE - 7
and LEFT(attribute_value, 6) = 'terra1'
and attribute_key not in ('acc_seq','create_pair','pair')
/*
select * from terra.core.fact_msg_attributes_standard
where block_timestamp > CURRENT_DATE - 7
and LEFT(attribute_value, 6) = 'terra1'
and attribute_key not in ('acc_seq','create_pair','pair')
and attribute_value = 'terra1s4gl6854gjfy90h7hy90wk8zzh7f9ryuw4lmeep6g8jasyrhpt4stve6nv-terra1pez3qw6pa24a06wee404yy5mp37j57n3s9zjkdfjeapwqf78dntql0ngsy'
*/
Run a query to Download Data