PREVIEW / stock_30min / 2012-11-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-27.parquet
  size:    1.4 MB
  rows:    76,700
  symbols: 3,492

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
2012-11-27 04:00:00	AAPL	Stock	21.1425	21.2143	21.1425	21.2	344904.0
2012-11-27 04:30:00	AAPL	Stock	21.1964	21.21	21.1964	21.2032	78680.0
2012-11-27 05:00:00	AAPL	Stock	21.2036	21.2036	21.1786	21.1786	100800.0
2012-11-27 05:30:00	AAPL	Stock	21.1786	21.1786	21.1482	21.1786	211036.0
2012-11-27 06:00:00	AAPL	Stock	21.1786	21.1786	21.1261	21.1375	336056.0
2012-11-27 06:30:00	AAPL	Stock	21.1375	21.1607	21.1179	21.1607	90692.0
2012-11-27 07:00:00	AAPL	Stock	21.16	21.1786	21.1357	21.1579	541744.0
2012-11-27 07:30:00	AAPL	Stock	21.1579	21.1786	21.1471	21.1561	495488.0
2012-11-27 08:00:00	AAPL	Stock	21.1536	21.1775	21.0761	21.0889	2932692.0
2012-11-27 08:30:00	AAPL	Stock	21.0893	21.1143	21.0129	21.0643	2868152.0
2012-11-27 09:00:00	AAPL	Stock	21.0414	21.0571	20.9682	21.0482	3197992.0
2012-11-27 09:30:00	AAPL	Stock	21.0482	21.0596	20.8107	20.9425	83297760.0
2012-11-27 10:00:00	AAPL	Stock	20.9454	20.9461	20.7179	20.7839	64069124.0
2012-11-27 10:30:00	AAPL	Stock	20.7839	20.8839	20.7504	20.8171	42085120.0
2012-11-27 11:00:00	AAPL	Stock	20.8193	20.9096	20.8171	20.8668	22811488.0
2012-11-27 11:30:00	AAPL	Stock	20.8611	20.9768	20.8354	20.945	29647968.0
2012-11-27 12:00:00	AAPL	Stock	20.9496	20.9946	20.91	20.9421	20313860.0
2012-11-27 12:30:00	AAPL	Stock	20.9454	21.0864	20.8804	21.0393	44678900.0
2012-11-27 13:00:00	AAPL	Stock	21.0386	21.0386	20.9218	20.9489	23870952.0
2012-11-27 13:30:00	AAPL	Stock	20.9488	20.9943	20.9211	20.9843	14932820.0
2012-11-27 14:00:00	AAPL	Stock	20.9816	21.035	20.8482	20.8843	33035072.0
2012-11-27 14:30:00	AAPL	Stock	20.8839	20.9179	20.8268	20.8843	29932420.0
2012-11-27 15:00:00	AAPL	Stock	20.8786	20.9514	20.8604	20.9088	24074176.0
2012-11-27 15:30:00	AAPL	Stock	20.9064	20.9232	20.8321	20.8825	44358216.0
2012-11-27 16:00:00	AAPL	Stock	20.8889	21.0136	20.798	20.8571	7300972.0
2012-11-27 16:30:00	AAPL	Stock	20.885	20.9051	20.8508	20.8707	223384.0
2012-11-27 17:00:00	AAPL	Stock	20.8721	20.8929	20.8721	20.8896	477792.0
2012-11-27 17:30:00	AAPL	Stock	20.8839	20.8889	20.8625	20.8675	281680.0
2012-11-27 18:00:00	AAPL	Stock	20.8661	20.8839	20.8643	20.8721	182812.0
2012-11-27 18:30:00	AAPL	Stock	20.8721	20.8786	20.8668	20.8732	83860.0
2012-11-27 19:00:00	AAPL	Stock	20.8654	20.875	20.8543	20.8675	203252.0
2012-11-27 19:30:00	AAPL	Stock	20.8611	20.8611	20.8396	20.8446	163884.0
2012-11-27 05:00:00	MSFT	Stock	27.42	27.42	27.42	27.42	1000.0
2012-11-27 07:00:00	MSFT	Stock	27.46	27.47	27.46	27.47	10167.0
2012-11-27 07:30:00	MSFT	Stock	27.41	27.41	27.41	27.41	138.0
2012-11-27 08:00:00	MSFT	Stock	27.47	27.49	27.45	27.45	9025.0
2012-11-27 08:30:00	MSFT	Stock	27.43	27.47	27.43	27.43	15739.0
2012-11-27 09:00:00	MSFT	Stock	27.43	27.47	27.32	27.35	63086.0
2012-11-27 09:30:00	MSFT	Stock	27.36	27.38	27.23	27.285	4498997.0
2012-11-27 10:00:00	MSFT	Stock	27.285	27.3	27.11	27.135	3912242.0
2012-11-27 10:30:00	MSFT	Stock	27.135	27.18	27.08	27.12	2454667.0
2012-11-27 11:00:00	MSFT	Stock	27.125	27.21	27.115	27.163	3164083.0
2012-11-27 11:30:00	MSFT	Stock	27.17	27.3	27.17	27.27	2471177.0
2012-11-27 12:00:00	MSFT	Stock	27.27	27.3	27.2	27.21	1363328.0
2012-11-27 12:30:00	MSFT	Stock	27.21	27.26	27.165	27.228	2621113.0
2012-11-27 13:00:00	MSFT	Stock	27.22	27.225	27.14	27.185	3125689.0
2012-11-27 13:30:00	MSFT	Stock	27.18	27.22	27.15	27.165	1771374.0
2012-11-27 14:00:00	MSFT	Stock	27.16	27.19	27.12	27.17	3131512.0
2012-11-27 14:30:00	MSFT	Stock	27.16	27.17	27.1	27.15	3191719.0
2012-11-27 15:00:00	MSFT	Stock	27.15	27.27	27.12	27.18	4239917.0

> showing 50 of 76,700 rows — these rows as CSV

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