alirsopensee fees-part-03
    Updated 2022-08-01
    with nft_tx_ids as(
    select tx_id from polygon.udm_events
    where origin_address ='0x9b814233894cd227f561b78cc65891aa55c62ad2'
    and event_name='transfer'
    and contract_address != '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'
    ),
    nft_tx as(
    select
    n.tx_id,
    block_timestamp,
    from_address,
    to_address,
    contract_address as contract,
    symbol,
    amount,
    amount_usd
    from polygon.udm_events p
    join nft_tx_ids n on p.tx_id = n.tx_id
    where event_name = 'transfer'
    ),
    nft_involved as(
    select tx_id,block_timestamp,contract from nft_tx
    where contract != '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'
    ),
    fees as(
    select tx_id, block_timestamp, amount, symbol, amount_usd
    from nft_tx
    where to_address = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073'
    ),
    opensea as(
    select
    f.tx_id,
    f.block_timestamp,
    contract,
    amount,
    symbol,
    Run a query to Download Data