Eman-RazNumber of Checking Transactions on Different Weeks of the Month
    Updated 2024-07-08
    select case
    when date_part('day', block_timestamp)<=7 then '1st week'
    when date_part('day', block_timestamp)>7 and date_part('day', block_timestamp)<=14 then '2st week'
    when date_part('day', block_timestamp)>14 and date_part('day', block_timestamp)<=21 then '3st week'
    when date_part('day', block_timestamp)>21 then '4st week'
    end as "Week", count(distinct tx_hash) as "Txn Count"
    from blast.core.fact_event_logs
    where origin_function_signature='0x183ff085'
    and tx_status='SUCCESS'
    and origin_to_address='0x5ff315aa82a8b2b435f866d20ecd46959999bdcd'
    group by 1
    order by 1
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived