flipside

    local-scarlet
    Mrftilocal-scarlet
    Updated 22 hours ago
    -- Adapted from TheLaughingMan / overview stats @ https://flipsidecrypto.xyz/TheLaughingMan/q/0lkt5CIyChGc/overview-stats

    WITH nft_trades AS (
    SELECT
    logs.block_timestamp,
    DATE_TRUNC('day', logs.block_timestamp) AS trade_date,
    logs.tx_hash,
    nfts.from_address AS seller,
    pays.from_address AS buyer,
    nfts.contract_address AS nft_contract,
    nfts.name AS collection_name,
    pays.amount_usd
    FROM ronin.core.fact_event_logs logs
    LEFT JOIN (
    SELECT
    tx_hash,
    from_address,
    amount_usd
    FROM ronin.core.ez_token_transfers
    WHERE to_address IN (
    '0x3ef234bc2a04d86f6041e419458d9acbd077f2c1', -- Collection Offer Proxy
    '0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3', -- Market Gateway Proxy
    '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' -- Market Gateway Multi Send Proxy
    )
    UNION ALL
    SELECT
    tx_hash,
    from_address,
    amount_usd
    FROM ronin.core.ez_native_transfers
    WHERE to_address IN (
    '0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3', -- Market Gateway Proxy
    '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' -- Market Gateway Multi Send Proxy
    )
    AND trace_index = 0
    ) pays ON logs.tx_hash = pays.tx_hash
    Last run: about 22 hours agoAuto-refreshes every 12 hours
    Collection
    Date
    Total Sales
    Unique Sellers
    Unique Buyers
    Total Volume (USD)
    1
    		Adventure LandZ2025-04-26 00:00:00.000785588.79
    2
    		Adventure LandZ2025-04-25 00:00:00.0001312122924.02
    3
    		Adventure LandZ2025-04-24 00:00:00.00013751074.13
    4
    		Adventure LandZ2025-04-23 00:00:00.000444213.23
    5
    		Adventure LandZ2025-04-22 00:00:00.000775989.73
    6
    		Adventure LandZ2025-04-21 00:00:00.00033392.07
    7
    		Adventure LandZ2025-04-20 00:00:00.0001096294.06
    8
    		Adventure LandZ2025-04-19 00:00:00.0006551174.63
    9
    		Adventure LandZ2025-04-18 00:00:00.00014106648.81
    10
    		Adventure LandZ2025-04-17 00:00:00.00010992520.79
    11
    		Adventure LandZ2025-04-16 00:00:00.00010961033.33
    12
    		Adventure LandZ2025-04-15 00:00:00.000785691.83
    13
    		Adventure LandZ2025-04-14 00:00:00.00081071692.59
    14
    		Adventure LandZ2025-04-13 00:00:00.00016181324375.59
    15
    		Adventure LandZ2025-04-12 00:00:00.0005651066.54
    16
    		Adventure LandZ2025-04-11 00:00:00.00010910565.12
    17
    		Adventure LandZ2025-04-10 00:00:00.000333175.32
    18
    		Adventure LandZ2025-04-09 00:00:00.000846270.71
    19
    		Adventure LandZ2025-04-08 00:00:00.0001510121061.55
    20
    		Adventure LandZ2025-04-07 00:00:00.0001187609.135915
    ...
    957
    57KB
    52s