WITH -------------------------------------------------- Algorand -------------------------------------------------- -- Algorand AS ( -- SELECT -- block_timestamp, -- tx_id AS tx, -- tx_sender AS user, -- address_name AS user_name, -- CASE -- WHEN label_type = 'cex' THEN 'CEX' -- WHEN label_type = 'chadmin' THEN 'Admin' -- WHEN label_type = 'dapp' THEN 'DApp' -- WHEN label_type = 'defi' THEN 'DeFi' -- WHEN label_type = 'dex' THEN 'DEX' -- WHEN label_type = 'layer2' THEN 'Layer 2' -- WHEN label_type = 'nft' THEN 'NFT' -- WHEN label_type = 'operator' THEN 'Operator' -- WHEN label_type = 'token' THEN 'Token' -- ELSE 'Other' -- END AS wallet_type, -- amount, -- CASE -- WHEN amount < 1 THEN '<1' -- WHEN amount >= 1 AND amount < 10 THEN '1-10' -- WHEN amount >= 10 AND amount < 100 THEN '10-100' -- WHEN amount >= 100 AND amount < 1000 THEN '100-1000' -- WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' -- WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' -- ELSE '>100000' -- END as bucket -- FROM -- algorand.core.ez_transfer transfers -- LEFT JOIN -- algorand.core.dim_label labels -- ON -- transfers.tx_sender = labels.address -- WHERE -- block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) -- AND asset_id = 31566704 -- AND amount > 0 -- ), -------------------------------------------------- Arbitrum -------------------------------------------------- Arbitrum AS ( SELECT block_timestamp, tx_hash AS tx, from_address AS user, address_name AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, (raw_amount / POW(10, 6)) AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM arbitrum.core.fact_token_transfers transfers LEFT JOIN arbitrum.core.dim_labels labels ON transfers.from_address = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND contract_address = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' AND from_address <> '0x0000000000000000000000000000000000000000' AND to_address <> '0x0000000000000000000000000000000000000000' AND raw_amount > 0 ), -------------------------------------------------- Avalanche -------------------------------------------------- Avalanche AS ( SELECT block_timestamp, tx_hash AS tx, from_address AS user, address_name AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, (raw_amount / POW(10, 6)) AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM avalanche.core.fact_token_transfers transfers LEFT JOIN avalanche.core.dim_labels labels ON transfers.from_address = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e' AND from_address <> '0x0000000000000000000000000000000000000000' AND to_address <> '0x0000000000000000000000000000000000000000' AND raw_amount > 0 ), -------------------------------------------------- Axelar -------------------------------------------------- Axelar AS ( SELECT block_timestamp, tx_id AS tx, sender AS user, address_name AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, amount / POW(10, decimal) AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM axelar.core.fact_transfers transfers LEFT JOIN axelar.core.dim_labels labels ON transfers.sender = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND tx_succeeded = TRUE AND currency = 'uusdc' AND amount > 0 ), -------------------------------------------------- BSC -------------------------------------------------- BSC AS ( SELECT block_timestamp, tx_hash AS tx, from_address AS user, address_name AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, (raw_amount / POW(10, 18)) AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM bsc.core.fact_token_transfers transfers LEFT JOIN bsc.core.dim_labels labels ON transfers.from_address = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND contract_address = '0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d' AND from_address <> '0x0000000000000000000000000000000000000000' AND to_address <> '0x0000000000000000000000000000000000000000' AND raw_amount > 0 ), -------------------------------------------------- Ethereum -------------------------------------------------- Ethereum AS ( SELECT block_timestamp, tx_hash AS tx, from_address AS user, address_name AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM ethereum.core.ez_token_transfers transfers LEFT JOIN ethereum.core.dim_labels labels ON transfers.from_address = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' AND from_address <> '0x0000000000000000000000000000000000000000' AND to_address <> '0x0000000000000000000000000000000000000000' AND amount > 0 ), -------------------------------------------------- Flow -------------------------------------------------- Flow AS ( SELECT block_timestamp, tx_id AS tx, event_data:from AS user, contract_name AS user_name, 'Other' AS wallet_type, event_data:amount AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM flow.core.fact_events transfers LEFT JOIN flow.core.dim_contract_labels labels ON transfers.event_data:from = labels.event_contract WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND tx_succeeded = TRUE AND transfers.event_contract = 'A.b19436aae4d94622.FiatToken' AND event_type = 'TokensWithdrawn' AND event_data:amount > 0 AND tx_id NOT IN (SELECT DISTINCT tx_id FROM flow.core.fact_events WHERE event_type IN ('Mint', 'Burn')) ), -------------------------------------------------- Gnosis -------------------------------------------------- Gnosis AS ( SELECT block_timestamp, tx_hash AS tx, from_address AS user, address_name AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, (raw_amount / POW(10, 6)) AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM gnosis.core.fact_token_transfers transfers LEFT JOIN gnosis.core.dim_labels labels ON transfers.from_address = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND contract_address = '0xddafbb505ad214d7b80b1f830fccc89b60fb7a83' AND from_address <> '0x0000000000000000000000000000000000000000' AND to_address <> '0x0000000000000000000000000000000000000000' AND raw_amount > 0 ), -------------------------------------------------- NEAR -------------------------------------------------- NEAR AS ( SELECT transactions.block_timestamp, transactions.tx_hash AS tx, transactions.tx_signer AS user, project_name AS user_name, INITCAP(l1_label) AS wallet_type, TRY_PARSE_JSON(TRY_PARSE_JSON(calls.args):msg):actions[0]:min_amount_out / POW(10, 6) AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM near.core.fact_transactions transactions JOIN near.core.fact_actions_events_function_call calls ON transactions.tx_hash = calls.tx_hash LEFT JOIN near.core.dim_address_labels labels ON transactions.tx_signer = labels.address WHERE transactions.block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND transactions.tx_status = 'Success' AND calls.method_name = 'ft_transfer_call' AND TRY_PARSE_JSON(TRY_PARSE_JSON(calls.args):msg):actions[0]:token_out = 'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near' AND TRY_PARSE_JSON(TRY_PARSE_JSON(calls.args):msg):actions[0]:min_amount_out > 0 ), -------------------------------------------------- Optimism -------------------------------------------------- Optimism AS ( SELECT block_timestamp, tx_hash AS tx, from_address AS user, address_name AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, (raw_amount / POW(10, 6)) AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM optimism.core.fact_token_transfers transfers LEFT JOIN optimism.core.dim_labels labels ON transfers.from_address = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607' AND from_address <> '0x0000000000000000000000000000000000000000' AND to_address <> '0x0000000000000000000000000000000000000000' AND raw_amount > 0 ), -------------------------------------------------- Osmosis -------------------------------------------------- Osmosis AS ( SELECT block_timestamp, tx_id AS tx, sender AS user, label AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, amount / POW(10, decimal) AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM osmosis.core.fact_transfers transfers LEFT JOIN osmosis.core.dim_labels labels ON transfers.sender = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND tx_succeeded = TRUE AND (currency LIKE '%usdc%' OR currency = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858') AND amount > 0 ), -------------------------------------------------- Polygon -------------------------------------------------- Polygon AS ( SELECT block_timestamp, tx_hash AS tx, from_address AS user, address_name AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, (raw_amount / POW(10, 6)) AS amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM polygon.core.fact_token_transfers transfers LEFT JOIN polygon.core.dim_labels labels ON transfers.from_address = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' AND from_address <> '0x0000000000000000000000000000000000000000' AND to_address <> '0x0000000000000000000000000000000000000000' AND raw_amount > 0 ), -------------------------------------------------- Solana -------------------------------------------------- Solana AS ( SELECT block_timestamp, tx_id AS tx, tx_from AS user, address_name AS user_name, CASE WHEN label_type = 'cex' THEN 'CEX' WHEN label_type = 'chadmin' THEN 'Admin' WHEN label_type = 'dapp' THEN 'DApp' WHEN label_type = 'defi' THEN 'DeFi' WHEN label_type = 'dex' THEN 'DEX' WHEN label_type = 'layer2' THEN 'Layer 2' WHEN label_type = 'nft' THEN 'NFT' WHEN label_type = 'operator' THEN 'Operator' WHEN label_type = 'token' THEN 'Token' ELSE 'Other' END AS wallet_type, amount, CASE WHEN amount < 1 THEN '<1' WHEN amount >= 1 AND amount < 10 THEN '1-10' WHEN amount >= 10 AND amount < 100 THEN '10-100' WHEN amount >= 100 AND amount < 1000 THEN '100-1000' WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000' WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000' ELSE '>100000' END as bucket FROM solana.core.fact_transfers transfers LEFT JOIN solana.core.dim_labels labels ON transfers.tx_from = labels.address WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1) AND mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' AND amount > 0 ) -- SELECT -- 'Algorand' AS "Blockchain", -- IFNULL(wallet_type, 'Unknown') AS "Wallet", -- COUNT(DISTINCT tx) AS "Transfers", -- COUNT(DISTINCT user) AS "Users", -- SUM(amount) AS "Volume", -- AVG(amount) AS "AmountAverage", -- MEDIAN(amount) AS "AmountMedian" -- FROM -- Algorand -- GROUP BY -- "Wallet" -- QUALIFY -- ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 -- UNION SELECT 'Arbitrum' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Arbitrum GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'Avalanche' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Avalanche GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'Axelar' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Axelar GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'BSC' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM BSC GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'Ethereum' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Ethereum GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'Flow' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Flow GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'Gnosis' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Gnosis GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'NEAR' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM NEAR GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'Optimism' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Optimism GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'Osmosis' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Osmosis GROUP BY "Wallet" HAVING "Volume" > 0 QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'Polygon' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Polygon GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 UNION SELECT 'Solana' AS "Blockchain", IFNULL(wallet_type, 'Unknown') AS "Wallet", COUNT(DISTINCT tx) AS "Transfers", COUNT(DISTINCT user) AS "Users", SUM(amount) AS "Volume", AVG(amount) AS "AmountAverage", MEDIAN(amount) AS "AmountMedian" FROM Solana GROUP BY "Wallet" QUALIFY ROW_NUMBER() OVER (ORDER BY "Transfers" DESC) <= 20 ORDER BY "Blockchain", "Transfers" DESC

Query	Creator	Created
Transfers Wallet Types gnosis flow axelar near bsc	alitaslimi	Dec 21, 2022
Axelar Blocks Block Count Daily axelar ibc	alitaslimi	May 7, 2023
Proposals Daily terra cosmos axelar osmosis ibc	alitaslimi	Jan 12, 2023
Transactions New Users Daily cosmos gnosis flow axelar near	alitaslimi	Jan 14, 2023
Proposals Types terra cosmos axelar osmosis ibc	alitaslimi	Jan 12, 2023

alitaslimi