PREVIEW / stock_1hour / 2013-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-21.parquet
  size:    1.0 MB
  rows:    47,577
  symbols: 3,518

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-06-21 05:00:00	AAPL	Stock	14.9707	14.9707	14.9675	14.9675	16800.0
2013-06-21 06:00:00	AAPL	Stock	14.9714	14.9718	14.9714	14.9714	22372.0
2013-06-21 07:00:00	AAPL	Stock	14.9643	14.9889	14.9436	14.9789	264964.0
2013-06-21 08:00:00	AAPL	Stock	14.9918	14.9946	14.8536	14.9286	2197300.0
2013-06-21 09:00:00	AAPL	Stock	14.93	15.0	14.7773	14.7793	117681144.0
2013-06-21 10:00:00	AAPL	Stock	14.7857	14.83	14.6554	14.6882	71715952.0
2013-06-21 11:00:00	AAPL	Stock	14.6857	14.6896	14.575	14.6164	75139232.0
2013-06-21 12:00:00	AAPL	Stock	14.6179	14.7546	14.6157	14.7404	54743920.0
2013-06-21 13:00:00	AAPL	Stock	14.7425	14.7736	14.6518	14.6611	36439228.0
2013-06-21 14:00:00	AAPL	Stock	14.6575	14.7293	14.6429	14.7218	32627056.0
2013-06-21 15:00:00	AAPL	Stock	14.7218	14.7768	14.6954	14.7743	62254416.0
2013-06-21 16:00:00	AAPL	Stock	14.7743	14.8916	14.6143	14.7589	21599928.0
2013-06-21 17:00:00	AAPL	Stock	14.7554	14.7679	14.6656	14.7321	3249456.0
2013-06-21 18:00:00	AAPL	Stock	14.7321	14.7743	14.7268	14.7268	67592.0
2013-06-21 19:00:00	AAPL	Stock	14.7321	14.75	14.7321	14.75	78232.0
2013-06-21 04:00:00	MSFT	Stock	33.54	33.54	33.49	33.49	200.0
2013-06-21 05:00:00	MSFT	Stock	33.59	33.59	33.59	33.59	100.0
2013-06-21 07:00:00	MSFT	Stock	33.65	33.68	33.65	33.65	2950.0
2013-06-21 08:00:00	MSFT	Stock	33.67	33.68	33.5	33.64	41985.0
2013-06-21 09:00:00	MSFT	Stock	33.64	33.73	33.21	33.25	28650171.0
2013-06-21 10:00:00	MSFT	Stock	33.245	33.36	33.05	33.315	9253264.0
2013-06-21 11:00:00	MSFT	Stock	33.318	33.38	33.13	33.26	6144167.0
2013-06-21 12:00:00	MSFT	Stock	33.26	33.46	33.06	33.459	4876542.0
2013-06-21 13:00:00	MSFT	Stock	33.45	33.51	33.22	33.25	4004910.0
2013-06-21 14:00:00	MSFT	Stock	33.255	33.29	33.12	33.29	6652237.0
2013-06-21 15:00:00	MSFT	Stock	33.29	33.45	33.22	33.25	12425176.0
2013-06-21 16:00:00	MSFT	Stock	33.25	33.69	33.17	33.24	11010737.0
2013-06-21 17:00:00	MSFT	Stock	33.27	33.27	33.19	33.19	511283.0
2013-06-21 18:00:00	MSFT	Stock	33.19	33.28	33.19	33.28	41504.0
2013-06-21 19:00:00	MSFT	Stock	33.28	33.28	33.21	33.21	355.0
2013-06-21 07:00:00	NVDA	Stock	0.3612	0.3612	0.3612	0.3612	12000.0
2013-06-21 09:00:00	NVDA	Stock	0.363	0.3642	0.3564	0.3575	113505840.0
2013-06-21 10:00:00	NVDA	Stock	0.3575	0.36	0.3545	0.3572	81117000.0
2013-06-21 11:00:00	NVDA	Stock	0.357	0.3582	0.3555	0.357	82823440.0
2013-06-21 12:00:00	NVDA	Stock	0.3572	0.3602	0.357	0.3594	49756880.0
2013-06-21 13:00:00	NVDA	Stock	0.3594	0.3618	0.357	0.3576	38816560.0
2013-06-21 14:00:00	NVDA	Stock	0.3575	0.3582	0.356	0.3574	44973520.0
2013-06-21 15:00:00	NVDA	Stock	0.3574	0.3624	0.3572	0.3602	155892560.0
2013-06-21 16:00:00	NVDA	Stock	0.3605	0.3614	0.3594	0.3605	138875680.0
2013-06-21 17:00:00	NVDA	Stock	0.3605	0.3605	0.3605	0.3605	249520.0
2013-06-21 18:00:00	NVDA	Stock	0.3605	0.3605	0.3605	0.3605	34320.0
2013-06-21 04:00:00	AMZN	Stock	13.722	13.722	13.722	13.722	2000.0
2013-06-21 05:00:00	AMZN	Stock	13.766	13.766	13.766	13.766	2000.0
2013-06-21 07:00:00	AMZN	Stock	13.7405	13.7465	13.7375	13.7465	46500.0
2013-06-21 08:00:00	AMZN	Stock	13.75	13.76	13.672	13.74	217000.0
2013-06-21 09:00:00	AMZN	Stock	13.7445	13.792	13.609	13.6915	28188200.0
2013-06-21 10:00:00	AMZN	Stock	13.6865	13.7178	13.5664	13.662	9716960.0
2013-06-21 11:00:00	AMZN	Stock	13.6635	13.6635	13.4895	13.5215	7550460.0
2013-06-21 12:00:00	AMZN	Stock	13.526	13.6375	13.505	13.6312	7115920.0
2013-06-21 13:00:00	AMZN	Stock	13.6292	13.664	13.603	13.6175	6538860.0

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

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