PREVIEW / stock_1hour / 2014-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-28.parquet
  size:    1.1 MB
  rows:    50,118
  symbols: 3,566

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
2014-05-28 04:00:00	AAPL	Stock	22.3596	22.3596	22.3596	22.3596	5600.0
2014-05-28 05:00:00	AAPL	Stock	22.4607	22.4907	22.4104	22.4907	28000.0
2014-05-28 06:00:00	AAPL	Stock	22.4711	22.4711	22.3929	22.4107	127316.0
2014-05-28 07:00:00	AAPL	Stock	22.4143	22.4143	22.3571	22.3571	312676.0
2014-05-28 08:00:00	AAPL	Stock	22.3839	22.4286	22.3207	22.3207	2432276.0
2014-05-28 09:00:00	AAPL	Stock	22.3104	22.4829	22.3104	22.46	61912536.0
2014-05-28 10:00:00	AAPL	Stock	22.4607	22.4939	22.2779	22.3611	59196172.0
2014-05-28 11:00:00	AAPL	Stock	22.3593	22.4141	22.3537	22.3686	23405396.0
2014-05-28 12:00:00	AAPL	Stock	22.3682	22.3993	22.36	22.3846	15031240.0
2014-05-28 13:00:00	AAPL	Stock	22.3861	22.4643	22.3854	22.4286	22863456.0
2014-05-28 14:00:00	AAPL	Stock	22.4286	22.4343	22.3461	22.3479	19741708.0
2014-05-28 15:00:00	AAPL	Stock	22.3485	22.3839	22.2836	22.2857	36410500.0
2014-05-28 16:00:00	AAPL	Stock	22.2861	22.3834	22.2679	22.2946	18588836.0
2014-05-28 17:00:00	AAPL	Stock	22.2861	22.3179	22.2861	22.3032	349160.0
2014-05-28 18:00:00	AAPL	Stock	22.2932	22.3018	22.2861	22.2982	202888.0
2014-05-28 19:00:00	AAPL	Stock	22.2907	22.3068	22.2907	22.3068	118216.0
2014-05-28 07:00:00	MSFT	Stock	40.21	40.24	40.17	40.19	1550.0
2014-05-28 08:00:00	MSFT	Stock	40.19	40.19	40.05	40.11	43835.0
2014-05-28 09:00:00	MSFT	Stock	40.09	40.19	39.85	39.875	3994127.0
2014-05-28 10:00:00	MSFT	Stock	39.87	39.95	39.82	39.92	4208649.0
2014-05-28 11:00:00	MSFT	Stock	39.925	40.19	39.89	40.075	3586809.0
2014-05-28 12:00:00	MSFT	Stock	40.075	40.13	39.96	39.98	1646012.0
2014-05-28 13:00:00	MSFT	Stock	39.98	40.07	39.97	40.05	1705577.0
2014-05-28 14:00:00	MSFT	Stock	40.046	40.075	39.99	40.037	1772621.0
2014-05-28 15:00:00	MSFT	Stock	40.036	40.1	40.0	40.0	3719768.0
2014-05-28 16:00:00	MSFT	Stock	40.01	40.057	39.92	39.98	2724012.0
2014-05-28 08:00:00	NVDA	Stock	0.4705	0.4705	0.4705	0.4705	108160.0
2014-05-28 09:00:00	NVDA	Stock	0.4718	0.4723	0.4678	0.4715	22171600.0
2014-05-28 10:00:00	NVDA	Stock	0.4718	0.4728	0.4705	0.4723	37249280.0
2014-05-28 11:00:00	NVDA	Stock	0.4723	0.4775	0.472	0.4749	42720920.0
2014-05-28 12:00:00	NVDA	Stock	0.475	0.4769	0.474	0.474	23601640.0
2014-05-28 13:00:00	NVDA	Stock	0.4742	0.4763	0.474	0.4752	22754680.0
2014-05-28 14:00:00	NVDA	Stock	0.475	0.477	0.4742	0.4753	30008120.0
2014-05-28 15:00:00	NVDA	Stock	0.4751	0.4755	0.4745	0.4745	35376040.0
2014-05-28 16:00:00	NVDA	Stock	0.4745	0.4746	0.4744	0.4745	2173480.0
2014-05-28 17:00:00	NVDA	Stock	0.4745	0.4745	0.4745	0.4745	10800.0
2014-05-28 18:00:00	NVDA	Stock	0.4758	0.476	0.4758	0.476	40000.0
2014-05-28 04:00:00	AMZN	Stock	15.574	15.574	15.574	15.574	5000.0
2014-05-28 05:00:00	AMZN	Stock	15.574	15.6	15.574	15.6	12000.0
2014-05-28 07:00:00	AMZN	Stock	15.6	15.6	15.565	15.565	28760.0
2014-05-28 08:00:00	AMZN	Stock	15.565	15.565	15.3945	15.4	225300.0
2014-05-28 09:00:00	AMZN	Stock	15.3985	15.5405	15.371	15.4602	8477040.0
2014-05-28 10:00:00	AMZN	Stock	15.457	15.6485	15.4315	15.581	10619360.0
2014-05-28 11:00:00	AMZN	Stock	15.5875	15.6745	15.5817	15.6275	6863700.0
2014-05-28 12:00:00	AMZN	Stock	15.626	15.691	15.604	15.6385	3251860.0
2014-05-28 13:00:00	AMZN	Stock	15.639	15.6615	15.584	15.622	3135300.0
2014-05-28 14:00:00	AMZN	Stock	15.622	15.6365	15.526	15.5545	4258320.0
2014-05-28 15:00:00	AMZN	Stock	15.554	15.585	15.49	15.508	8178180.0
2014-05-28 16:00:00	AMZN	Stock	15.508	15.5542	15.5	15.5049	371580.0
2014-05-28 17:00:00	AMZN	Stock	15.508	15.508	15.508	15.508	560000.0

> showing 50 of 50,118 rows — these rows as CSV

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