PREVIEW / stock_1hour / 2013-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-09.parquet
  size:    1.0 MB
  rows:    49,306
  symbols: 3,531

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-09-09 04:00:00	AAPL	Stock	18.0268	18.1036	17.9757	18.0393	303772.0
2013-09-09 05:00:00	AAPL	Stock	18.0354	18.0354	18.0039	18.0193	95620.0
2013-09-09 06:00:00	AAPL	Stock	18.0193	18.0357	17.9857	17.9911	208880.0
2013-09-09 07:00:00	AAPL	Stock	17.9807	18.0229	17.9679	17.9807	1928500.0
2013-09-09 08:00:00	AAPL	Stock	17.9996	18.0579	17.9646	18.0579	5943140.0
2013-09-09 09:00:00	AAPL	Stock	18.055	18.1157	17.9814	17.9969	91048188.0
2013-09-09 10:00:00	AAPL	Stock	17.9971	18.0568	17.9868	18.0236	51417156.0
2013-09-09 11:00:00	AAPL	Stock	18.0215	18.0907	18.0193	18.0652	32805304.0
2013-09-09 12:00:00	AAPL	Stock	18.0629	18.1339	18.0557	18.0946	39133892.0
2013-09-09 13:00:00	AAPL	Stock	18.095	18.1121	18.0893	18.1082	17449516.0
2013-09-09 14:00:00	AAPL	Stock	18.1082	18.14	18.0571	18.0584	33014856.0
2013-09-09 15:00:00	AAPL	Stock	18.0579	18.1064	18.0432	18.0782	46810680.0
2013-09-09 16:00:00	AAPL	Stock	18.0782	18.0911	18.0353	18.0779	12029556.0
2013-09-09 17:00:00	AAPL	Stock	18.0854	18.0857	18.0054	18.0357	2496284.0
2013-09-09 18:00:00	AAPL	Stock	18.0357	18.0779	18.0289	18.0643	459060.0
2013-09-09 19:00:00	AAPL	Stock	18.0614	18.0804	18.0357	18.0782	677544.0
2013-09-09 04:00:00	MSFT	Stock	31.27	31.41	31.27	31.39	1600.0
2013-09-09 06:00:00	MSFT	Stock	31.37	31.37	31.37	31.37	100.0
2013-09-09 07:00:00	MSFT	Stock	31.37	31.37	31.28	31.28	4900.0
2013-09-09 08:00:00	MSFT	Stock	31.29	31.35	31.24	31.24	41186.0
2013-09-09 09:00:00	MSFT	Stock	31.24	31.48	31.2	31.455	7257333.0
2013-09-09 10:00:00	MSFT	Stock	31.46	31.48	31.33	31.37	8258262.0
2013-09-09 11:00:00	MSFT	Stock	31.369	31.49	31.34	31.45	4453153.0
2013-09-09 12:00:00	MSFT	Stock	31.45	31.63	31.45	31.599	5812015.0
2013-09-09 13:00:00	MSFT	Stock	31.59	31.62	31.56	31.6	4473042.0
2013-09-09 14:00:00	MSFT	Stock	31.6	31.74	31.457	31.65	6587862.0
2013-09-09 15:00:00	MSFT	Stock	31.65	31.79	31.65	31.65	10478247.0
2013-09-09 16:00:00	MSFT	Stock	31.65	31.75	31.2	31.64	423805.0
2013-09-09 17:00:00	MSFT	Stock	31.64	31.65	31.6	31.61	342701.0
2013-09-09 18:00:00	MSFT	Stock	31.65	31.65	31.65	31.65	17266.0
2013-09-09 19:00:00	MSFT	Stock	31.62	31.65	31.62	31.65	600.0
2013-09-09 08:00:00	NVDA	Stock	0.3745	0.3745	0.3745	0.3745	12000.0
2013-09-09 09:00:00	NVDA	Stock	0.3745	0.3768	0.374	0.376	37076440.0
2013-09-09 10:00:00	NVDA	Stock	0.376	0.3765	0.374	0.3751	48452360.0
2013-09-09 11:00:00	NVDA	Stock	0.3753	0.3763	0.3748	0.3754	36241000.0
2013-09-09 12:00:00	NVDA	Stock	0.3754	0.3765	0.3753	0.3763	15229600.0
2013-09-09 13:00:00	NVDA	Stock	0.3763	0.3783	0.376	0.378	21816720.0
2013-09-09 14:00:00	NVDA	Stock	0.378	0.3783	0.377	0.3771	23800000.0
2013-09-09 15:00:00	NVDA	Stock	0.3773	0.3783	0.3768	0.3781	46775200.0
2013-09-09 16:00:00	NVDA	Stock	0.378	0.3785	0.3762	0.3775	15749200.0
2013-09-09 17:00:00	NVDA	Stock	0.3775	0.378	0.3775	0.378	1040800.0
2013-09-09 18:00:00	NVDA	Stock	0.378	0.378	0.378	0.378	32440.0
2013-09-09 19:00:00	NVDA	Stock	0.3788	0.3788	0.3788	0.3788	16000.0
2013-09-09 08:00:00	AMZN	Stock	14.826	14.855	14.826	14.8515	33900.0
2013-09-09 09:00:00	AMZN	Stock	14.861	14.9795	14.83	14.9478	5264400.0
2013-09-09 10:00:00	AMZN	Stock	14.9478	14.9545	14.842	14.895	4530680.0
2013-09-09 11:00:00	AMZN	Stock	14.889	14.944	14.86	14.9172	2638560.0
2013-09-09 12:00:00	AMZN	Stock	14.924	14.95	14.9075	14.9428	4099400.0
2013-09-09 13:00:00	AMZN	Stock	14.943	14.95	14.8805	14.9105	2509820.0
2013-09-09 14:00:00	AMZN	Stock	14.9105	14.98	14.908	14.9715	3712020.0

> showing 50 of 49,306 rows — these rows as CSV

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