SELECT

DATE_TRUNC('month', swaps.block_timestamp) AS month,

platform,

COUNT(DISTINCT swaps.tx_hash) AS uniswap_tx_count,

SUM(CAST(blocks.block_header_json:baseFeePerGas AS FLOAT) / 1e18 * tx.gas_used) AS uniswap_eth_burnt

FROM crosschain.defi.ez_dex_swaps swaps

JOIN ethereum.core.fact_transactions tx ON swaps.tx_hash = tx.tx_hash

JOIN ethereum.core.fact_blocks blocks ON tx.block_number = blocks.block_number

WHERE lower(swaps.platform) LIKE 'uniswap%'

AND swaps.blockchain = 'ethereum'

AND swaps.block_timestamp >= '2021-07-01'

GROUP BY month, platform

),

eth_burnt AS (

SELECT

DATE_TRUNC('month', block_timestamp) AS month,

SUM(CAST(block_header_json:baseFeePerGas AS FLOAT) / 1e18 * block_header_json:gasUsed) AS eth_burnt

FROM ethereum.core.fact_blocks

WHERE block_timestamp >= '2021-07-01'

GROUP BY month

),

uniswap_eth_pivot AS (

SELECT

month,

SUM(CASE WHEN platform LIKE 'uniswap-v2%' THEN uniswap_eth_burnt ELSE 0 END) AS uniswap_v2_eth_burnt,

SUM(CASE WHEN platform LIKE 'uniswap-v3%' THEN uniswap_eth_burnt ELSE 0 END) AS uniswap_v3_eth_burnt

FROM uniswap_eth

GROUP BY month

SELECT

u_eth_pivot.month,

u_eth_pivot.uniswap_v2_eth_burnt,