PREVIEW / stock_1hour / 2023-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-03.parquet
  size:    1.4 MB
  rows:    61,781
  symbols: 1,950

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
2023-01-03 04:00:00	AAPL	Stock	130.28	131.46	130.28	131.3	97871.0
2023-01-03 05:00:00	AAPL	Stock	131.4	131.4	130.8	131.0	28583.0
2023-01-03 06:00:00	AAPL	Stock	130.91	131.25	130.05	130.38	56528.0
2023-01-03 07:00:00	AAPL	Stock	130.38	130.75	130.03	130.5	109271.0
2023-01-03 08:00:00	AAPL	Stock	130.25	131.2285	129.63	130.92	380185.0
2023-01-03 09:00:00	AAPL	Stock	130.95	131.36	126.88	126.9336	13607268.0
2023-01-03 10:00:00	AAPL	Stock	126.94	127.3	125.05	125.595	17510935.0
2023-01-03 11:00:00	AAPL	Stock	125.595	125.87	124.49	124.7425	13223056.0
2023-01-03 12:00:00	AAPL	Stock	124.75	125.055	124.3491	124.59	7916793.0
2023-01-03 13:00:00	AAPL	Stock	124.5999	124.84	124.19	124.815	7254560.0
2023-01-03 14:00:00	AAPL	Stock	124.82	125.33	124.17	124.6283	8547630.0
2023-01-03 15:00:00	AAPL	Stock	124.63	125.42	124.4	125.05	14239276.0
2023-01-03 16:00:00	AAPL	Stock	125.04	125.18	124.85	125.0207	14963915.0
2023-01-03 17:00:00	AAPL	Stock	125.02	125.04	124.84	124.92	69888.0
2023-01-03 18:00:00	AAPL	Stock	124.9	124.98	124.81	124.96	31074.0
2023-01-03 19:00:00	AAPL	Stock	124.97	125.12	124.92	125.0	88425.0
2023-01-03 04:00:00	MSFT	Stock	240.99	243.63	240.99	243.54	12310.0
2023-01-03 05:00:00	MSFT	Stock	243.55	243.55	242.64	242.95	1584.0
2023-01-03 06:00:00	MSFT	Stock	242.87	242.87	239.97	240.92	4475.0
2023-01-03 07:00:00	MSFT	Stock	240.88	241.65	240.87	241.25	10078.0
2023-01-03 08:00:00	MSFT	Stock	240.9739	242.49	240.55	242.29	33236.0
2023-01-03 09:00:00	MSFT	Stock	242.16	245.75	241.25	241.25	3068120.0
2023-01-03 10:00:00	MSFT	Stock	241.27	241.82	238.3	239.63	2680102.0
2023-01-03 11:00:00	MSFT	Stock	239.665	239.83	237.5	238.2	1854491.0
2023-01-03 12:00:00	MSFT	Stock	238.2	238.99	237.61	238.17	1508987.0
2023-01-03 13:00:00	MSFT	Stock	238.15	238.75	237.4	238.57	1397048.0
2023-01-03 14:00:00	MSFT	Stock	238.63	239.97	237.91	239.4399	1999643.0
2023-01-03 15:00:00	MSFT	Stock	239.44	240.38	239.22	239.57	2851759.0
2023-01-03 16:00:00	MSFT	Stock	239.58	239.77	239.332	239.77	4391903.0
2023-01-03 17:00:00	MSFT	Stock	239.5	239.6998	239.5	239.5041	1356.0
2023-01-03 18:00:00	MSFT	Stock	239.5	239.89	239.36	239.89	7319.0
2023-01-03 19:00:00	MSFT	Stock	239.95	240.87	239.71	240.87	31077.0
2023-01-03 04:00:00	NVDA	Stock	15.07	15.1	14.817	14.978	274670.0
2023-01-03 05:00:00	NVDA	Stock	14.979	14.988	14.88	14.949	101580.0
2023-01-03 06:00:00	NVDA	Stock	14.945	14.97	14.776	14.8	622610.0
2023-01-03 07:00:00	NVDA	Stock	14.8	14.864	14.7	14.815	482820.0
2023-01-03 08:00:00	NVDA	Stock	14.776	14.875	14.671	14.85	1005520.0
2023-01-03 09:00:00	NVDA	Stock	14.832	14.996	14.536	14.5427	58443700.0
2023-01-03 10:00:00	NVDA	Stock	14.545	14.559	14.103	14.337	75385140.0
2023-01-03 11:00:00	NVDA	Stock	14.338	14.357	14.096	14.139	45818790.0
2023-01-03 12:00:00	NVDA	Stock	14.1405	14.251	14.129	14.1977	28671430.0
2023-01-03 13:00:00	NVDA	Stock	14.197	14.286	14.163	14.262	27328000.0
2023-01-03 14:00:00	NVDA	Stock	14.264	14.363	14.164	14.311	34199900.0
2023-01-03 15:00:00	NVDA	Stock	14.312	14.408	14.273	14.315	45468680.0
2023-01-03 16:00:00	NVDA	Stock	14.315	14.337	14.28	14.337	19146090.0
2023-01-03 17:00:00	NVDA	Stock	14.337	14.337	14.314	14.314	80110.0
2023-01-03 18:00:00	NVDA	Stock	14.313	14.322	14.307	14.314	162490.0
2023-01-03 19:00:00	NVDA	Stock	14.315	14.334	14.305	14.311	141400.0
2023-01-03 04:00:00	AMZN	Stock	85.01	85.66	84.65	85.59	52145.0
2023-01-03 05:00:00	AMZN	Stock	85.59	85.64	85.25	85.48	18665.0

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

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