MONTH_START | PROPOSALS_CREATED | |
|---|---|---|
1 | 2023-12-01 00:00:00.000 | 206 |
2 | 2024-01-01 00:00:00.000 | 283 |
3 | 2024-02-01 00:00:00.000 | 1 |
senecaPoposals created per month
Updated 2024-02-03
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
›
⌄
-- forked from Poposals created per week @ https://flipsidecrypto.xyz/edit/queries/7a0cba17-74bb-44c8-a990-ab62af7293b8
SELECT
DATE_TRUNC('month', TIMESTAMP) AS month_start,
COUNT(*) AS proposals_created
FROM
external.tokenflow_starknet.decoded_events
WHERE
CONTRACT IN (
SELECT
CONCAT('0x0', SUBSTR(starknet_round, 3)) AS modified_address
FROM (
SELECT
FLATTENED.VALUE:value :: STRING AS starknet_round,
TIMESTAMP
FROM
external.tokenflow_starknet.decoded_events,
LATERAL FLATTEN(input => PARAMETERS) AS FLATTENED
WHERE
CONTRACT = '0x054b7b08b5389709af79a65b21574231b9adb0c313c1598aac94ee44fe99d213'
AND NAME = 'RoundRegistered'
AND FLATTENED.VALUE:name = 'starknet_round'
)
)
AND NAME = 'ProposalCreated'
GROUP BY
DATE_TRUNC('month', TIMESTAMP)
ORDER BY
month_start
Last run: about 1 year ago
3
95B
5s