DAILY | LABEL_TYPE | TXNS | Active Daily Contracts | |
|---|---|---|---|---|
1 | 2024-09-17 00:00:00.000 | dapp | 12796 | 14 |
2 | 2024-10-11 00:00:00.000 | dapp | 17693 | 15 |
3 | 2024-09-05 00:00:00.000 | dapp | 17489 | 16 |
4 | 2024-08-20 00:00:00.000 | defi | 3242 | 38 |
5 | 2024-07-18 00:00:00.000 | dex | 20735 | 1145 |
6 | 2024-07-05 00:00:00.000 | bridge | 9523 | 34 |
7 | 2024-07-31 00:00:00.000 | bridge | 5846 | 33 |
8 | 2024-08-30 00:00:00.000 | dex | 31170 | 1433 |
9 | 2024-07-21 00:00:00.000 | games | 139252 | 225 |
10 | 2024-10-01 00:00:00.000 | dapp | 16771 | 15 |
11 | 2024-09-24 00:00:00.000 | dapp | 17267 | 17 |
12 | 2024-11-05 00:00:00.000 | nft | 2276 | 12 |
13 | 2024-09-22 00:00:00.000 | dex | 23635 | 1291 |
14 | 2024-10-23 00:00:00.000 | dex | 31522 | 1314 |
15 | 2024-01-09 00:00:00.000 | defi | 9088 | 87 |
16 | 2024-12-20 00:00:00.000 | games | 217271 | 204 |
17 | 2024-12-20 00:00:00.000 | bridge | 10361 | 41 |
18 | 2025-01-29 00:00:00.000 | dex | 23840 | 1059 |
19 | 2025-02-03 00:00:00.000 | dex | 92616 | 1171 |
20 | 2025-01-19 00:00:00.000 | bridge | 7551 | 36 |
MasiDaily Numbers Per Label Type
Updated 2025-02-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select trunc(a.block_timestamp,'day') as daily,
label_type,
count(DISTINCT tx_hash) as txns,
count(DISTINCT contract_address) as "Active Daily Contracts"
from kaia.core.fact_event_logs a join kaia.core.dim_labels b on a.contract_address = b.address
where a.TX_SUCCEEDED = 'TRUE'
and label_type != 'token'
and label_type != 'chadmin'
and label_type is not null
and block_timestamp::Date >= '2024-01-01'
group by 1,2
Last run: 2 months ago
...
2456
106KB
52s