PREVIEW / stock_1hour / 2013-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-15.parquet
  size:    1019 KB
  rows:    47,048
  symbols: 3,544

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
2013-10-15 04:00:00	AAPL	Stock	17.6786	17.7829	17.6786	17.7829	14280.0
2013-10-15 05:00:00	AAPL	Stock	17.7743	17.8107	17.7743	17.8107	29288.0
2013-10-15 06:00:00	AAPL	Stock	17.8111	17.8214	17.7857	17.7893	138712.0
2013-10-15 07:00:00	AAPL	Stock	17.7929	17.8214	17.7479	17.7479	694484.0
2013-10-15 08:00:00	AAPL	Stock	17.7321	17.8214	17.7143	17.7821	1837220.0
2013-10-15 09:00:00	AAPL	Stock	17.7743	17.8107	17.6971	17.78	51202480.0
2013-10-15 10:00:00	AAPL	Stock	17.7854	17.8514	17.7729	17.8029	51448180.0
2013-10-15 11:00:00	AAPL	Stock	17.8018	17.9179	17.7886	17.8586	60150216.0
2013-10-15 12:00:00	AAPL	Stock	17.8589	17.9043	17.7954	17.8775	35650020.0
2013-10-15 13:00:00	AAPL	Stock	17.8786	17.9286	17.8543	17.9168	26471088.0
2013-10-15 14:00:00	AAPL	Stock	17.9161	17.9286	17.7793	17.8321	40423460.0
2013-10-15 15:00:00	AAPL	Stock	17.8314	17.8839	17.7932	17.8171	37840012.0
2013-10-15 16:00:00	AAPL	Stock	17.81	17.8482	17.8064	17.8161	6627376.0
2013-10-15 17:00:00	AAPL	Stock	17.8182	17.8482	17.8157	17.825	360892.0
2013-10-15 18:00:00	AAPL	Stock	17.8214	17.8404	17.8171	17.8179	314496.0
2013-10-15 19:00:00	AAPL	Stock	17.8161	17.855	17.8125	17.855	759220.0
2013-10-15 04:00:00	MSFT	Stock	34.65	34.88	34.65	34.79	1015.0
2013-10-15 05:00:00	MSFT	Stock	34.75	34.99	34.7	34.86	2836.0
2013-10-15 06:00:00	MSFT	Stock	34.79	34.81	34.79	34.81	3000.0
2013-10-15 07:00:00	MSFT	Stock	34.78	34.83	34.66	34.73	54505.0
2013-10-15 08:00:00	MSFT	Stock	34.72	34.89	34.72	34.85	90755.0
2013-10-15 09:00:00	MSFT	Stock	34.83	34.98	34.53	34.965	8048719.0
2013-10-15 10:00:00	MSFT	Stock	34.96	34.99	34.81	34.835	9978205.0
2013-10-15 11:00:00	MSFT	Stock	34.84	34.965	34.8	34.835	6531590.0
2013-10-15 12:00:00	MSFT	Stock	34.835	34.867	34.77	34.8	4668240.0
2013-10-15 13:00:00	MSFT	Stock	34.804	34.81	34.68	34.69	3846343.0
2013-10-15 14:00:00	MSFT	Stock	34.7	34.75	34.49	34.514	4592274.0
2013-10-15 15:00:00	MSFT	Stock	34.52	34.62	34.47	34.49	7302228.0
2013-10-15 16:00:00	MSFT	Stock	34.49	34.886	34.402	34.5	1729951.0
2013-10-15 17:00:00	MSFT	Stock	34.52	34.55	34.5	34.5	7592.0
2013-10-15 18:00:00	MSFT	Stock	34.5	34.55	34.5	34.55	300.0
2013-10-15 19:00:00	MSFT	Stock	34.58	34.59	34.52	34.59	9255.0
2013-10-15 09:00:00	NVDA	Stock	0.387	0.3895	0.3858	0.3875	29104200.0
2013-10-15 10:00:00	NVDA	Stock	0.3878	0.3885	0.3863	0.388	45385640.0
2013-10-15 11:00:00	NVDA	Stock	0.3879	0.3893	0.3878	0.3884	26110000.0
2013-10-15 12:00:00	NVDA	Stock	0.3882	0.3885	0.387	0.3874	29954120.0
2013-10-15 13:00:00	NVDA	Stock	0.3873	0.3882	0.3871	0.3878	10948040.0
2013-10-15 14:00:00	NVDA	Stock	0.3878	0.3882	0.3853	0.3862	22195480.0
2013-10-15 15:00:00	NVDA	Stock	0.3862	0.3875	0.385	0.3853	34921160.0
2013-10-15 16:00:00	NVDA	Stock	0.3853	0.3868	0.385	0.3868	9996200.0
2013-10-15 17:00:00	NVDA	Stock	0.3855	0.3855	0.3855	0.3855	142200.0
2013-10-15 05:00:00	AMZN	Stock	15.5625	15.596	15.5625	15.596	4000.0
2013-10-15 06:00:00	AMZN	Stock	15.585	15.585	15.585	15.585	2000.0
2013-10-15 07:00:00	AMZN	Stock	15.6445	15.6445	15.575	15.575	15000.0
2013-10-15 08:00:00	AMZN	Stock	15.5885	15.614	15.545	15.545	13040.0
2013-10-15 09:00:00	AMZN	Stock	15.5505	15.5505	15.425	15.4405	6490700.0
2013-10-15 10:00:00	AMZN	Stock	15.4415	15.48	15.4035	15.4418	7291380.0
2013-10-15 11:00:00	AMZN	Stock	15.437	15.493	15.411	15.4395	4875300.0
2013-10-15 12:00:00	AMZN	Stock	15.433	15.4495	15.3305	15.3308	4966540.0
2013-10-15 13:00:00	AMZN	Stock	15.332	15.386	15.295	15.386	6035360.0

> showing 50 of 47,048 rows — these rows as CSV

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