PREVIEW / stock_1hour / 2022-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-20.parquet
  size:    1.4 MB
  rows:    61,907
  symbols: 2,299

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2022-07-20 04:00:00	AAPL	Stock	151.6	151.6	151.12	151.4	29936.0
2022-07-20 05:00:00	AAPL	Stock	151.41	151.62	151.26	151.62	12882.0
2022-07-20 06:00:00	AAPL	Stock	151.55	151.56	150.6	151.02	32680.0
2022-07-20 07:00:00	AAPL	Stock	151.04	151.47	150.88	151.41	78683.0
2022-07-20 08:00:00	AAPL	Stock	151.09	153.0	150.623	151.45	372399.0
2022-07-20 09:00:00	AAPL	Stock	151.49	151.73	150.37	151.05	7347038.0
2022-07-20 10:00:00	AAPL	Stock	151.05	153.6	150.83	153.38	11041297.0
2022-07-20 11:00:00	AAPL	Stock	153.38	153.4821	152.87	153.175	6228027.0
2022-07-20 12:00:00	AAPL	Stock	153.18	153.72	152.6305	153.135	5364953.0
2022-07-20 13:00:00	AAPL	Stock	153.13	153.28	152.08	152.1811	5274875.0
2022-07-20 14:00:00	AAPL	Stock	152.19	153.37	152.16	153.2774	5903046.0
2022-07-20 15:00:00	AAPL	Stock	153.275	153.6899	152.85	153.03	8751220.0
2022-07-20 16:00:00	AAPL	Stock	153.03	153.38	152.34	152.43	6049872.0
2022-07-20 17:00:00	AAPL	Stock	152.41	152.6891	152.3	152.5006	29885.0
2022-07-20 18:00:00	AAPL	Stock	152.58	152.68	152.16	152.36	40667.0
2022-07-20 19:00:00	AAPL	Stock	152.53	152.69	152.33	152.65	15007.0
2022-07-20 04:00:00	MSFT	Stock	259.31	259.63	259.05	259.39	5688.0
2022-07-20 05:00:00	MSFT	Stock	259.57	259.79	259.5	259.79	638.0
2022-07-20 06:00:00	MSFT	Stock	259.65	259.77	258.03	258.31	5099.0
2022-07-20 07:00:00	MSFT	Stock	258.68	258.75	258.32	258.32	7648.0
2022-07-20 08:00:00	MSFT	Stock	258.79	258.995	258.0	258.78	47538.0
2022-07-20 09:00:00	MSFT	Stock	258.8	261.71	258.75	260.08	2020326.0
2022-07-20 10:00:00	MSFT	Stock	260.13	263.16	259.6	263.1595	1894848.0
2022-07-20 11:00:00	MSFT	Stock	263.15	263.79	262.08	263.77	1585864.0
2022-07-20 12:00:00	MSFT	Stock	263.77	264.87	261.92	262.92	1934163.0
2022-07-20 13:00:00	MSFT	Stock	262.91	263.17	260.28	261.07	2036987.0
2022-07-20 14:00:00	MSFT	Stock	261.09	262.9699	261.06	262.1669	1166382.0
2022-07-20 15:00:00	MSFT	Stock	262.16	263.01	261.73	262.24	2861806.0
2022-07-20 16:00:00	MSFT	Stock	262.21	262.69	261.11	261.3	2969952.0
2022-07-20 17:00:00	MSFT	Stock	261.43	261.99	261.11	261.5	10257.0
2022-07-20 18:00:00	MSFT	Stock	261.52	261.69	258.81	259.75	43794.0
2022-07-20 19:00:00	MSFT	Stock	259.75	260.88	259.52	260.3	31082.0
2022-07-20 04:00:00	NVDA	Stock	17.242	17.243	17.033	17.124	241060.0
2022-07-20 05:00:00	NVDA	Stock	17.137	17.19	17.137	17.18	25310.0
2022-07-20 06:00:00	NVDA	Stock	17.162	17.175	17.004	17.06	239590.0
2022-07-20 07:00:00	NVDA	Stock	17.09	17.099	17.012	17.051	418850.0
2022-07-20 08:00:00	NVDA	Stock	17.0209	17.49	16.954	16.972	1920900.0
2022-07-20 09:00:00	NVDA	Stock	16.953	17.208	16.801	17.0605	69669790.0
2022-07-20 10:00:00	NVDA	Stock	17.065	17.895	17.011	17.8015	139670440.0
2022-07-20 11:00:00	NVDA	Stock	17.804	17.832	17.631	17.7598	87146000.0
2022-07-20 12:00:00	NVDA	Stock	17.7601	17.845	17.46	17.65	79285580.0
2022-07-20 13:00:00	NVDA	Stock	17.65	17.663	17.428	17.542	64671130.0
2022-07-20 14:00:00	NVDA	Stock	17.544	17.768	17.538	17.734	56343190.0
2022-07-20 15:00:00	NVDA	Stock	17.735	17.9325	17.715	17.804	91631690.0
2022-07-20 16:00:00	NVDA	Stock	17.805	17.8868	17.5532	17.625	22478790.0
2022-07-20 17:00:00	NVDA	Stock	17.637	17.807	17.622	17.672	819330.0
2022-07-20 18:00:00	NVDA	Stock	17.68	17.715	17.64	17.641	300990.0
2022-07-20 19:00:00	NVDA	Stock	17.65	17.7	17.63	17.65	584740.0
2022-07-20 04:00:00	AMZN	Stock	118.45	118.88	118.45	118.72	8110.0
2022-07-20 05:00:00	AMZN	Stock	118.7	118.98	118.7	118.93	3401.0

> showing 50 of 61,907 rows — these rows as CSV

> unlock the full archive -- $79 one-time