SandeshNFT Sales Ronin
    Updated 3 days ago
    -- forked from TLM https://flipsidecrypto.xyz/TheLaughingMan/q/zd9PrybB0sGM/daily-stats
    with offer_sales as (
    SELECT
    logs.block_timestamp
    , 'collection-offer' as label
    , logs.tx_hash
    , buyer
    , seller
    , symbol
    , amount
    , amount_usd
    , collection
    , nft_contract
    , token_id
    , quantity
    from ronin.core.fact_event_logs logs
    LEFT JOIN (
    SELECT
    tx_hash
    , from_address as buyer
    , symbol
    , amount
    , amount_usd
    from ronin.core.ez_token_transfers
    WHERE 1=1
    --AND tx_hash = '0xb93daf89d0a2a32e00382888ce2425e058319751fc481768cd5fc53f82f5f86e'
    AND to_address = '0x3ef234bc2a04d86f6041e419458d9acbd077f2c1' --Collection Offer Proxy
    ) pays on logs.tx_hash = pays.tx_hash
    LEFT JOIN (
    SELECT
    tx_hash
    , from_address as seller
    , contract_address as nft_contract
    , name as collection
    , token_id
    , quantity
    Last run: 3 days ago
    DDATE
    NFT_CONTRACT
    COLLECTION
    TOP_COLLECTIONS
    TOTAL_TRADES
    TOTAL_ITEMS
    TOTAL_VOLUME_USD
    UNIQUE_BUYERS
    1
    2025-02-01 00:00:00.0000x02286d77425ae3287335ff28b264109225ed6991Armoryother22146.86012
    2
    2025-02-04 00:00:00.0000x72288a7f32bec9de4a42bd19a746b9e7798996bbPrimal HeroZother1461603396.9844662
    3
    2025-02-04 00:00:00.0000x554bced1db572e16fdf4c8a6f23a301f7eb0293bPixel Heroes Adventure : Material Itemsother597954.24584920
    4
    2025-02-03 00:00:00.0000x72288a7f32bec9de4a42bd19a746b9e7798996bbPrimal HeroZother1682205026.97158659
    5
    2025-02-23 00:00:00.0000x727b7ff568e7173134eb02517c4a87eac390a77bFableborne KingdomsFableborne Kingdoms8722350659.5455
    6
    2025-02-25 00:00:00.0000x727b7ff568e7173134eb02517c4a87eac390a77bFableborne KingdomsFableborne Kingdoms16422457557.61949106
    7
    2025-02-23 00:00:00.0000x0e268edc8750d50c440d715c935eba2e7c6ae775PHZMother531701933.5850211224
    8
    2025-02-27 00:00:00.0000x954bd1181f5ca8a0485c1d634658677ecd22cb08Infomonother22437613.6212
    9
    2025-02-10 00:00:00.0000x79c691a5d6cc37ac727d8f9dadca64f8ab4ec467The Hordeother39562045.5229
    10
    2025-02-08 00:00:00.0000x883649b1d9e8b6d69ac9c36ca58531419d7dda8fFightLeagueChipsother25284.5719
    11
    2025-02-09 00:00:00.0000xf7d2ef2124837fe5c7ebf28635c2853db5964778Realms Ticketsother33945713.7621
    12
    2025-02-28 00:00:00.0000x17f93440990354a442369d56baeb20ab56e73ab1CambriaCoresother18364102.1066988810
    13
    2025-02-21 00:00:00.0000xc676f28365c8bfb73b1158b19a98c7fb342184eaKaidroPilotother22782.352
    14
    2025-02-13 00:00:00.0000x954bd1181f5ca8a0485c1d634658677ecd22cb08Infomonother1766849.5911
    15
    2025-02-09 00:00:00.0000x59cfa86b6820901ebeddd60f131c473c15eae130Nyang Kitother27653163.7312
    16
    2025-02-22 00:00:00.0000x9467ed740f52437ba7eaf65e29354ef0f7a8855dKongother11128211.5864
    17
    2025-02-18 00:00:00.000other431363.045627
    18
    2025-02-05 00:00:00.0000xd43bdbd75141f328104eb2887689479f1258703cMystery Boxother3450.05653
    19
    2025-02-07 00:00:00.0000xe0042bffba452767e68ed4a0289ae5873281eb8bPuzzleChampionsNFTother1515130.66
    20
    2025-02-03 00:00:00.0000x0c4479a7b1a3eb3e653797548028bdafd86b8498Ronin Chibisother3317.8463
    ...
    1604
    179KB
    20s