LTirrellUntitled Query
Updated 2022-10-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
e.block_timestamp :: DATE AS "Date",
e.program_id,
COUNT(
DISTINCT e.tx_id
) AS tx_count,
COUNT(
DISTINCT t.signers [0]
) AS signers
FROM
solana.core.fact_events e
JOIN solana.core.fact_transactions t
ON (
e.tx_id = t.tx_id
)
WHERE
e.block_timestamp :: DATE = '2021-07-09'
GROUP BY
program_id,
"Date"
ORDER BY
signers
Run a query to Download Data