TheLaughingManoverview stats
    Updated 2 hours ago
    -- forked from base sales search @ https://flipsidecrypto.xyz/studio/queries/a0f255cb-4118-4ac1-80ef-5e0cfaa05aaa

    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
    Last run: about 2 hours ago
    TOTAL_TRADES
    TOTAL_ITEMS
    TOTAL_VOLUME_USD
    BUYERS
    1
    5832001919965318462697.746401748207
    1
    42B
    21s