PREVIEW / stock_1hour / 2014-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-09.parquet
  size:    1.0 MB
  rows:    48,671
  symbols: 3,570

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-07-09 04:00:00	AAPL	Stock	23.85	23.85	23.8125	23.8275	6280.0
2014-07-09 05:00:00	AAPL	Stock	23.8075	23.8275	23.8075	23.8275	6400.0
2014-07-09 06:00:00	AAPL	Stock	23.8375	23.8525	23.8375	23.8475	11040.0
2014-07-09 07:00:00	AAPL	Stock	23.84	23.875	23.84	23.865	95456.0
2014-07-09 08:00:00	AAPL	Stock	23.865	23.9225	23.83	23.895	504580.0
2014-07-09 09:00:00	AAPL	Stock	23.895	23.9875	23.8025	23.8775	26500980.0
2014-07-09 10:00:00	AAPL	Stock	23.8775	23.97	23.8025	23.9338	23070488.0
2014-07-09 11:00:00	AAPL	Stock	23.935	23.955	23.8825	23.945	12238384.0
2014-07-09 12:00:00	AAPL	Stock	23.9475	23.9475	23.8378	23.8525	10207120.0
2014-07-09 13:00:00	AAPL	Stock	23.8525	23.89	23.795	23.795	10037028.0
2014-07-09 14:00:00	AAPL	Stock	23.7925	23.9018	23.69	23.86	22698348.0
2014-07-09 15:00:00	AAPL	Stock	23.8575	23.8875	23.8275	23.8475	17465084.0
2014-07-09 16:00:00	AAPL	Stock	23.8475	23.9015	23.84	23.84	12695808.0
2014-07-09 17:00:00	AAPL	Stock	23.8425	23.845	23.835	23.8375	66632.0
2014-07-09 18:00:00	AAPL	Stock	23.84	23.8475	23.8	23.8375	92940.0
2014-07-09 19:00:00	AAPL	Stock	23.8375	23.8475	23.8275	23.8425	543588.0
2014-07-09 08:00:00	MSFT	Stock	41.99	42.0	41.99	42.0	480.0
2014-07-09 09:00:00	MSFT	Stock	41.89	41.99	41.65	41.653	2488993.0
2014-07-09 10:00:00	MSFT	Stock	41.66	41.81	41.53	41.735	2612883.0
2014-07-09 11:00:00	MSFT	Stock	41.74	41.79	41.61	41.63	1798423.0
2014-07-09 12:00:00	MSFT	Stock	41.632	41.7	41.63	41.669	1257131.0
2014-07-09 13:00:00	MSFT	Stock	41.669	41.67	41.61	41.613	922870.0
2014-07-09 14:00:00	MSFT	Stock	41.62	41.74	41.555	41.685	2283518.0
2014-07-09 15:00:00	MSFT	Stock	41.687	41.78	41.62	41.67	3789605.0
2014-07-09 16:00:00	MSFT	Stock	41.67	41.72	41.654	41.69	2446341.0
2014-07-09 17:00:00	MSFT	Stock	41.7	41.7	41.7	41.7	400.0
2014-07-09 18:00:00	MSFT	Stock	41.69	41.69	41.69	41.69	600.0
2014-07-09 19:00:00	MSFT	Stock	41.67	41.67	41.67	41.67	70000.0
2014-07-09 08:00:00	NVDA	Stock	0.4638	0.4638	0.4638	0.4638	596000.0
2014-07-09 09:00:00	NVDA	Stock	0.4678	0.4708	0.4643	0.469	25381240.0
2014-07-09 10:00:00	NVDA	Stock	0.469	0.472	0.4685	0.4705	89479960.0
2014-07-09 11:00:00	NVDA	Stock	0.4708	0.473	0.469	0.4728	33606800.0
2014-07-09 12:00:00	NVDA	Stock	0.4728	0.4742	0.4725	0.473	21655040.0
2014-07-09 13:00:00	NVDA	Stock	0.4732	0.4778	0.473	0.4765	42984320.0
2014-07-09 14:00:00	NVDA	Stock	0.4765	0.4798	0.4754	0.4765	43252280.0
2014-07-09 15:00:00	NVDA	Stock	0.4765	0.4788	0.476	0.478	109984360.0
2014-07-09 16:00:00	NVDA	Stock	0.4778	0.479	0.4777	0.479	1166920.0
2014-07-09 08:00:00	AMZN	Stock	16.265	16.275	16.2635	16.2635	25800.0
2014-07-09 09:00:00	AMZN	Stock	16.2625	16.4275	16.1575	16.3255	12431000.0
2014-07-09 10:00:00	AMZN	Stock	16.3315	16.4775	16.252	16.454	12256940.0
2014-07-09 11:00:00	AMZN	Stock	16.448	16.492	16.3075	16.3675	7159560.0
2014-07-09 12:00:00	AMZN	Stock	16.3622	16.4615	16.357	16.4553	2913300.0
2014-07-09 13:00:00	AMZN	Stock	16.4553	16.4553	16.3925	16.3986	2464900.0
2014-07-09 14:00:00	AMZN	Stock	16.3995	16.499	16.365	16.4665	5375840.0
2014-07-09 15:00:00	AMZN	Stock	16.4735	16.51	16.4518	16.496	10055920.0
2014-07-09 16:00:00	AMZN	Stock	16.4985	16.538	16.1905	16.515	3588520.0
2014-07-09 17:00:00	AMZN	Stock	16.52	16.52	16.52	16.52	3480.0
2014-07-09 18:00:00	AMZN	Stock	16.4985	16.5395	16.4985	16.5395	49560.0
2014-07-09 19:00:00	AMZN	Stock	16.525	16.545	16.5145	16.545	8000.0
2014-07-09 08:00:00	GOOGL	Stock	29.02	29.0985	29.0125	29.0175	36000.0

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

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