PREVIEW / stock_1hour / 2022-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-06.parquet
  size:    1.4 MB
  rows:    61,938
  symbols: 2,190

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-09-06 04:00:00	AAPL	Stock	156.22	157.33	156.22	157.23	35465.0
2022-09-06 05:00:00	AAPL	Stock	157.19	157.19	156.83	157.07	19428.0
2022-09-06 06:00:00	AAPL	Stock	157.06	157.39	156.97	157.17	33173.0
2022-09-06 07:00:00	AAPL	Stock	157.05	157.18	156.34	156.85	92652.0
2022-09-06 08:00:00	AAPL	Stock	157.16	157.88	155.421	156.89	259868.0
2022-09-06 09:00:00	AAPL	Stock	156.9	157.1277	155.06	155.26	8063197.0
2022-09-06 10:00:00	AAPL	Stock	155.26	156.44	153.69	156.12	12168270.0
2022-09-06 11:00:00	AAPL	Stock	156.1129	156.53	155.48	156.0738	7541910.0
2022-09-06 12:00:00	AAPL	Stock	156.08	156.27	154.64	155.215	6416817.0
2022-09-06 13:00:00	AAPL	Stock	155.2054	155.27	153.904	154.5	5715275.0
2022-09-06 14:00:00	AAPL	Stock	154.5	155.12	154.2	154.33	5271368.0
2022-09-06 15:00:00	AAPL	Stock	154.33	155.1	153.99	154.54	11623387.0
2022-09-06 16:00:00	AAPL	Stock	154.54	154.85	154.32	154.71	5466796.0
2022-09-06 17:00:00	AAPL	Stock	154.74	154.75	154.57	154.63	28774.0
2022-09-06 18:00:00	AAPL	Stock	154.7	154.87	154.63	154.65	35435.0
2022-09-06 19:00:00	AAPL	Stock	154.68	154.75	154.48	154.49	54250.0
2022-09-06 04:00:00	MSFT	Stock	257.91	258.0	257.11	258.0	6778.0
2022-09-06 05:00:00	MSFT	Stock	257.82	257.88	257.67	257.88	636.0
2022-09-06 06:00:00	MSFT	Stock	257.85	258.49	257.82	257.82	2231.0
2022-09-06 07:00:00	MSFT	Stock	257.65	257.77	256.42	257.09	11943.0
2022-09-06 08:00:00	MSFT	Stock	257.56	258.82	255.42	257.35	18087.0
2022-09-06 09:00:00	MSFT	Stock	257.14	257.83	254.7001	255.525	1808615.0
2022-09-06 10:00:00	MSFT	Stock	255.49	256.97	252.66	256.5	2387599.0
2022-09-06 11:00:00	MSFT	Stock	256.505	257.13	255.21	256.115	1624298.0
2022-09-06 12:00:00	MSFT	Stock	256.11	256.2	253.48	254.32	1215683.0
2022-09-06 13:00:00	MSFT	Stock	254.3	254.325	251.94	252.95	1504776.0
2022-09-06 14:00:00	MSFT	Stock	252.93	254.18	252.86	253.4	1392339.0
2022-09-06 15:00:00	MSFT	Stock	253.4054	254.3	252.52	253.3	2898369.0
2022-09-06 16:00:00	MSFT	Stock	253.31	253.41	253.2	253.37	2697404.0
2022-09-06 17:00:00	MSFT	Stock	253.4	253.4	253.3	253.4	3754.0
2022-09-06 18:00:00	MSFT	Stock	253.39	253.6	253.27	253.4	5281.0
2022-09-06 19:00:00	MSFT	Stock	253.74	253.74	252.84	253.25	12854.0
2022-09-06 04:00:00	NVDA	Stock	13.712	13.865	13.712	13.803	101680.0
2022-09-06 05:00:00	NVDA	Stock	13.82	13.82	13.76	13.799	101950.0
2022-09-06 06:00:00	NVDA	Stock	13.8	13.838	13.799	13.799	55520.0
2022-09-06 07:00:00	NVDA	Stock	13.81	13.81	13.709	13.727	436320.0
2022-09-06 08:00:00	NVDA	Stock	13.8	13.82	13.647	13.738	4546630.0
2022-09-06 09:00:00	NVDA	Stock	13.738	13.7668	13.51	13.571	64186300.0
2022-09-06 10:00:00	NVDA	Stock	13.573	13.67	13.351	13.654	91416950.0
2022-09-06 11:00:00	NVDA	Stock	13.655	13.779	13.58	13.733	65034330.0
2022-09-06 12:00:00	NVDA	Stock	13.733	13.739	13.551	13.6024	43876160.0
2022-09-06 13:00:00	NVDA	Stock	13.6012	13.6012	13.462	13.49	43630710.0
2022-09-06 14:00:00	NVDA	Stock	13.488	13.592	13.4812	13.515	37870580.0
2022-09-06 15:00:00	NVDA	Stock	13.516	13.5755	13.436	13.465	62051580.0
2022-09-06 16:00:00	NVDA	Stock	13.465	13.47	13.442	13.462	25278680.0
2022-09-06 17:00:00	NVDA	Stock	13.462	13.468	13.452	13.468	208870.0
2022-09-06 18:00:00	NVDA	Stock	13.468	13.475	13.456	13.461	286040.0
2022-09-06 19:00:00	NVDA	Stock	13.462	13.5	13.455	13.5	348380.0
2022-09-06 04:00:00	AMZN	Stock	128.21	128.7	128.1	128.69	5145.0
2022-09-06 05:00:00	AMZN	Stock	128.63	128.7	128.4	128.7	11730.0

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

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