cybergenlabEVM metrics [Ecosystem]
Updated 2024-11-18
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
›
⌄
-- Scripts extracting all the latest network metric values from each network centric dashboard
--Arbitrum Ecosystem metric
--QueryID: 91ca8a22-1867-4669-a5b9-e293d27bac25
with arb_metrics as (
select
value:TIME::date AS time,
'Arbitrum' as network,
value:CONTRACTS_DEPLOYED::numeric as contracts_deployed,
value:DEPLOYERS::numeric AS deployers,
value:USERS::numeric as users
from (
select
livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/91ca8a22-1867-4669-a5b9-e293d27bac25/data/latest') as response
), lateral FLATTEN (input => response:data)
)
--Optimism Ecosystem metric
--QueryID: 1375b1f7-994a-4aaa-a761-9904571d3144
, op_metrics as (
select
value:TIME::date AS time,
'Optimism' as network,
value:CONTRACTS_DEPLOYED::numeric as contracts_deployed,
value:DEPLOYERS::numeric AS deployers,
value:USERS::numeric as users
from (
select
livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/1375b1f7-994a-4aaa-a761-9904571d3144/data/latest') as response
), lateral FLATTEN (input => response:data)
)
--Avalanche Ecosystem metric
--Query ID: d5ecb510-1cb5-418c-9a2f-6de0231a5e8d
, avax_metrics as (
select
QueryRunArchived: QueryRun has been archived