PREVIEW / stock_30min / 2013-04-19

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-19.parquet
  size:    1.4 MB
  rows:    75,357
  symbols: 3,473

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-19 04:00:00	AAPL	Stock	14.0264	14.0268	14.0264	14.0268	28000.0
2013-04-19 04:30:00	AAPL	Stock	14.0496	14.0536	14.0496	14.0536	8400.0
2013-04-19 05:00:00	AAPL	Stock	14.0557	14.0557	14.0557	14.0557	2800.0
2013-04-19 05:30:00	AAPL	Stock	14.0536	14.0679	14.0486	14.0679	26096.0
2013-04-19 06:00:00	AAPL	Stock	14.0779	14.0786	14.0779	14.0786	11200.0
2013-04-19 06:30:00	AAPL	Stock	14.0632	14.0796	14.0486	14.0796	36008.0
2013-04-19 07:00:00	AAPL	Stock	14.0607	14.0786	14.0486	14.0714	119868.0
2013-04-19 07:30:00	AAPL	Stock	14.0736	14.0736	14.0361	14.0361	336392.0
2013-04-19 08:00:00	AAPL	Stock	14.0507	14.0714	13.9654	13.9907	1071532.0
2013-04-19 08:30:00	AAPL	Stock	13.9857	13.9986	13.9471	13.9721	1247092.0
2013-04-19 09:00:00	AAPL	Stock	13.9725	13.9825	13.8064	13.8629	3608976.0
2013-04-19 09:30:00	AAPL	Stock	13.8625	13.9871	13.7536	13.9857	142594900.0
2013-04-19 10:00:00	AAPL	Stock	13.9854	14.2232	13.9757	14.1532	95803540.0
2013-04-19 10:30:00	AAPL	Stock	14.1532	14.2143	14.1218	14.1543	37534392.0
2013-04-19 11:00:00	AAPL	Stock	14.1543	14.2714	14.1518	14.1879	52411688.0
2013-04-19 11:30:00	AAPL	Stock	14.1886	14.2357	14.1643	14.17	23522128.0
2013-04-19 12:00:00	AAPL	Stock	14.17	14.1986	14.0857	14.1189	26445328.0
2013-04-19 12:30:00	AAPL	Stock	14.1209	14.1471	14.0739	14.114	17065272.0
2013-04-19 13:00:00	AAPL	Stock	14.1143	14.1161	14.0211	14.05	28284788.0
2013-04-19 13:30:00	AAPL	Stock	14.0486	14.0771	14.025	14.0621	14918736.0
2013-04-19 14:00:00	AAPL	Stock	14.0621	14.1261	14.0611	14.0961	20749960.0
2013-04-19 14:30:00	AAPL	Stock	14.0957	14.11	13.9982	14.0061	28985544.0
2013-04-19 15:00:00	AAPL	Stock	14.0096	14.0357	13.9629	14.0236	33689460.0
2013-04-19 15:30:00	AAPL	Stock	14.0221	14.0418	13.9446	13.9525	52103436.0
2013-04-19 16:00:00	AAPL	Stock	13.9461	14.1089	13.9357	13.9364	15958516.0
2013-04-19 16:30:00	AAPL	Stock	13.9343	14.1956	13.93	13.9318	714084.0
2013-04-19 17:00:00	AAPL	Stock	13.9346	13.935	13.93	13.93	169792.0
2013-04-19 17:30:00	AAPL	Stock	13.9318	13.9407	13.93	13.9311	249060.0
2013-04-19 18:00:00	AAPL	Stock	13.93	13.9325	13.9214	13.9254	226072.0
2013-04-19 18:30:00	AAPL	Stock	13.9225	13.9279	13.9225	13.9268	38864.0
2013-04-19 19:00:00	AAPL	Stock	13.9282	13.9321	13.9268	13.9286	115276.0
2013-04-19 19:30:00	AAPL	Stock	13.9282	13.9321	13.9239	13.9321	114940.0
2013-04-19 04:00:00	MSFT	Stock	29.62	29.62	29.62	29.62	100.0
2013-04-19 04:30:00	MSFT	Stock	29.6	29.6	29.55	29.55	520.0
2013-04-19 06:30:00	MSFT	Stock	29.5	29.55	29.5	29.5	4000.0
2013-04-19 07:00:00	MSFT	Stock	29.5	29.55	29.4	29.46	10060.0
2013-04-19 07:30:00	MSFT	Stock	29.45	29.53	29.38	29.51	76484.0
2013-04-19 08:00:00	MSFT	Stock	29.5	29.62	29.2	29.6	261809.0
2013-04-19 08:30:00	MSFT	Stock	29.6	29.76	29.59	29.7	752219.0
2013-04-19 09:00:00	MSFT	Stock	29.7	29.96	29.62	29.63	1019834.0
2013-04-19 09:30:00	MSFT	Stock	29.63	30.24	29.62	29.925	34129235.0
2013-04-19 10:00:00	MSFT	Stock	29.925	30.055	29.75	29.78	10862771.0
2013-04-19 10:30:00	MSFT	Stock	29.78	29.9	29.74	29.882	4984249.0
2013-04-19 11:00:00	MSFT	Stock	29.89	29.9	29.71	29.779	5075517.0
2013-04-19 11:30:00	MSFT	Stock	29.78	29.83	29.67	29.717	3105554.0
2013-04-19 12:00:00	MSFT	Stock	29.72	29.81	29.71	29.72	5280547.0
2013-04-19 12:30:00	MSFT	Stock	29.71	29.72	29.62	29.65	3047563.0
2013-04-19 13:00:00	MSFT	Stock	29.642	29.76	29.61	29.75	2430856.0
2013-04-19 13:30:00	MSFT	Stock	29.75	29.77	29.66	29.705	2472370.0
2013-04-19 14:00:00	MSFT	Stock	29.7	29.8	29.7	29.8	2356706.0

> showing 50 of 75,357 rows — these rows as CSV

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