freeman_7pool stats
    Updated 2024-12-31
    with timeframe as (
    select
    case
    when '{{timeframe}}' = 'last 7 days' then 7
    when '{{timeframe}}' = 'last 30 days' then 30
    when '{{timeframe}}' = 'A year' then 365
    when '{{timeframe}}' = 'All time' then 2000
    else 2000
    end as time_change
    ),
    aerodrome as (
    Select
    date_trunc({{period}}, block_timestamp) as date_time,
    pool_name,
    sum(amount_in_usd) as volume,
    avg(amount_in_usd) as average_trade,
    count(distinct tx_hash) as transaction
    from
    base.defi.ez_dex_swaps
    join timeframe
    where
    block_timestamp >= current_date - time_change
    and platform ilike 'aerodrome-slipstream'
    and pool_name ilike 'USDC-WETH'
    group by
    date_time,
    pool_name
    order by
    1 desc
    ),
    univ3 as (
    select
    date_trunc({{period}}, block_timestamp) as date_time,
    --'WETH-USDC' as pool_name,
    sum(amount_in_usd) as volume,
    avg(amount_in_usd) as average_trade,
    Last run: 3 months ago
    Date Time
    POOL NAME
    Aerodrome Volume
    Univ3 Volume
    Average Trade Size(Aero)
    Average Trade Size (Uni)
    Aerodrome Pool Transaction
    Univ3 Transaction
    1
    2024-12-31 00:00:00.000USDC-WETH83492518.4875668023282.910875627963.75522782335678820
    2
    2024-12-30 00:00:00.000USDC-WETH561103337.5969655372.6122546.9475845861221.4240830822437455452
    3
    2024-12-29 00:00:00.000USDC-WETH319903108.5840312393.3118135.096858277758.8929463481739751579
    4
    2024-12-28 00:00:00.000USDC-WETH309702186.9336656441.7917438.186201014697.5934266471745250710
    5
    2024-12-27 00:00:00.000USDC-WETH561173765.9865015429.0422069.1271818471056.2511825582502959497
    6
    2024-12-26 00:00:00.000USDC-WETH479262302.4956961756.4520732.92535431042.4155707852260252988
    7
    2024-12-25 00:00:00.000USDC-WETH443060471.646348764.5823078.4702364831063.9723745471904642618
    8
    2024-12-24 00:00:00.000USDC-WETH481499629.6456677692.4121798.1633229211114.3206733782172549289
    9
    2024-12-23 00:00:00.000USDC-WETH640329173.7284434101.8722657.6969576451295.9954239452787163370
    10
    2024-12-22 00:00:00.000USDC-WETH508291479.5456723776.4822728.111229655993.0633137252211855723
    11
    2024-12-21 00:00:00.000USDC-WETH606526807.5469502456.521816.7262882631033.5091451172750965560
    12
    2024-12-20 00:00:00.000USDC-WETH704668194.27131887352.2316890.4169288111370.6426969644056692393
    13
    2024-12-19 00:00:00.000USDC-WETH669736511.15151826834.7918568.7177317841804.7766394063499781313
    14
    2024-12-18 00:00:00.000USDC-WETH674585973.03133531724.6224313.7852957291968.5363262722727666179
    15
    2024-12-17 00:00:00.000USDC-WETH583585909.798808644.5324393.3251003181642.1306697582372859054
    16
    2024-12-16 00:00:00.000USDC-WETH654650872.98103231933.1126892.7771014251737.7358029492411258186
    17
    2024-12-15 00:00:00.000USDC-WETH422715901.7857879633.2525715.7745333981255.2239866841627445142
    18
    2024-12-14 00:00:00.000USDC-WETH438786296.1755196207.3426351.9486018861235.4225198081652243810
    19
    2024-12-13 00:00:00.000USDC-WETH568000565.8680385351.4627606.3458498181563.5523119122040350361
    20
    2024-12-12 00:00:00.000USDC-WETH667005199.28116523999.6325952.4998747131893.6215101972533359964
    ...
    245
    26KB
    14s