boomer77mirror lp??
Updated 2021-11-25
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('day', block_timestamp) as dt,
sum(event_attributes:"2_amount"[0]:amount/1e6) as volume,
event_attributes:"2_amount"[0]:denom::string as denom,
event_attributes:"2_recipient"::string as LP
from terra.msg_events
where tx_status = 'SUCCEEDED' and event_type = 'transfer' and block_timestamp >= CURRENT_DATE - 10 and lp is not null
group by 1,3,4
--event_attributes:"0_recipient"::string as staking_platform
Run a query to Download Data