AndyCoolApollo
Updated 2021-12-07
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('day', block_timestamp) as date,
sum(msg_value:coins[0]:amount/POW(10,6)) as volume_uusd
From terra.msgs
where msg_value:contract = 'terra1leadedadm2fguezmd4e445h6fe337yzq8n2dxf'
and tx_status = 'SUCCEEDED'
and msg_value:execute_msg:zap_into_strategy is not null
and block_timestamp > CURRENT_DATE - 30
group by 1
order by 1 asc
Run a query to Download Data