PREVIEW / stock_1hour / 2012-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-01.parquet
  size:    957 KB
  rows:    45,658
  symbols: 3,476

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
2012-10-01 04:00:00	AAPL	Stock	23.8093	23.9289	23.8093	23.9286	160300.0
2012-10-01 05:00:00	AAPL	Stock	23.9446	23.9679	23.9407	23.9679	87780.0
2012-10-01 06:00:00	AAPL	Stock	23.95	23.95	23.9429	23.9429	18200.0
2012-10-01 07:00:00	AAPL	Stock	23.9571	24.0	23.8654	23.9879	922040.0
2012-10-01 08:00:00	AAPL	Stock	23.9604	24.0071	23.8307	23.9896	2178288.0
2012-10-01 09:00:00	AAPL	Stock	23.9918	24.0232	23.8126	23.9307	70535752.0
2012-10-01 10:00:00	AAPL	Stock	23.9354	24.1696	23.935	24.0521	88343388.0
2012-10-01 11:00:00	AAPL	Stock	24.0521	24.1196	24.0179	24.0264	31850140.0
2012-10-01 12:00:00	AAPL	Stock	24.0271	24.0695	23.8304	23.8782	57056552.0
2012-10-01 13:00:00	AAPL	Stock	23.8771	23.9107	23.6429	23.8271	90607720.0
2012-10-01 14:00:00	AAPL	Stock	23.8271	23.8479	23.7004	23.7318	50982456.0
2012-10-01 15:00:00	AAPL	Stock	23.7325	23.7379	23.4464	23.5621	131218108.0
2012-10-01 16:00:00	AAPL	Stock	23.5571	24.095	23.5052	23.5679	12586700.0
2012-10-01 17:00:00	AAPL	Stock	23.5714	23.5839	23.5496	23.5618	347144.0
2012-10-01 18:00:00	AAPL	Stock	23.5664	23.5707	23.5546	23.5679	356104.0
2012-10-01 19:00:00	AAPL	Stock	23.5629	23.5643	23.5414	23.55	383040.0
2012-10-01 04:00:00	MSFT	Stock	29.76	29.77	29.76	29.76	700.0
2012-10-01 05:00:00	MSFT	Stock	29.71	29.71	29.69	29.69	6190.0
2012-10-01 06:00:00	MSFT	Stock	29.7	29.76	29.69	29.76	3300.0
2012-10-01 07:00:00	MSFT	Stock	29.77	29.77	29.66	29.66	20858.0
2012-10-01 08:00:00	MSFT	Stock	29.7	29.78	29.67	29.78	37198.0
2012-10-01 09:00:00	MSFT	Stock	29.8	29.98	29.43	29.47	7331436.0
2012-10-01 10:00:00	MSFT	Stock	29.47	29.7	29.47	29.565	9644082.0
2012-10-01 11:00:00	MSFT	Stock	29.57	29.7	29.56	29.61	5052797.0
2012-10-01 12:00:00	MSFT	Stock	29.62	29.68	29.51	29.55	4280738.0
2012-10-01 13:00:00	MSFT	Stock	29.55	29.63	29.43	29.62	5475107.0
2012-10-01 14:00:00	MSFT	Stock	29.61	29.675	29.55	29.59	4270753.0
2012-10-01 15:00:00	MSFT	Stock	29.59	29.6	29.42	29.52	11743675.0
2012-10-01 16:00:00	MSFT	Stock	29.51	29.78	29.47	29.5	2499537.0
2012-10-01 17:00:00	MSFT	Stock	29.49	29.53	29.49	29.52	19881.0
2012-10-01 18:00:00	MSFT	Stock	29.53	29.54	29.5	29.53	8550.0
2012-10-01 19:00:00	MSFT	Stock	29.5	29.54	29.5	29.5	39999.0
2012-10-01 08:00:00	NVDA	Stock	0.3335	0.3335	0.3335	0.3335	400360.0
2012-10-01 09:00:00	NVDA	Stock	0.336	0.337	0.3288	0.3295	74909480.0
2012-10-01 10:00:00	NVDA	Stock	0.3295	0.3333	0.3295	0.333	151549800.0
2012-10-01 11:00:00	NVDA	Stock	0.333	0.3353	0.3313	0.332	49928320.0
2012-10-01 12:00:00	NVDA	Stock	0.332	0.3325	0.3303	0.3308	32118320.0
2012-10-01 13:00:00	NVDA	Stock	0.331	0.3315	0.3273	0.3295	55616600.0
2012-10-01 14:00:00	NVDA	Stock	0.3294	0.33	0.3288	0.33	29179520.0
2012-10-01 15:00:00	NVDA	Stock	0.33	0.33	0.3268	0.328	86696360.0
2012-10-01 16:00:00	NVDA	Stock	0.328	0.3305	0.3278	0.3282	15585400.0
2012-10-01 17:00:00	NVDA	Stock	0.328	0.328	0.328	0.328	21200.0
2012-10-01 18:00:00	NVDA	Stock	0.3278	0.3278	0.3278	0.3278	20000.0
2012-10-01 08:00:00	AMZN	Stock	12.716	12.8145	12.716	12.8145	130540.0
2012-10-01 09:00:00	AMZN	Stock	12.81	12.81	12.6845	12.7195	6111920.0
2012-10-01 10:00:00	AMZN	Stock	12.7195	12.808	12.7	12.707	6985240.0
2012-10-01 11:00:00	AMZN	Stock	12.708	12.7565	12.6725	12.6795	5672980.0
2012-10-01 12:00:00	AMZN	Stock	12.6795	12.7035	12.6105	12.6478	3147060.0
2012-10-01 13:00:00	AMZN	Stock	12.6455	12.69	12.5954	12.6835	4012200.0
2012-10-01 14:00:00	AMZN	Stock	12.6815	12.693	12.6573	12.6665	5362160.0

> showing 50 of 45,658 rows — these rows as CSV

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