SocioCryptoSource over time
Updated 2024-10-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- forked from Source-Destination @ https://flipsidecrypto.xyz/edit/queries/1d4a3c9e-0aaf-4e32-a954-ec4d31911da1
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