permarythin-fuchsia
    Updated 2025-04-03
    --- forked from https://flipsidecrypto.xyz/TheLaughingMan/q/0lkt5CIyChGc/overview-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
    Last run: about 2 months ago
    DDATE
    TOTAL_TRADES
    TOTAL_ITEMS
    TOTAL_VOLUME_USD
    UNIQUE_BUYERS
    TOTAL_VOLUME_RON
    CUMULATIVE_TOTAL_TRADES
    CUMULATIVE_TOTAL_VOLUME_USD
    CUMULATIVE_TOTAL_VOLUME_RON
    1
    2024-10-12 00:00:00.000449868.86314781.09291352769249.82103718.972977949
    2
    2025-02-28 00:00:00.000456169.6359240.568239079329778498.9141165997.36756758
    3
    2025-03-11 00:00:00.000777195.84610777.575082703393855387.9946899991281158.04931932
    4
    2025-02-01 00:00:00.0005510718.82416054.121179456221602705.89902703.226067025
    5
    2024-10-02 00:00:00.00011315414723.906008311514215.7821291.695800516
    6
    2025-03-12 00:00:00.000443418.9545120.73508152397858806.9446899991286278.78440084
    7
    2025-02-21 00:00:00.00091223693.96835487.647433316305744601.4541115227.41989463
    8
    2025-02-03 00:00:00.000458255.82512365.160970683225610961.71915068.387037708
    9
    2024-10-26 00:00:00.0006615239.13622824.41907686552132248.61198075.460802084
    10
    2024-12-29 00:00:00.000112265.613393.304201785172481380.45720987.951819413
    11
    2025-01-24 00:00:00.00011199212983.519584196203561564.58841083.796295693
    12
    2025-01-08 00:00:00.000227740.46111593.280120828182511677.89766365.96667434
    13
    2025-02-19 00:00:00.000778573.09312840.352365501292714244.4941069760.25891237
    14
    2025-03-29 00:00:00.00011775.2511161.13130404445917948.8646899991374858.64211519
    15
    2024-10-10 00:00:00.000447992.69411971.0578039211847309.8870858.410394569
    16
    2025-03-19 00:00:00.000459273.43513889.287157467420888737.2046899991331106.85511876
    17
    2025-01-30 00:00:00.000112145.613213.574106351214588183.27880951.960412486
    18
    2024-11-20 00:00:00.000225769.128640.674113046120296125.26443521.843667293
    19
    2025-03-09 00:00:00.000899244.09664813845.353094199377841791.618341260794.06582819
    20
    2025-03-04 00:00:00.000443988.9945974.512944861349804892.3241205528.11838521
    ...
    146
    13KB
    29s