PREVIEW / stock_1hour / 2000-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-05-01.parquet
  size:    285 KB
  rows:    14,656
  symbols: 1,164

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
2000-05-01 09:00:00	AAPL	Stock	1.115	1.1161	1.0882	1.1032	25267200.0
2000-05-01 10:00:00	AAPL	Stock	1.1066	1.1172	1.0882	1.1172	44004800.0
2000-05-01 11:00:00	AAPL	Stock	1.1172	1.1172	1.1077	1.1105	18345600.0
2000-05-01 12:00:00	AAPL	Stock	1.1099	1.1161	1.0949	1.0965	29971200.0
2000-05-01 13:00:00	AAPL	Stock	1.0965	1.1049	1.0949	1.1021	39088000.0
2000-05-01 14:00:00	AAPL	Stock	1.1021	1.1133	1.1016	1.1085	17628800.0
2000-05-01 15:00:00	AAPL	Stock	1.1088	1.1138	1.1016	1.1099	40208000.0
2000-05-01 16:00:00	AAPL	Stock	1.1099	1.1099	1.1094	1.1099	1635200.0
2000-05-01 09:00:00	MSFT	Stock	36.4375	36.625	35.8438	36.0781	22181800.0
2000-05-01 10:00:00	MSFT	Stock	36.0938	36.375	35.875	36.3125	16426800.0
2000-05-01 11:00:00	MSFT	Stock	36.3438	36.8125	36.1875	36.7188	15956400.0
2000-05-01 12:00:00	MSFT	Stock	36.7188	36.7188	36.2812	36.3438	8340600.0
2000-05-01 13:00:00	MSFT	Stock	36.375	36.4375	36.0625	36.3125	9748800.0
2000-05-01 14:00:00	MSFT	Stock	36.3438	36.9375	36.2812	36.875	11138000.0
2000-05-01 15:00:00	MSFT	Stock	36.875	37.0	36.4062	36.7188	16701400.0
2000-05-01 16:00:00	MSFT	Stock	36.7031	36.7188	36.6875	36.7188	322400.0
2000-05-01 09:00:00	NVDA	Stock	0.1927	0.194	0.1904	0.1917	9504000.0
2000-05-01 10:00:00	NVDA	Stock	0.1915	0.1969	0.1906	0.1932	33456000.0
2000-05-01 11:00:00	NVDA	Stock	0.1932	0.1932	0.1918	0.1924	10032000.0
2000-05-01 12:00:00	NVDA	Stock	0.1924	0.1924	0.1885	0.1891	8544000.0
2000-05-01 13:00:00	NVDA	Stock	0.1888	0.191	0.1871	0.1909	18912000.0
2000-05-01 14:00:00	NVDA	Stock	0.1906	0.1931	0.1891	0.1891	14928000.0
2000-05-01 15:00:00	NVDA	Stock	0.1914	0.1927	0.1878	0.1927	16800000.0
2000-05-01 16:00:00	NVDA	Stock	0.1917	0.1917	0.1917	0.1917	240000.0
2000-05-01 09:00:00	AMZN	Stock	2.8	2.8313	2.7625	2.825	20712000.0
2000-05-01 10:00:00	AMZN	Stock	2.825	2.9375	2.8063	2.9125	29808000.0
2000-05-01 11:00:00	AMZN	Stock	2.9094	2.9875	2.8812	2.9531	20438000.0
2000-05-01 12:00:00	AMZN	Stock	2.95	2.9875	2.9469	2.9469	16084000.0
2000-05-01 13:00:00	AMZN	Stock	2.9469	2.9625	2.8844	2.9375	23694000.0
2000-05-01 14:00:00	AMZN	Stock	2.9375	2.9625	2.9188	2.9609	17092000.0
2000-05-01 15:00:00	AMZN	Stock	2.9594	3.0156	2.9313	3.0	33500000.0
2000-05-01 16:00:00	AMZN	Stock	3.0	3.0	2.9969	2.9969	234000.0
2000-05-01 09:00:00	CL	Stock	28.0	28.0312	27.9062	27.9375	244400.0
2000-05-01 10:00:00	CL	Stock	27.9375	28.25	27.875	28.0	412200.0
2000-05-01 11:00:00	CL	Stock	28.0	28.0312	27.8438	27.9062	202800.0
2000-05-01 12:00:00	CL	Stock	27.9062	28.0	27.6875	27.7188	292000.0
2000-05-01 13:00:00	CL	Stock	27.7188	27.9062	27.7188	27.875	459200.0
2000-05-01 14:00:00	CL	Stock	27.8438	27.9688	27.8438	27.9375	372000.0
2000-05-01 15:00:00	CL	Stock	27.9375	28.0	27.6562	27.7188	509000.0
2000-05-01 16:00:00	CL	Stock	27.6562	27.6562	27.5625	27.5625	96800.0

> showing 40 of 14,656 rows — these rows as CSV

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