yasminwallet time copy
Updated 2025-02-24
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 wallet time @ https://flipsidecrypto.xyz/studio/queries/c6db3b9d-3ad8-4f2e-8726-f4dd74696248
WITH base_data AS (
SELECT
live.udf_api( 'https://metrics.avax.network/v2/chains/49321/metrics/activeAddresses?startTimestamp=1726272000&endTimestamp=1739923200&timeInterval=day&pageSize=2160') AS response
),
flattened_data AS (
SELECT
to_timestamp(tx.value:timestamp)::date AS date,
tx.value:value::integer AS daily_active_addresses
FROM
base_data,
LATERAL FLATTEN(input => response:data:results) AS tx
)
SELECT
date_trunc('day', date) AS truncated_date,
SUM(daily_active_addresses) AS total_active_addresses
FROM
flattened_data
-- WHERE
-- date >= DATEADD(DAY, -{{period}}, CURRENT_DATE)
GROUP BY
truncated_date
ORDER BY
truncated_date ASC;
-- curl --request GET \
QueryRunArchived: QueryRun has been archived