Holonymactivity on Eth and L2s
    Updated 2024-11-30
    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