kaibladeMonthly Transaction volume Distribution - 3 months
    Updated 2022-10-01
    WITH nft_sales AS
    (SELECT *
    FROM ethereum.core.ez_nft_sales
    WHERE block_timestamp::date >= CURRENT_DATE() - INTERVAL '3 month'
    ),

    nft_trx AS
    (SELECT *
    FROM ethereum.core.fact_transactions
    WHERE to_address IN (SELECT DISTINCT(platform_address) FROM ethereum.core.ez_nft_sales)
    AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '3 month'
    ),
    combined AS
    (SELECT trx.block_timestamp,
    trx.tx_hash,
    trx.from_address,
    trx.status,
    sales.platform_name
    FROM nft_trx trx
    JOIN nft_sales sales
    ON trx.to_address = sales.platform_address
    WHERE trx.status ='SUCCESS')

    SELECT
    COUNT(tx_hash) AS "Transactions",
    platform_name

    FROM combined

    GROUP BY platform_name





    Run a query to Download Data