PREVIEW / stock_1hour / 2001-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-20.parquet
  size:    375 KB
  rows:    18,278
  symbols: 1,345

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
2001-09-20 08:00:00	AAPL	Stock	0.3	0.3	0.2964	0.2964	476000.0
2001-09-20 09:00:00	AAPL	Stock	0.3039	0.3039	0.2877	0.2927	36517600.0
2001-09-20 10:00:00	AAPL	Stock	0.2936	0.2959	0.283	0.2909	40280800.0
2001-09-20 11:00:00	AAPL	Stock	0.2905	0.3021	0.2891	0.2986	55703200.0
2001-09-20 12:00:00	AAPL	Stock	0.2986	0.3027	0.2866	0.2882	47656000.0
2001-09-20 13:00:00	AAPL	Stock	0.2882	0.292	0.2882	0.2913	30850400.0
2001-09-20 14:00:00	AAPL	Stock	0.2911	0.2914	0.285	0.2852	30139200.0
2001-09-20 15:00:00	AAPL	Stock	0.2863	0.2875	0.2768	0.28	83294400.0
2001-09-20 16:00:00	AAPL	Stock	0.28	0.2857	0.2796	0.2821	45763200.0
2001-09-20 17:00:00	AAPL	Stock	0.28	0.2826	0.28	0.28	3057600.0
2001-09-20 08:00:00	MSFT	Stock	26.675	26.9475	26.18	26.375	109600.0
2001-09-20 09:00:00	MSFT	Stock	26.375	26.935	25.805	26.075	17264400.0
2001-09-20 10:00:00	MSFT	Stock	26.075	26.3	25.8	26.1245	24115000.0
2001-09-20 11:00:00	MSFT	Stock	26.125	26.2245	25.856	25.9055	10672200.0
2001-09-20 12:00:00	MSFT	Stock	25.905	26.075	25.545	25.59	12266400.0
2001-09-20 13:00:00	MSFT	Stock	25.59	25.925	25.5495	25.835	9235200.0
2001-09-20 14:00:00	MSFT	Stock	25.835	25.87	25.525	25.6	10553200.0
2001-09-20 15:00:00	MSFT	Stock	25.595	25.925	25.35	25.375	22596600.0
2001-09-20 16:00:00	MSFT	Stock	25.38	26.1	25.12	25.175	3804200.0
2001-09-20 17:00:00	MSFT	Stock	25.305	25.84	25.18	25.38	1200400.0
2001-09-20 18:00:00	MSFT	Stock	25.225	25.25	25.2	25.225	5800.0
2001-09-20 08:00:00	NVDA	Stock	0.2582	0.2582	0.2512	0.2563	912000.0
2001-09-20 09:00:00	NVDA	Stock	0.2563	0.2629	0.2427	0.2489	234108000.0
2001-09-20 10:00:00	NVDA	Stock	0.2488	0.2521	0.2333	0.2485	378660000.0
2001-09-20 11:00:00	NVDA	Stock	0.2499	0.2508	0.2402	0.2412	217980000.0
2001-09-20 12:00:00	NVDA	Stock	0.2412	0.2442	0.2355	0.2383	108876000.0
2001-09-20 13:00:00	NVDA	Stock	0.2379	0.2446	0.2371	0.2437	125160000.0
2001-09-20 14:00:00	NVDA	Stock	0.2437	0.2448	0.2371	0.2407	129300000.0
2001-09-20 15:00:00	NVDA	Stock	0.2404	0.2423	0.2359	0.2407	154800000.0
2001-09-20 16:00:00	NVDA	Stock	0.2406	0.2412	0.2389	0.2396	23520000.0
2001-09-20 17:00:00	NVDA	Stock	0.2406	0.2407	0.2396	0.2407	1860000.0
2001-09-20 18:00:00	NVDA	Stock	0.2407	0.241	0.2407	0.241	36000.0
2001-09-20 08:00:00	AMZN	Stock	0.3615	0.3615	0.357	0.357	162000.0
2001-09-20 09:00:00	AMZN	Stock	0.3575	0.3725	0.3525	0.368	24942000.0
2001-09-20 10:00:00	AMZN	Stock	0.3685	0.3775	0.3645	0.3775	30852000.0
2001-09-20 11:00:00	AMZN	Stock	0.3765	0.382	0.371	0.3795	19754000.0
2001-09-20 12:00:00	AMZN	Stock	0.378	0.382	0.371	0.371	29782000.0
2001-09-20 13:00:00	AMZN	Stock	0.3725	0.379	0.371	0.3745	10682000.0
2001-09-20 14:00:00	AMZN	Stock	0.3755	0.3795	0.37	0.3705	12290000.0
2001-09-20 15:00:00	AMZN	Stock	0.371	0.3765	0.37	0.3735	18392000.0
2001-09-20 16:00:00	AMZN	Stock	0.374	0.377	0.367	0.367	4832000.0
2001-09-20 17:00:00	AMZN	Stock	0.374	0.374	0.374	0.374	204000.0
2001-09-20 09:00:00	CL	Stock	28.15	28.185	27.985	28.095	680400.0
2001-09-20 10:00:00	CL	Stock	28.125	28.14	27.65	27.8	582200.0
2001-09-20 11:00:00	CL	Stock	27.775	27.975	27.65	27.8	360800.0
2001-09-20 12:00:00	CL	Stock	27.785	27.9	27.31	27.325	761600.0
2001-09-20 13:00:00	CL	Stock	27.32	27.495	27.245	27.4	567000.0
2001-09-20 14:00:00	CL	Stock	27.375	27.5	27.345	27.45	541000.0
2001-09-20 15:00:00	CL	Stock	27.445	27.57	27.375	27.405	810600.0
2001-09-20 16:00:00	CL	Stock	27.405	27.625	27.375	27.375	194200.0

> showing 50 of 18,278 rows — these rows as CSV

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