PREVIEW / stock_1hour / 2006-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-13.parquet
  size:    635 KB
  rows:    29,942
  symbols: 2,300

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
2006-06-13 06:00:00	AAPL	Stock	2.0196	2.0196	2.0196	2.0196	2800.0
2006-06-13 07:00:00	AAPL	Stock	2.0221	2.0446	2.0221	2.0446	630420.0
2006-06-13 08:00:00	AAPL	Stock	2.0414	2.0604	2.0311	2.0536	8064448.0
2006-06-13 09:00:00	AAPL	Stock	2.0546	2.0964	2.0489	2.0786	155671376.0
2006-06-13 10:00:00	AAPL	Stock	2.0786	2.0804	2.0486	2.0593	193873204.0
2006-06-13 11:00:00	AAPL	Stock	2.0593	2.0971	2.0543	2.0961	154550704.0
2006-06-13 12:00:00	AAPL	Stock	2.0957	2.1107	2.0911	2.1039	128294320.0
2006-06-13 13:00:00	AAPL	Stock	2.1039	2.105	2.0811	2.1007	107861712.0
2006-06-13 14:00:00	AAPL	Stock	2.1007	2.1011	2.075	2.0865	107790872.0
2006-06-13 15:00:00	AAPL	Stock	2.0871	2.1064	2.0675	2.0814	206295208.0
2006-06-13 16:00:00	AAPL	Stock	2.0796	2.103	2.0779	2.0843	2453332.0
2006-06-13 17:00:00	AAPL	Stock	2.0843	2.0871	2.0843	2.0843	151060.0
2006-06-13 18:00:00	AAPL	Stock	2.0843	2.0893	2.0843	2.0893	269640.0
2006-06-13 06:00:00	MSFT	Stock	21.63	21.63	21.58	21.58	1700.0
2006-06-13 07:00:00	MSFT	Stock	21.59	21.65	21.59	21.64	6300.0
2006-06-13 08:00:00	MSFT	Stock	21.64	21.74	21.62	21.69	68751.0
2006-06-13 09:00:00	MSFT	Stock	21.68	22.03	21.67	21.89	14254939.0
2006-06-13 10:00:00	MSFT	Stock	21.9	21.99	21.77	21.89	16427823.0
2006-06-13 11:00:00	MSFT	Stock	21.89	22.02	21.82	21.93	14954024.0
2006-06-13 12:00:00	MSFT	Stock	21.928	21.95	21.74	21.86	12424727.0
2006-06-13 13:00:00	MSFT	Stock	21.86	21.87	21.68	21.76	11506241.0
2006-06-13 14:00:00	MSFT	Stock	21.75	21.93	21.47	21.56	17375100.0
2006-06-13 15:00:00	MSFT	Stock	21.57	21.94	21.46	21.48	22785027.0
2006-06-13 16:00:00	MSFT	Stock	21.48	21.85	21.45	21.53	841811.0
2006-06-13 17:00:00	MSFT	Stock	21.54	21.57	21.54	21.55	41500.0
2006-06-13 18:00:00	MSFT	Stock	21.54	21.54	21.53	21.53	4000.0
2006-06-13 08:00:00	NVDA	Stock	0.3335	0.3337	0.3322	0.3332	272100.0
2006-06-13 09:00:00	NVDA	Stock	0.3333	0.3428	0.3333	0.3395	55205580.0
2006-06-13 10:00:00	NVDA	Stock	0.3395	0.3408	0.328	0.329	84663840.0
2006-06-13 11:00:00	NVDA	Stock	0.3288	0.3403	0.328	0.3383	79849800.0
2006-06-13 12:00:00	NVDA	Stock	0.3382	0.3395	0.334	0.3342	57419220.0
2006-06-13 13:00:00	NVDA	Stock	0.3342	0.3342	0.3292	0.3323	47441580.0
2006-06-13 14:00:00	NVDA	Stock	0.3322	0.333	0.3287	0.3292	52649040.0
2006-06-13 15:00:00	NVDA	Stock	0.3293	0.3363	0.3278	0.331	116433900.0
2006-06-13 16:00:00	NVDA	Stock	0.3308	0.3317	0.3303	0.331	282000.0
2006-06-13 17:00:00	NVDA	Stock	0.3317	0.3317	0.3317	0.3317	30000.0
2006-06-13 18:00:00	NVDA	Stock	0.3318	0.3318	0.3318	0.3318	60000.0
2006-06-13 09:00:00	AMZN	Stock	1.6725	1.704	1.6568	1.6935	16319180.0
2006-06-13 10:00:00	AMZN	Stock	1.6925	1.6945	1.6715	1.6775	16119680.0
2006-06-13 11:00:00	AMZN	Stock	1.677	1.7075	1.673	1.707	13560280.0
2006-06-13 12:00:00	AMZN	Stock	1.707	1.7085	1.6885	1.6975	10657780.0
2006-06-13 13:00:00	AMZN	Stock	1.697	1.7	1.685	1.6935	8431640.0
2006-06-13 14:00:00	AMZN	Stock	1.6932	1.694	1.666	1.6725	19050640.0
2006-06-13 15:00:00	AMZN	Stock	1.6725	1.6925	1.6655	1.673	21637700.0
2006-06-13 16:00:00	AMZN	Stock	1.673	1.6844	1.6705	1.6844	96460.0
2006-06-13 17:00:00	AMZN	Stock	1.6905	1.6905	1.6905	1.6905	2000.0
2006-06-13 09:00:00	CL	Stock	30.625	30.75	30.625	30.69	362800.0
2006-06-13 10:00:00	CL	Stock	30.685	30.685	30.41	30.515	940400.0
2006-06-13 11:00:00	CL	Stock	30.505	30.8	30.445	30.7625	695000.0
2006-06-13 12:00:00	CL	Stock	30.73	30.755	30.6	30.615	445200.0

> showing 50 of 29,942 rows — these rows as CSV

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