0xaimanUntitled Query
Updated 2022-05-11
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('hour',t) as hour, count(distinct s) as n_address
from
(select block_timestamp as t , msg_value:sender as s from terra.msgs
where --tx_id='2C93DDEF9264F63CE0CC0F7C4BFACFA4AF301EE92B3E78E6D156D067287AF425' and
msg_value:contract='terra1hzh9vpxhsk8253se0vv5jj6etdvxu3nv8z07zu' and msg_value:execute_msg:send:contract='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'
)
where t>='2022-05-01'
group by 1 order by 1
limit 100
Run a query to Download Data