PREVIEW / stock_30min / 2014-01-09

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-09.parquet
  size:    1.6 MB
  rows:    82,962
  symbols: 3,519

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-01-09 04:00:00	AAPL	Stock	19.4586	19.5225	19.4586	19.5225	11200.0
2014-01-09 04:30:00	AAPL	Stock	19.4971	19.4971	19.4643	19.4643	5600.0
2014-01-09 05:00:00	AAPL	Stock	19.4864	19.4929	19.4864	19.4929	12600.0
2014-01-09 05:30:00	AAPL	Stock	19.4743	19.4979	19.4743	19.4979	8400.0
2014-01-09 06:30:00	AAPL	Stock	19.4821	19.4846	19.4714	19.4846	16800.0
2014-01-09 07:00:00	AAPL	Stock	19.4714	19.5096	19.4714	19.5007	152264.0
2014-01-09 07:30:00	AAPL	Stock	19.5086	19.5757	19.5086	19.5361	345716.0
2014-01-09 08:00:00	AAPL	Stock	19.4843	19.5482	19.4843	19.5207	594748.0
2014-01-09 08:30:00	AAPL	Stock	19.5146	19.5214	19.4875	19.5211	386512.0
2014-01-09 09:00:00	AAPL	Stock	19.5147	19.5346	19.4993	19.5286	663628.0
2014-01-09 09:30:00	AAPL	Stock	19.5286	19.535	19.4464	19.5096	33580988.0
2014-01-09 10:00:00	AAPL	Stock	19.51	19.5175	19.3689	19.4314	25746056.0
2014-01-09 10:30:00	AAPL	Stock	19.4314	19.4314	19.3289	19.3594	15841812.0
2014-01-09 11:00:00	AAPL	Stock	19.3586	19.3586	19.2446	19.2721	17778404.0
2014-01-09 11:30:00	AAPL	Stock	19.27	19.2957	19.2429	19.2675	12360712.0
2014-01-09 12:00:00	AAPL	Stock	19.2664	19.2993	19.2321	19.2714	8641584.0
2014-01-09 12:30:00	AAPL	Stock	19.2696	19.3243	19.2696	19.3014	15001784.0
2014-01-09 13:00:00	AAPL	Stock	19.3011	19.3179	19.2714	19.2814	5746664.0
2014-01-09 13:30:00	AAPL	Stock	19.2814	19.2989	19.1814	19.1843	11927468.0
2014-01-09 14:00:00	AAPL	Stock	19.1861	19.1993	19.1196	19.195	19937792.0
2014-01-09 14:30:00	AAPL	Stock	19.1946	19.2089	19.15	19.1702	11546164.0
2014-01-09 15:00:00	AAPL	Stock	19.1707	19.2218	19.1682	19.1932	9378852.0
2014-01-09 15:30:00	AAPL	Stock	19.1971	19.2179	19.1457	19.1607	28592844.0
2014-01-09 16:00:00	AAPL	Stock	19.1611	19.33	19.1496	19.1657	15010800.0
2014-01-09 16:30:00	AAPL	Stock	19.1636	19.2078	19.1486	19.1486	150136.0
2014-01-09 17:00:00	AAPL	Stock	19.1489	19.1636	19.1486	19.1557	884800.0
2014-01-09 17:30:00	AAPL	Stock	19.1518	19.1586	19.1468	19.1493	83776.0
2014-01-09 18:00:00	AAPL	Stock	19.1511	19.1596	19.1493	19.1493	136388.0
2014-01-09 18:30:00	AAPL	Stock	19.1554	19.1554	19.1432	19.1432	26572.0
2014-01-09 19:00:00	AAPL	Stock	19.1482	19.1639	19.1482	19.1639	109144.0
2014-01-09 19:30:00	AAPL	Stock	19.1554	19.1636	19.1518	19.1518	52948.0
2014-01-09 06:30:00	MSFT	Stock	35.87	35.87	35.87	35.87	500.0
2014-01-09 07:00:00	MSFT	Stock	35.86	35.86	35.86	35.86	317.0
2014-01-09 08:00:00	MSFT	Stock	35.8	35.9	35.8	35.82	7743.0
2014-01-09 08:30:00	MSFT	Stock	35.849	35.88	35.83	35.88	4167.0
2014-01-09 09:00:00	MSFT	Stock	35.88	35.9	35.85	35.86	26746.0
2014-01-09 09:30:00	MSFT	Stock	35.88	35.91	35.72	35.9	4735728.0
2014-01-09 10:00:00	MSFT	Stock	35.9	35.9	35.72	35.744	2466138.0
2014-01-09 10:30:00	MSFT	Stock	35.74	35.745	35.51	35.555	2702714.0
2014-01-09 11:00:00	MSFT	Stock	35.55	35.56	35.4	35.48	2568340.0
2014-01-09 11:30:00	MSFT	Stock	35.48	35.52	35.43	35.48	2373365.0
2014-01-09 12:00:00	MSFT	Stock	35.49	35.545	35.43	35.54	1525880.0
2014-01-09 12:30:00	MSFT	Stock	35.55	35.61	35.54	35.58	1908459.0
2014-01-09 13:00:00	MSFT	Stock	35.58	35.58	35.54	35.56	1080481.0
2014-01-09 13:30:00	MSFT	Stock	35.56	35.6	35.505	35.525	2139031.0
2014-01-09 14:00:00	MSFT	Stock	35.525	35.53	35.445	35.515	1219356.0
2014-01-09 14:30:00	MSFT	Stock	35.519	35.56	35.48	35.512	1775309.0
2014-01-09 15:00:00	MSFT	Stock	35.515	35.65	35.49	35.64	2783438.0
2014-01-09 15:30:00	MSFT	Stock	35.635	35.64	35.51	35.53	5277368.0
2014-01-09 16:00:00	MSFT	Stock	35.53	35.636	35.35	35.52	2765256.0

> showing 50 of 82,962 rows — these rows as CSV

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