EVENT_NAME | Total Users | Total Volume (USD) | |
|---|---|---|---|
1 | Borrow | 108 | 16276684.7205821 |
2 | Repay | 75 | 12431622.6624152 |
3 | Deposit | 189 | 39542200.4535744 |
4 | Withdraw | 119 | 31799212.0076773 |
Mrftitricky-plum
Updated 12 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
›
⌄
-- forked from tricky-plum copy @ https://flipsidecrypto.xyz/studio/queries/3146f5c6-78de-4a57-9c56-4123ce0dd2c6
WITH assettbl AS (
SELECT
origin_from_address AS user,
DATE_TRUNC('day', block_timestamp) AS date,
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 -- Using AVG to handle multiple hourly price records
FROM
crosschain.price.ez_prices_hourly
WHERE
blockchain = 'ethereum'
Last run: about 12 hours agoAuto-refreshes every 12 hours
4
130B
5s