flipside

    local-scarlet
    Mrftilocal-scarlet
    Updated 4 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 4 hours agoAuto-refreshes every 12 hours
    Collection
    Date
    Total Sales
    Unique Sellers
    Unique Buyers
    Total Volume (USD)
    1
    		Adventure LandZ2025-04-13 00:00:00.00016181324375.59
    2
    		Adventure LandZ2025-04-12 00:00:00.0005651066.54
    3
    		Adventure LandZ2025-04-11 00:00:00.00010910565.12
    4
    		Adventure LandZ2025-04-10 00:00:00.000333175.32
    5
    		Adventure LandZ2025-04-09 00:00:00.000846270.71
    6
    		Adventure LandZ2025-04-08 00:00:00.0001510121061.55
    7
    		Adventure LandZ2025-04-07 00:00:00.0001187609.135915
    8
    		Adventure LandZ2025-04-06 00:00:00.000101071519.32
    9
    		Adventure LandZ2025-04-05 00:00:00.0007961757.65
    10
    		Adventure LandZ2025-04-04 00:00:00.0002115141353.96
    11
    		Adventure LandZ2025-04-03 00:00:00.00013117839.750856
    12
    		Adventure LandZ2025-04-02 00:00:00.0002315182471.5462148
    13
    		Adventure LandZ2025-04-01 00:00:00.0001818165295.13
    14
    		Adventure LandZ2025-03-31 00:00:00.0001111102127.18
    15
    		Adventure LandZ2025-03-30 00:00:00.00010981770.43
    16
    		Adventure LandZ2025-03-29 00:00:00.0001413113297.55
    17
    		Adventure LandZ2025-03-28 00:00:00.000151410793.1
    18
    		Adventure LandZ2025-03-27 00:00:00.0001515112158.22
    19
    		Adventure LandZ2025-03-26 00:00:00.000131271695.03
    20
    		Adventure LandZ2025-03-25 00:00:00.0001920136434.14
    ...
    835
    50KB
    53s