adriaparcerisassquid sources to cosmos
Updated 2023-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
trunc(block_timestamp,'day') as date,
source_chain,
count(distinct tx_hash) as actions,
count(distinct sender) as active_users--,
--sum(amount) as volume
from axelar.core.ez_squid x
where destination_chain not in ('filecoin','kava','polygon','avalanche','moonbeam','binance','arbitrum','fantom','celo','ethereum')
--join osmosis.core.ez_prices y on x.token_symbol=y.symbol and trunc(x.block_timestamp,'hour')=y.recorded_hour
group by 1,2
order by 1 asc
Run a query to Download Data