senecaProposals created by week
Updated 2024-01-04
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
›
⌄
SELECT
DATE_TRUNC('week', TIMESTAMP) AS week_start,
COUNT(*) AS proposal_count
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('week', TIMESTAMP)
ORDER BY
week_start
QueryRunArchived: QueryRun has been archived