PREVIEW / stock_1hour / 2000-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-19.parquet
  size:    300 KB
  rows:    15,643
  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-19 08:00:00	AAPL	Stock	1.0536	1.0848	1.0536	1.0804	980000.0
2000-09-19 09:00:00	AAPL	Stock	1.0804	1.0804	1.0458	1.0692	46457600.0
2000-09-19 10:00:00	AAPL	Stock	1.0692	1.0737	1.0458	1.0625	44850400.0
2000-09-19 11:00:00	AAPL	Stock	1.0625	1.0804	1.0603	1.0709	42033600.0
2000-09-19 12:00:00	AAPL	Stock	1.0703	1.0714	1.0513	1.0558	17824800.0
2000-09-19 13:00:00	AAPL	Stock	1.0558	1.0681	1.0536	1.0658	21526400.0
2000-09-19 14:00:00	AAPL	Stock	1.0658	1.0748	1.0647	1.0703	39855200.0
2000-09-19 15:00:00	AAPL	Stock	1.0703	1.0737	1.0575	1.0692	34518400.0
2000-09-19 16:00:00	AAPL	Stock	1.0692	1.0714	1.0636	1.0658	9996000.0
2000-09-19 17:00:00	AAPL	Stock	1.0653	1.0653	1.0653	1.0653	336000.0
2000-09-19 08:00:00	MSFT	Stock	31.5312	31.9688	31.1875	31.8125	358402.0
2000-09-19 09:00:00	MSFT	Stock	31.8125	32.1875	31.0	31.9531	10827800.0
2000-09-19 10:00:00	MSFT	Stock	31.9375	32.1875	31.75	31.9531	9665000.0
2000-09-19 11:00:00	MSFT	Stock	31.9688	32.375	31.9062	32.0625	8499200.0
2000-09-19 12:00:00	MSFT	Stock	32.0312	32.0938	31.875	31.9688	4727000.0
2000-09-19 13:00:00	MSFT	Stock	31.9688	32.875	31.9688	32.4844	21526800.0
2000-09-19 14:00:00	MSFT	Stock	32.4688	32.5	32.1875	32.3438	6347800.0
2000-09-19 15:00:00	MSFT	Stock	32.3125	32.7812	32.2812	32.5312	12465200.0
2000-09-19 16:00:00	MSFT	Stock	32.5312	32.6875	32.4375	32.6875	2656000.0
2000-09-19 17:00:00	MSFT	Stock	32.5	32.6875	32.5	32.625	11400.0
2000-09-19 18:00:00	MSFT	Stock	32.6562	32.6562	32.6562	32.6562	4000.0
2000-09-19 08:00:00	NVDA	Stock	0.2818	0.2818	0.2708	0.2708	12408000.0
2000-09-19 09:00:00	NVDA	Stock	0.2688	0.2719	0.2625	0.2698	58680000.0
2000-09-19 10:00:00	NVDA	Stock	0.2695	0.2706	0.2643	0.2646	54768000.0
2000-09-19 11:00:00	NVDA	Stock	0.2646	0.2688	0.2643	0.2667	25056000.0
2000-09-19 12:00:00	NVDA	Stock	0.2656	0.2682	0.2635	0.2674	12528000.0
2000-09-19 13:00:00	NVDA	Stock	0.2672	0.2729	0.2669	0.2706	24000000.0
2000-09-19 14:00:00	NVDA	Stock	0.271	0.2729	0.2685	0.2703	32232000.0
2000-09-19 15:00:00	NVDA	Stock	0.2711	0.2875	0.2711	0.287	68376000.0
2000-09-19 16:00:00	NVDA	Stock	0.2867	0.2875	0.2849	0.2867	4392000.0
2000-09-19 17:00:00	NVDA	Stock	0.2875	0.2875	0.2875	0.2875	240000.0
2000-09-19 18:00:00	NVDA	Stock	0.2875	0.2875	0.2865	0.2865	96000.0
2000-09-19 08:00:00	AMZN	Stock	2.0875	2.1297	2.0781	2.0906	510000.0
2000-09-19 09:00:00	AMZN	Stock	2.0969	2.1344	2.0813	2.1125	10882000.0
2000-09-19 10:00:00	AMZN	Stock	2.1125	2.1375	1.9906	2.0094	26914000.0
2000-09-19 11:00:00	AMZN	Stock	2.0062	2.0438	2.0031	2.025	23912000.0
2000-09-19 12:00:00	AMZN	Stock	2.0219	2.0281	1.975	2.0031	18370000.0
2000-09-19 13:00:00	AMZN	Stock	2.0031	2.025	1.9562	1.975	14788000.0
2000-09-19 14:00:00	AMZN	Stock	1.975	2.0188	1.9719	2.0094	14360000.0
2000-09-19 15:00:00	AMZN	Stock	2.0094	2.0594	2.0094	2.0375	26174000.0
2000-09-19 16:00:00	AMZN	Stock	2.0375	2.0406	1.9812	1.9812	5708000.0
2000-09-19 17:00:00	AMZN	Stock	2.0312	2.0328	1.9906	2.025	144000.0
2000-09-19 18:00:00	AMZN	Stock	2.0312	2.0312	2.025	2.0312	20000.0
2000-09-19 09:00:00	CL	Stock	22.5	22.625	22.4062	22.4688	2016000.0
2000-09-19 10:00:00	CL	Stock	22.4688	22.5312	22.125	22.1562	2077000.0
2000-09-19 11:00:00	CL	Stock	22.1875	22.3125	22.1875	22.2812	1399000.0
2000-09-19 12:00:00	CL	Stock	22.3125	22.375	22.1875	22.2188	732000.0
2000-09-19 13:00:00	CL	Stock	22.1875	22.3125	22.1562	22.3125	2158000.0
2000-09-19 14:00:00	CL	Stock	22.3125	22.3125	22.0312	22.0938	1192000.0
2000-09-19 15:00:00	CL	Stock	22.0625	22.3125	22.0312	22.25	3399000.0

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

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