DATE | USERS | PROTOCOL | |
|---|---|---|---|
1 | 2023-09-25 00:00:00.000 | 887 | Nostra |
2 | 2023-04-16 00:00:00.000 | 635 | Nostra |
3 | 2024-01-05 00:00:00.000 | 1085 | Nostra |
4 | 2023-05-10 00:00:00.000 | 103 | Nostra |
5 | 2023-11-22 00:00:00.000 | 1366 | Nostra |
6 | 2023-06-04 00:00:00.000 | 241 | Nostra |
7 | 2024-02-01 00:00:00.000 | 924 | Nostra |
8 | 2023-11-06 00:00:00.000 | 854 | Nostra |
9 | 2023-12-08 00:00:00.000 | 643 | Nostra |
10 | 2023-03-26 00:00:00.000 | 860 | Nostra |
11 | 2023-02-20 00:00:00.000 | 40 | Nostra |
12 | 2023-08-13 00:00:00.000 | 725 | Nostra |
13 | 2023-11-03 00:00:00.000 | 987 | Nostra |
14 | 2023-03-19 00:00:00.000 | 578 | Nostra |
15 | 2023-03-22 00:00:00.000 | 800 | Nostra |
16 | 2023-08-03 00:00:00.000 | 565 | Nostra |
17 | 2023-05-08 00:00:00.000 | 26 | Nostra |
18 | 2023-07-05 00:00:00.000 | 20 | Nostra |
19 | 2023-01-08 00:00:00.000 | 71 | Nostra |
20 | 2023-03-24 00:00:00.000 | 796 | Nostra |
Starknet reportsfdn_stark - dau - nostra
Updated 2024-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with nost_all as
(sELECT DISTINCT tx_hash as hash0
FROM external.tokenflow_starknet.decoded_traces
where --tx_hash in ('0x046aca6d44ae85d14ad984e10237b1187d6d4a3c18713e236934fe45e770978c','0x04bc5a19b0b6ce66183fc9c0eec317ec52d90a812a65817f541d90a48006edab') and
caller in ('0x03d39f7248fb2bfb960275746470f7fb470317350ad8656249ec66067559e892','0x059a943ca214c10234b9a3b61c558ac20c005127d183b86a99a8f3c60a08b4ff')
and function = '__default__'
and chain_id = 'mainnet')
SELECT timestamp::date as date, count(DISTINCT contract) as users, 'Nostra' as protocol
from external.tokenflow_starknet.decoded_transactions join nost_all on tx_hash =hash0
where chain_id = 'mainnet'
GROUP by all
Last run: about 1 year ago
...
435
17KB
56s