PREVIEW / stock_1hour / 2014-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-04.parquet
  size:    1.0 MB
  rows:    48,688
  symbols: 3,544

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-04 05:00:00	AAPL	Stock	19.2754	19.2754	19.2754	19.2754	2884.0
2014-04-04 06:00:00	AAPL	Stock	19.2754	19.2896	19.2754	19.2896	16800.0
2014-04-04 07:00:00	AAPL	Stock	19.2839	19.2839	19.2696	19.2696	43036.0
2014-04-04 08:00:00	AAPL	Stock	19.2739	19.2925	19.1429	19.2757	835772.0
2014-04-04 09:00:00	AAPL	Stock	19.2632	19.2918	19.1546	19.185	27440364.0
2014-04-04 10:00:00	AAPL	Stock	19.185	19.2107	19.1	19.1086	33366900.0
2014-04-04 11:00:00	AAPL	Stock	19.1079	19.1125	19.0465	19.0907	30307340.0
2014-04-04 12:00:00	AAPL	Stock	19.088	19.0964	18.9654	18.9743	28678580.0
2014-04-04 13:00:00	AAPL	Stock	18.9757	19.0571	18.9643	19.0296	23654848.0
2014-04-04 14:00:00	AAPL	Stock	19.0271	19.0379	18.9493	18.9614	23182768.0
2014-04-04 15:00:00	AAPL	Stock	18.9625	19.0357	18.9507	18.9939	45424764.0
2014-04-04 16:00:00	AAPL	Stock	18.9939	19.0629	18.9929	19.0118	14987868.0
2014-04-04 17:00:00	AAPL	Stock	19.0107	19.2425	18.9936	19.0175	430696.0
2014-04-04 18:00:00	AAPL	Stock	18.9936	19.0179	18.9936	19.0	579936.0
2014-04-04 19:00:00	AAPL	Stock	19.01	19.0175	19.0071	19.0175	82376.0
2014-04-04 07:00:00	MSFT	Stock	41.02	41.02	41.0	41.0	1100.0
2014-04-04 08:00:00	MSFT	Stock	40.9	41.25	40.9	41.17	41116.0
2014-04-04 09:00:00	MSFT	Stock	41.17	41.39	40.67	40.86	3573268.0
2014-04-04 10:00:00	MSFT	Stock	40.855	40.95	40.4	40.43	7579680.0
2014-04-04 11:00:00	MSFT	Stock	40.43	40.45	39.87	40.005	8943609.0
2014-04-04 12:00:00	MSFT	Stock	40.0	40.045	39.695	39.75	6536314.0
2014-04-04 13:00:00	MSFT	Stock	39.755	39.925	39.7	39.77	4894498.0
2014-04-04 14:00:00	MSFT	Stock	39.775	39.93	39.64	39.92	5090961.0
2014-04-04 15:00:00	MSFT	Stock	39.916	40.11	39.84	39.87	9656149.0
2014-04-04 16:00:00	MSFT	Stock	39.87	40.145	39.85	39.95	2636192.0
2014-04-04 17:00:00	MSFT	Stock	39.9	39.9	39.87	39.9	60444.0
2014-04-04 18:00:00	MSFT	Stock	39.87	39.93	39.84	39.85	24830.0
2014-04-04 19:00:00	MSFT	Stock	39.84	39.92	39.84	39.9	2525.0
2014-04-04 09:00:00	NVDA	Stock	0.4708	0.4735	0.4665	0.468	30276480.0
2014-04-04 10:00:00	NVDA	Stock	0.468	0.4688	0.4618	0.462	56286800.0
2014-04-04 11:00:00	NVDA	Stock	0.4618	0.462	0.4538	0.4552	57009000.0
2014-04-04 12:00:00	NVDA	Stock	0.455	0.4564	0.4518	0.4532	39866440.0
2014-04-04 13:00:00	NVDA	Stock	0.4532	0.456	0.4516	0.4552	37755160.0
2014-04-04 14:00:00	NVDA	Stock	0.4552	0.4568	0.453	0.455	35926480.0
2014-04-04 15:00:00	NVDA	Stock	0.4552	0.4569	0.4535	0.4538	91626120.0
2014-04-04 16:00:00	NVDA	Stock	0.4538	0.4538	0.4532	0.4538	14255880.0
2014-04-04 04:00:00	AMZN	Stock	16.6655	16.7155	16.6655	16.7155	10000.0
2014-04-04 07:00:00	AMZN	Stock	16.715	16.731	16.715	16.718	10000.0
2014-04-04 08:00:00	AMZN	Stock	16.73	16.7745	16.65	16.75	268720.0
2014-04-04 09:00:00	AMZN	Stock	16.765	16.772	15.956	16.1815	40792020.0
2014-04-04 10:00:00	AMZN	Stock	16.175	16.4945	16.1555	16.156	36098500.0
2014-04-04 11:00:00	AMZN	Stock	16.1608	16.171	15.9655	16.0175	36667380.0
2014-04-04 12:00:00	AMZN	Stock	16.015	16.05	15.7805	15.9148	27857360.0
2014-04-04 13:00:00	AMZN	Stock	15.9075	15.996	15.81	15.9339	19126220.0
2014-04-04 14:00:00	AMZN	Stock	15.9315	16.146	15.9265	16.1457	24665920.0
2014-04-04 15:00:00	AMZN	Stock	16.146	16.302	16.035	16.1395	37839620.0
2014-04-04 16:00:00	AMZN	Stock	16.139	16.15	16.1025	16.15	348200.0
2014-04-04 17:00:00	AMZN	Stock	16.139	16.139	16.1025	16.1025	51240.0
2014-04-04 18:00:00	AMZN	Stock	16.139	16.139	16.0725	16.0875	154140.0
2014-04-04 19:00:00	AMZN	Stock	16.0805	16.1025	16.0805	16.1025	33600.0

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

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