Updated 2025-02-22
    with ftm_daily_price as (
    select
    hour::date as day,
    avg(price) as price_usd
    from crosschain.price.ez_prices_hourly
    where token_address = '0x4e15361fd6b4bb609fa63c81a2be19d873717870'
    and blockchain = 'ethereum'
    group by day
    ),
    eth_daily_price as (
    select
    hour::date as day,
    avg(price) as price_usd
    from crosschain.price.ez_prices_hourly
    where token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    and blockchain = 'ethereum'
    group by day
    ),
    avax_daily_price as (
    select
    hour::date as day,
    avg(price) as price_usd
    from crosschain.price.ez_prices_hourly
    where token_address = '0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7'
    and blockchain = 'avalanche'
    group by day
    ),
    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'
    Last run: about 2 months ago
    MONTH
    NO_MINTS
    Minters
    NFTS
    TOTAL_FEE_BNB
    Fee (USD)
    Total Minters
    Cumulative Fee (USD)
    1
    2025-02-01 00:00:00.0004654654650.0670744743.791812032591208713.353111951
    2
    2025-01-01 00:00:00.0003173173170.04572608631.604223156586558669.561299919
    3
    2024-12-01 00:00:00.0005355355350.07717205553.646511477583388637.957076763
    4
    2024-11-01 00:00:00.0003663663660.05279428332.65167416578038584.310565286
    5
    2024-10-01 00:00:00.0003143143140.04529327226.231885871574378551.658891126
    6
    2024-09-01 00:00:00.0002392392390.03447519119.761236477571238525.427005255
    7
    2024-08-01 00:00:00.0002982982980.043028963723.58339847568848505.665768777
    8
    2024-07-01 00:00:00.0004744744740.06837260437.286974475565868482.082370307
    9
    2024-06-01 00:00:00.0009959959950.14352504288.093765536561128444.795395832
    10
    2024-05-01 00:00:00.0001389138913890.200358408118.25470767551178356.701630296
    11
    2024-04-01 00:00:00.0003114311431140.6081910551350.419559568537288238.446922626
    12
    2024-03-01 00:00:00.0006311631163112.6136869721309.643275712506147888.027363058
    13
    2024-02-01 00:00:00.0007067706770673.1694206851104.40341427443036578.384087346
    14
    2024-01-01 00:00:00.0003090309030901.500052476459.609997967372365473.980673076
    15
    2023-12-01 00:00:00.0007357357350.348576852991.92495852341465014.370675109
    16
    2023-11-01 00:00:00.0005795795790.266739976663.738877865334114922.445716589
    17
    2023-10-01 00:00:00.0006196196190.283418512860.74093795328324858.706838724
    18
    2023-09-01 00:00:00.0008128128120.38986940483.490607554322134797.965900774
    19
    2023-08-01 00:00:00.0002706270627061.196528795283.962423091314014714.475293221
    20
    2023-07-01 00:00:00.0004459445944591.957468386476.743529414286954430.51287013
    30
    3KB
    265s