select 'Ethereum' as chain, CASE WHEN RAW_AMOUNT/1e6 < 5 then 'a. Below 5' WHEN RAW_AMOUNT/1e6 < 100 then 'b. 5 - 100' WHEN RAW_AMOUNT/1e6 < 500 then 'c. 100 - 500' WHEN RAW_AMOUNT/1e6 < 2000 then 'd. 500 - 2,000' WHEN RAW_AMOUNT/1e6 < 10000 then 'e. 2,000 - 10,000' WHEN RAW_AMOUNT/1e6 >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_hash) as no_transfers, count(distinct FROM_ADDRESS) as no_senders, count(distinct TO_ADDRESS) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from ethereum.core.ez_token_transfers where SYMBOL='USDC' and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} and RAW_AMOUNT>0 group by 1,2 union all select 'Optimism' as chain, CASE WHEN RAW_AMOUNT/1e6 < 5 then 'a. Below 5' WHEN RAW_AMOUNT/1e6 < 100 then 'b. 5 - 100' WHEN RAW_AMOUNT/1e6 < 500 then 'c. 100 - 500' WHEN RAW_AMOUNT/1e6 < 2000 then 'd. 500 - 2,000' WHEN RAW_AMOUNT/1e6 < 10000 then 'e. 2,000 - 10,000' WHEN RAW_AMOUNT/1e6 >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_hash) as no_transfers, count(distinct FROM_ADDRESS) as no_senders, count(distinct TO_ADDRESS) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from optimism.core.fact_token_transfers where CONTRACT_ADDRESS=lower('0x7F5c764cBc14f9669B88837ca1490cCa17c31607') and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} and RAW_AMOUNT>0 group by 1,2 union all select 'Arbitrum' as chain, CASE WHEN RAW_AMOUNT/1e6 < 5 then 'a. Below 5' WHEN RAW_AMOUNT/1e6 < 100 then 'b. 5 - 100' WHEN RAW_AMOUNT/1e6 < 500 then 'c. 100 - 500' WHEN RAW_AMOUNT/1e6 < 2000 then 'd. 500 - 2,000' WHEN RAW_AMOUNT/1e6 < 10000 then 'e. 2,000 - 10,000' WHEN RAW_AMOUNT/1e6 >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_hash) as no_transfers, count(distinct FROM_ADDRESS) as no_senders, count(distinct TO_ADDRESS) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from arbitrum.core.fact_token_transfers where CONTRACT_ADDRESS=lower('0xff970a61a04b1ca14834a43f5de4533ebddb5cc8') and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} and RAW_AMOUNT>0 group by 1,2 union all select 'Polygon' as chain, CASE WHEN RAW_AMOUNT/1e6 < 5 then 'a. Below 5' WHEN RAW_AMOUNT/1e6 < 100 then 'b. 5 - 100' WHEN RAW_AMOUNT/1e6 < 500 then 'c. 100 - 500' WHEN RAW_AMOUNT/1e6 < 2000 then 'd. 500 - 2,000' WHEN RAW_AMOUNT/1e6 < 10000 then 'e. 2,000 - 10,000' WHEN RAW_AMOUNT/1e6 >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_hash) as no_transfers, count(distinct FROM_ADDRESS) as no_senders, count(distinct TO_ADDRESS) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from polygon.core.fact_token_transfers where CONTRACT_ADDRESS=lower('0x2791Bca1f2de4661ED88A30C99A7a9449Aa84174') and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} and RAW_AMOUNT>0 group by 1,2 union all select 'Solana' as chain, CASE WHEN AMOUNT < 5 then 'a. Below 5' WHEN AMOUNT < 100 then 'b. 5 - 100' WHEN AMOUNT < 500 then 'c. 100 - 500' WHEN AMOUNT < 2000 then 'd. 500 - 2,000' WHEN AMOUNT < 10000 then 'e. 2,000 - 10,000' WHEN AMOUNT >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_id) as no_transfers, count(distinct TX_FROM) as no_senders, count(distinct TX_TO) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from solana.core.fact_transfers where MINT='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} and AMOUNT>0 group by 1,2 union all select 'Algorand' as chain, CASE WHEN AMOUNT < 5 then 'a. Below 5' WHEN AMOUNT < 100 then 'b. 5 - 100' WHEN AMOUNT < 500 then 'c. 100 - 500' WHEN AMOUNT < 2000 then 'd. 500 - 2,000' WHEN AMOUNT < 10000 then 'e. 2,000 - 10,000' WHEN AMOUNT >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_id) as no_transfers, count(distinct ASSET_SENDER) as no_senders, count(distinct RECEIVER) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from algorand.core.ez_transfer where ASSET_ID='31566704' and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} and AMOUNT>0 group by 1,2 union all select 'Osmosis' as chain, CASE WHEN AMOUNT/1e6 < 5 then 'a. Below 5' WHEN AMOUNT/1e6 < 100 then 'b. 5 - 100' WHEN AMOUNT/1e6 < 500 then 'c. 100 - 500' WHEN AMOUNT/1e6 < 2000 then 'd. 500 - 2,000' WHEN AMOUNT/1e6 < 10000 then 'e. 2,000 - 10,000' WHEN AMOUNT/1e6 >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_id) as no_transfers, count(distinct SENDER) as no_senders, count(distinct RECEIVER) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from osmosis.core.fact_transfers where CURRENCY in ('ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858','uusdc') and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} and TX_STATUS='SUCCEEDED' and AMOUNT>0 group by 1,2 union all select 'Axelar' as chain, CASE WHEN AMOUNT/1e6 < 5 then 'a. Below 5' WHEN AMOUNT/1e6 < 100 then 'b. 5 - 100' WHEN AMOUNT/1e6 < 500 then 'c. 100 - 500' WHEN AMOUNT/1e6 < 2000 then 'd. 500 - 2,000' WHEN AMOUNT/1e6 < 10000 then 'e. 2,000 - 10,000' WHEN AMOUNT/1e6 >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_id) as no_transfers, count(distinct SENDER) as no_senders, count(distinct RECEIVER) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from axelar.core.fact_transfers where currency = 'uusdc' and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} and TX_SUCCEEDED='TRUE' and AMOUNT>0 group by 1,2 union all select 'Near' as chain, CASE WHEN (split(logs[0], ' ')[1] / pow(10, 6))::float < 5 then 'a. Below 5' WHEN (split(logs[0], ' ')[1] / pow(10, 6))::float< 100 then 'b. 5 - 100' WHEN (split(logs[0], ' ')[1] / pow(10, 6))::float < 500 then 'c. 100 - 500' WHEN (split(logs[0], ' ')[1] / pow(10, 6))::float < 2000 then 'd. 500 - 2,000' WHEN (split(logs[0], ' ')[1] / pow(10, 6))::float < 10000 then 'e. 2,000 - 10,000' WHEN (split(logs[0], ' ')[1] / pow(10, 6))::float >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_hash) as no_transfers, count(distinct split(logs[0], ' ')[3]::string) as no_senders, count(distinct split(logs[0], ' ')[5]::string) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from near.core.fact_receipts where receiver_id = 'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near' and logs[0] is not null and split(logs[0], ' ')[1] > 0 and split(logs[0], ' ')[1] is not null and left(logs[0]::string, 9) = 'Transfer ' and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} group by 1,2 union all select 'Flow' as chain, CASE WHEN event_data:amount < 5 then 'a. Below 5' WHEN event_data:amount < 100 then 'b. 5 - 100' WHEN event_data:amount < 500 then 'c. 100 - 500' WHEN event_data:amount < 2000 then 'd. 500 - 2,000' WHEN event_data:amount < 10000 then 'e. 2,000 - 10,000' WHEN event_data:amount >= 10000 then 'f. Over 10,000' end as gp, count(distinct tx_id) as no_transfers, count(distinct event_data:from) as no_senders, count(distinct event_data:to) as no_receivers, no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day from flow.core.fact_events where event_contract = 'A.b19436aae4d94622.FiatToken' --usdc AND (event_type ='TokensWithdrawn') and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}} group by 1,2