HolonymHolonym - Fee and User Over Time
    Updated 6 hours ago
    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 6 hours agoAuto-refreshes every 24 hours
    Date
    Users
    Growth of the number of users
    Fees in USD
    Cumulative fees in USD
    1
    2023-07-16 00:00:00.0002222241.452688096241.452688096
    2
    2023-07-17 00:00:00.0005980670.788753275912.241441371
    3
    2023-07-18 00:00:00.00042120418.3415698451330.583011216
    4
    2023-07-19 00:00:00.000952111125.3364991132455.919510329
    5
    2023-07-20 00:00:00.00044254512.9541802352968.873690564
    6
    2023-07-21 00:00:00.00057309634.171625583603.045316144
    7
    2023-07-22 00:00:00.00050359510.3917414654113.437057609
    8
    2023-07-23 00:00:00.00039398412.9470514254526.384109035
    9
    2023-07-24 00:00:00.00035433381.4779898014907.862098835
    10
    2023-07-25 00:00:00.00037469380.1456272265288.007726061
    11
    2023-07-26 00:00:00.00039505399.7433092355687.751035296
    12
    2023-07-27 00:00:00.0001166201226.4256095516914.176644847
    13
    2023-07-28 00:00:00.0002258432324.5052288219238.681873668
    14
    2023-07-29 00:00:00.00026311012736.90841672211975.59029039
    15
    2023-07-30 00:00:00.00042415194331.41304795116307.00333834
    16
    2023-07-31 00:00:00.00050120075248.12623637921555.129574719
    17
    2023-08-01 00:00:00.00042824224475.95812586226031.087700581
    18
    2023-08-02 00:00:00.00025626712640.58789245928671.675593039
    19
    2023-08-03 00:00:00.00021228732123.84365537730795.519248416
    20
    2023-08-04 00:00:00.00021330832230.26272205833025.781970474
    ...
    578
    39KB
    121s