PREVIEW / stock_30min / 2013-01-23

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-23.parquet
  size:    1.5 MB
  rows:    77,262
  symbols: 3,489

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-01-23 04:00:00	AAPL	Stock	18.1143	18.125	18.0939	18.1225	22400.0
2013-01-23 05:00:00	AAPL	Stock	18.1164	18.1429	18.1164	18.125	11200.0
2013-01-23 05:30:00	AAPL	Stock	18.1264	18.1268	18.1246	18.125	33880.0
2013-01-23 06:00:00	AAPL	Stock	18.1268	18.1275	18.125	18.1275	23100.0
2013-01-23 06:30:00	AAPL	Stock	18.1307	18.1429	18.1307	18.1393	14000.0
2013-01-23 07:00:00	AAPL	Stock	18.1571	18.1775	18.1336	18.1589	301924.0
2013-01-23 07:30:00	AAPL	Stock	18.1586	18.1596	18.0918	18.0918	394912.0
2013-01-23 08:00:00	AAPL	Stock	18.0993	18.1811	18.0214	18.0739	1986852.0
2013-01-23 08:30:00	AAPL	Stock	18.0786	18.1232	18.0604	18.1182	1305080.0
2013-01-23 09:00:00	AAPL	Stock	18.1179	18.1929	18.1179	18.1714	2182488.0
2013-01-23 09:30:00	AAPL	Stock	18.1693	18.2429	18.0275	18.1121	70676116.0
2013-01-23 10:00:00	AAPL	Stock	18.1146	18.3371	18.1043	18.235	75509980.0
2013-01-23 10:30:00	AAPL	Stock	18.235	18.2632	18.1486	18.2496	45709496.0
2013-01-23 11:00:00	AAPL	Stock	18.2514	18.2768	18.1771	18.2082	35007980.0
2013-01-23 11:30:00	AAPL	Stock	18.2082	18.2204	18.1429	18.1782	34304760.0
2013-01-23 12:00:00	AAPL	Stock	18.1732	18.2254	18.1525	18.2254	22924300.0
2013-01-23 12:30:00	AAPL	Stock	18.2261	18.2821	18.1971	18.2646	26002116.0
2013-01-23 13:00:00	AAPL	Stock	18.2666	18.3304	18.2254	18.3	39668552.0
2013-01-23 13:30:00	AAPL	Stock	18.2971	18.3193	18.211	18.2157	35220360.0
2013-01-23 14:00:00	AAPL	Stock	18.2143	18.2246	18.1586	18.2069	35816144.0
2013-01-23 14:30:00	AAPL	Stock	18.2064	18.3721	18.1964	18.3423	50027684.0
2013-01-23 15:00:00	AAPL	Stock	18.3454	18.3925	18.2954	18.3745	50568476.0
2013-01-23 15:30:00	AAPL	Stock	18.3729	18.3779	18.3161	18.3571	67910220.0
2013-01-23 16:00:00	AAPL	Stock	18.3571	18.5321	18.0211	18.0357	11815832.0
2013-01-23 16:30:00	AAPL	Stock	18.0268	18.8561	17.2679	17.2682	93269540.0
2013-01-23 17:00:00	AAPL	Stock	17.2689	17.2736	16.5268	16.6043	63553644.0
2013-01-23 17:30:00	AAPL	Stock	16.6043	16.6232	16.385	16.385	50104348.0
2013-01-23 18:00:00	AAPL	Stock	16.385	16.4296	16.3321	16.4279	18248524.0
2013-01-23 18:30:00	AAPL	Stock	16.4286	16.5	16.4157	16.4946	4813060.0
2013-01-23 19:00:00	AAPL	Stock	16.4893	16.4979	16.4464	16.4893	2137632.0
2013-01-23 19:30:00	AAPL	Stock	16.4911	16.5636	16.4911	16.5532	2953440.0
2013-01-23 07:00:00	MSFT	Stock	27.29	27.29	27.29	27.29	100.0
2013-01-23 07:30:00	MSFT	Stock	27.28	27.28	27.27	27.27	2300.0
2013-01-23 08:00:00	MSFT	Stock	27.27	27.29	27.1	27.26	20859.0
2013-01-23 08:30:00	MSFT	Stock	27.25	27.32	27.22	27.3	8658.0
2013-01-23 09:00:00	MSFT	Stock	27.28	27.29	27.17	27.2	231100.0
2013-01-23 09:30:00	MSFT	Stock	27.22	27.58	27.2	27.55	8591115.0
2013-01-23 10:00:00	MSFT	Stock	27.54	27.635	27.46	27.531	3937211.0
2013-01-23 10:30:00	MSFT	Stock	27.535	27.54	27.44	27.48	2655733.0
2013-01-23 11:00:00	MSFT	Stock	27.48	27.58	27.44	27.45	2369244.0
2013-01-23 11:30:00	MSFT	Stock	27.445	27.5	27.41	27.49	2158717.0
2013-01-23 12:00:00	MSFT	Stock	27.48	27.52	27.44	27.455	1456734.0
2013-01-23 12:30:00	MSFT	Stock	27.455	27.52	27.42	27.5	1602570.0
2013-01-23 13:00:00	MSFT	Stock	27.5	27.54	27.47	27.505	1348682.0
2013-01-23 13:30:00	MSFT	Stock	27.5	27.54	27.5	27.539	1261075.0
2013-01-23 14:00:00	MSFT	Stock	27.54	27.56	27.505	27.51	2013868.0
2013-01-23 14:30:00	MSFT	Stock	27.515	27.52	27.47	27.493	3173562.0
2013-01-23 15:00:00	MSFT	Stock	27.49	27.5	27.46	27.485	5162006.0
2013-01-23 15:30:00	MSFT	Stock	27.49	27.61	27.48	27.6	9218330.0
2013-01-23 16:00:00	MSFT	Stock	27.6	27.62	27.15	27.59	2821796.0

> showing 50 of 77,262 rows — these rows as CSV

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