PREVIEW / stock_1hour / 2014-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-30.parquet
  size:    1.1 MB
  rows:    49,203
  symbols: 3,567

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-09-30 04:00:00	AAPL	Stock	25.0275	25.12	25.0275	25.095	37400.0
2014-09-30 05:00:00	AAPL	Stock	25.0875	25.14	25.075	25.1	22376.0
2014-09-30 06:00:00	AAPL	Stock	25.1	25.155	25.0825	25.155	236096.0
2014-09-30 07:00:00	AAPL	Stock	25.1525	25.2675	25.15	25.2125	474828.0
2014-09-30 08:00:00	AAPL	Stock	25.225	25.3125	25.0275	25.25	1472848.0
2014-09-30 09:00:00	AAPL	Stock	25.2525	25.3575	25.135	25.225	32618032.0
2014-09-30 10:00:00	AAPL	Stock	25.2225	25.3475	25.1325	25.3275	31840132.0
2014-09-30 11:00:00	AAPL	Stock	25.325	25.385	25.28	25.325	24986008.0
2014-09-30 12:00:00	AAPL	Stock	25.3225	25.3275	25.1775	25.2472	18789700.0
2014-09-30 13:00:00	AAPL	Stock	25.245	25.325	25.1625	25.229	17998520.0
2014-09-30 14:00:00	AAPL	Stock	25.2275	25.2425	25.1325	25.224	17286668.0
2014-09-30 15:00:00	AAPL	Stock	25.225	25.2925	25.185	25.1875	31626676.0
2014-09-30 16:00:00	AAPL	Stock	25.1888	25.375	25.15	25.165	17287000.0
2014-09-30 17:00:00	AAPL	Stock	25.1525	25.1875	25.1375	25.1375	270332.0
2014-09-30 18:00:00	AAPL	Stock	25.1375	25.155	25.115	25.1325	362784.0
2014-09-30 19:00:00	AAPL	Stock	25.125	25.145	25.1175	25.12	89276.0
2014-09-30 08:00:00	MSFT	Stock	46.55	46.55	46.55	46.55	1165.0
2014-09-30 09:00:00	MSFT	Stock	46.55	46.55	46.13	46.23	4293262.0
2014-09-30 10:00:00	MSFT	Stock	46.23	46.409	46.11	46.38	3877443.0
2014-09-30 11:00:00	MSFT	Stock	46.38	46.476	46.32	46.365	4126700.0
2014-09-30 12:00:00	MSFT	Stock	46.365	46.41	46.19	46.235	2350549.0
2014-09-30 13:00:00	MSFT	Stock	46.235	46.35	46.1	46.11	2219510.0
2014-09-30 14:00:00	MSFT	Stock	46.11	46.28	46.01	46.2	3374944.0
2014-09-30 15:00:00	MSFT	Stock	46.21	46.38	46.13	46.36	6960077.0
2014-09-30 16:00:00	MSFT	Stock	46.36	46.4	46.28	46.3	4284116.0
2014-09-30 17:00:00	MSFT	Stock	46.27	46.36	46.267	46.36	2513.0
2014-09-30 18:00:00	MSFT	Stock	46.36	46.36	46.3	46.3	34251.0
2014-09-30 09:00:00	NVDA	Stock	0.4628	0.4628	0.4562	0.4572	26624600.0
2014-09-30 10:00:00	NVDA	Stock	0.4572	0.462	0.4558	0.4612	58174440.0
2014-09-30 11:00:00	NVDA	Stock	0.4615	0.4645	0.4615	0.463	25344000.0
2014-09-30 12:00:00	NVDA	Stock	0.463	0.4633	0.4598	0.4604	19558800.0
2014-09-30 13:00:00	NVDA	Stock	0.4604	0.4612	0.4593	0.4603	21515920.0
2014-09-30 14:00:00	NVDA	Stock	0.4603	0.4635	0.4599	0.4616	34342640.0
2014-09-30 15:00:00	NVDA	Stock	0.4615	0.463	0.4608	0.4614	65126280.0
2014-09-30 16:00:00	NVDA	Stock	0.4612	0.4617	0.4611	0.4613	19239200.0
2014-09-30 07:00:00	AMZN	Stock	16.1655	16.2425	16.1485	16.15	64000.0
2014-09-30 08:00:00	AMZN	Stock	16.149	16.15	16.1375	16.15	61580.0
2014-09-30 09:00:00	AMZN	Stock	16.15	16.15	15.9255	16.0131	7268480.0
2014-09-30 10:00:00	AMZN	Stock	16.0175	16.1324	15.9575	16.1275	6986900.0
2014-09-30 11:00:00	AMZN	Stock	16.124	16.1595	16.08	16.1265	6332280.0
2014-09-30 12:00:00	AMZN	Stock	16.127	16.147	16.0835	16.0975	3999280.0
2014-09-30 13:00:00	AMZN	Stock	16.1022	16.1375	16.0255	16.0625	2992420.0
2014-09-30 14:00:00	AMZN	Stock	16.0535	16.109	16.0205	16.096	4441000.0
2014-09-30 15:00:00	AMZN	Stock	16.0945	16.1715	16.0575	16.122	9071740.0
2014-09-30 16:00:00	AMZN	Stock	16.122	16.1265	16.0826	16.125	1561220.0
2014-09-30 17:00:00	AMZN	Stock	16.115	16.122	16.105	16.122	52140.0
2014-09-30 18:00:00	AMZN	Stock	16.122	16.122	16.1	16.1	58860.0
2014-09-30 19:00:00	AMZN	Stock	16.1	16.1	16.1	16.1	2000.0
2014-09-30 07:00:00	GOOGL	Stock	29.425	29.425	29.425	29.425	2000.0
2014-09-30 08:00:00	GOOGL	Stock	29.3905	29.575	29.3905	29.57	33360.0

> showing 50 of 49,203 rows — these rows as CSV

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