datasovrun2023-12-25 10:52 PM
    Updated 2024-01-02
    with filtered as (
    select *
    from ethereum.nft.ez_nft_transfers
    where nft_address = '0xd1258db6ac08eb0e625b75b371c023da478e94a9'
    and block_timestamp <=
    ( dateadd('day', 10, (select min(block_timestamp) from ethereum.nft.ez_nft_transfers where nft_address = '0xd1258db6ac08eb0e625b75b371c023da478e94a9') ) )
    )

    , base as (
    select nft_from_address AS addr
    , 'from' as type
    , count(*) as tokens_transferred
    from filtered
    group by 1
    union
    select nft_to_address AS addr
    , 'to' as type
    , count(*) AS tokens_transferred
    from filtered
    group by 1


    )

    , base_agg as (
    select addr
    , sum(tokens_transferred) as tokens_transferred
    from base
    group by 1
    order by 2 desc
    )

    , outflow as (
    select
    QueryRunArchived: QueryRun has been archived