PREVIEW / stock_1hour / 2013-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-18.parquet
  size:    1.0 MB
  rows:    47,806
  symbols: 3,511

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-18 04:00:00	AAPL	Stock	16.2857	16.4107	16.2857	16.3561	150220.0
2013-09-18 05:00:00	AAPL	Stock	16.3607	16.3929	16.3575	16.375	198184.0
2013-09-18 06:00:00	AAPL	Stock	16.3696	16.3861	16.3586	16.3607	94584.0
2013-09-18 07:00:00	AAPL	Stock	16.375	16.4539	16.3718	16.4539	1460088.0
2013-09-18 08:00:00	AAPL	Stock	16.4421	16.4711	16.3686	16.4532	3216136.0
2013-09-18 09:00:00	AAPL	Stock	16.45	16.5925	16.4371	16.5818	87518620.0
2013-09-18 10:00:00	AAPL	Stock	16.5804	16.6554	16.5475	16.5732	81529308.0
2013-09-18 11:00:00	AAPL	Stock	16.575	16.5939	16.4547	16.4782	46635372.0
2013-09-18 12:00:00	AAPL	Stock	16.4768	16.5354	16.4768	16.5119	23094148.0
2013-09-18 13:00:00	AAPL	Stock	16.5093	16.5243	16.4521	16.5043	26607196.0
2013-09-18 14:00:00	AAPL	Stock	16.5114	16.6429	16.4857	16.6296	85327816.0
2013-09-18 15:00:00	AAPL	Stock	16.6296	16.6375	16.5536	16.5946	63582512.0
2013-09-18 16:00:00	AAPL	Stock	16.5929	16.6043	16.5363	16.5821	32380376.0
2013-09-18 17:00:00	AAPL	Stock	16.5961	16.625	16.59	16.625	878612.0
2013-09-18 18:00:00	AAPL	Stock	16.6261	16.6743	16.6164	16.6743	702716.0
2013-09-18 19:00:00	AAPL	Stock	16.6768	16.7379	16.5946	16.7346	1186304.0
2013-09-18 06:00:00	MSFT	Stock	33.15	33.15	33.14	33.14	700.0
2013-09-18 07:00:00	MSFT	Stock	33.1	33.1	33.1	33.1	700.0
2013-09-18 08:00:00	MSFT	Stock	33.13	33.13	32.97	32.98	65634.0
2013-09-18 09:00:00	MSFT	Stock	32.99	33.09	32.86	33.05	5605491.0
2013-09-18 10:00:00	MSFT	Stock	33.05	33.18	32.9	33.097	7393477.0
2013-09-18 11:00:00	MSFT	Stock	33.095	33.15	32.92	33.01	10066272.0
2013-09-18 12:00:00	MSFT	Stock	33.01	33.03	32.95	32.96	3650001.0
2013-09-18 13:00:00	MSFT	Stock	32.965	33.0	32.83	32.932	4942284.0
2013-09-18 14:00:00	MSFT	Stock	32.94	33.35	32.935	33.35	12840141.0
2013-09-18 15:00:00	MSFT	Stock	33.345	33.4	33.18	33.33	13347901.0
2013-09-18 16:00:00	MSFT	Stock	33.32	33.39	32.937	33.31	5677143.0
2013-09-18 17:00:00	MSFT	Stock	33.33	33.33	33.23	33.23	129060.0
2013-09-18 18:00:00	MSFT	Stock	33.24	33.24	33.23	33.23	1905.0
2013-09-18 19:00:00	MSFT	Stock	33.33	33.33	33.27	33.33	1250.0
2013-09-18 09:00:00	NVDA	Stock	0.3962	0.3995	0.3962	0.3985	31927280.0
2013-09-18 10:00:00	NVDA	Stock	0.3982	0.3993	0.3955	0.397	33156200.0
2013-09-18 11:00:00	NVDA	Stock	0.3971	0.398	0.3962	0.3962	22636800.0
2013-09-18 12:00:00	NVDA	Stock	0.3964	0.3965	0.3948	0.3954	21551960.0
2013-09-18 13:00:00	NVDA	Stock	0.3955	0.397	0.3955	0.3962	15770280.0
2013-09-18 14:00:00	NVDA	Stock	0.3965	0.3993	0.3965	0.399	50405600.0
2013-09-18 15:00:00	NVDA	Stock	0.3993	0.401	0.3988	0.3998	80322800.0
2013-09-18 16:00:00	NVDA	Stock	0.4	0.4004	0.3965	0.4	3146320.0
2013-09-18 17:00:00	NVDA	Stock	0.4	0.4	0.4	0.4	127320.0
2013-09-18 18:00:00	NVDA	Stock	0.3978	0.3978	0.3978	0.3978	8000.0
2013-09-18 04:00:00	AMZN	Stock	15.215	15.215	15.215	15.215	2000.0
2013-09-18 08:00:00	AMZN	Stock	15.2025	15.2475	15.2025	15.2375	29600.0
2013-09-18 09:00:00	AMZN	Stock	15.203	15.2465	15.1455	15.1575	6986020.0
2013-09-18 10:00:00	AMZN	Stock	15.1611	15.275	15.1535	15.275	6924400.0
2013-09-18 11:00:00	AMZN	Stock	15.274	15.2875	15.233	15.241	3868200.0
2013-09-18 12:00:00	AMZN	Stock	15.2405	15.323	15.2395	15.315	3212300.0
2013-09-18 13:00:00	AMZN	Stock	15.311	15.3345	15.285	15.3032	3532920.0
2013-09-18 14:00:00	AMZN	Stock	15.308	15.592	15.3075	15.584	16218960.0
2013-09-18 15:00:00	AMZN	Stock	15.584	15.637	15.5815	15.606	15611480.0
2013-09-18 16:00:00	AMZN	Stock	15.6035	15.605	15.3385	15.6	2351460.0

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

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