LSTS | TX_COUNT | DEPOSITORS | DEPOSIT_AMOUNT | DEPOSIT_AMOUNT_USD | |
|---|---|---|---|---|---|
1 | Lron | 1559 | 1151 | 4685972.74345144 | 3671370.34737405 |
2 | rSwell | 912 | 876 | 18021005.0061351 | 752116.242565576 |
3 | ynBNB | 57 | 55 | 253.307092589 | 143501.225771487 |
SpecterLRON, rSwell and ynbnb
Updated 2025-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
),
-- Deposit Data
Deposits AS (
SELECT
'Lron' AS LSTs,
block_timestamp,
DATE_TRUNC('day', block_timestamp) AS date,
tx_hash,
origin_from_address AS depositor,
decoded_log:assets / 1e18 AS deposit_amount
FROM ronin.core.ez_decoded_event_logs
WHERE
contract_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2'
Last run: 22 days ago
3
154B
20s