PREVIEW / stock_1hour / 2014-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-14.parquet
  size:    1.0 MB
  rows:    47,850
  symbols: 3,541

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-05-14 05:00:00	AAPL	Stock	21.1579	21.1582	21.1257	21.1257	25200.0
2014-05-14 06:00:00	AAPL	Stock	21.1321	21.1479	21.1321	21.1479	19600.0
2014-05-14 07:00:00	AAPL	Stock	21.1425	21.1532	21.1321	21.1532	28000.0
2014-05-14 08:00:00	AAPL	Stock	21.1439	21.1664	21.135	21.1571	290136.0
2014-05-14 09:00:00	AAPL	Stock	21.1607	21.2757	21.1482	21.2493	22634668.0
2014-05-14 10:00:00	AAPL	Stock	21.2489	21.3357	21.2326	21.2804	30574572.0
2014-05-14 11:00:00	AAPL	Stock	21.2832	21.3007	21.2111	21.2307	14447020.0
2014-05-14 12:00:00	AAPL	Stock	21.2316	21.2854	21.23	21.2757	6715212.0
2014-05-14 13:00:00	AAPL	Stock	21.2789	21.2946	21.2293	21.2464	7556192.0
2014-05-14 14:00:00	AAPL	Stock	21.2471	21.275	21.2321	21.2382	8908452.0
2014-05-14 15:00:00	AAPL	Stock	21.2406	21.2421	21.1336	21.2093	30804116.0
2014-05-14 16:00:00	AAPL	Stock	21.2089	21.2698	21.1932	21.2268	7502600.0
2014-05-14 17:00:00	AAPL	Stock	21.2289	21.2289	21.22	21.22	24304.0
2014-05-14 18:00:00	AAPL	Stock	21.2264	21.2286	21.2096	21.2179	173656.0
2014-05-14 19:00:00	AAPL	Stock	21.2214	21.2357	21.2196	21.225	127988.0
2014-05-14 07:00:00	MSFT	Stock	40.22	40.22	40.22	40.22	200.0
2014-05-14 08:00:00	MSFT	Stock	40.3	40.3	40.26	40.3	1950.0
2014-05-14 09:00:00	MSFT	Stock	40.3	40.45	40.2	40.41	3151717.0
2014-05-14 10:00:00	MSFT	Stock	40.416	40.45	40.21	40.27	3009824.0
2014-05-14 11:00:00	MSFT	Stock	40.27	40.29	40.17	40.2	1647426.0
2014-05-14 12:00:00	MSFT	Stock	40.204	40.36	40.203	40.28	1273434.0
2014-05-14 13:00:00	MSFT	Stock	40.29	40.35	40.26	40.27	947251.0
2014-05-14 14:00:00	MSFT	Stock	40.28	40.31	40.205	40.235	1512262.0
2014-05-14 15:00:00	MSFT	Stock	40.232	40.28	40.05	40.24	4934260.0
2014-05-14 16:00:00	MSFT	Stock	40.24	40.292	40.15	40.235	1772110.0
2014-05-14 17:00:00	MSFT	Stock	40.241	40.3	40.241	40.25	2195.0
2014-05-14 18:00:00	MSFT	Stock	40.3	40.3	40.24	40.24	12018.0
2014-05-14 19:00:00	MSFT	Stock	40.34	40.34	40.34	40.34	1160.0
2014-05-14 08:00:00	NVDA	Stock	0.457	0.457	0.457	0.457	6592000.0
2014-05-14 09:00:00	NVDA	Stock	0.4572	0.459	0.4558	0.4575	12243880.0
2014-05-14 10:00:00	NVDA	Stock	0.4575	0.4588	0.4558	0.4578	19011720.0
2014-05-14 11:00:00	NVDA	Stock	0.458	0.4585	0.4555	0.4555	18562080.0
2014-05-14 12:00:00	NVDA	Stock	0.4555	0.456	0.4535	0.4538	28040800.0
2014-05-14 13:00:00	NVDA	Stock	0.4536	0.4578	0.4535	0.4578	17488520.0
2014-05-14 14:00:00	NVDA	Stock	0.4578	0.458	0.4558	0.4566	19650920.0
2014-05-14 15:00:00	NVDA	Stock	0.4566	0.4566	0.4522	0.4528	69349080.0
2014-05-14 16:00:00	NVDA	Stock	0.4525	0.4579	0.4524	0.4524	19699240.0
2014-05-14 05:00:00	AMZN	Stock	15.182	15.182	15.182	15.182	2000.0
2014-05-14 06:00:00	AMZN	Stock	15.167	15.167	15.167	15.167	2000.0
2014-05-14 07:00:00	AMZN	Stock	15.15	15.171	15.15	15.171	6460.0
2014-05-14 08:00:00	AMZN	Stock	15.0775	15.125	15.0765	15.125	121380.0
2014-05-14 09:00:00	AMZN	Stock	15.1125	15.232	15.065	15.1905	9756780.0
2014-05-14 10:00:00	AMZN	Stock	15.1895	15.232	14.978	14.9977	16478020.0
2014-05-14 11:00:00	AMZN	Stock	15.0085	15.0494	14.95	15.036	6599260.0
2014-05-14 12:00:00	AMZN	Stock	15.0402	15.0649	14.9905	14.9985	4648380.0
2014-05-14 13:00:00	AMZN	Stock	15.0015	15.0625	14.99	14.9995	3381880.0
2014-05-14 14:00:00	AMZN	Stock	14.9975	15.0055	14.9055	14.9095	4787960.0
2014-05-14 15:00:00	AMZN	Stock	14.9125	14.9145	14.833	14.881	13095940.0
2014-05-14 16:00:00	AMZN	Stock	14.881	15.0171	14.873	14.8792	328740.0
2014-05-14 17:00:00	AMZN	Stock	14.925	14.925	14.915	14.925	10000.0

> showing 50 of 47,850 rows — these rows as CSV

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