NavidCopy of Untitled Query
    Updated 2022-07-31
    with mints as (
    select
    block_timestamp,
    to_address,
    case when symbol is null then 'Unknown' else symbol end as symbol,
    amount,
    amount_usd
    from
    polygon.udm_events
    where
    event_type = 'erc20_transfer' and
    origin_address = '0x0000000000000000000000000000000000000000' and
    from_address = '0x0000000000000000000000000000000000000000' and
    block_timestamp > CURRENT_DATE - 30 and
    amount > 0 and event_id is not null
    ), transfers as (
    select
    ue.block_timestamp,
    ue.from_address,
    ue.symbol,
    ue.amount,
    ue.amount_usd,
    mints.symbol as minted_symbol,
    case when ue.to_label is null then 'Unknown' else ue.to_label end as to_label
    from
    polygon.udm_events ue join mints on ue.from_address = mints.to_address and ue.symbol=mints.symbol
    where
    ue.block_timestamp >= mints.block_timestamp
    ), res as (
    select
    minted_symbol,
    to_label,
    amount_usd,
    lead(to_label, 1) over (partition by from_address order by block_timestamp asc) as lead_to_label
    from transfers
    )
    Run a query to Download Data