PREVIEW / stock_1hour / 2022-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-21.parquet
  size:    1.4 MB
  rows:    64,260
  symbols: 2,376

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-06-21 04:00:00	AAPL	Stock	132.51	135.99	132.51	134.44	117647.0
2022-06-21 05:00:00	AAPL	Stock	134.45	134.5	133.93	134.02	30601.0
2022-06-21 06:00:00	AAPL	Stock	134.09	134.43	133.96	134.23	58174.0
2022-06-21 07:00:00	AAPL	Stock	134.21	134.3	133.4	133.44	154067.0
2022-06-21 08:00:00	AAPL	Stock	134.2	134.2	131.232	133.48	509705.0
2022-06-21 09:00:00	AAPL	Stock	133.51	136.46	133.2	136.34	14329205.0
2022-06-21 10:00:00	AAPL	Stock	136.35	136.9	135.79	136.8094	10783318.0
2022-06-21 11:00:00	AAPL	Stock	136.81	137.06	135.99	135.99	6974893.0
2022-06-21 12:00:00	AAPL	Stock	135.995	136.25	135.7	136.07	5911930.0
2022-06-21 13:00:00	AAPL	Stock	136.075	136.18	135.64	135.82	4024476.0
2022-06-21 14:00:00	AAPL	Stock	135.83	136.23	135.47	136.195	5530631.0
2022-06-21 15:00:00	AAPL	Stock	136.2	136.41	135.585	135.86	10428200.0
2022-06-21 16:00:00	AAPL	Stock	135.86	135.99	135.71	135.87	12017120.0
2022-06-21 17:00:00	AAPL	Stock	135.88	135.94	135.78	135.84	46506.0
2022-06-21 18:00:00	AAPL	Stock	135.8	135.8	135.53	135.61	31255.0
2022-06-21 19:00:00	AAPL	Stock	135.64	135.7	135.51	135.6	44893.0
2022-06-21 04:00:00	MSFT	Stock	249.01	252.7	249.01	252.06	10259.0
2022-06-21 05:00:00	MSFT	Stock	252.2	252.2	251.59	251.59	2973.0
2022-06-21 06:00:00	MSFT	Stock	251.59	251.84	251.59	251.79	2523.0
2022-06-21 07:00:00	MSFT	Stock	251.51	251.76	250.64	250.75	18645.0
2022-06-21 08:00:00	MSFT	Stock	251.6	251.7899	247.031	250.37	56612.0
2022-06-21 09:00:00	MSFT	Stock	250.11	254.35	249.51	253.14	3006695.0
2022-06-21 10:00:00	MSFT	Stock	253.06	254.75	252.77	254.33	2730404.0
2022-06-21 11:00:00	MSFT	Stock	254.325	254.41	253.15	253.38	1641937.0
2022-06-21 12:00:00	MSFT	Stock	253.37	253.82	252.77	253.72	1274482.0
2022-06-21 13:00:00	MSFT	Stock	253.7199	254.17	252.96	253.2499	1321431.0
2022-06-21 14:00:00	MSFT	Stock	253.25	254.02	252.65	253.98	1339712.0
2022-06-21 15:00:00	MSFT	Stock	253.99	254.49	253.15	253.74	2875713.0
2022-06-21 16:00:00	MSFT	Stock	253.74	253.9509	253.3	253.78	5373305.0
2022-06-21 17:00:00	MSFT	Stock	253.6	253.75	253.52	253.6101	53024.0
2022-06-21 18:00:00	MSFT	Stock	253.61	253.77	253.0	253.4	9223.0
2022-06-21 19:00:00	MSFT	Stock	253.3	253.36	253.09	253.09	2761.0
2022-06-21 04:00:00	NVDA	Stock	16.308	16.375	16.263	16.354	536980.0
2022-06-21 05:00:00	NVDA	Stock	16.365	16.38	16.332	16.349	200810.0
2022-06-21 06:00:00	NVDA	Stock	16.348	16.396	16.325	16.37	264230.0
2022-06-21 07:00:00	NVDA	Stock	16.37	16.396	16.31	16.333	543390.0
2022-06-21 08:00:00	NVDA	Stock	16.3407	16.444	16.264	16.375	1224880.0
2022-06-21 09:00:00	NVDA	Stock	16.38	16.912	16.375	16.907	77198980.0
2022-06-21 10:00:00	NVDA	Stock	16.912	17.007	16.825	16.922	66313350.0
2022-06-21 11:00:00	NVDA	Stock	16.928	17.008	16.745	16.7475	52224900.0
2022-06-21 12:00:00	NVDA	Stock	16.746	16.896	16.693	16.893	37609490.0
2022-06-21 13:00:00	NVDA	Stock	16.895	16.923	16.778	16.787	29707140.0
2022-06-21 14:00:00	NVDA	Stock	16.786	16.7885	16.656	16.709	38051830.0
2022-06-21 15:00:00	NVDA	Stock	16.7098	16.739	16.525	16.565	54322640.0
2022-06-21 16:00:00	NVDA	Stock	16.566	16.566	16.532	16.55	25421990.0
2022-06-21 17:00:00	NVDA	Stock	16.566	16.566	16.535	16.544	305010.0
2022-06-21 18:00:00	NVDA	Stock	16.54	16.54	16.51	16.515	174800.0
2022-06-21 19:00:00	NVDA	Stock	16.515	16.524	16.48	16.48	182540.0
2022-06-21 04:00:00	AMZN	Stock	108.36	109.28	107.51	108.4	56663.0
2022-06-21 05:00:00	AMZN	Stock	108.44	108.81	108.27	108.31	49379.0

> showing 50 of 64,260 rows — these rows as CSV

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