maybeyonasuni_nft_moves
    Updated 2022-01-22
    with
    -- uniswap_mint_txs as (
    -- select
    -- tx_id
    -- from polygon.transactions
    -- where to_address = '0xc36442b4a4522e871399cd717abdd847ab11fe88'
    -- ),
    -- uniswap_mint as (
    -- select
    -- block_timestamp,
    -- tx_id,
    -- event_inputs:to::string as user ,
    -- event_inputs:tokenId as token_id
    -- from polygon.events_emitted
    -- where event_removed = 'FALSE'
    -- and tx_id in (select tx_id from uniswap_mint_txs)
    -- and event_name = 'Transfer'
    -- and event_inputs:from::string = '0x0000000000000000000000000000000000000000'
    -- and event_inputs:tokenId is not null
    -- ),
    -- uniswap_add_rem as (
    -- select
    -- tx_id,
    -- event_name
    -- from polygon.events_emitted
    -- where event_removed = 'FALSE'
    -- and tx_id in (select tx_id from uniswap_mint_txs)
    -- and event_name in ('DecreaseLiquidity','IncreaseLiquidity')
    -- limit 100
    -- )
    uni_nft_move as (
    select
    block_timestamp,
    tx_id,
    tx_from_address,
    event_inputs:from::string as transfer_from,
    Run a query to Download Data