CONTRACT_NAME | CONTRACT_ADDRESS | DEPOSIT_AMOUNT | TX_HASH | BLOCK_TIMESTAMP | |
|---|---|---|---|---|---|
1 | tsEnaUsde | 0x0d7e8e1aa35148adb65e7487b8bda6af1bf37b7c | 87.863097 | 0xfb60c90a4bff1ffaeb5b2777c889fa4cf2fa6a0c103cb7fcd652b936845ef2dc | 2025-01-29 10:12:25.000 |
2 | tsWeethRsETH | 0x4c399de501e8d9e6fc65e2612fd9350d717e32da | 0.688788 | 0x4e4ad2f2e2c116dc4fbedae4578b1fb1c0233804e0efe66c55a12736c85dc6a0 | 2025-01-28 11:26:57.000 |
3 | tsEnaUsde | 0x0d7e8e1aa35148adb65e7487b8bda6af1bf37b7c | 1944.4501 | 0xc997bc8581d0efa631ce8c27fc3c327b98e14f33a311ef228b8d158f78b31ed4 | 2025-01-30 14:19:37.000 |
4 | tsPzethEzeth | 0x9baa086a096504e90583bc2c91a75350ab426f33 | 0.842 | 0x259320141cf89358de0bb3219aeab2643df852d3d1c829de7cde0db23314d74a | 2025-02-01 16:51:19.000 |
5 | tsSwellETH | 0x7fe118bee84900faed30dab9ecfbead633392f05 | 3459.351 | 0x27bffaf4091ef582dfb668201eb0a1f01b2469735fc2e3c2ddd4fe1552006641 | 2025-02-05 12:27:05.000 |
6 | tsSwellETH | 0x7fe118bee84900faed30dab9ecfbead633392f05 | 155673.5535 | 0x7df5837e69f9bb6cc8723dae76562275d05214365ec9a69b8b533de29e05d96e | 2025-01-31 14:51:31.000 |
7 | tsSwellETH | 0x7fe118bee84900faed30dab9ecfbead633392f05 | 153192.1447 | 0x4102fc50d0730db7fa958dfa100a2412621f7ef3df23e50e3d77f3d3a793d115 | 2025-01-29 14:33:57.000 |
8 | tsWeethRsETH | 0x4c399de501e8d9e6fc65e2612fd9350d717e32da | 0.234217 | 0xb2db1e91ae6b24b432a03e9d5eea8246b6c00855ae187714b937f4fd5295db5c | 2025-01-28 15:28:55.000 |
9 | tsSwellETH | 0x7fe118bee84900faed30dab9ecfbead633392f05 | 209192.6015 | 0xc2e979e8c1197f873cf47be2283e1c65935cd86171fe9a6856325216e0425287 | 2025-01-29 12:15:53.000 |
10 | tsWeethRsETH | 0x4c399de501e8d9e6fc65e2612fd9350d717e32da | 14.3 | 0xd8b5fc5fbbabb5c434fabb30f2f1e9626d16ab97ae754f7bbda3361c17cf7ced | 2025-02-05 18:23:49.000 |
11 | tsWeethRsETH | 0x4c399de501e8d9e6fc65e2612fd9350d717e32da | 3.471881 | 0xcfb2442d0b06690b2d8b0ebb12ad8c848aa64fcbd635bf895a1eadecc2f8f4f2 | 2025-01-28 11:18:07.000 |
12 | tsSwellETH | 0x7fe118bee84900faed30dab9ecfbead633392f05 | 4000 | 0x3ba29c8cb4619746648acefd3202e9627ace053d3d60c9a36cf027c28a24a3d4 | 2025-01-31 00:46:03.000 |
13 | tsEnaUsde | 0x0d7e8e1aa35148adb65e7487b8bda6af1bf37b7c | 46.677918 | 0xbdd0913f5f71f7e37d7da8e029c459cbac8811bbd5aea773280b9bbac5da1961 | 2025-01-31 00:37:55.000 |
14 | tsPzethEzeth | 0x9baa086a096504e90583bc2c91a75350ab426f33 | 0.7127 | 0x1019a36128dbe9e677d18ea30931b97ed84b121a2d384e0b198b85644a7eb22b | 2025-01-28 16:21:59.000 |
15 | tsSwellETH | 0x7fe118bee84900faed30dab9ecfbead633392f05 | 30841.5658 | 0x64ed1aebb68b3ffcfd73980e158467310a5c7e29dd72a209f212191b3ede9d1d | 2025-01-30 00:44:19.000 |
16 | tsSwellETH | 0x7fe118bee84900faed30dab9ecfbead633392f05 | 152938.1532 | 0x6b1a226355c3e823149b7227596b802e8de9595c3bf8301a9ccf0ea1e3a75eca | 2025-01-29 12:22:23.000 |
17 | tsWeethRsETH | 0x4c399de501e8d9e6fc65e2612fd9350d717e32da | 3.777534 | 0x1f8fbf8ed21213f46119bfb3900a1657339bd858aea53cc1a2079b256a4c9662 | 2025-01-28 02:31:25.000 |
18 | tsWeethRsETH | 0x4c399de501e8d9e6fc65e2612fd9350d717e32da | 2.956796 | 0xfa0a884e21bc1edf0610a0ce113d1628dbd38699fd1f3e32a01367c75e94a409 | 2025-01-30 22:52:53.000 |
19 | tsEnaUsde | 0x0d7e8e1aa35148adb65e7487b8bda6af1bf37b7c | 58.374094 | 0x727cd48c8231b5ea3c44ada3593fe65d40ff2421883852f9336bf186c357fbbf | 2025-01-28 07:24:09.000 |
20 | tsSwellETH | 0x7fe118bee84900faed30dab9ecfbead633392f05 | 146860.4324 | 0x81b1808c9609868799440512574cf7e8bbd746cc3a962a04e9b589bcfd4e5899 | 2025-01-28 05:02:23.000 |
datavortexultimate-moccasin
Updated 2025-02-07
999
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
›
⌄
⌄
SELECT DISTINCT contract_name, contract_address,
(decoded_log:assets[1])/1e18 AS deposit_amount,
tx_hash, block_timestamp
FROM swell.core.ez_decoded_event_logs
WHERE event_name = 'Deposits'
/*
WITH deposits AS (
SELECT DISTINCT
contract_name,
contract_address,
(decoded_log:assets[1]) AS deposit_amount,
tx_hash,
block_timestamp
FROM swell.core.ez_decoded_event_logs
WHERE event_name = 'Deposits'
),
prices AS (
SELECT
LOWER(name) AS name,
LOWER(symbol) AS symbol,
date_trunc('hour', hour) AS hour,
price,
decimals
FROM ethereum.price.ez_prices_hourly
WHERE LOWER(symbol) ILIKE '%swell%'
)
SELECT
COUNT(DISTINCT d.tx_hash) AS total_deposit_transactions,
COUNT(DISTINCT d.contract_address) AS total_depositors,
SUM(d.deposit_amount) AS total_eth_deposited,
SUM(
CASE
WHEN LOWER(p.symbol) = 'swell'
Last run: 3 months ago
38
6KB
2s