Updated 2022-08-01

    with opensea_trasactions_fee as
    (
    SELECT TX_ID,
    AMOUNT,
    AMOUNT_USD,
    SYMBOL,
    BLOCK_TIMESTAMP::date as day
    FROM polygon.udm_events
    WHERE to_address = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073'
    AND symbol IS NOT NULL
    AND from_address='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
    AND AMOUNT_USD is not null
    ),

    opensea_trasactions_all_info as
    (
    select t1.CONTRACT_ADDRESS as nft_address,
    t2.day,
    t2.SYMBOL,
    t2.AMOUNT as fee_token_amount,
    t2.AMOUNT_USD as fee_usd_amount
    from flipside_prod_db.polygon.events_emitted as t1
    join opensea_trasactions_fee as t2
    on t1.TX_ID=t2.TX_ID
    where t1.CONTRACT_ADDRESS not in
    ('0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' --WETH: 0x7ceb23fd6bc0add59e62ac25578270cff1b9f619
    ,'0x70c006878a5a50ed185ac4c87d837633923de296' --REW: 0x70c006878a5a50ed185ac4c87d837633923de296
    ,'0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' --DAI: 0x8f3cf7ad23cd3cadbd9735aff958023239c6a063
    ,'0x2791bca1f2de4661ed88a30c99a7a9449aa84174' --USDC : 0x2791bca1f2de4661ed88a30c99a7a9449aa84174
    ,'0xfede379e48c873c75f3cc0c81f7c784ad730a8f7'
    ,'0x0000000000000000000000000000000000001010'
    )
    and t1.CONTRACT_ADDRESS is not null
    )

    Run a query to Download Data