davidwallNew Query
Updated 2023-01-28
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
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/a9a745e2-6179-4926-bb6c-c80cd1c9b5d5
WITH t0 AS (
SELECT block_timestamp::date AS date
, 'Solana' AS chain
, SUM(CASE WHEN succeeded THEN 1 ELSE 0 END) AS n_tx_successful
, COUNT(1) AS n_tx
FROM solana.core.fact_transactions
WHERE block_timestamp >= CURRENT_DATE - 90
GROUP BY 1
UNION
SELECT block_timestamp::date AS date
, 'Polygon' AS chain
, SUM(CASE WHEN status = 'SUCCESS' THEN 1 ELSE 0 END) AS n_tx_successful
, COUNT(1) AS n_tx
FROM polygon.core.fact_transactions
WHERE block_timestamp >= CURRENT_DATE - 90
GROUP BY 1
UNION
SELECT block_timestamp::date AS date
, 'Ethereum' AS chain
, SUM(CASE WHEN status = 'SUCCESS' THEN 1 ELSE 0 END) AS n_tx_successful
, COUNT(1) AS n_tx
FROM ethereum.core.fact_transactions
WHERE block_timestamp >= CURRENT_DATE - 90
GROUP BY 1
)
SELECT *
FROM t0
WHERE date < CURRENT_DATE::date
Run a query to Download Data