DATE | TXS | USERS | VOLUME | CUMULATIVE_TRANSACTIONS | CUMULATIVE_USERS | |
|---|---|---|---|---|---|---|
1 | 2025-04-05 00:00:00.000 | 1 | 1 | 0.0001288019877 | 2815 | 695 |
2 | 2025-04-04 00:00:00.000 | 6 | 4 | 4.501776124 | 2814 | 694 |
3 | 2025-04-03 00:00:00.000 | 24 | 3 | 156.480324087 | 2808 | 690 |
4 | 2025-04-02 00:00:00.000 | 28 | 5 | 325.566735946 | 2784 | 687 |
5 | 2025-04-01 00:00:00.000 | 29 | 4 | 3.31510828 | 2756 | 682 |
6 | 2025-03-31 00:00:00.000 | 105 | 9 | 50.362564325 | 2727 | 678 |
7 | 2025-03-30 00:00:00.000 | 37 | 8 | 2.966290679 | 2622 | 669 |
8 | 2025-03-29 00:00:00.000 | 5 | 3 | 1.601031788 | 2585 | 661 |
9 | 2025-03-28 00:00:00.000 | 22 | 6 | 51.112529872 | 2580 | 658 |
10 | 2025-03-27 00:00:00.000 | 33 | 10 | 62.771172196 | 2558 | 652 |
11 | 2025-03-26 00:00:00.000 | 40 | 13 | 210.91291867 | 2525 | 642 |
12 | 2025-03-25 00:00:00.000 | 74 | 11 | 4102.89148601 | 2485 | 629 |
13 | 2025-03-24 00:00:00.000 | 13 | 6 | 176.938764035 | 2411 | 618 |
14 | 2025-03-23 00:00:00.000 | 28 | 1 | 1.666688199 | 2398 | 612 |
15 | 2025-03-22 00:00:00.000 | 9 | 5 | 7.225882252 | 2370 | 611 |
16 | 2025-03-21 00:00:00.000 | 5 | 5 | 27.667700559 | 2361 | 606 |
17 | 2025-03-20 00:00:00.000 | 34 | 4 | 33.156460958 | 2356 | 601 |
18 | 2025-03-19 00:00:00.000 | 33 | 10 | 86.84355989 | 2322 | 597 |
19 | 2025-03-18 00:00:00.000 | 12 | 4 | 43.53592935 | 2289 | 587 |
20 | 2025-03-17 00:00:00.000 | 11 | 3 | 338.346438535 | 2277 | 583 |
SniperDaily Users
Updated 22 hours 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: about 22 hours ago
70
4KB
7s