bigquery query

SELECT
  btc,
  timestamp,
  STRFTIME_UTC_USEC(TIMESTAMP_TO_USEC(timestamp) + 32400000000, '%Y/%m/%d %H') as timestamp2
 FROM
  [bit-flyer:twitter.followers_counts]
 ORDER BY
  timestamp desc;