MLDZMNaur-user2
    Updated 2023-04-26

    with t1 AS (
    SELECT
    block_timestamp,
    tx_hash,
    tx_signer
    from near.core.fact_transactions
    where tx_status = 'Success'
    and tx_receiver = 'aurora'
    and tx_signer <> 'aurora'
    )


    SELECT
    CASE
    WHEN EXTRACT(DOW FROM block_timestamp) = 0 THEN 'Sunday'
    WHEN EXTRACT(DOW FROM block_timestamp) = 1 THEN 'Monday'
    WHEN EXTRACT(DOW FROM block_timestamp) = 2 THEN 'Tuesday'
    WHEN EXTRACT(DOW FROM block_timestamp) = 3 THEN 'Wednesday'
    WHEN EXTRACT(DOW FROM block_timestamp) = 4 THEN 'Thursday'
    WHEN EXTRACT(DOW FROM block_timestamp) = 5 THEN 'Friday'
    WHEN EXTRACT(DOW FROM block_timestamp) = 6 THEN 'Saturday'
    END AS "Day",
    DATE_PART(hour, block_timestamp) AS "Hour",
    count(distinct tx_hash) as no_txn,
    count(distinct tx_signer) as no_stakers
    FROM t1
    group by 1,2 having "Day" is not null
    Run a query to Download Data