binhachonUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
›
-- Anchor_deposit_earn as (
-- select
-- block_timestamp,
-- msg_value:sender::string as address,
-- msg_value:coins[0]:amount / pow(10,6) as deposit_amount,
-- row_number() over (partition by address order by block_timestamp) as rownumber
-- from
-- terra.msgs
-- where msg_value:execute_msg:deposit_stable is not null
-- and tx_status = 'SUCCEEDED'
-- ),
Run a query to Download Data