maybeyonasUntitled Query
    Updated 2022-06-03
    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