Date | Label | Transactions | Users | |
|---|---|---|---|---|
1 | 2024-01-28 00:00:00.000 | Unlabeled | 221220 | 54959 |
2 | 2024-01-28 00:00:00.000 | Wrapped Ether | 6732 | 2440 |
3 | 2024-01-28 00:00:00.000 | Merkly ONFT | 1114 | 378 |
4 | 2024-01-28 00:00:00.000 | PancakeSwap | 685 | 498 |
5 | 2024-01-28 00:00:00.000 | Uniswap | 608 | 311 |
6 | 2024-01-28 00:00:00.000 | Base Bridge | 300 | 1 |
7 | 2024-01-28 00:00:00.000 | Bald | 103 | 79 |
8 | 2024-01-28 00:00:00.000 | OasisSwap | 17 | 17 |
9 | 2024-01-28 00:00:00.000 | Base Genesis NFT | 13 | 8 |
10 | 2024-01-28 00:00:00.000 | Based | 7 | 7 |
11 | 2024-01-28 00:00:00.000 | Pira Passport | 1 | 1 |
12 | 2024-01-27 00:00:00.000 | Unlabeled | 208377 | 54898 |
13 | 2024-01-27 00:00:00.000 | Wrapped Ether | 8969 | 2535 |
14 | 2024-01-27 00:00:00.000 | Merkly ONFT | 1022 | 394 |
15 | 2024-01-27 00:00:00.000 | PancakeSwap | 813 | 496 |
16 | 2024-01-27 00:00:00.000 | Uniswap | 614 | 292 |
17 | 2024-01-27 00:00:00.000 | Base Bridge | 230 | 1 |
18 | 2024-01-27 00:00:00.000 | Bald | 81 | 72 |
19 | 2024-01-27 00:00:00.000 | OasisSwap | 20 | 20 |
20 | 2024-01-27 00:00:00.000 | Base Genesis NFT | 14 | 12 |
alitaslimiProtocols Over Time
Updated 2024-01-29
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
›
⌄
select
block_timestamp::date as "Date",
case origin_to_address
when '0x27d2decb4bfc9c76f0309b8e88dec3a601fe25a8' then 'Bald'
when '0x3666f603cc164936c1b87e207f36beba4ac5f18a' then 'Base Bridge'
when '0x1fc10ef15e041c5d3c54042e52eb0c54cb9b710c' then 'Base Genesis NFT'
when '0xc85f505b43fcbffbf7808a55bc4e8cecac18d85b' then 'Based'
when '0xc4623408e3060f3c57e1a8d3716123f478e5d82f' then 'CBSwap'
when '0xfcd3842f85ed87ba2889b4d35893403796e67ff1' then 'LeetSwap'
when '0xf882c982a95f4d3e8187efe12713835406d11840' then 'Merkly ONFT'
when '0xb588a34afa5be3f3af703159fb6586a2caf04ba8' then 'OasisSwap'
when '0x327df1e6de05895d2ab08513aadd9313fe505d86' then 'PancakeSwap'
when '0x89518f11346c761c48cb7086bbd2008806f75149' then 'Pira Passport'
when '0xb21d7fdc1b8e3cdbe2061e1f05fd094f46ef2f47' then 'Rainbow Road'
when '0x4cf76043b3f97ba06917cbd90f9e3a2aac1b306e' then 'Uniswap'
when '0xbceb0ee20ed1489dbea44db08a1e95004ca2753a' then 'Uniswap'
when '0xfb7ef66a7e61224dd6fcd0d7d9c3be5c8b049b9f' then 'Uniswap'
when '0xaaa3b1f1bd7bcc97fd1917c18ade665c5d31f066' then 'Uniswap'
when '0x4200000000000000000000000000000000000006' then 'Wrapped Ether'
else 'Unlabeled'
end as "Label",
count(distinct tx_hash) as "Transactions",
count(distinct origin_from_address) as "Users"
from
base.core.ez_decoded_event_logs
where
tx_status = 'SUCCESS'
and block_timestamp::date between '2023-07-13' and (current_date - 1)
group by
"Date",
"Label"
order by
"Date" desc,
"Transactions" desc
Last run: over 1 year agoAuto-refreshes every 6 hours
...
2172
102KB
49s