PREVIEW / stock_1hour / 2000-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-18.parquet
  size:    307 KB
  rows:    15,724
  symbols: 1,224

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-09-18 08:00:00	AAPL	Stock	0.9861	0.9994	0.9861	0.9994	576800.0
2000-09-18 09:00:00	AAPL	Stock	0.9955	1.0134	0.9849	1.0089	45231200.0
2000-09-18 10:00:00	AAPL	Stock	1.0089	1.0246	1.0056	1.0112	51856000.0
2000-09-18 11:00:00	AAPL	Stock	1.0112	1.0201	1.0022	1.0056	44178400.0
2000-09-18 12:00:00	AAPL	Stock	1.0056	1.0067	0.9833	1.0011	53664800.0
2000-09-18 13:00:00	AAPL	Stock	1.0	1.0156	0.9955	1.014	37010400.0
2000-09-18 14:00:00	AAPL	Stock	1.0134	1.0525	1.0089	1.0502	46698400.0
2000-09-18 15:00:00	AAPL	Stock	1.0469	1.0848	1.0402	1.0826	106618400.0
2000-09-18 16:00:00	AAPL	Stock	1.0826	1.0893	1.0223	1.0759	34288800.0
2000-09-18 17:00:00	AAPL	Stock	1.0748	1.0831	1.0748	1.0753	151200.0
2000-09-18 18:00:00	AAPL	Stock	1.0753	1.0753	1.0748	1.0748	61600.0
2000-09-18 08:00:00	MSFT	Stock	32.0938	32.7188	32.0625	32.4375	735000.0
2000-09-18 09:00:00	MSFT	Stock	32.4375	32.4375	31.9375	32.1875	8939800.0
2000-09-18 10:00:00	MSFT	Stock	32.1875	32.2188	31.9062	31.9062	10951400.0
2000-09-18 11:00:00	MSFT	Stock	31.9062	31.9688	31.625	31.6875	8178800.0
2000-09-18 12:00:00	MSFT	Stock	31.6875	31.8125	31.2812	31.3125	7828600.0
2000-09-18 13:00:00	MSFT	Stock	31.3438	31.5	31.0938	31.5	9998000.0
2000-09-18 14:00:00	MSFT	Stock	31.5	31.5938	31.1875	31.5	7197400.0
2000-09-18 15:00:00	MSFT	Stock	31.5	31.75	31.1875	31.5312	11540400.0
2000-09-18 16:00:00	MSFT	Stock	31.5312	31.8594	31.3438	31.75	1709200.0
2000-09-18 17:00:00	MSFT	Stock	31.75	31.75	31.25	31.6875	103600.0
2000-09-18 18:00:00	MSFT	Stock	31.5625	31.6875	31.5625	31.625	600.0
2000-09-18 09:00:00	NVDA	Stock	0.2958	0.2979	0.288	0.2958	17520000.0
2000-09-18 10:00:00	NVDA	Stock	0.2958	0.2969	0.2914	0.2914	16512000.0
2000-09-18 11:00:00	NVDA	Stock	0.2914	0.2932	0.2875	0.2891	24120000.0
2000-09-18 12:00:00	NVDA	Stock	0.2888	0.2904	0.276	0.2781	27240000.0
2000-09-18 13:00:00	NVDA	Stock	0.2755	0.2823	0.275	0.2823	29448000.0
2000-09-18 14:00:00	NVDA	Stock	0.2792	0.2865	0.2792	0.2831	15960000.0
2000-09-18 15:00:00	NVDA	Stock	0.2831	0.2854	0.2763	0.2781	23784000.0
2000-09-18 16:00:00	NVDA	Stock	0.2792	0.2797	0.2781	0.2781	2592000.0
2000-09-18 17:00:00	NVDA	Stock	0.2833	0.2833	0.2833	0.2833	24000.0
2000-09-18 08:00:00	AMZN	Stock	2.1812	2.2188	2.1812	2.2094	48000.0
2000-09-18 09:00:00	AMZN	Stock	2.2063	2.2188	2.1438	2.1953	11028000.0
2000-09-18 10:00:00	AMZN	Stock	2.2	2.2312	2.15	2.2188	15858000.0
2000-09-18 11:00:00	AMZN	Stock	2.2188	2.225	2.1781	2.1875	14334000.0
2000-09-18 12:00:00	AMZN	Stock	2.1875	2.1906	2.1375	2.1375	9070000.0
2000-09-18 13:00:00	AMZN	Stock	2.1406	2.1406	2.0938	2.1281	12072000.0
2000-09-18 14:00:00	AMZN	Stock	2.1281	2.1812	2.1062	2.175	9764000.0
2000-09-18 15:00:00	AMZN	Stock	2.175	2.1812	2.1156	2.1406	14312000.0
2000-09-18 16:00:00	AMZN	Stock	2.1375	2.1625	2.1344	2.1438	1298000.0
2000-09-18 17:00:00	AMZN	Stock	2.1406	2.1406	2.1281	2.1281	24000.0
2000-09-18 09:00:00	CL	Stock	22.8125	23.1562	22.6562	22.6562	1387800.0
2000-09-18 10:00:00	CL	Stock	22.6562	22.75	22.4062	22.5625	1589200.0
2000-09-18 11:00:00	CL	Stock	22.625	22.7812	22.3438	22.4375	882800.0
2000-09-18 12:00:00	CL	Stock	22.4062	22.4688	22.2188	22.2188	765200.0
2000-09-18 13:00:00	CL	Stock	22.2188	22.4375	22.1875	22.3438	1013200.0
2000-09-18 14:00:00	CL	Stock	22.3125	22.5	22.1875	22.3438	1968000.0
2000-09-18 15:00:00	CL	Stock	22.3125	22.4062	22.125	22.2188	2397800.0
2000-09-18 16:00:00	CL	Stock	22.2188	22.6875	22.2188	22.25	464400.0
2000-09-18 17:00:00	CL	Stock	22.25	22.25	22.25	22.25	20000.0

> showing 50 of 15,724 rows — these rows as CSV

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