SELECT date_trunc('day',TIMESTAMP::date) as date , count(DISTINCT tx_hash)/86400 as tps ,

case when TIMESTAMP::date >= '2023-07-12' and TIMESTAMP::date < '2023-08-21' then 'After V 0.12.0 upgrade'

when TIMESTAMP::date >= '2023-08-21' and TIMESTAMP::date < '2023-09-05' then 'After V 0.12.1 upgrade'

when TIMESTAMP::date >= '2023-09-05' then 'After V 0.12.2 upgrade'

else 'Other days' end as period

from external.tokenflow_starknet.decoded_transactions

CHAIN_ID = 'mainnet'

and TIMESTAMP::date >= current_date - 365

group by 1,3