HolonymPopular NFTs on Optimism copy
    Updated 8 days ago
    with optimism_fees_transactions as (
    select
    block_timestamp,
    tx_hash,
    from_address as userAddress,
    value as fee,
    'ETH' as currency
    from optimism.core.fact_transactions
    where to_address = '0xdca2e9ae8423d7b0f94d7f9fc09e698a45f3c851'
    ),
    avalanche_fees_transactions as (
    select
    block_timestamp,
    tx_hash,
    from_address as userAddress,
    value as fee,
    'AVAX' as currency
    from avalanche.core.fact_transactions
    where to_address = '0xdca2e9ae8423d7b0f94d7f9fc09e698a45f3c851'
    ),

    ethereum_fees_transactions as (
    select
    block_timestamp,
    tx_hash,
    from_address as userAddress,
    value as fee,
    'ETH' as currency
    from ethereum.core.fact_transactions
    where to_address = '0xdca2e9ae8423d7b0f94d7f9fc09e698a45f3c851'
    ),
    fantom_fees_transactions_from_dune as (
    select
    livequery.live.udf_api(
    'https://api.flipsidecrypto.com/api/v2/queries/38a8ae12-3a05-4dc2-bd02-af696e63518c/data/latest'
    ):"data" as response
    Last run: 8 days ago
    PROJECT_NAME
    TOTAL_HELD_NFTS
    TOTAL_HOLDERS
    1
    BLOCKAID WARNING8965636636
    2
    Layer3 CUBE146375334697
    3
    Galxe OAT32407133926
    4
    $ZRO Token at https://zro.lat2325623256
    5
    Superchain2013120676
    6
    FoxyToken2279719574
    7
    BLOCKAID WARNING!2239919311
    8
    Event2860117555
    9
    Uniswap V3 Positions NFT-V15929916136
    10
    Event 13541212510
    10
    314B
    25s