Updated 2023-05-22

    with t1 AS (
    SELECT
    block_timestamp,
    tx_hash,
    SIGNER_ID
    from near.core.fact_actions_events_function_call
    WHERE receiver_id = 'nearhorizon.near'
    )


    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 SIGNER_ID) as no_users
    FROM t1
    group by 1,2 having "Day" is not null
    Run a query to Download Data