PREVIEW / stock_1hour / 2021-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-14.parquet
  size:    1.4 MB
  rows:    64,717
  symbols: 2,685

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
2021-10-14 04:00:00	AAPL	Stock	141.71	142.06	141.7	142.06	25410.0
2021-10-14 05:00:00	AAPL	Stock	141.94	142.09	141.89	141.92	8379.0
2021-10-14 06:00:00	AAPL	Stock	141.95	142.02	141.77	141.77	9662.0
2021-10-14 07:00:00	AAPL	Stock	141.79	142.22	141.72	142.13	156114.0
2021-10-14 08:00:00	AAPL	Stock	142.13	142.5	141.74	142.27	544091.0
2021-10-14 09:00:00	AAPL	Stock	142.27	142.87	141.51	142.7798	9814464.0
2021-10-14 10:00:00	AAPL	Stock	142.7718	143.29	142.7	142.86	9803236.0
2021-10-14 11:00:00	AAPL	Stock	142.86	143.22	142.64	143.19	6636418.0
2021-10-14 12:00:00	AAPL	Stock	143.19	143.61	143.17	143.52	5630962.0
2021-10-14 13:00:00	AAPL	Stock	143.52	143.64	143.33	143.5953	4316790.0
2021-10-14 14:00:00	AAPL	Stock	143.59	143.88	143.445	143.85	4548934.0
2021-10-14 15:00:00	AAPL	Stock	143.85	143.86	143.34	143.7554	9873070.0
2021-10-14 16:00:00	AAPL	Stock	143.75	144.0	143.2167	143.79	9661675.0
2021-10-14 17:00:00	AAPL	Stock	143.78	143.86	143.78	143.8	33210.0
2021-10-14 18:00:00	AAPL	Stock	143.79	143.89	143.76	143.85	21819.0
2021-10-14 19:00:00	AAPL	Stock	143.84	143.99	143.83	143.94	40091.0
2021-10-14 04:00:00	MSFT	Stock	298.0	298.7	298.0	298.65	2441.0
2021-10-14 05:00:00	MSFT	Stock	298.58	298.64	298.48	298.48	2829.0
2021-10-14 06:00:00	MSFT	Stock	298.57	298.7	298.36	298.53	3612.0
2021-10-14 07:00:00	MSFT	Stock	298.43	299.34	298.05	299.19	22145.0
2021-10-14 08:00:00	MSFT	Stock	299.1	300.29	297.05	299.41	55782.0
2021-10-14 09:00:00	MSFT	Stock	299.41	300.3195	297.83	299.84	3306833.0
2021-10-14 10:00:00	MSFT	Stock	299.86	301.08	299.68	300.2	2795729.0
2021-10-14 11:00:00	MSFT	Stock	300.21	301.057	299.85	301.02	1749439.0
2021-10-14 12:00:00	MSFT	Stock	301.02	302.0	300.95	301.66	1589253.0
2021-10-14 13:00:00	MSFT	Stock	301.66	301.84	301.135	301.39	1204576.0
2021-10-14 14:00:00	MSFT	Stock	301.39	302.1294	301.31	302.03	1337726.0
2021-10-14 15:00:00	MSFT	Stock	302.04	303.27	301.9348	302.76	3752465.0
2021-10-14 16:00:00	MSFT	Stock	302.77	303.29	302.54	303.15	5375212.0
2021-10-14 17:00:00	MSFT	Stock	303.14	303.23	303.0	303.0	9415.0
2021-10-14 18:00:00	MSFT	Stock	303.01	303.23	302.95	303.1	3451.0
2021-10-14 19:00:00	MSFT	Stock	303.02	303.5	303.0	303.35	13815.0
2021-10-14 04:00:00	NVDA	Stock	21.119	21.25	21.119	21.249	53140.0
2021-10-14 05:00:00	NVDA	Stock	21.248	21.337	21.248	21.301	94940.0
2021-10-14 06:00:00	NVDA	Stock	21.3	21.318	21.28	21.296	125530.0
2021-10-14 07:00:00	NVDA	Stock	21.28	21.3	21.205	21.29	800550.0
2021-10-14 08:00:00	NVDA	Stock	21.226	21.325	21.201	21.271	607020.0
2021-10-14 09:00:00	NVDA	Stock	21.28	21.375	21.122	21.286	31265680.0
2021-10-14 10:00:00	NVDA	Stock	21.287	21.54	21.241	21.5	33863220.0
2021-10-14 11:00:00	NVDA	Stock	21.501	21.595	21.439	21.592	20234990.0
2021-10-14 12:00:00	NVDA	Stock	21.592	21.667	21.573	21.6349	16942670.0
2021-10-14 13:00:00	NVDA	Stock	21.633	21.66	21.5716	21.626	16916770.0
2021-10-14 14:00:00	NVDA	Stock	21.624	21.6635	21.584	21.661	12225850.0
2021-10-14 15:00:00	NVDA	Stock	21.662	21.755	21.606	21.746	26578820.0
2021-10-14 16:00:00	NVDA	Stock	21.7475	21.849	21.746	21.795	15152450.0
2021-10-14 17:00:00	NVDA	Stock	21.8	21.825	21.795	21.803	137980.0
2021-10-14 18:00:00	NVDA	Stock	21.806	21.82	21.4618	21.81	95080.0
2021-10-14 19:00:00	NVDA	Stock	21.81	21.873	21.8	21.873	212490.0
2021-10-14 05:00:00	AMZN	Stock	165.5475	165.5485	165.5475	165.5485	4520.0
2021-10-14 06:00:00	AMZN	Stock	165.5255	165.5255	165.4755	165.4755	6120.0

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

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