SocioCryptoDestination over time
Updated 2024-10-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- forked from Source over time @ https://flipsidecrypto.xyz/edit/queries/25b813a0-3e84-4edd-8dba-da75798086e8
SELECT date_trunc('week',block_timestamp) as date,
--source_chain as source,
destination_chain as destination,
sum(case when a.token_symbol = 'axlUSDC' then amount else zeroifnull(price*amount) end) as size,
count(distinct tx_hash) as n_txns,
count(DISTINCT sender) as n_users
FROM axelar.defi.ez_bridge_squid a
LEFT JOIN crosschain.price.ez_prices_hourly b
on SOURCE_CHAIN = blockchain AND a.TOKEN_ADDRESS = b.TOKEN_ADDRESS AND date_trunc('hour',block_timestamp) = b.hour
WHERE block_timestamp::timestamp >= current_date -90
--AND destination_chain in ('ethereum', 'avalanche', 'binance', 'arbitrum', 'polygon', 'base','optimism','blast','sei')--, 'celo', 'fantom', 'moonbeam')
group by 1,2
QueryRunArchived: QueryRun has been archived