StangFAST003 - cumulative activity [ part 2 ]
Updated 2023-10-01
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
35
36
›
⌄
-- forked from 003 - cumulative activity [ part 1 ] @ https://flipsidecrypto.xyz/edit/queries/f5ec6b09-c34d-4dad-9d61-7125a8fcbe12
-- forked from 002 - active addresses @ https://flipsidecrypto.xyz/edit/queries/ec965c74-56ba-494a-9cd6-93c2f16f57f0
-- forked from 001 - active users [ sent transactions ] @ https://flipsidecrypto.xyz/edit/queries/5b871eea-809d-427e-85a5-ce8b89792439
--- primary name | chain - ID
-------------------------------------------------------
--- avalanche [ c - chain ] | 43114
--- avalanche [ p - chain ] |
--- avalanche [ x - chain ] |
-------------------------------------------------------
--- subnet name | chain - ID | rgb - color
---------------------------------------------------
--- beam | 4337 | 42d217
--- dexalot | 432204 | e61777
--- dft | 53935 | dbaa25
--- loco legends | 262018 | f83600
--- meld | 333000333 | 673ab7
--- mintara | 1080 | 00a992
--- shrapnel | 2044 | 118ab2
---------------------------------------------------
--- dos | 7979 | ff2e29
--- step network | 1234 | f9d549
--- uptn | 6119 | 5f46ff
--- xana | 8888 | ea2ac0
---------------------------------------------------
SELECT
to_timestamp_ntz( a.value:"timestamp"::numeric ) AS "date"
, a.value:"value"::numeric AS "addresses"
, case
when a.seq = 1 then 'Beam Subnet'
when a.seq = 2 then 'Dexalot Subnet'
Run a query to Download Data