PREVIEW / stock_1hour / 2000-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-20.parquet
  size:    304 KB
  rows:    15,577
  symbols: 1,229

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-20 08:00:00	AAPL	Stock	1.0698	1.0748	1.0698	1.0714	812000.0
2000-09-20 09:00:00	AAPL	Stock	1.067	1.067	1.0458	1.0502	23088800.0
2000-09-20 10:00:00	AAPL	Stock	1.0502	1.0692	1.0469	1.0636	28750400.0
2000-09-20 11:00:00	AAPL	Stock	1.0636	1.067	1.0513	1.0603	17718400.0
2000-09-20 12:00:00	AAPL	Stock	1.0614	1.0658	1.0513	1.0569	12902400.0
2000-09-20 13:00:00	AAPL	Stock	1.0575	1.0625	1.0469	1.0603	20916000.0
2000-09-20 14:00:00	AAPL	Stock	1.0603	1.0804	1.0569	1.0725	44828000.0
2000-09-20 15:00:00	AAPL	Stock	1.0737	1.0971	1.0725	1.0893	61409600.0
2000-09-20 16:00:00	AAPL	Stock	1.0898	1.0915	1.0692	1.0898	11720800.0
2000-09-20 17:00:00	AAPL	Stock	1.0737	1.0848	1.0737	1.0848	22400.0
2000-09-20 08:00:00	MSFT	Stock	32.625	32.6875	32.5	32.5312	411800.0
2000-09-20 09:00:00	MSFT	Stock	32.5312	32.6875	31.8438	31.9062	8993200.0
2000-09-20 10:00:00	MSFT	Stock	31.9062	32.1875	31.6562	31.75	10895600.0
2000-09-20 11:00:00	MSFT	Stock	31.75	31.8125	31.5938	31.6875	10572000.0
2000-09-20 12:00:00	MSFT	Stock	31.6875	31.875	31.6562	31.875	8137000.0
2000-09-20 13:00:00	MSFT	Stock	31.875	31.9062	31.6875	31.875	7970400.0
2000-09-20 14:00:00	MSFT	Stock	31.875	32.2188	31.8125	32.0938	9951000.0
2000-09-20 15:00:00	MSFT	Stock	32.0938	32.25	31.8125	32.125	7633000.0
2000-09-20 16:00:00	MSFT	Stock	32.1562	32.3125	31.8438	32.25	930400.0
2000-09-20 17:00:00	MSFT	Stock	32.25	32.25	32.1875	32.25	3800.0
2000-09-20 18:00:00	MSFT	Stock	32.25	32.3125	32.25	32.25	600.0
2000-09-20 09:00:00	NVDA	Stock	0.2844	0.2844	0.2773	0.2797	44760000.0
2000-09-20 10:00:00	NVDA	Stock	0.2799	0.2802	0.2766	0.2781	29976000.0
2000-09-20 11:00:00	NVDA	Stock	0.2786	0.2786	0.2766	0.2766	12576000.0
2000-09-20 12:00:00	NVDA	Stock	0.2771	0.2792	0.2766	0.2766	13560000.0
2000-09-20 13:00:00	NVDA	Stock	0.276	0.276	0.2729	0.2745	19464000.0
2000-09-20 14:00:00	NVDA	Stock	0.2747	0.2788	0.2737	0.2771	26232000.0
2000-09-20 15:00:00	NVDA	Stock	0.2771	0.2802	0.2768	0.2773	53784000.0
2000-09-20 16:00:00	NVDA	Stock	0.2773	0.2786	0.2773	0.2773	18120000.0
2000-09-20 08:00:00	AMZN	Stock	2.025	2.0438	1.975	2.0125	844000.0
2000-09-20 09:00:00	AMZN	Stock	2.0125	2.0375	1.9781	1.9969	21302000.0
2000-09-20 10:00:00	AMZN	Stock	1.9969	2.0188	1.9438	1.9469	32490000.0
2000-09-20 11:00:00	AMZN	Stock	1.9438	1.9469	1.875	1.8812	36028000.0
2000-09-20 12:00:00	AMZN	Stock	1.8812	1.9062	1.875	1.8938	15826000.0
2000-09-20 13:00:00	AMZN	Stock	1.8938	1.9094	1.875	1.8938	12498000.0
2000-09-20 14:00:00	AMZN	Stock	1.8938	1.9375	1.8875	1.9344	27878000.0
2000-09-20 15:00:00	AMZN	Stock	1.9312	1.9625	1.8688	1.8781	38754000.0
2000-09-20 16:00:00	AMZN	Stock	1.8781	1.9	1.875	1.8812	1736000.0
2000-09-20 17:00:00	AMZN	Stock	1.875	1.8812	1.875	1.8781	106000.0
2000-09-20 18:00:00	AMZN	Stock	1.8812	1.8812	1.8812	1.8812	8000.0
2000-09-20 09:00:00	CL	Stock	22.125	22.4688	22.0938	22.2812	1233600.0
2000-09-20 10:00:00	CL	Stock	22.3125	22.3438	22.125	22.2188	651400.0
2000-09-20 11:00:00	CL	Stock	22.1875	22.2188	21.875	22.0625	1138000.0
2000-09-20 12:00:00	CL	Stock	22.0625	22.0938	21.375	21.5	1671000.0
2000-09-20 13:00:00	CL	Stock	21.5	21.5938	21.4375	21.5938	945800.0
2000-09-20 14:00:00	CL	Stock	21.5938	21.9375	21.5	21.625	988200.0
2000-09-20 15:00:00	CL	Stock	21.625	21.7812	21.4062	21.5	1909000.0
2000-09-20 16:00:00	CL	Stock	21.5312	21.7656	21.5	21.7656	122200.0
2000-09-20 17:00:00	CL	Stock	21.5312	21.5312	21.5312	21.5312	30000.0

> showing 49 of 15,577 rows — these rows as CSV

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