PREVIEW / stock_1hour / 2011-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-07.parquet
  size:    930 KB
  rows:    44,727
  symbols: 3,515

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
2011-12-07 04:00:00	AAPL	Stock	14.0536	14.0536	14.0536	14.0536	2800.0
2011-12-07 05:00:00	AAPL	Stock	14.0361	14.0393	14.0	14.0	68600.0
2011-12-07 07:00:00	AAPL	Stock	14.0	14.0	13.9625	13.9796	240436.0
2011-12-07 08:00:00	AAPL	Stock	13.9714	13.9939	13.9036	13.9225	3023160.0
2011-12-07 09:00:00	AAPL	Stock	13.9168	13.9554	13.8186	13.8429	56439544.0
2011-12-07 10:00:00	AAPL	Stock	13.8429	13.8704	13.8129	13.8704	49244468.0
2011-12-07 11:00:00	AAPL	Stock	13.8704	13.921	13.8454	13.9179	36233792.0
2011-12-07 12:00:00	AAPL	Stock	13.9211	13.9343	13.8793	13.9143	25856656.0
2011-12-07 13:00:00	AAPL	Stock	13.9143	13.9232	13.8657	13.8732	16285668.0
2011-12-07 14:00:00	AAPL	Stock	13.8742	13.8832	13.825	13.8376	34930028.0
2011-12-07 15:00:00	AAPL	Stock	13.8396	13.9621	13.8214	13.8979	65954364.0
2011-12-07 16:00:00	AAPL	Stock	13.8975	13.9357	13.8521	13.9196	10505992.0
2011-12-07 17:00:00	AAPL	Stock	13.9625	13.9625	13.9179	13.9321	299684.0
2011-12-07 18:00:00	AAPL	Stock	13.9346	13.9371	13.8961	13.9304	111720.0
2011-12-07 19:00:00	AAPL	Stock	13.9318	13.9339	13.9268	13.9286	199528.0
2011-12-07 06:00:00	MSFT	Stock	25.77	25.77	25.77	25.77	200.0
2011-12-07 08:00:00	MSFT	Stock	25.7	25.7	25.62	25.66	21690.0
2011-12-07 09:00:00	MSFT	Stock	25.63	25.72	25.39	25.471	7049613.0
2011-12-07 10:00:00	MSFT	Stock	25.479	25.48	25.335	25.405	10833899.0
2011-12-07 11:00:00	MSFT	Stock	25.405	25.495	25.37	25.449	9299049.0
2011-12-07 12:00:00	MSFT	Stock	25.45	25.6	25.42	25.589	6962066.0
2011-12-07 13:00:00	MSFT	Stock	25.585	25.6	25.495	25.53	5726400.0
2011-12-07 14:00:00	MSFT	Stock	25.525	25.56	25.41	25.49	6964643.0
2011-12-07 15:00:00	MSFT	Stock	25.49	25.76	25.48	25.6	13235484.0
2011-12-07 16:00:00	MSFT	Stock	25.6	25.69	25.409	25.62	1857284.0
2011-12-07 17:00:00	MSFT	Stock	25.66	25.69	25.65	25.69	4350.0
2011-12-07 18:00:00	MSFT	Stock	25.63	25.63	25.6	25.6	11560.0
2011-12-07 19:00:00	MSFT	Stock	25.68	25.69	25.68	25.69	891.0
2011-12-07 08:00:00	NVDA	Stock	0.382	0.382	0.3783	0.3783	65600.0
2011-12-07 09:00:00	NVDA	Stock	0.3815	0.3828	0.3718	0.3748	85796080.0
2011-12-07 10:00:00	NVDA	Stock	0.375	0.3755	0.3713	0.3753	73472040.0
2011-12-07 11:00:00	NVDA	Stock	0.3753	0.379	0.3738	0.3783	55816480.0
2011-12-07 12:00:00	NVDA	Stock	0.3783	0.3808	0.3768	0.3795	53603040.0
2011-12-07 13:00:00	NVDA	Stock	0.3795	0.3803	0.3755	0.3764	41932600.0
2011-12-07 14:00:00	NVDA	Stock	0.3763	0.3776	0.374	0.375	52505120.0
2011-12-07 15:00:00	NVDA	Stock	0.3753	0.382	0.375	0.379	121865400.0
2011-12-07 16:00:00	NVDA	Stock	0.3793	0.3842	0.3769	0.3808	21416600.0
2011-12-07 17:00:00	NVDA	Stock	0.3808	0.381	0.3808	0.3808	30800.0
2011-12-07 18:00:00	NVDA	Stock	0.3793	0.3808	0.3793	0.3808	189240.0
2011-12-07 19:00:00	NVDA	Stock	0.3798	0.3808	0.3798	0.3808	8400.0
2011-12-07 04:00:00	AMZN	Stock	9.616	9.621	9.616	9.6195	16000.0
2011-12-07 05:00:00	AMZN	Stock	9.638	9.638	9.638	9.638	2000.0
2011-12-07 07:00:00	AMZN	Stock	9.6425	9.645	9.615	9.615	30360.0
2011-12-07 08:00:00	AMZN	Stock	9.637	9.65	9.5805	9.604	232360.0
2011-12-07 09:00:00	AMZN	Stock	9.595	9.6141	9.456	9.5474	21181320.0
2011-12-07 10:00:00	AMZN	Stock	9.5438	9.74	9.535	9.73	24978940.0
2011-12-07 11:00:00	AMZN	Stock	9.733	9.7855	9.6655	9.7785	18734160.0
2011-12-07 12:00:00	AMZN	Stock	9.7788	9.806	9.732	9.8025	12006560.0
2011-12-07 13:00:00	AMZN	Stock	9.801	9.81	9.732	9.739	9408980.0
2011-12-07 14:00:00	AMZN	Stock	9.7395	9.746	9.6804	9.691	12444180.0

> showing 50 of 44,727 rows — these rows as CSV

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