PREVIEW / stock_1hour / 2014-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-21.parquet
  size:    1.0 MB
  rows:    48,601
  symbols: 3,534

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-21 04:00:00	AAPL	Stock	21.5893	21.5893	21.5889	21.5889	11200.0
2014-05-21 05:00:00	AAPL	Stock	21.6	21.6286	21.6	21.6286	5600.0
2014-05-21 07:00:00	AAPL	Stock	21.5821	21.6179	21.575	21.6107	168476.0
2014-05-21 08:00:00	AAPL	Stock	21.5986	21.6186	21.5468	21.5893	686616.0
2014-05-21 09:00:00	AAPL	Stock	21.5846	21.6286	21.5379	21.5996	32569292.0
2014-05-21 10:00:00	AAPL	Stock	21.5971	21.6096	21.5021	21.58	34120016.0
2014-05-21 11:00:00	AAPL	Stock	21.574	21.5867	21.5339	21.5636	19614728.0
2014-05-21 12:00:00	AAPL	Stock	21.5643	21.6161	21.5475	21.5975	10634904.0
2014-05-21 13:00:00	AAPL	Stock	21.6011	21.6179	21.5821	21.6039	10166408.0
2014-05-21 14:00:00	AAPL	Stock	21.6061	21.6671	21.5943	21.6321	23522044.0
2014-05-21 15:00:00	AAPL	Stock	21.6328	21.6679	21.6154	21.6529	23718128.0
2014-05-21 16:00:00	AAPL	Stock	21.6539	21.6643	21.5911	21.6571	5941152.0
2014-05-21 17:00:00	AAPL	Stock	21.6536	21.6536	21.6468	21.6504	59640.0
2014-05-21 18:00:00	AAPL	Stock	21.65	21.6539	21.65	21.6518	77840.0
2014-05-21 19:00:00	AAPL	Stock	21.6536	21.6536	21.6486	21.6486	94724.0
2014-05-21 07:00:00	MSFT	Stock	39.78	39.78	39.76	39.76	300.0
2014-05-21 08:00:00	MSFT	Stock	39.75	39.76	39.71	39.75	1821.0
2014-05-21 09:00:00	MSFT	Stock	39.76	40.24	39.74	40.105	3080670.0
2014-05-21 10:00:00	MSFT	Stock	40.105	40.18	40.04	40.14	2571662.0
2014-05-21 11:00:00	MSFT	Stock	40.14	40.145	39.97	40.112	2337536.0
2014-05-21 12:00:00	MSFT	Stock	40.12	40.18	40.09	40.16	1266032.0
2014-05-21 13:00:00	MSFT	Stock	40.16	40.2	40.14	40.17	1644611.0
2014-05-21 14:00:00	MSFT	Stock	40.165	40.28	40.12	40.24	2592380.0
2014-05-21 15:00:00	MSFT	Stock	40.25	40.35	40.23	40.35	5769575.0
2014-05-21 16:00:00	MSFT	Stock	40.35	40.358	40.099	40.3	2329662.0
2014-05-21 17:00:00	MSFT	Stock	40.35	40.35	40.31	40.33	13895.0
2014-05-21 18:00:00	MSFT	Stock	40.32	40.35	40.32	40.35	21079.0
2014-05-21 19:00:00	MSFT	Stock	40.34	40.35	40.33	40.34	500.0
2014-05-21 09:00:00	NVDA	Stock	0.4578	0.4616	0.457	0.4588	15986320.0
2014-05-21 10:00:00	NVDA	Stock	0.4589	0.4603	0.4575	0.4593	19817800.0
2014-05-21 11:00:00	NVDA	Stock	0.459	0.459	0.4548	0.455	28835920.0
2014-05-21 12:00:00	NVDA	Stock	0.4552	0.4562	0.4531	0.4558	27891880.0
2014-05-21 13:00:00	NVDA	Stock	0.4558	0.4582	0.4556	0.458	13661000.0
2014-05-21 14:00:00	NVDA	Stock	0.4579	0.459	0.456	0.4577	20056960.0
2014-05-21 15:00:00	NVDA	Stock	0.4575	0.4582	0.4558	0.4562	72015400.0
2014-05-21 16:00:00	NVDA	Stock	0.456	0.4633	0.4558	0.4561	1660320.0
2014-05-21 17:00:00	NVDA	Stock	0.4562	0.4562	0.455	0.455	246000.0
2014-05-21 08:00:00	AMZN	Stock	15.122	15.197	15.087	15.197	83520.0
2014-05-21 09:00:00	AMZN	Stock	15.1915	15.2595	15.076	15.229	11609800.0
2014-05-21 10:00:00	AMZN	Stock	15.2365	15.298	15.2156	15.2445	12629020.0
2014-05-21 11:00:00	AMZN	Stock	15.2415	15.2535	15.1405	15.1755	9065460.0
2014-05-21 12:00:00	AMZN	Stock	15.183	15.236	15.1624	15.215	3080400.0
2014-05-21 13:00:00	AMZN	Stock	15.2155	15.2599	15.209	15.249	3758240.0
2014-05-21 14:00:00	AMZN	Stock	15.242	15.265	15.199	15.2325	5636300.0
2014-05-21 15:00:00	AMZN	Stock	15.233	15.282	15.2155	15.251	13415420.0
2014-05-21 16:00:00	AMZN	Stock	15.2505	15.272	15.2275	15.24	2453000.0
2014-05-21 17:00:00	AMZN	Stock	15.235	15.2505	15.235	15.2505	28200.0
2014-05-21 18:00:00	AMZN	Stock	15.2505	15.2505	15.2505	15.2505	58680.0
2014-05-21 06:00:00	GOOGL	Stock	27.21	27.21	27.21	27.21	2000.0
2014-05-21 08:00:00	GOOGL	Stock	27.0865	27.095	27.035	27.095	20600.0

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

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