Updated 2023-04-10
    SELECT
    COUNT(TO_ADDRESS) TOTAL_VOLUME,
    SUM(AVAX_VALUE) AS total_sales,
    BLOCK_TIMESTAMP::DATE day_agg,
    CASE WHEN TO_ADDRESS = '0xc28f1550160478a7fb3b085f25d4b179e08e649a' THEN 'NFTrade'
    WHEN TO_ADDRESS IN ('0x11ac3118309a7215c6d87c7c396e2df333ae3a9c', '0xeff2357c9e40103ac4d268b32de478e4fbbfc4f0') THEN 'Kalao'
    WHEN TO_ADDRESS IN ('0xcf91b99548b1c17dd1095c0680e20de380635e20','0x8927985b358692815e18f2138964679dca5d3b79') THEN 'Chikn'
    WHEN TO_ADDRESS = '0xae079eda901f7727d0715aff8f82ba8295719977' THEN 'JoePegs'
    WHEN TO_ADDRESS = '0xbcb09cdb2011fea0591b52e52085bb102e4a082a' THEN 'Campfire'
    WHEN TO_ADDRESS = lower('0x00000000006c3852cbEf3e08E8dF289169EdE581') THEN 'OpenSea'
    END AS market

    FROM avalanche.core.fact_transactions trans

    WHERE TO_ADDRESS IN ('0xc28f1550160478a7fb3b085f25d4b179e08e649a', -- NFTrade
    '0x11ac3118309a7215c6d87c7c396e2df333ae3a9c', -- Kalao v1
    '0xeff2357c9e40103ac4d268b32de478e4fbbfc4f0', -- Kalao v2
    '0xcf91b99548b1c17dd1095c0680e20de380635e20', -- Roostr
    '0x8927985b358692815e18f2138964679dca5d3b79', -- Chikn
    '0xae079eda901f7727d0715aff8f82ba8295719977', -- joepegs
    '0xbcb09cdb2011fea0591b52e52085bb102e4a082a', -- Campfire.exchange
    lower('0x00000000006c3852cbEf3e08E8dF289169EdE581') -- OpenSea
    )



    AND status ='SUCCESS'

    GROUP BY day_agg, market
    ORDER BY day_agg DESC
    Run a query to Download Data