D3 AnalyticsDaily NFT Trades
    Updated 2025-03-31
    -- Inspiration https://flipsidecrypto.xyz/TheLaughingMan/q/zd9PrybB0sGM/daily-stats
    with payment as (
    SELECT to_address as contract_address
    , tx_hash
    , 1 as token_transfer_index
    , 1 as payment_rows
    , from_address as buyer
    , 'RON' as symbol
    , amount
    , amount_usd
    from ronin.core.ez_native_transfers
    WHERE 1=1
    AND trace_index = 0
    AND to_address in (
    '0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3' --Market Gateway Proxy
    , '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' --Market Gateway Proxy Multi Send Proxy
    )

    UNION ALL
    --incase other erc20 not native
    SELECT to_address as contract_address
    , tx_hash
    , row_number() over(partition by tx_hash order by event_index) token_transfer_index
    , count(*) over(partition by tx_hash) payment_rows
    , from_address as buyer
    , symbol
    , amount
    , amount_usd
    from ronin.core.ez_token_transfers
    WHERE 1=1
    AND to_address in (
    '0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3' --Market Gateway Proxy
    , '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' --Market Gateway Proxy Multi Send Proxy
    )
    AND from_address <> '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' -- Exclude intermediate cases where MG Multi Send Proxy indirectly forwards tokens to MG Proxy for token distribution
    ),
    QueryRunArchived: QueryRun has been archived