Sajjadiiifurvoc flow
Updated 2022-12-18
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
›
⌄
WITH first__jan AS (
SELECT DISTINCT proposer FROM flow.core.fact_transactions WHERE block_timestamp::date BETWEEN '2022-01-01' AND '2022-02-01' AND tx_succeeded = TRUE
),
first__Feb AS (
SELECT DISTINCT proposer FROM flow.core.fact_transactions WHERE block_timestamp::date BETWEEN '2022-02-01' AND '2022-03-01' AND tx_succeeded = TRUE
),
first__mar AS (
SELECT DISTINCT proposer FROM flow.core.fact_transactions WHERE block_timestamp::date BETWEEN '2022-03-01' AND '2022-04-01' AND tx_succeeded = TRUE
),
first__apr AS (
SELECT DISTINCT proposer FROM flow.core.fact_transactions WHERE block_timestamp::date BETWEEN '2022-04-01' AND '2022-05-01' AND tx_succeeded = TRUE
),
first__may AS (
SELECT DISTINCT proposer FROM flow.core.fact_transactions WHERE block_timestamp::date BETWEEN '2022-05-01' AND '2022-06-01' AND tx_succeeded = TRUE
),
first__jun AS (
SELECT DISTINCT proposer FROM flow.core.fact_transactions WHERE block_timestamp::date BETWEEN '2022-06-01' AND '2022-07-01' AND tx_succeeded = TRUE
),
first__jul AS (
SELECT DISTINCT proposer FROM flow.core.fact_transactions WHERE block_timestamp::date BETWEEN '2022-07-01' AND '2022-08-01' AND tx_succeeded = TRUE
),
first__aug AS (
SELECT DISTINCT proposer FROM flow.core.fact_transactions WHERE block_timestamp::date BETWEEN '2022-08-01' AND '2022-09-01' AND tx_succeeded = TRUE
),
Run a query to Download Data