PREVIEW / stock_1hour / 2022-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-18.parquet
  size:    1.4 MB
  rows:    64,237
  symbols: 2,482

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-03-18 04:00:00	AAPL	Stock	159.89	160.07	159.55	159.61	17274.0
2022-03-18 05:00:00	AAPL	Stock	159.6	159.85	159.36	159.71	5437.0
2022-03-18 06:00:00	AAPL	Stock	159.78	159.99	159.35	159.5	11124.0
2022-03-18 07:00:00	AAPL	Stock	159.55	159.72	159.32	159.49	70384.0
2022-03-18 08:00:00	AAPL	Stock	159.5301	161.021	159.04	159.53	451125.0
2022-03-18 09:00:00	AAPL	Stock	159.52	161.05	159.41	160.985	21678244.0
2022-03-18 10:00:00	AAPL	Stock	160.99	161.92	160.82	161.2342	10196610.0
2022-03-18 11:00:00	AAPL	Stock	161.235	162.51	161.16	162.34	9288564.0
2022-03-18 12:00:00	AAPL	Stock	162.34	162.9	162.09	162.6	7127119.0
2022-03-18 13:00:00	AAPL	Stock	162.595	162.73	162.245	162.45	5872004.0
2022-03-18 14:00:00	AAPL	Stock	162.46	163.5581	162.42	163.432	7698840.0
2022-03-18 15:00:00	AAPL	Stock	163.43	164.48	163.32	163.96	16954657.0
2022-03-18 16:00:00	AAPL	Stock	163.93	164.52	163.7	164.37	26666148.0
2022-03-18 17:00:00	AAPL	Stock	164.31	164.39	164.1	164.16	49109.0
2022-03-18 18:00:00	AAPL	Stock	164.16	164.22	164.08	164.09	21402.0
2022-03-18 19:00:00	AAPL	Stock	164.11	164.34	164.01	164.34	52143.0
2022-03-18 04:00:00	MSFT	Stock	293.4	294.0	292.3	292.87	3896.0
2022-03-18 05:00:00	MSFT	Stock	293.0	293.4	292.86	293.4	4174.0
2022-03-18 06:00:00	MSFT	Stock	293.65	293.65	292.9	293.07	3222.0
2022-03-18 07:00:00	MSFT	Stock	293.04	293.4	292.5	293.12	15148.0
2022-03-18 08:00:00	MSFT	Stock	292.7001	294.34	292.5001	292.57	16264.0
2022-03-18 09:00:00	MSFT	Stock	293.2	295.48	292.73	295.075	8101559.0
2022-03-18 10:00:00	MSFT	Stock	295.11	297.24	294.63	295.58	3054515.0
2022-03-18 11:00:00	MSFT	Stock	295.58	298.09	295.38	296.68	2346477.0
2022-03-18 12:00:00	MSFT	Stock	296.731	298.14	296.1	297.6731	1808011.0
2022-03-18 13:00:00	MSFT	Stock	297.66	298.68	297.46	298.32	1470217.0
2022-03-18 14:00:00	MSFT	Stock	298.32	298.97	297.75	298.88	1474094.0
2022-03-18 15:00:00	MSFT	Stock	298.88	300.99	298.72	300.5	5349803.0
2022-03-18 16:00:00	MSFT	Stock	301.0	301.0	300.0	300.7	9831825.0
2022-03-18 17:00:00	MSFT	Stock	300.46	300.46	299.72	300.2425	17280.0
2022-03-18 18:00:00	MSFT	Stock	300.25	300.55	300.25	300.25	7151.0
2022-03-18 19:00:00	MSFT	Stock	300.35	300.8	300.25	300.78	6400.0
2022-03-18 04:00:00	NVDA	Stock	24.55	24.59	24.508	24.56	38310.0
2022-03-18 05:00:00	NVDA	Stock	24.56	24.59	24.5	24.524	16660.0
2022-03-18 06:00:00	NVDA	Stock	24.543	24.578	24.503	24.503	32880.0
2022-03-18 07:00:00	NVDA	Stock	24.483	24.54	24.413	24.477	152770.0
2022-03-18 08:00:00	NVDA	Stock	24.48	24.702	24.4107	24.471	513300.0
2022-03-18 09:00:00	NVDA	Stock	24.4945	25.895	24.412	25.89	99148520.0
2022-03-18 10:00:00	NVDA	Stock	25.89	26.256	25.664	26.096	108487950.0
2022-03-18 11:00:00	NVDA	Stock	26.1049	26.256	25.95	26.0	61987900.0
2022-03-18 12:00:00	NVDA	Stock	26.0088	26.167	25.902	26.118	43182910.0
2022-03-18 13:00:00	NVDA	Stock	26.1255	26.281	26.031	26.1362	39200970.0
2022-03-18 14:00:00	NVDA	Stock	26.137	26.258	26.031	26.2202	36843330.0
2022-03-18 15:00:00	NVDA	Stock	26.2209	26.569	26.194	26.461	85769840.0
2022-03-18 16:00:00	NVDA	Stock	26.382	26.47	26.382	26.448	81829780.0
2022-03-18 17:00:00	NVDA	Stock	26.447	26.464	26.42	26.444	461970.0
2022-03-18 18:00:00	NVDA	Stock	26.436	26.495	26.436	26.463	371950.0
2022-03-18 19:00:00	NVDA	Stock	26.47	26.514	26.47	26.509	303430.0
2022-03-18 04:00:00	AMZN	Stock	156.692	156.692	156.692	156.692	3400.0
2022-03-18 06:00:00	AMZN	Stock	156.25	156.25	156.25	156.25	2480.0

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

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