Holonymwallet age
    Updated 2025-02-13
    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: 2 months ago
    USER_TYPE
    Number of Users
    1
    20- 50 Days2444
    2
    under 20 Days3225
    3
    over 365 Days100388
    4
    100- 365 Days45098
    5
    50- 100 Days6792
    5
    116B
    276s