flipside

    TVL trend
    damidezTVL trend
    Updated 7 days ago
    WITH Ronprice AS (
    SELECT
    DATE_TRUNC('day', hour) AS date,
    AVG(price) AS price_usd
    FROM ronin.price.ez_prices_hourly
    WHERE token_address = '0xe514d9deb7966c8be0ca922de8a064264ea6bcd4' -- Wrapped RON
    GROUP BY date
    ),
    Swellprice AS (
    SELECT
    DATE_TRUNC('day', hour) AS date,
    AVG(price) AS price_usd
    FROM ethereum.price.ez_prices_hourly
    WHERE token_address = '0x0a6e7ba5042b38349e437ec6db6214aec7b35676' -- Wrapped SWELL
    GROUP BY date
    ),
    Bnbprice AS (
    SELECT
    DATE_TRUNC('day', hour) AS date,
    AVG(price) AS price_usd
    FROM bsc.price.ez_prices_hourly
    WHERE token_address = '0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c' -- Wrapped BNB
    GROUP BY date
    ),

    DepositData AS (
    SELECT
    'Lron' AS LSTs,
    DATE_TRUNC('day', d.block_timestamp) AS date,
    SUM(d.decoded_log:assets / 1e18) AS deposit_amount
    FROM ronin.core.ez_decoded_event_logs d
    WHERE
    d.contract_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2'
    AND d.event_name = 'Deposit'
    AND d.tx_succeeded = 1
    AND block_timestamp BETWEEN '2025-03-20' AND '2025-03-31'
    Last run: 7 days ago
    LSTS
    DATE
    TOTAL_DEPOSITS
    TOTAL_WITHDRAWALS
    TVL
    TOTAL_DEPOSITS_USD
    TOTAL_WITHDRAWALS_USD
    TVL_USD
    1
    		Lron2025-03-20 00:00:00.0002320732232071182245.824553251.5705905182244.25396275
    2
    		Lron2025-03-21 00:00:00.000513645.03517765.607495879.428395683.11401952313685.619876004381997.494143518
    3
    		Lron2025-03-22 00:00:00.00022111.8542443.77119668.08317198.884731321900.79654735215298.088183969
    4
    		Lron2025-03-23 00:00:00.00029025.691052718498.6922760.6084974538254.7882807514505.820216702
    5
    		Lron2025-03-24 00:00:00.000454448.8138719883577.784450871.029871988365428.236939782876.942923741362551.294016039
    6
    		Lron2025-03-25 00:00:00.000387228.65484314632790.894354437.760843146311417.33535397326371.118732138285046.216621836
    7
    		Lron2025-03-26 00:00:00.00040331.90823584.471498816747.436501232418.94897803218957.29252862113461.656449411
    8
    		Lron2025-03-27 00:00:00.0002703957.4914251.3885409982699706.1024592118573.227177593330.998350112115242.22882748
    9
    		Lron2025-03-28 00:00:00.000268257.20673631110587.791441972257669.415294338200673.1790689497920.330617876192752.848451072
    10
    		Lron2025-03-29 00:00:00.00027670.28622856.0103601954814.27563980519835.55635317316384.4234030813451.132950091
    11
    		Lron2025-03-30 00:00:00.0007222.8044777.6088924762445.1951075245135.431701013396.8918665721738.539834438
    12
    		rSwell2024-11-07 00:00:00.0005633625.8612545814392673.1027445-8759047.24148991186137.730764394475540.899761133-289403.168996739
    13
    		rSwell2024-11-08 00:00:00.0003311282.705568463919380.91789661-608098.212328149146985.016431678173977.977673198-26992.961241521
    14
    		rSwell2024-11-09 00:00:00.0001760981.557534833298081.94662054-1537100.38908571109526.174044457205127.813947193-95601.639902736
    15
    		rSwell2024-11-10 00:00:00.000597081.2287852051395243.46504894-798162.23626373834631.76088858580926.57369458-46294.812805995
    16
    		rSwell2024-11-11 00:00:00.0001056564.99985865998671.47995480157893.51990385449304.91388319646603.2958912722701.617991923
    17
    		rSwell2024-11-12 00:00:00.000859413.1734060831185866.20568869-326453.03228260533544.30129857846286.296899276-12741.995600698
    18
    		rSwell2024-11-13 00:00:00.000261966.48273638371096.858736072190869.624000319845.0748149982671.9215605627173.153254436
    19
    		rSwell2024-11-14 00:00:00.000390751.09946786439620.742741754-48869.64327389516439.22031020518495.206418382-2055.986108177
    20
    		rSwell2024-11-15 00:00:00.0001058741.58324592474984.591209774583756.99203614540210.47860774218039.67846931322170.800138429
    33
    4KB
    34s