cheeyoung-kekUntitled Query
Updated 2022-09-08Copy Reference Fork
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 near as(
SELECT
block_timestamp::date as date,
substr(tx[0]:"outcome":"status",3,7) as status,
COUNT(TX_HASH)/1440 AS near_tmp
FROM flipside_prod_db.mdao_near.transactions
WHERE block_timestamp::date > '2022-01-01'
GROUP BY date, status
),
sol as(
SELECT
block_timestamp::date as date,
succeeded as status,
COUNT(tx_id)/1440 AS sol_tmp
FROM solana.core.fact_transactions
WHERE (block_timestamp::date > '2022-01-01')
GROUP BY date,status
),
eth as(
SELECT
block_timestamp::date as date,
status,
COUNT(tx_hash)/1440 AS Eth_tmp
FROM ethereum.core.fact_transactions
WHERE (block_timestamp::date > '2022-01-01')
GROUP BY date,status
)
Run a query to Download Data