--credit : https://app.flipsidecrypto.com/velocity/queries/f93304b5-9d3d-4f7e-afff-37a1d72779be with pricet as ( select timestamp::date as day, token_contract as Token1, avg (price_usd) as USDPrice from flow.core.fact_prices where timestamp::date >= '2022-12-17' group by 1,2 union ALL select block_timestamp::date as day, swap_from_mint as token1, median (swap_to_amount/swap_from_amount) as USD_Price from solana.fact_swaps where swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') --USDC,USDT and swap_to_amount > 0 and swap_from_amount > 0 and succeeded = 'TRUE' and block_timestamp::date >= '2022-12-17' group by 1,2 union ALL select timestamp::date as day, token_contract as Token1, avg (price_usd) as USDPrice from near.core.fact_prices where timestamp::date >= '2022-12-17' and symbol = 'wNEAR' group by 1,2), maintable as ( select 'Ethereum' as chain, block_timestamp::date as date, case when date >= '2022-12-24' and date < '2023-01-04' then 'Holidays' else 'Other Days' end as timespan, count (distinct tx_hash) as TX_Count, count (distinct eth_from_address) as Users_Count, sum (amount_usd) as Volume from ethereum.core.ez_eth_transfers where block_timestamp::date >= '2022-12-17' and amount_usd > 0 and amount_usd < 1e9 group by 1,2,3 union ALL select 'Avalanche' as chain, block_timestamp::date as date, case when date >= '2022-12-24' and date < '2023-01-04' then 'Holidays' else 'Other Days' end as timespan, count (distinct tx_hash) as TX_Count, count (distinct eth_from_address) as Users_Count, sum (amount_usd) as Volume from avalanche.core.ez_avax_transfers where block_timestamp::date >= '2022-12-17' and amount_usd > 0 and amount_usd < 1e9 group by 1,2,3 union ALL select 'Arbitrum' as chain, block_timestamp::date as date, case when date >= '2022-12-24' and date < '2023-01-04' then 'Holidays' else 'Other Days' end as timespan, count (distinct tx_hash) as TX_Count, count (distinct eth_from_address) as Users_Count, sum (amount_usd) as Volume from arbitrum.core.ez_eth_transfers where block_timestamp::date >= '2022-12-17' and amount_usd > 0 and amount_usd < 1e9 group by 1,2,3 union ALL select 'Binance Smart Chain' as chain, block_timestamp::date as date, case when date >= '2022-12-24' and date < '2023-01-04' then 'Holidays' else 'Other Days' end as timespan, count (distinct tx_hash) as TX_Count, count (distinct bnb_from_address) as Users_Count, sum (amount_usd) as Volume from bsc.core.ez_bnb_transfers where block_timestamp::date >= '2022-12-17' and amount_usd > 0 and amount_usd < 1e9 group by 1,2,3 union ALL select 'Optimism' as chain, block_timestamp::date as date, case when date >= '2022-12-24' and date < '2023-01-04' then 'Holidays' else 'Other Days' end as timespan, count (distinct tx_hash) as TX_Count, count (distinct eth_from_address) as Users_Count, sum (amount_usd) as Volume from optimism.core.ez_eth_transfers where block_timestamp::date >= '2022-12-17' and amount_usd > 0 and amount_usd < 1e9 group by 1,2,3 union ALL select 'Polygon' as chain, block_timestamp::date as date, case when date >= '2022-12-24' and date < '2023-01-04' then 'Holidays' else 'Other Days' end as timespan, count (distinct tx_hash) as TX_Count, count (distinct matic_from_address) as Users_Count, sum (amount_usd) as Volume from polygon.core.ez_matic_transfers where block_timestamp::date >= '2022-12-17' and amount_usd > 0 and amount_usd < 1e9 group by 1,2,3) select chain, timespan, avg (Tx_count) as Average_TX_Count, avg (volume) as Average_Volume from maintable group by 1,2

Query	Creator	Created
Untitled Query flow near bsc arbitrum prices	davidwall	Jan 14, 2023
Untitled Query near	davidwall	Jan 14, 2023
Untitled Query flow near bsc arbitrum prices	davidwall	Jan 14, 2023

davidwall