DATE | EVENT_NAME | Total Volume (USD) | Cumulative Volume | |
|---|---|---|---|---|
1 | 2025-03-17 00:00:00.000 | Withdraw | 1212.057497945 | 31801795.3910642 |
2 | 2025-03-17 00:00:00.000 | Borrow | 328383.771088447 | 16606302.8239813 |
3 | 2025-03-17 00:00:00.000 | Repay | 51666.782618447 | 12483278.1083368 |
4 | 2025-03-17 00:00:00.000 | Deposit | 312633.616787788 | 39857566.6586601 |
5 | 2025-03-16 00:00:00.000 | Repay | 1031.260799717 | 12431611.3257184 |
6 | 2025-03-16 00:00:00.000 | Withdraw | 3996.749040701 | 31800583.3335663 |
7 | 2025-03-16 00:00:00.000 | Deposit | 3445.235944512 | 39544933.0418723 |
8 | 2025-03-16 00:00:00.000 | Borrow | 1234.332310808 | 16277919.0528929 |
9 | 2025-03-15 00:00:00.000 | Withdraw | 240.549400417 | 31796586.5845256 |
10 | 2025-03-15 00:00:00.000 | Deposit | 1300.483327652 | 39541487.8059278 |
11 | 2025-03-15 00:00:00.000 | Borrow | 1040.8037122 | 16276684.7205821 |
12 | 2025-03-14 00:00:00.000 | Borrow | 51463.69366979 | 16275643.9168699 |
13 | 2025-03-14 00:00:00.000 | Deposit | 64826.676576447 | 39540187.3226001 |
14 | 2025-03-14 00:00:00.000 | Withdraw | 30363.928202035 | 31796346.0351252 |
15 | 2025-03-14 00:00:00.000 | Repay | 4554.215 | 12430580.0649186 |
16 | 2025-03-13 00:00:00.000 | Repay | 9653.236974328 | 12426025.8499186 |
17 | 2025-03-13 00:00:00.000 | Deposit | 13618.246899304 | 39475360.6460237 |
18 | 2025-03-13 00:00:00.000 | Withdraw | 11092.823362145 | 31765982.1069232 |
19 | 2025-03-13 00:00:00.000 | Borrow | 9061.497859666 | 16224180.2232001 |
20 | 2025-03-12 00:00:00.000 | Repay | 445.424705476 | 12416372.6129443 |
Mrftitricky-plum
Updated 13 hours ago
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 assettbl AS (
SELECT
origin_from_address AS user,
DATE_TRUNC('day', block_timestamp) AS date, -- Include the date column
CASE
WHEN contract_name = 'EVK Vault eswETH-1' THEN 'SWETH'
WHEN contract_name = 'EVK Vault epzETH-1' THEN 'PZETH'
WHEN contract_name = 'EVK Vault eweETH-1' THEN 'WEETH'
WHEN contract_name = 'EVK Vault eezETH-1' THEN 'EZETH'
WHEN contract_name = 'EVK Vault eWETH-1' THEN 'WETH'
WHEN contract_name = 'EVK Vault ersETH-1' THEN 'RSETH'
WHEN contract_name = 'EVK Vault erswETH-1' THEN 'RSWETH'
WHEN contract_name = 'EVK Vault ewstETH-1' THEN 'WSTETH'
END AS token,
contract_address,
event_name,
SUM(decoded_log:assets / POW(10, 18)) AS amount
FROM
swell.core.ez_decoded_event_logs
WHERE
event_name IN ('Deposit', 'Borrow', 'Repay', 'Withdraw')
AND origin_to_address = '0x08739cbede6e28e387685ba20e6409bd16969cde'
GROUP BY 1, 2, 3, 4, 5
),
pricetbl AS (
SELECT
DATE_TRUNC('day', hour) AS date,
symbol,
AVG(price) AS price
FROM
crosschain.price.ez_prices_hourly
WHERE
blockchain = 'ethereum'
GROUP BY 1, 2
)
Last run: about 13 hours agoAuto-refreshes every 12 hours
...
186
13KB
142s