maybeyonasfrac_top_nft_basket
    Updated 2022-04-26
    with
    baskets as (
    select event_inputs:"_address"::string as basket
    from ethereum_core.fact_event_logs
    where contract_address = '0xde771104c0c44123d22d39bb716339cd0c3333a1'
    and event_name = 'NewBasket'
    ),
    deposits as (
    -- Basket Deposits Only
    select
    block_timestamp,
    tx_hash,
    -- event_inputs:from::string as user,
    event_inputs:token::string as contract,
    event_inputs:tokenId as token_id
    from ethereum_core.fact_event_logs
    where contract_address in (select * from baskets)
    and event_name = 'Deposit'
    ),
    mints as (
    select
    block_timestamp,
    tx_hash,
    -- event_inputs:from::string as user,
    event_inputs:token::string as contract,
    event_inputs:id as token_id
    from ethereum_core.fact_event_logs
    where contract_address = '0x85aa7f78bdb2de8f3e0c0010d99ad5853ffcfc63'
    and event_name = 'Mint'
    )

    select
    contract,
    symbol,
    case when contract = '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85' then 'ENS' else name end as name,
    count(token_id) as txs
    Run a query to Download Data