PREVIEW / stock_1hour / 2013-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-05.parquet
  size:    977 KB
  rows:    45,576
  symbols: 3,494

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-07-05 04:00:00	AAPL	Stock	15.1429	15.1632	15.1429	15.1632	5600.0
2013-07-05 05:00:00	AAPL	Stock	15.1571	15.1571	15.1571	15.1571	2800.0
2013-07-05 06:00:00	AAPL	Stock	15.1393	15.1761	15.1118	15.1118	74004.0
2013-07-05 07:00:00	AAPL	Stock	15.1143	15.1711	15.0929	15.1057	323288.0
2013-07-05 08:00:00	AAPL	Stock	15.1161	15.1589	14.9093	15.1393	4033820.0
2013-07-05 09:00:00	AAPL	Stock	15.1411	15.1411	14.9821	15.0179	51359364.0
2013-07-05 10:00:00	AAPL	Stock	15.0168	15.0289	14.8543	14.91	60194204.0
2013-07-05 11:00:00	AAPL	Stock	14.9107	14.9361	14.8629	14.8893	35552608.0
2013-07-05 12:00:00	AAPL	Stock	14.8943	14.9346	14.8893	14.8964	25751796.0
2013-07-05 13:00:00	AAPL	Stock	14.8964	14.898	14.8343	14.8504	24580304.0
2013-07-05 14:00:00	AAPL	Stock	14.8471	14.9104	14.8461	14.8782	21858536.0
2013-07-05 15:00:00	AAPL	Stock	14.8829	14.9079	14.8339	14.9079	36867376.0
2013-07-05 16:00:00	AAPL	Stock	14.9079	14.9507	14.8537	14.9125	10368540.0
2013-07-05 17:00:00	AAPL	Stock	14.91	14.9111	14.9018	14.9071	148624.0
2013-07-05 18:00:00	AAPL	Stock	14.9107	14.9286	14.9107	14.9125	30800.0
2013-07-05 19:00:00	AAPL	Stock	14.9129	14.9289	14.9107	14.9289	29064.0
2013-07-05 04:00:00	MSFT	Stock	34.2	34.2	34.2	34.2	100.0
2013-07-05 08:00:00	MSFT	Stock	34.2	34.32	34.01	34.28	25637.0
2013-07-05 09:00:00	MSFT	Stock	34.2	34.21	33.83	33.94	4333257.0
2013-07-05 10:00:00	MSFT	Stock	33.94	34.005	33.581	33.735	5700486.0
2013-07-05 11:00:00	MSFT	Stock	33.735	34.02	33.73	34.005	3564724.0
2013-07-05 12:00:00	MSFT	Stock	34.005	34.11	33.99	34.0	2117007.0
2013-07-05 13:00:00	MSFT	Stock	34.005	34.07	33.95	34.065	1247583.0
2013-07-05 14:00:00	MSFT	Stock	34.065	34.17	34.02	34.12	2144243.0
2013-07-05 15:00:00	MSFT	Stock	34.13	34.24	34.02	34.2	3195863.0
2013-07-05 16:00:00	MSFT	Stock	34.2	34.218	33.755	34.071	3647460.0
2013-07-05 17:00:00	MSFT	Stock	34.21	34.21	34.16	34.16	1832.0
2013-07-05 19:00:00	MSFT	Stock	34.21	34.21	34.21	34.21	150.0
2013-07-05 08:00:00	NVDA	Stock	0.3572	0.3572	0.3565	0.3565	24000.0
2013-07-05 09:00:00	NVDA	Stock	0.3542	0.3568	0.3533	0.3542	26794240.0
2013-07-05 10:00:00	NVDA	Stock	0.354	0.3553	0.3519	0.3545	35330200.0
2013-07-05 11:00:00	NVDA	Stock	0.3545	0.3555	0.3535	0.355	20184200.0
2013-07-05 12:00:00	NVDA	Stock	0.3551	0.3562	0.3542	0.3553	20486000.0
2013-07-05 13:00:00	NVDA	Stock	0.3555	0.3562	0.3542	0.356	13483280.0
2013-07-05 14:00:00	NVDA	Stock	0.3561	0.3566	0.3553	0.3553	19814200.0
2013-07-05 15:00:00	NVDA	Stock	0.3554	0.3562	0.3542	0.356	39185320.0
2013-07-05 16:00:00	NVDA	Stock	0.356	0.356	0.3558	0.3558	8835280.0
2013-07-05 19:00:00	NVDA	Stock	0.3558	0.3558	0.3558	0.3558	16000.0
2013-07-05 06:00:00	AMZN	Stock	14.3125	14.3125	14.3125	14.3125	50000.0
2013-07-05 07:00:00	AMZN	Stock	14.345	14.345	14.325	14.325	68000.0
2013-07-05 08:00:00	AMZN	Stock	14.345	14.345	14.16	14.308	200520.0
2013-07-05 09:00:00	AMZN	Stock	14.308	14.308	14.1565	14.2165	8785880.0
2013-07-05 10:00:00	AMZN	Stock	14.207	14.207	14.1035	14.1435	6841820.0
2013-07-05 11:00:00	AMZN	Stock	14.143	14.247	14.14	14.2465	3369560.0
2013-07-05 12:00:00	AMZN	Stock	14.2495	14.2935	14.244	14.2765	4261060.0
2013-07-05 13:00:00	AMZN	Stock	14.277	14.3035	14.2645	14.2685	2962700.0
2013-07-05 14:00:00	AMZN	Stock	14.2671	14.319	14.2643	14.3	3882580.0
2013-07-05 15:00:00	AMZN	Stock	14.2915	14.304	14.25	14.294	7319900.0
2013-07-05 16:00:00	AMZN	Stock	14.294	14.3205	14.231	14.2788	234480.0
2013-07-05 17:00:00	AMZN	Stock	14.294	14.325	14.294	14.325	30100.0

> showing 50 of 45,576 rows — these rows as CSV

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