PREVIEW / etf_30min / 2013-02-28

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-28.parquet
  size:    313 KB
  rows:    10,519

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-02-28 04:00:00	SPY	ETF	152.15	152.19	152.01	152.01	2700.0
2013-02-28 04:30:00	SPY	ETF	152.11	152.18	152.11	152.18	346841.0
2013-02-28 05:00:00	SPY	ETF	152.19	152.23	152.07	152.08	66366.0
2013-02-28 05:30:00	SPY	ETF	152.13	152.13	152.05	152.08	5154.0
2013-02-28 06:00:00	SPY	ETF	152.13	152.26	152.13	152.26	28880.0
2013-02-28 06:30:00	SPY	ETF	152.25	152.33	152.25	152.28	32900.0
2013-02-28 07:00:00	SPY	ETF	152.27	152.32	152.22	152.26	29770.0
2013-02-28 07:30:00	SPY	ETF	152.23	152.25	152.09	152.17	809070.0
2013-02-28 08:00:00	SPY	ETF	152.15	152.35	152.04	152.13	839124.0
2013-02-28 08:30:00	SPY	ETF	152.11	152.17	151.94	152.1	400895.0
2013-02-28 09:00:00	SPY	ETF	152.08	152.08	151.8	151.9	740341.0
2013-02-28 09:30:00	SPY	ETF	151.9	152.48	151.75	152.24	15643323.0
2013-02-28 10:00:00	SPY	ETF	152.245	152.31	151.9	152.15	8471717.0
2013-02-28 10:30:00	SPY	ETF	152.14	152.16	151.79	151.938	7651548.0
2013-02-28 11:00:00	SPY	ETF	151.94	152.3	151.84	152.3	5884297.0
2013-02-28 11:30:00	SPY	ETF	152.29	152.3	152.04	152.1501	4289488.0
2013-02-28 12:00:00	SPY	ETF	152.151	152.27	152.09	152.18	3966661.0
2013-02-28 12:30:00	SPY	ETF	152.19	152.39	152.15	152.29	2678173.0
2013-02-28 13:00:00	SPY	ETF	152.29	152.73	152.28	152.67	7334662.0
2013-02-28 13:30:00	SPY	ETF	152.66	152.77	152.55	152.7	6039606.0
2013-02-28 14:00:00	SPY	ETF	152.69	152.83	152.65	152.785	5022966.0
2013-02-28 14:30:00	SPY	ETF	152.785	152.87	152.46	152.5	7373809.0
2013-02-28 15:00:00	SPY	ETF	152.5	152.51	152.24	152.408	9818235.0
2013-02-28 15:30:00	SPY	ETF	152.4	152.45	151.59	151.61	20494880.0
2013-02-28 16:00:00	SPY	ETF	151.6	151.9288	151.38	151.71	8482750.0
2013-02-28 16:30:00	SPY	ETF	151.69	151.7364	151.35	151.36	2823780.0
2013-02-28 17:00:00	SPY	ETF	151.37	151.68	151.34	151.58	316411.0
2013-02-28 17:30:00	SPY	ETF	151.58	151.65	151.58	151.64	2692326.0
2013-02-28 18:00:00	SPY	ETF	151.67	151.68	151.39	151.45	93696.0
2013-02-28 18:30:00	SPY	ETF	151.45	151.47	151.2	151.35	71956.0
2013-02-28 19:00:00	SPY	ETF	151.39	151.55	151.37	151.53	35760.0
2013-02-28 19:30:00	SPY	ETF	151.51	151.54	151.32	151.35	45750.0
2013-02-28 04:00:00	QQQ	ETF	67.3	67.32	67.3	67.32	200.0
2013-02-28 06:00:00	QQQ	ETF	67.37	67.37	67.37	67.37	200.0
2013-02-28 06:30:00	QQQ	ETF	67.37	67.37	67.37	67.37	100.0
2013-02-28 07:00:00	QQQ	ETF	67.39	67.39	67.35	67.35	1300.0
2013-02-28 07:30:00	QQQ	ETF	67.37	67.37	67.28	67.29	682900.0
2013-02-28 08:00:00	QQQ	ETF	67.28	67.36	67.25	67.29	818485.0
2013-02-28 08:30:00	QQQ	ETF	67.28	67.36	67.24	67.34	90083.0
2013-02-28 09:00:00	QQQ	ETF	67.35	67.35	67.22	67.24	288070.0
2013-02-28 09:30:00	QQQ	ETF	67.24	67.63	67.22	67.53	5201627.0
2013-02-28 10:00:00	QQQ	ETF	67.53	67.69	67.41	67.55	2246706.0
2013-02-28 10:30:00	QQQ	ETF	67.55	67.55	67.32	67.39	1608952.0
2013-02-28 11:00:00	QQQ	ETF	67.39	67.55	67.34	67.515	1549774.0
2013-02-28 11:30:00	QQQ	ETF	67.52	67.53	67.3952	67.46	560132.0
2013-02-28 12:00:00	QQQ	ETF	67.46	67.52	67.43	67.49	801286.0
2013-02-28 12:30:00	QQQ	ETF	67.49	67.56	67.478	67.5	611400.0
2013-02-28 13:00:00	QQQ	ETF	67.5	67.668	67.4799	67.64	1298964.0
2013-02-28 13:30:00	QQQ	ETF	67.64	67.69	67.59	67.65	890971.0
2013-02-28 14:00:00	QQQ	ETF	67.65	67.71	67.63	67.7	913791.0

> showing 50 of 10,519 rows — these rows as CSV

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