USER | Total Events (USD) | |
---|---|---|
1 | 0x1b648ade1ef219c87987cd60eba069a7faf1621f | 22488884.2022619 |
2 | 0x0c883bacaf927076c702fd580505275be44fb63e | 21832645.2506337 |
3 | 0x29dfdd80d6acc0f9028d8a6fa7d7d448342e25c1 | 7950718.97201739 |
4 | 0x5c0642fe68fc72cf03f676b28faf5cf97cc0b265 | 5590283.39904498 |
5 | 0xfc88e456b3a5620e63a449ce429dccf2687cac26 | 4334455.02008888 |
6 | 0xa6086e3190c145f1b6b089de98b1866296137a50 | 4249811.9513994 |
7 | 0x19391f0a0d3b6409e57faef5f62bc509433b3d2e | 3713385.70289559 |
8 | 0xacae46375cef811bab8f3d572b2dab327085c609 | 3492654.15906251 |
9 | 0xe641e37ea4846374c4b9347af6a4979acae79cbc | 2714566.73318527 |
10 | 0xbc3a058d1c919f6b1f48e8846246d04d467902c8 | 2534354.4971875 |
11 | 0xf91d92176255b58bb631e36973e44cae271570a5 | 2087582.93096338 |
12 | 0x5b9effdcbd65946f2b143725dc244563248aa4ee | 1740631.20007532 |
13 | 0x2d689f316cd3b7a0faa03f341ef0137fb0cdb70c | 1661613.0748412 |
14 | 0xcdbcf8b223e7b2612a394a83caf6052ff79d7030 | 1246613.46282814 |
15 | 0x1fe6eb1add4a58d9ca4fe68467492f9a1a350d4d | 799277.930325327 |
16 | 0x42ed8ca138de808fd22afc29928f09ad4a31e7c3 | 782873.982359433 |
17 | 0x2ccebdf8f9d2da7ba0cdae60886cdac4f827a568 | 703892.332446992 |
18 | 0xefc0f8be7afd2eb878956450d1f484cfb3368417 | 668531.293557266 |
19 | 0x1d098a8d7fa63a39e0884b720f86f9ba8cbbeef1 | 667607.112459411 |
20 | 0x4086f688855dcae061e7f68fc181566fffa856ea | 632192.13152387 |
Mrftitricky-plum copy
Updated 10 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 @ https://flipsidecrypto.xyz/studio/queries/4486e2a6-3c7a-4a9f-bd79-e1ad1a68e6fc
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
FROM
crosschain.price.ez_prices_hourly
WHERE
blockchain = 'ethereum'
GROUP BY 1, 2
)
Last run: about 10 hours agoAuto-refreshes every 12 hours
100
6KB
179s