PREVIEW / stock_1hour / 2022-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-01.parquet
  size:    1.3 MB
  rows:    60,574
  symbols: 2,270

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-01 04:00:00	AAPL	Stock	135.76	136.32	135.32	136.32	44686.0
2022-07-01 05:00:00	AAPL	Stock	136.12	136.59	136.04	136.41	34238.0
2022-07-01 06:00:00	AAPL	Stock	136.5	136.5	135.89	135.89	40059.0
2022-07-01 07:00:00	AAPL	Stock	135.98	136.35	135.42	135.65	97789.0
2022-07-01 08:00:00	AAPL	Stock	136.08	136.72	135.45	136.05	473691.0
2022-07-01 09:00:00	AAPL	Stock	136.07	138.13	135.92	137.74	8900372.0
2022-07-01 10:00:00	AAPL	Stock	137.75	138.32	135.66	136.59	10541641.0
2022-07-01 11:00:00	AAPL	Stock	136.58	137.25	136.16	136.35	6337608.0
2022-07-01 12:00:00	AAPL	Stock	136.355	137.1899	136.0718	136.52	5082933.0
2022-07-01 13:00:00	AAPL	Stock	136.505	137.72	136.44	137.7178	4943871.0
2022-07-01 14:00:00	AAPL	Stock	137.715	138.56	137.24	138.375	5638185.0
2022-07-01 15:00:00	AAPL	Stock	138.38	139.04	137.851	138.94	11213074.0
2022-07-01 16:00:00	AAPL	Stock	138.899	139.23	138.85	139.03	8387756.0
2022-07-01 17:00:00	AAPL	Stock	139.03	139.05	138.94	138.97	60557.0
2022-07-01 18:00:00	AAPL	Stock	138.97	139.02	138.92	138.96	29994.0
2022-07-01 19:00:00	AAPL	Stock	138.96	139.03	138.93	139.02	12437.0
2022-07-01 04:00:00	MSFT	Stock	255.53	256.49	254.55	256.49	5347.0
2022-07-01 05:00:00	MSFT	Stock	256.47	256.82	256.47	256.81	775.0
2022-07-01 06:00:00	MSFT	Stock	256.69	256.73	255.49	255.6	7727.0
2022-07-01 07:00:00	MSFT	Stock	255.6	256.5	254.8	255.0	11075.0
2022-07-01 08:00:00	MSFT	Stock	256.3	256.8999	254.8001	256.89	13669.0
2022-07-01 09:00:00	MSFT	Stock	256.8	258.37	254.61	257.78	2032937.0
2022-07-01 10:00:00	MSFT	Stock	257.77	258.97	254.941	256.07	2123008.0
2022-07-01 11:00:00	MSFT	Stock	256.025	257.4758	255.56	256.02	1722170.0
2022-07-01 12:00:00	MSFT	Stock	256.02	257.11	255.47	256.0217	1301479.0
2022-07-01 13:00:00	MSFT	Stock	256.0	257.77	255.8736	257.59	989099.0
2022-07-01 14:00:00	MSFT	Stock	257.6	258.88	256.94	258.72	1261420.0
2022-07-01 15:00:00	MSFT	Stock	258.73	259.77	258.2	259.61	2850241.0
2022-07-01 16:00:00	MSFT	Stock	259.55	259.84	259.01	259.58	3724214.0
2022-07-01 17:00:00	MSFT	Stock	259.7499	259.8	259.63	259.63	4815.0
2022-07-01 18:00:00	MSFT	Stock	259.6	259.79	259.57	259.57	2465.0
2022-07-01 19:00:00	MSFT	Stock	259.56	259.7	259.56	259.7	6314.0
2022-07-01 04:00:00	NVDA	Stock	14.943	15.045	14.899	15.0	212700.0
2022-07-01 05:00:00	NVDA	Stock	15.0	15.03	14.951	15.015	142330.0
2022-07-01 06:00:00	NVDA	Stock	15.017	15.017	14.871	14.871	99120.0
2022-07-01 07:00:00	NVDA	Stock	14.88	14.966	14.875	14.891	506770.0
2022-07-01 08:00:00	NVDA	Stock	14.9438	14.97	14.822	14.87	1650430.0
2022-07-01 09:00:00	NVDA	Stock	14.87	15.0629	14.59	14.841	80176440.0
2022-07-01 10:00:00	NVDA	Stock	14.845	14.973	14.517	14.66	83945170.0
2022-07-01 11:00:00	NVDA	Stock	14.657	14.763	14.537	14.565	47104250.0
2022-07-01 12:00:00	NVDA	Stock	14.564	14.65	14.462	14.463	48879400.0
2022-07-01 13:00:00	NVDA	Stock	14.461	14.545	14.413	14.509	52359370.0
2022-07-01 14:00:00	NVDA	Stock	14.51	14.642	14.392	14.607	55048740.0
2022-07-01 15:00:00	NVDA	Stock	14.609	14.62	14.466	14.521	74831380.0
2022-07-01 16:00:00	NVDA	Stock	14.521	14.525	14.48	14.515	23428230.0
2022-07-01 17:00:00	NVDA	Stock	14.515	14.525	14.5	14.514	559470.0
2022-07-01 18:00:00	NVDA	Stock	14.502	14.51	14.42	14.441	363260.0
2022-07-01 19:00:00	NVDA	Stock	14.44	14.456	14.421	14.435	374260.0
2022-07-01 04:00:00	AMZN	Stock	106.0	106.3	105.5	106.17	36535.0
2022-07-01 05:00:00	AMZN	Stock	106.15	106.5	105.95	106.49	16032.0

> showing 50 of 60,574 rows — these rows as CSV

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