flipside

    Capy 2
    SajjadiiiCapy 2
    Updated 2025-03-18
    with current_price_tab AS (

    SELECT
    hour::date as date,
    avg(price)::string as price,
    'WETH' :: string AS token_symbol,
    '0x98a8345bb9d3dda9d808ca1c9142a28f6b0430e1' :: string AS token_contract,
    '0x3ce1aa52eeaf57a355939c09ac76f03f01988f13' :: string AS pool_contract_address
    FROM ethereum.price.ez_prices_hourly
    WHERE symbol = 'WETH'
    AND token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    AND hour::date >= current_date - interval '365 day'
    GROUP BY 1

    UNION all

    SELECT
    hour::date as date,
    avg(price)::string as price,
    'WKLAY' :: string AS token_symbol,
    '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432' :: string AS token_contract,
    '0x8a5562d2a17488647381c1a0e9cf527a01b6f3bd' :: string AS pool_contract_address
    FROM kaia.price.ez_prices_hourly
    WHERE symbol = 'KLAY'
    AND hour::date >= current_date - interval '365 day'
    GROUP BY 1

    UNION all

    SELECT
    hour::date as date,
    '1'::string as price,
    'USDT' :: string AS token_symbol,
    '0x5c13e303a62fc5dedf5b52d66873f2e59fedadc2' :: string AS token_contract,
    '0xa856b5da8e85b23395c17783954edda010317fce' :: string AS pool_contract_address
    FROM kaia.price.ez_prices_hourly
    Last run: 19 days ago
    Date
    Functions
    Txs Count
    Users Count
    Cumulative Txs
    Cumulative LP providers
    Net Amount $USD
    TVL
    Total LP Providers
    Liquidity Amount in $USD
    1
    		2024-09-09 00:00:00.000Add Liquidity82611391155325101.18574135534193.135800065605325101.1857413
    2
    		2024-08-26 00:00:00.000Remove Liquidity0000560
    3
    		2024-12-09 00:00:00.000Remove Liquidity1916426304-2184391.7677042614818850.1534171560-2184391.76770426
    4
    		2025-02-17 00:00:00.000Add Liquidity1110702503190103.03177315329049646.7373378560190103.031773153
    5
    		2024-09-02 00:00:00.000Add Liquidity50485754206048.600701242209091.950058758560206048.600701242
    6
    		2024-09-09 00:00:00.000Remove Liquidity66145121-50570.9052992485584764.0410993560-50570.905299248
    7
    		2024-10-28 00:00:00.000Add Liquidity001791496212128.90204746560
    8
    		2025-03-03 00:00:00.000Remove Liquidity22730517-1910.90065499830184134.272599560-1910.900654998
    9
    		2024-12-09 00:00:00.000Add Liquidity78455043492841082.9548643817659933.10828155602841082.95486438
    10
    		2025-02-10 00:00:00.000Add Liquidity7668048714437.86070243228791891.679400156014437.860702432
    11
    		2024-12-23 00:00:00.000Remove Liquidity1611553383-390063.48702406718974260.7586551560-390063.487024067
    12
    		2025-03-03 00:00:00.000Add Liquidity77737524313.40308214530184447.6756812560313.403082145
    13
    		2024-09-23 00:00:00.000Add Liquidity86153127272266.2106648285857030.25176413560272266.210664828
    14
    		2024-12-02 00:00:00.000Add Liquidity101464072881039682.5089390212634458.38571295601039682.50893902
    15
    		2024-11-18 00:00:00.000Add Liquidity1510237190919047.4280358947931529.49945419560919047.428035894
    16
    		2024-11-11 00:00:00.000Remove Liquidity77217175-385674.8672526886986870.84507806560-385674.867252688
    17
    		2024-10-14 00:00:00.000Add Liquidity11170142623.0660908066159138.38899974560623.066090806
    18
    		2024-09-23 00:00:00.000Remove Liquidity22155129-272266.1947241676129296.4464883560-272266.194724167
    19
    		2025-01-27 00:00:00.000Remove Liquidity66657468-50464.39503403528298253.0307055560-50464.395034035
    20
    		2024-10-07 00:00:00.000Remove Liquidity001681406157892.25266432560
    60
    6KB
    90s