PREVIEW / stock_30min / 2013-04-29

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-29.parquet
  size:    1.5 MB
  rows:    78,258
  symbols: 3,507

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-04-29 04:00:00	AAPL	Stock	14.9464	15.3286	14.9464	15.0	39564.0
2013-04-29 04:30:00	AAPL	Stock	14.9607	14.9607	14.9607	14.9607	2800.0
2013-04-29 06:00:00	AAPL	Stock	14.9786	14.9786	14.9643	14.9786	23828.0
2013-04-29 06:30:00	AAPL	Stock	14.9818	14.9829	14.9754	14.9754	14700.0
2013-04-29 07:00:00	AAPL	Stock	14.9732	14.9804	14.9546	14.9782	94864.0
2013-04-29 07:30:00	AAPL	Stock	14.9771	15.0232	14.97	14.9818	508872.0
2013-04-29 08:00:00	AAPL	Stock	14.9729	15.0243	14.9643	15.0107	1092168.0
2013-04-29 08:30:00	AAPL	Stock	15.0061	15.015	14.9857	14.9893	769300.0
2013-04-29 09:00:00	AAPL	Stock	14.9893	15.0196	14.975	15.0171	1796480.0
2013-04-29 09:30:00	AAPL	Stock	15.0168	15.213	15.0	15.1389	90963572.0
2013-04-29 10:00:00	AAPL	Stock	15.1389	15.2539	15.1336	15.2339	48759900.0
2013-04-29 10:30:00	AAPL	Stock	15.2329	15.3179	15.2182	15.2686	49009212.0
2013-04-29 11:00:00	AAPL	Stock	15.2633	15.3196	15.2618	15.2829	26522552.0
2013-04-29 11:30:00	AAPL	Stock	15.2793	15.3525	15.2675	15.3511	27393884.0
2013-04-29 12:00:00	AAPL	Stock	15.3511	15.4389	15.3375	15.4261	54010264.0
2013-04-29 12:30:00	AAPL	Stock	15.4266	15.4863	15.3982	15.4075	42395108.0
2013-04-29 13:00:00	AAPL	Stock	15.4078	15.4371	15.365	15.3864	27861092.0
2013-04-29 13:30:00	AAPL	Stock	15.3868	15.4586	15.3779	15.4214	23994852.0
2013-04-29 14:00:00	AAPL	Stock	15.4214	15.4604	15.4025	15.4461	19886636.0
2013-04-29 14:30:00	AAPL	Stock	15.4436	15.4732	15.4179	15.4604	17292408.0
2013-04-29 15:00:00	AAPL	Stock	15.4607	15.4704	15.3789	15.4036	31152716.0
2013-04-29 15:30:00	AAPL	Stock	15.4028	15.4571	15.3571	15.3611	51537164.0
2013-04-29 16:00:00	AAPL	Stock	15.3614	15.4304	15.3151	15.3482	51607668.0
2013-04-29 16:30:00	AAPL	Stock	15.35	15.3992	15.1307	15.3571	1643320.0
2013-04-29 17:00:00	AAPL	Stock	15.3571	15.3735	15.2412	15.3675	316372.0
2013-04-29 17:30:00	AAPL	Stock	15.3675	15.3675	15.3593	15.3618	105980.0
2013-04-29 18:00:00	AAPL	Stock	15.3586	15.3657	15.3571	15.3582	84140.0
2013-04-29 18:30:00	AAPL	Stock	15.3625	15.3625	15.3589	15.3589	97020.0
2013-04-29 19:00:00	AAPL	Stock	15.3571	15.3618	15.3554	15.3571	152068.0
2013-04-29 19:30:00	AAPL	Stock	15.36	15.3661	15.3571	15.3643	155708.0
2013-04-29 05:30:00	MSFT	Stock	32.1	32.12	32.1	32.12	990.0
2013-04-29 07:30:00	MSFT	Stock	31.84	31.84	31.82	31.82	900.0
2013-04-29 08:00:00	MSFT	Stock	31.82	31.85	31.82	31.85	1629.0
2013-04-29 08:30:00	MSFT	Stock	31.82	31.86	31.82	31.85	6000.0
2013-04-29 09:00:00	MSFT	Stock	31.85	31.85	31.76	31.77	19900.0
2013-04-29 09:30:00	MSFT	Stock	31.83	32.33	31.77	32.25	8012539.0
2013-04-29 10:00:00	MSFT	Stock	32.255	32.63	32.255	32.51	6892230.0
2013-04-29 10:30:00	MSFT	Stock	32.505	32.56	32.41	32.501	4600820.0
2013-04-29 11:00:00	MSFT	Stock	32.5	32.52	32.41	32.415	3554380.0
2013-04-29 11:30:00	MSFT	Stock	32.42	32.5	32.41	32.5	2768796.0
2013-04-29 12:00:00	MSFT	Stock	32.49	32.52	32.45	32.47	2878386.0
2013-04-29 12:30:00	MSFT	Stock	32.469	32.52	32.44	32.45	1506708.0
2013-04-29 13:00:00	MSFT	Stock	32.45	32.53	32.44	32.517	2325926.0
2013-04-29 13:30:00	MSFT	Stock	32.516	32.55	32.49	32.545	1865387.0
2013-04-29 14:00:00	MSFT	Stock	32.545	32.68	32.54	32.635	2956313.0
2013-04-29 14:30:00	MSFT	Stock	32.63	32.68	32.62	32.655	3068359.0
2013-04-29 15:00:00	MSFT	Stock	32.655	32.66	32.44	32.555	3543927.0
2013-04-29 15:30:00	MSFT	Stock	32.56	32.67	32.55	32.62	8233674.0
2013-04-29 16:00:00	MSFT	Stock	32.61	32.65	32.456	32.6	2137518.0
2013-04-29 16:30:00	MSFT	Stock	32.6	32.613	32.469	32.6	77397.0

> showing 50 of 78,258 rows — these rows as CSV

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