PREVIEW / stock_1hour / 2013-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-26.parquet
  size:    995 KB
  rows:    46,199
  symbols: 3,526

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
2013-06-26 04:00:00	AAPL	Stock	14.4139	14.4361	14.4107	14.4107	20440.0
2013-06-26 05:00:00	AAPL	Stock	14.4286	14.4286	14.4286	14.4286	5600.0
2013-06-26 06:00:00	AAPL	Stock	14.4361	14.4554	14.4361	14.4464	75488.0
2013-06-26 07:00:00	AAPL	Stock	14.4464	14.4464	14.4107	14.4286	251048.0
2013-06-26 08:00:00	AAPL	Stock	14.4264	14.4429	14.3661	14.3893	623896.0
2013-06-26 09:00:00	AAPL	Stock	14.3825	14.4568	14.2779	14.295	56791000.0
2013-06-26 10:00:00	AAPL	Stock	14.2943	14.3482	14.22	14.2554	67050816.0
2013-06-26 11:00:00	AAPL	Stock	14.255	14.2921	14.165	14.165	41080144.0
2013-06-26 12:00:00	AAPL	Stock	14.165	14.2086	14.1468	14.1518	39792844.0
2013-06-26 13:00:00	AAPL	Stock	14.1536	14.2136	14.1393	14.1857	28335916.0
2013-06-26 14:00:00	AAPL	Stock	14.1863	14.1925	14.1307	14.1354	27607748.0
2013-06-26 15:00:00	AAPL	Stock	14.1354	14.2493	14.135	14.2143	56029372.0
2013-06-26 16:00:00	AAPL	Stock	14.2168	14.3741	14.1811	14.2	47230848.0
2013-06-26 17:00:00	AAPL	Stock	14.2	14.2	14.1832	14.1893	145880.0
2013-06-26 18:00:00	AAPL	Stock	14.1964	14.1964	14.1875	14.1879	65464.0
2013-06-26 19:00:00	AAPL	Stock	14.1875	14.1964	14.1789	14.1821	180852.0
2013-06-26 06:00:00	MSFT	Stock	33.9	34.11	33.9	34.1	10594.0
2013-06-26 07:00:00	MSFT	Stock	34.03	34.08	33.81	33.93	69722.0
2013-06-26 08:00:00	MSFT	Stock	34.03	34.03	33.91	33.93	31102.0
2013-06-26 09:00:00	MSFT	Stock	33.98	34.385	33.888	34.069	7179190.0
2013-06-26 10:00:00	MSFT	Stock	34.07	34.31	34.05	34.26	7426117.0
2013-06-26 11:00:00	MSFT	Stock	34.26	34.36	34.15	34.205	4653708.0
2013-06-26 12:00:00	MSFT	Stock	34.2	34.4	34.2	34.3	4262375.0
2013-06-26 13:00:00	MSFT	Stock	34.305	34.36	34.24	34.35	3308733.0
2013-06-26 14:00:00	MSFT	Stock	34.35	34.4	34.28	34.345	3167271.0
2013-06-26 15:00:00	MSFT	Stock	34.35	34.48	34.33	34.36	8134934.0
2013-06-26 16:00:00	MSFT	Stock	34.35	34.455	34.202	34.35	10198344.0
2013-06-26 17:00:00	MSFT	Stock	34.35	34.35	34.34	34.35	1375.0
2013-06-26 18:00:00	MSFT	Stock	34.35	34.35	34.34	34.34	670.0
2013-06-26 19:00:00	MSFT	Stock	34.34	34.34	34.34	34.34	1572.0
2013-06-26 08:00:00	NVDA	Stock	0.3568	0.3568	0.3562	0.3562	16000.0
2013-06-26 09:00:00	NVDA	Stock	0.3595	0.3599	0.3535	0.355	54338480.0
2013-06-26 10:00:00	NVDA	Stock	0.355	0.3562	0.352	0.3533	104468120.0
2013-06-26 11:00:00	NVDA	Stock	0.3534	0.355	0.3525	0.3549	69712520.0
2013-06-26 12:00:00	NVDA	Stock	0.3548	0.355	0.3538	0.3539	38657160.0
2013-06-26 13:00:00	NVDA	Stock	0.3538	0.3558	0.3538	0.3546	46021440.0
2013-06-26 14:00:00	NVDA	Stock	0.3546	0.3548	0.354	0.354	49277000.0
2013-06-26 15:00:00	NVDA	Stock	0.354	0.3548	0.3528	0.3533	141723560.0
2013-06-26 16:00:00	NVDA	Stock	0.3535	0.3543	0.353	0.3535	67056440.0
2013-06-26 17:00:00	NVDA	Stock	0.3538	0.3538	0.3538	0.3538	24000.0
2013-06-26 18:00:00	NVDA	Stock	0.353	0.3533	0.353	0.3533	68000.0
2013-06-26 05:00:00	AMZN	Stock	13.655	13.6575	13.655	13.6575	6220.0
2013-06-26 06:00:00	AMZN	Stock	13.6575	13.6575	13.6575	13.6575	2000.0
2013-06-26 07:00:00	AMZN	Stock	13.6545	13.68	13.654	13.677	18000.0
2013-06-26 08:00:00	AMZN	Stock	13.6535	13.682	13.648	13.67	62700.0
2013-06-26 09:00:00	AMZN	Stock	13.6665	13.825	13.6665	13.8207	13102900.0
2013-06-26 10:00:00	AMZN	Stock	13.8208	13.8885	13.74	13.866	13106260.0
2013-06-26 11:00:00	AMZN	Stock	13.866	13.899	13.823	13.8235	9266280.0
2013-06-26 12:00:00	AMZN	Stock	13.82	13.886	13.8155	13.8535	3619420.0
2013-06-26 13:00:00	AMZN	Stock	13.86	13.895	13.843	13.8705	3605280.0

> showing 50 of 46,199 rows — these rows as CSV

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