SELECT

*,

dense_rank() OVER (

PARTITION BY blockchain

ORDER BY

date_part('epoch', date) / (30 * 24 * 60 * 60)

) as month_rank,

dense_rank() OVER (

PARTITION BY blockchain

ORDER BY

date_trunc('day', date)

) as day_rank,

dense_rank() OVER (

PARTITION BY blockchain

ORDER BY

date_part('epoch', date) / (7 * 24 * 60 * 60)

) as week_rank

FROM

(

SELECT

*

FROM

(

SELECT

'Blast' as blockchain,

date_trunc('{{time_frame}}', block_Timestamp) as date,

count(DISTINCT from_address) as Daily_Active_User,

count(tx_hash) as "Daily # of TXs"

FROM

blast.core.fact_transactions

group by

1,

2

union

all