intraday.sql

-- This query will return no intraday data as there is no intraday data available in the sample data set.
SELECT
  _table_suffix AS Table_Suffix,
  COUNT(DISTINCT CONCAT(fullVisitorId, CAST(visitStartTime AS STRING))) AS Sessions
FROM
  `bigquery-public-data.google_analytics_sample.ga_sessions_*`
WHERE
  REGEXP_EXTRACT(_table_suffix, r'[0-9]+') BETWEEN '20160801'
  AND FORMAT_DATE('%Y%m%d', CURRENT_DATE())
  AND totals.visits = 1
GROUP BY
  1
ORDER BY
  1 DESC