maybeyonasUntitled Query
Updated 2022-06-03
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
›
⌄
with
polygon_txs as (
select
block_timestamp,
tx_id
from polygon.transactions
where success = 'TRUE'
and block_timestamp >= '2022-05-09'
),
polygon_minute_data as (
select
date_trunc(minute,block_timestamp) as minute_time,
count(tx_id) as txs
from polygon_txs
group by 1
),
polygon_speed as (
select
date(minute_time) as date,
avg(txs) as avg_txs,
median(txs) as median_txs,
max(txs) as max_txs
from polygon_minute_data
where minute_time >= '2022-05-09'
group by 1
)
select * from polygon_speed
limit 100
-- limit 100
Run a query to Download Data