PREVIEW / stock_30min / 2013-12-26

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-26.parquet
  size:    1.5 MB
  rows:    81,005
  symbols: 3,532

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-12-26 05:30:00	AAPL	Stock	20.3475	20.3475	20.3475	20.3475	5600.0
2013-12-26 06:00:00	AAPL	Stock	20.2893	20.2893	20.2893	20.2893	5600.0
2013-12-26 06:30:00	AAPL	Stock	20.2861	20.2861	20.2861	20.2861	2800.0
2013-12-26 07:30:00	AAPL	Stock	20.3125	20.3314	20.3036	20.3314	189280.0
2013-12-26 08:00:00	AAPL	Stock	20.2914	20.3429	20.2914	20.3304	549808.0
2013-12-26 08:30:00	AAPL	Stock	20.3304	20.3304	20.2739	20.2914	484204.0
2013-12-26 09:00:00	AAPL	Stock	20.2964	20.3018	20.2779	20.2861	367192.0
2013-12-26 09:30:00	AAPL	Stock	20.2893	20.3393	20.1206	20.1396	41257636.0
2013-12-26 10:00:00	AAPL	Stock	20.1396	20.2121	20.1361	20.1725	14646268.0
2013-12-26 10:30:00	AAPL	Stock	20.1686	20.2051	20.1557	20.1918	12480580.0
2013-12-26 11:00:00	AAPL	Stock	20.1946	20.2804	20.1829	20.2582	13391896.0
2013-12-26 11:30:00	AAPL	Stock	20.26	20.2714	20.2043	20.23	7733320.0
2013-12-26 12:00:00	AAPL	Stock	20.2316	20.2368	20.2032	20.2225	4972968.0
2013-12-26 12:30:00	AAPL	Stock	20.2207	20.2218	20.1875	20.2096	5703124.0
2013-12-26 13:00:00	AAPL	Stock	20.2114	20.2139	20.1825	20.1858	4765936.0
2013-12-26 13:30:00	AAPL	Stock	20.19	20.2075	20.1821	20.1975	3763088.0
2013-12-26 14:00:00	AAPL	Stock	20.1964	20.2014	20.1657	20.1761	6917764.0
2013-12-26 14:30:00	AAPL	Stock	20.175	20.1957	20.1639	20.1857	6227004.0
2013-12-26 15:00:00	AAPL	Stock	20.186	20.1875	20.1532	20.1629	8261008.0
2013-12-26 15:30:00	AAPL	Stock	20.1643	20.1786	20.1268	20.1368	17374448.0
2013-12-26 16:00:00	AAPL	Stock	20.1393	20.191	20.1339	20.1429	13196904.0
2013-12-26 16:30:00	AAPL	Stock	20.1382	20.1464	20.1357	20.1357	104580.0
2013-12-26 17:00:00	AAPL	Stock	20.1364	20.1393	20.1339	20.1393	62160.0
2013-12-26 17:30:00	AAPL	Stock	20.1357	20.1357	20.1271	20.1271	100800.0
2013-12-26 18:00:00	AAPL	Stock	20.1261	20.13	20.1189	20.1218	45976.0
2013-12-26 18:30:00	AAPL	Stock	20.1225	20.125	20.1225	20.125	12516.0
2013-12-26 19:00:00	AAPL	Stock	20.1254	20.1254	20.1232	20.1232	11732.0
2013-12-26 19:30:00	AAPL	Stock	20.1225	20.1339	20.1214	20.1261	99848.0
2013-12-26 07:30:00	MSFT	Stock	37.12	37.12	37.12	37.12	100.0
2013-12-26 08:00:00	MSFT	Stock	37.17	37.26	37.17	37.26	1600.0
2013-12-26 08:30:00	MSFT	Stock	37.25	37.25	37.08	37.23	553900.0
2013-12-26 09:00:00	MSFT	Stock	37.23	37.28	37.2	37.2	1600.0
2013-12-26 09:30:00	MSFT	Stock	37.2	37.49	37.17	37.39	2239571.0
2013-12-26 10:00:00	MSFT	Stock	37.39	37.41	37.33	37.4	1128583.0
2013-12-26 10:30:00	MSFT	Stock	37.4	37.42	37.36	37.395	1034864.0
2013-12-26 11:00:00	MSFT	Stock	37.39	37.425	37.35	37.42	1412207.0
2013-12-26 11:30:00	MSFT	Stock	37.41	37.43	37.372	37.405	959449.0
2013-12-26 12:00:00	MSFT	Stock	37.4	37.43	37.39	37.425	710245.0
2013-12-26 12:30:00	MSFT	Stock	37.425	37.46	37.41	37.44	772360.0
2013-12-26 13:00:00	MSFT	Stock	37.44	37.467	37.413	37.434	656262.0
2013-12-26 13:30:00	MSFT	Stock	37.43	37.45	37.4	37.45	715041.0
2013-12-26 14:00:00	MSFT	Stock	37.45	37.47	37.44	37.455	676251.0
2013-12-26 14:30:00	MSFT	Stock	37.45	37.46	37.4	37.415	690715.0
2013-12-26 15:00:00	MSFT	Stock	37.415	37.44	37.4	37.44	843844.0
2013-12-26 15:30:00	MSFT	Stock	37.44	37.46	37.41	37.43	2039929.0
2013-12-26 16:00:00	MSFT	Stock	37.44	37.47	37.139	37.44	2743746.0
2013-12-26 16:30:00	MSFT	Stock	37.44	37.48	37.44	37.48	1216.0
2013-12-26 17:00:00	MSFT	Stock	37.49	37.49	37.44	37.44	620.0
2013-12-26 18:00:00	MSFT	Stock	37.48	37.49	37.48	37.49	500.0
2013-12-26 18:30:00	MSFT	Stock	37.47	37.47	37.47	37.47	500.0

> showing 50 of 81,005 rows — these rows as CSV

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