PREVIEW / stock_1hour / 2014-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-22.parquet
  size:    1.0 MB
  rows:    48,411
  symbols: 3,564

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-04-22 04:00:00	AAPL	Stock	18.9589	18.9589	18.9589	18.9589	5600.0
2014-04-22 05:00:00	AAPL	Stock	18.9036	18.9179	18.9036	18.9179	37184.0
2014-04-22 06:00:00	AAPL	Stock	18.92	18.9529	18.92	18.9286	8540.0
2014-04-22 07:00:00	AAPL	Stock	18.9293	18.9321	18.8661	18.8707	314888.0
2014-04-22 08:00:00	AAPL	Stock	18.8796	18.9464	18.8786	18.9318	1195236.0
2014-04-22 09:00:00	AAPL	Stock	18.9214	18.9289	18.8036	18.8696	27527808.0
2014-04-22 10:00:00	AAPL	Stock	18.8696	18.9104	18.8614	18.9061	24294984.0
2014-04-22 11:00:00	AAPL	Stock	18.9057	18.9579	18.8957	18.9216	18876424.0
2014-04-22 12:00:00	AAPL	Stock	18.9254	18.9339	18.905	18.9204	10951416.0
2014-04-22 13:00:00	AAPL	Stock	18.9214	18.9821	18.9154	18.9725	13618192.0
2014-04-22 14:00:00	AAPL	Stock	18.975	18.9938	18.9375	18.9759	14732900.0
2014-04-22 15:00:00	AAPL	Stock	18.975	18.9911	18.9573	18.9889	26485928.0
2014-04-22 16:00:00	AAPL	Stock	18.9889	18.9964	18.9211	18.9839	15266468.0
2014-04-22 17:00:00	AAPL	Stock	18.9889	18.9982	18.9829	18.9829	606788.0
2014-04-22 18:00:00	AAPL	Stock	18.9829	18.9889	18.9714	18.9864	100660.0
2014-04-22 19:00:00	AAPL	Stock	18.9775	18.9857	18.9775	18.9839	39620.0
2014-04-22 07:00:00	MSFT	Stock	40.12	40.19	40.12	40.19	500.0
2014-04-22 08:00:00	MSFT	Stock	40.19	40.19	40.0	40.0	2750.0
2014-04-22 09:00:00	MSFT	Stock	39.96	40.07	39.83	39.988	3387485.0
2014-04-22 10:00:00	MSFT	Stock	39.99	40.14	39.885	39.985	5080542.0
2014-04-22 11:00:00	MSFT	Stock	39.989	40.005	39.88	39.94	2168095.0
2014-04-22 12:00:00	MSFT	Stock	39.94	40.01	39.93	39.98	1600416.0
2014-04-22 13:00:00	MSFT	Stock	39.98	40.0	39.895	39.995	1539443.0
2014-04-22 14:00:00	MSFT	Stock	40.0	40.0	39.95	39.97	1691335.0
2014-04-22 15:00:00	MSFT	Stock	39.97	40.0	39.84	39.98	4620348.0
2014-04-22 16:00:00	MSFT	Stock	39.99	40.004	39.8	39.8	4966673.0
2014-04-22 17:00:00	MSFT	Stock	39.9	39.99	39.9	39.97	164541.0
2014-04-22 18:00:00	MSFT	Stock	39.97	39.97	39.97	39.97	2900.0
2014-04-22 19:00:00	MSFT	Stock	39.95	39.95	39.95	39.95	600.0
2014-04-22 08:00:00	NVDA	Stock	0.469	0.469	0.469	0.469	4000.0
2014-04-22 09:00:00	NVDA	Stock	0.468	0.4686	0.4665	0.4668	15421840.0
2014-04-22 10:00:00	NVDA	Stock	0.4668	0.4723	0.466	0.471	40914000.0
2014-04-22 11:00:00	NVDA	Stock	0.471	0.4745	0.471	0.4738	34383640.0
2014-04-22 12:00:00	NVDA	Stock	0.4737	0.4742	0.4728	0.4735	14322080.0
2014-04-22 13:00:00	NVDA	Stock	0.4735	0.474	0.4725	0.4738	10938280.0
2014-04-22 14:00:00	NVDA	Stock	0.4736	0.4748	0.473	0.4742	13684520.0
2014-04-22 15:00:00	NVDA	Stock	0.4742	0.4742	0.4718	0.472	62797400.0
2014-04-22 16:00:00	NVDA	Stock	0.472	0.473	0.471	0.4716	11381920.0
2014-04-22 17:00:00	NVDA	Stock	0.4718	0.475	0.4678	0.475	508160.0
2014-04-22 18:00:00	NVDA	Stock	0.474	0.474	0.4735	0.474	62000.0
2014-04-22 07:00:00	AMZN	Stock	16.645	16.645	16.605	16.605	28980.0
2014-04-22 08:00:00	AMZN	Stock	16.626	16.649	16.6085	16.6245	46960.0
2014-04-22 09:00:00	AMZN	Stock	16.6105	16.875	16.5562	16.7445	11763220.0
2014-04-22 10:00:00	AMZN	Stock	16.73	16.78	16.63	16.687	9892180.0
2014-04-22 11:00:00	AMZN	Stock	16.683	16.709	16.6555	16.6788	4917300.0
2014-04-22 12:00:00	AMZN	Stock	16.6775	16.688	16.603	16.6265	7913700.0
2014-04-22 13:00:00	AMZN	Stock	16.635	16.656	16.575	16.6365	5909540.0
2014-04-22 14:00:00	AMZN	Stock	16.633	16.642	16.506	16.5495	8035480.0
2014-04-22 15:00:00	AMZN	Stock	16.5495	16.5815	16.447	16.47	14137180.0
2014-04-22 16:00:00	AMZN	Stock	16.466	16.6192	16.4627	16.467	2746840.0

> showing 50 of 48,411 rows — these rows as CSV

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