boomer77mine vs luna
Updated 2021-10-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with mine as (select date_trunc('day', block_timestamp) as dt, sum(msg_value:execute_msg:send:amount/1e6) as stake_mine
from terra.msgs
where msg_value:execute_msg:send:contract::string = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' and msg_value:contract::string = 'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' and tx_status = 'SUCCEEDED'
group by 1),
luna as (select date_trunc('day', block_timestamp) as dt, sum(event_amount) as stake_Luna
from terra.staking
where action = 'delegate' and tx_status = 'SUCCEEDED'
group by 1)
select a.dt, a.stake_mine, b.stake_luna
from mine a
join luna b on a.dt = b.dt
Run a query to Download Data