PREVIEW / stock_1hour / 2015-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-17.parquet
  size:    1.0 MB
  rows:    48,887
  symbols: 3,511

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
2015-04-17 04:00:00	AAPL	Stock	31.6825	31.7	31.645	31.6575	6000.0
2015-04-17 05:00:00	AAPL	Stock	31.695	31.7125	31.6575	31.675	9900.0
2015-04-17 06:00:00	AAPL	Stock	31.6575	31.6575	31.275	31.425	74980.0
2015-04-17 07:00:00	AAPL	Stock	31.425	31.525	31.4125	31.425	213908.0
2015-04-17 08:00:00	AAPL	Stock	31.425	31.55	31.275	31.4825	644604.0
2015-04-17 09:00:00	AAPL	Stock	31.48	31.535	31.29	31.3125	32490696.0
2015-04-17 10:00:00	AAPL	Stock	31.3125	31.3375	31.18	31.3062	32958116.0
2015-04-17 11:00:00	AAPL	Stock	31.3062	31.4425	31.2925	31.3575	23158288.0
2015-04-17 12:00:00	AAPL	Stock	31.3575	31.4125	31.3	31.3275	10636056.0
2015-04-17 13:00:00	AAPL	Stock	31.33	31.3438	31.2225	31.25	13792784.0
2015-04-17 14:00:00	AAPL	Stock	31.2525	31.255	31.115	31.17	21805592.0
2015-04-17 15:00:00	AAPL	Stock	31.17	31.2575	31.1425	31.19	27819616.0
2015-04-17 16:00:00	AAPL	Stock	31.1875	31.2175	31.175	31.2	6630044.0
2015-04-17 17:00:00	AAPL	Stock	31.195	31.195	31.1	31.1725	312064.0
2015-04-17 18:00:00	AAPL	Stock	31.1725	31.185	31.15	31.18	84932.0
2015-04-17 19:00:00	AAPL	Stock	31.175	31.1825	31.1625	31.1675	61292.0
2015-04-17 04:00:00	MSFT	Stock	42.09	42.09	42.09	42.09	300.0
2015-04-17 06:00:00	MSFT	Stock	41.9	42.08	41.65	41.73	3950.0
2015-04-17 07:00:00	MSFT	Stock	41.79	41.8	41.74	41.74	4420.0
2015-04-17 08:00:00	MSFT	Stock	41.83	41.86	41.8	41.83	14967.0
2015-04-17 09:00:00	MSFT	Stock	41.82	41.86	41.41	41.466	6731009.0
2015-04-17 10:00:00	MSFT	Stock	41.465	41.5	41.245	41.29	5643554.0
2015-04-17 11:00:00	MSFT	Stock	41.29	41.36	41.16	41.315	4262939.0
2015-04-17 12:00:00	MSFT	Stock	41.32	41.35	41.21	41.31	2537977.0
2015-04-17 13:00:00	MSFT	Stock	41.31	41.56	41.29	41.45	5137697.0
2015-04-17 14:00:00	MSFT	Stock	41.46	41.555	41.44	41.5	5107140.0
2015-04-17 15:00:00	MSFT	Stock	41.51	41.71	41.46	41.62	8307300.0
2015-04-17 16:00:00	MSFT	Stock	41.615	41.7	41.57	41.61	2713833.0
2015-04-17 17:00:00	MSFT	Stock	41.61	41.61	41.55	41.6	2254.0
2015-04-17 18:00:00	MSFT	Stock	41.6	41.6	41.6	41.6	200.0
2015-04-17 19:00:00	MSFT	Stock	41.6	41.6	41.55	41.56	1600.0
2015-04-17 06:00:00	NVDA	Stock	0.5638	0.5638	0.5638	0.5638	4000.0
2015-04-17 09:00:00	NVDA	Stock	0.5528	0.5595	0.55	0.559	47958000.0
2015-04-17 10:00:00	NVDA	Stock	0.5589	0.5605	0.5579	0.5601	44313200.0
2015-04-17 11:00:00	NVDA	Stock	0.56	0.5602	0.5552	0.557	31111000.0
2015-04-17 12:00:00	NVDA	Stock	0.557	0.5582	0.5558	0.5562	24084160.0
2015-04-17 13:00:00	NVDA	Stock	0.5564	0.5568	0.5532	0.5536	22116520.0
2015-04-17 14:00:00	NVDA	Stock	0.5536	0.5542	0.5512	0.5528	38284360.0
2015-04-17 15:00:00	NVDA	Stock	0.5525	0.555	0.5512	0.5549	57628080.0
2015-04-17 16:00:00	NVDA	Stock	0.555	0.5552	0.5545	0.555	7123800.0
2015-04-17 19:00:00	NVDA	Stock	0.5598	0.5598	0.5598	0.5598	16000.0
2015-04-17 07:00:00	AMZN	Stock	19.2525	19.2525	19.15	19.15	17420.0
2015-04-17 08:00:00	AMZN	Stock	19.271	19.271	19.155	19.192	33520.0
2015-04-17 09:00:00	AMZN	Stock	19.1655	19.2	19.035	19.09	10755180.0
2015-04-17 10:00:00	AMZN	Stock	19.092	19.1125	19.018	19.041	6750020.0
2015-04-17 11:00:00	AMZN	Stock	19.047	19.047	18.8925	18.9	7568660.0
2015-04-17 12:00:00	AMZN	Stock	18.9028	18.935	18.825	18.935	6543280.0
2015-04-17 13:00:00	AMZN	Stock	18.9315	18.9742	18.8375	18.8695	5700980.0
2015-04-17 14:00:00	AMZN	Stock	18.8708	18.8845	18.768	18.787	7992140.0
2015-04-17 15:00:00	AMZN	Stock	18.7835	18.8524	18.72	18.776	19013460.0

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

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