DATE | SYMBOL | TXS | USERS | CUMULATIVE_TRANSACTIONS | CUMULATIVE_USERS | |
|---|---|---|---|---|---|---|
1 | 2025-04-19 00:00:00.000 | WEETH | 7 | 2 | 3920 | 1464 |
2 | 2025-04-19 00:00:00.000 | WETH | 17 | 2 | 3920 | 1464 |
3 | 2025-04-18 00:00:00.000 | SWETH | 2 | 2 | 3896 | 1460 |
4 | 2025-04-18 00:00:00.000 | RSWETH | 2 | 1 | 3896 | 1460 |
5 | 2025-04-18 00:00:00.000 | WEETH | 8 | 4 | 3896 | 1460 |
6 | 2025-04-18 00:00:00.000 | WETH | 15 | 8 | 3896 | 1460 |
7 | 2025-04-17 00:00:00.000 | WETH | 21 | 6 | 3869 | 1445 |
8 | 2025-04-17 00:00:00.000 | WEETH | 12 | 4 | 3869 | 1445 |
9 | 2025-04-16 00:00:00.000 | RSETH | 2 | 1 | 3836 | 1435 |
10 | 2025-04-16 00:00:00.000 | WSTETH | 1 | 1 | 3836 | 1435 |
11 | 2025-04-16 00:00:00.000 | RSWETH | 1 | 1 | 3836 | 1435 |
12 | 2025-04-16 00:00:00.000 | SWETH | 5 | 1 | 3836 | 1435 |
13 | 2025-04-16 00:00:00.000 | WETH | 10 | 6 | 3836 | 1435 |
14 | 2025-04-16 00:00:00.000 | EZETH | 3 | 3 | 3836 | 1435 |
15 | 2025-04-15 00:00:00.000 | WEETH | 2 | 1 | 3814 | 1422 |
16 | 2025-04-15 00:00:00.000 | WSTETH | 5 | 1 | 3814 | 1422 |
17 | 2025-04-15 00:00:00.000 | RSETH | 2 | 1 | 3814 | 1422 |
18 | 2025-04-15 00:00:00.000 | RSWETH | 14 | 3 | 3814 | 1422 |
19 | 2025-04-15 00:00:00.000 | WETH | 27 | 6 | 3814 | 1422 |
20 | 2025-04-15 00:00:00.000 | SWETH | 2 | 1 | 3814 | 1422 |
SniperDaly Transactions by Pool
Updated 6 days ago
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
›
⌄
with tbl as( select
a.BLOCK_TIMESTAMP::date as date_,
'Borrow' as type,
case
when c.contract_address = '0x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef3' then 'WEETH'
when c.contract_address = '0x49c077b74292aa8f589d39034bf9c1ed1825a608' then 'WETH'
when c.contract_address = '0x29c85c752e854b0cf2372e6b6c56f260755f5120' then 'PZETH'
when c.contract_address = '0x4a5c95a0e3fca4148f91ceb637fba0e1080be40e' then 'EZETH'
when c.contract_address = '0x3c12aa52b014acf7957308808362909b5757cca8' then 'WSTETH'
when c.contract_address = '0x1773002742a2bcc7666e38454f761ce8fe613de5' then 'RSWETH'
when c.contract_address = '0xf34253ec3dd0cb39c29cf5eeb62161fb350a9d14' then 'SWETH'
when c.contract_address = '0x46e3c018798d6de4517a3c98358e4bd8d334b79c' then 'RSETH'
when c.contract_address = '0xf18de8d3bcf95da46bb667c8a222956199b94e6c' then 'WETH'
when c.contract_address = '0x522d58aefb7b4f54fc1bd31b5063e55c7984badd' then 'SWELL'
end as symbol,
a.tx_hash as tx,
a.from_address as user,
DECODED_LOG:assets/pow(10,18) as amount
from
swell.core.fact_transactions a
left join
swell.core.fact_event_logs b
on a.tx_hash = b.tx_hash
join
swell.core.ez_decoded_event_logs c
on b.contract_address = c.contract_address and a.tx_hash = c.tx_hash
where
-- a.TO_ADDRESS = '0x08739cbede6e28e387685ba20e6409bd16969cde'
--and
c.EVENT_NAME = 'Borrow'
and b.topics[0] = '0x80b61abbfc5f73cfe5cf93cec97a69ed20643dc6c6f1833b05a1560aa164e24c'
and c.topics[0] = '0xcbc04eca7e9da35cb1393a6135a199ca52e450d5e9251cbd99f7847d33a36750'
-- and c.contract_address = '0x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef3'
-- and c.contract_address = '0x49c077b74292aa8f589d39034bf9c1ed1825a608'
and c.TX_SUCCEEDED = 'TRUE'
-- GROUP by 1,2
Last run: 6 days ago
...
454
22KB
8s