neo_nguyenBera era fee
    Updated 6 hours ago
    with

    bera_era_db as(
    select
    *
    from
    $query('dad38d26-487c-4b71-8fc6-b64f9fea599c')
    ),

    bera_era_price as(
    select
    date(hour) date,
    replace(replace(symbol, 'W', ''), 'USDC', 'USD') assets,
    avg(price) price
    from
    ethereum.price.ez_prices_hourly
    where
    token_address in (
    '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599',
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',
    '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
    )
    group by
    1,
    2
    order by
    date desc
    limit
    3000
    ),

    bera_era_fees as(
    select
    date(block_timestamp) date,
    pool,
    asset,
    Last run: about 6 hours agoAuto-refreshes every 24 hours
    DATE
    FIRST_TIME
    POOL
    FEES
    FEES_USD
    FEES_ALL
    1
    2025-06-09 00:00:00.0002025-06-09 04:20:23.000liquidBeraETH0.003052715157.71080674491484.362887002
    2
    2025-06-08 00:00:00.0002025-06-08 12:36:59.000liquidBeraETH0.0024019935436.05217202291476.652080259
    3
    2025-06-08 00:00:00.0002025-06-08 01:58:47.000sUSDe (Bera Concrete)0.59132817870.591191310945977.499281078
    4
    2025-06-07 00:00:00.0002025-06-07 22:15:23.000sUSDe (Bera Concrete)7.8652239147.86342605545976.908089767
    5
    2025-06-07 00:00:00.0002025-06-07 20:58:59.000liquidBeraETH0.00017750565920.443588787291470.599908237
    6
    2025-06-06 00:00:00.0002025-06-06 08:18:23.000sUSDe (Bera Concrete)1.2294543161.22919162245969.044663712
    7
    2025-06-05 00:00:00.0002025-06-05 03:55:47.000liquidBeraETH0.0031777816888.22365544291470.156319449
    8
    2025-06-04 00:00:00.0002025-06-04 04:26:11.000sUSDe (Bera Concrete)0.12764959980.127621777545967.81547209
    9
    2025-06-03 00:00:00.0002025-06-03 04:29:35.000sUSDe (Bera Concrete)3.9253294883.92448734245967.687850312
    10
    2025-06-02 00:00:00.0002025-06-02 01:57:59.000liquidBeraETH0.00052552326881.32285768391461.932664007
    11
    2025-06-02 00:00:00.0002025-06-02 07:30:59.000sUSDe (Bera Concrete)0.1629363960.162901894245963.763362971
    12
    2025-06-01 00:00:00.0002025-06-01 16:17:47.000liquidBeraETH0.0907828879228.51304932891460.609806325
    13
    2025-06-01 00:00:00.0002025-06-01 04:29:35.000sUSDe (Bera Concrete)4.6963855594.69537642345963.600461076
    14
    2025-05-31 00:00:00.0002025-05-31 16:05:47.000sUSDe (Bera Concrete)0.69532974450.695194560845958.905084653
    15
    2025-05-31 00:00:00.0002025-05-31 02:58:35.000liquidBeraETH0.00402079437210.16571409991232.096756996
    16
    2025-05-30 00:00:00.0002025-05-30 06:05:59.000liquidBeraETH0.05131647636133.74418657691221.931042898
    17
    2025-05-28 00:00:00.0002025-05-28 06:10:59.000liquidBeraETH1.7397931774603.07374715491088.186856322
    18
    2025-05-28 00:00:00.0002025-05-28 04:07:59.000sUSDe (Bera Concrete)5510.4040165335509.1928756545958.209890092
    19
    2025-05-27 00:00:00.0002025-05-27 13:41:47.000liquidBeraETH0.0191919101250.26346867186485.113109168
    20
    2025-05-26 00:00:00.0002025-05-26 07:57:11.000sUSDe (Bera Concrete)6.0962375236.09477315540449.017014442
    ...
    797
    90KB
    59s