PREVIEW / stock_30min / 2012-08-23

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-23.parquet
  size:    1.4 MB
  rows:    73,987
  symbols: 3,444

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-08-23 04:00:00	AAPL	Stock	23.9286	24.0354	23.9286	24.0	62776.0
2012-08-23 04:30:00	AAPL	Stock	24.0	24.0	23.9911	23.9911	21000.0
2012-08-23 05:00:00	AAPL	Stock	23.9861	24.0068	23.9861	24.0	42280.0
2012-08-23 05:30:00	AAPL	Stock	24.0071	24.0071	24.0071	24.0071	22400.0
2012-08-23 06:00:00	AAPL	Stock	24.0154	24.0214	24.0079	24.0079	14000.0
2012-08-23 06:30:00	AAPL	Stock	24.0207	24.0214	23.9946	23.9946	40880.0
2012-08-23 07:00:00	AAPL	Stock	23.9857	24.0004	23.9643	23.9814	523460.0
2012-08-23 07:30:00	AAPL	Stock	23.9821	23.9946	23.8629	23.8714	460572.0
2012-08-23 08:00:00	AAPL	Stock	23.8714	23.9786	23.8661	23.9071	1736364.0
2012-08-23 08:30:00	AAPL	Stock	23.9107	23.9107	23.7768	23.8332	2157260.0
2012-08-23 09:00:00	AAPL	Stock	23.8293	23.8304	23.7679	23.7896	1627332.0
2012-08-23 09:30:00	AAPL	Stock	23.7896	23.925	23.704	23.7325	91827792.0
2012-08-23 10:00:00	AAPL	Stock	23.7321	23.8207	23.6125	23.7554	52849888.0
2012-08-23 10:30:00	AAPL	Stock	23.755	23.8803	23.75	23.835	36314572.0
2012-08-23 11:00:00	AAPL	Stock	23.835	23.9229	23.8111	23.9107	28366828.0
2012-08-23 11:30:00	AAPL	Stock	23.9136	23.9186	23.7557	23.8075	24337572.0
2012-08-23 12:00:00	AAPL	Stock	23.8046	23.8157	23.6804	23.7461	24982216.0
2012-08-23 12:30:00	AAPL	Stock	23.7461	23.8214	23.7232	23.7322	13035008.0
2012-08-23 13:00:00	AAPL	Stock	23.7364	23.7836	23.6614	23.7092	15355844.0
2012-08-23 13:30:00	AAPL	Stock	23.7039	23.7675	23.669	23.7532	12814536.0
2012-08-23 14:00:00	AAPL	Stock	23.7529	23.7657	23.7025	23.7393	14939428.0
2012-08-23 14:30:00	AAPL	Stock	23.7393	23.8175	23.7179	23.7836	16082920.0
2012-08-23 15:00:00	AAPL	Stock	23.785	23.8521	23.7143	23.7646	24060736.0
2012-08-23 15:30:00	AAPL	Stock	23.7711	23.7804	23.6521	23.6557	52572912.0
2012-08-23 16:00:00	AAPL	Stock	23.6557	23.8432	23.6557	23.6932	1214248.0
2012-08-23 16:30:00	AAPL	Stock	23.6946	23.8882	23.6557	23.7	717360.0
2012-08-23 17:00:00	AAPL	Stock	23.6946	23.7	23.6654	23.6957	220724.0
2012-08-23 17:30:00	AAPL	Stock	23.6943	23.6946	23.6882	23.6929	136024.0
2012-08-23 18:00:00	AAPL	Stock	23.6929	23.71	23.6929	23.7018	167440.0
2012-08-23 18:30:00	AAPL	Stock	23.7068	23.7107	23.6807	23.6921	127008.0
2012-08-23 19:00:00	AAPL	Stock	23.6907	23.6929	23.6857	23.6893	41832.0
2012-08-23 19:30:00	AAPL	Stock	23.69	23.7032	23.69	23.6989	194264.0
2012-08-23 07:30:00	MSFT	Stock	30.55	30.59	30.55	30.55	2100.0
2012-08-23 08:00:00	MSFT	Stock	30.42	30.45	30.28	30.33	28647.0
2012-08-23 08:30:00	MSFT	Stock	30.32	30.32	30.28	30.32	19616.0
2012-08-23 09:00:00	MSFT	Stock	30.32	30.41	30.3	30.39	9354.0
2012-08-23 09:30:00	MSFT	Stock	30.39	30.39	30.08	30.22	4594688.0
2012-08-23 10:00:00	MSFT	Stock	30.22	30.29	30.15	30.16	3083060.0
2012-08-23 10:30:00	MSFT	Stock	30.16	30.28	30.15	30.24	2473541.0
2012-08-23 11:00:00	MSFT	Stock	30.235	30.4	30.2	30.37	1948215.0
2012-08-23 11:30:00	MSFT	Stock	30.38	30.38	30.27	30.298	1291788.0
2012-08-23 12:00:00	MSFT	Stock	30.3	30.31	30.2	30.275	1714735.0
2012-08-23 12:30:00	MSFT	Stock	30.275	30.33	30.25	30.27	912395.0
2012-08-23 13:00:00	MSFT	Stock	30.265	30.28	30.18	30.2	1354776.0
2012-08-23 13:30:00	MSFT	Stock	30.205	30.27	30.2	30.255	905010.0
2012-08-23 14:00:00	MSFT	Stock	30.25	30.31	30.22	30.268	1305318.0
2012-08-23 14:30:00	MSFT	Stock	30.266	30.345	30.25	30.274	1138439.0
2012-08-23 15:00:00	MSFT	Stock	30.275	30.36	30.26	30.292	1678181.0
2012-08-23 15:30:00	MSFT	Stock	30.295	30.315	30.2	30.25	3878709.0
2012-08-23 16:00:00	MSFT	Stock	30.25	30.275	30.21	30.245	1477355.0

> showing 50 of 73,987 rows — these rows as CSV

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