WITH DOLPHINS AS (

SELECT

'NEAR' AS chain,

block_timestamp,

trader as trader,

SUM(COALESCE(amount_in_usd, amount_out_usd, 0)) AS total_trade_volume

FROM near.defi.ez_dex_swaps

WHERE COALESCE(amount_in_usd, amount_out_usd, 0) BETWEEN 10000 AND 100000

AND DATE_TRUNC('day', block_timestamp) >= '2024-01-01'

GROUP BY 1, 2,3

UNION ALL

SELECT

'Aptos' AS chain,

block_timestamp,

swapper as trader,

SUM(COALESCE(amount_in_usd, amount_out_usd, 0)) AS total_trade_volume

FROM aptos.defi.ez_dex_swaps

WHERE COALESCE(amount_in_usd, amount_out_usd, 0) BETWEEN 10000 AND 100000

AND DATE_TRUNC('day', block_timestamp) >= '2024-01-01'

GROUP BY 1, 2,3

UNION ALL

SELECT

'Solana' AS chain,

block_timestamp,

swapper as trader,

SUM(COALESCE(SWAP_FROM_AMOUNT_USD, SWAP_TO_AMOUNT_USD, 0)) AS total_trade_volume

FROM solana.defi.ez_dex_swaps

WHERE COALESCE(SWAP_FROM_AMOUNT_USD, SWAP_TO_AMOUNT_USD, 0) BETWEEN 10000 AND 100000

AND DATE_TRUNC('day', block_timestamp) >= '2024-01-01'

GROUP BY 1, 2,3