PREVIEW / etf_30min / 2013-02-07

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-07.parquet
  size:    310 KB
  rows:    10,358

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-07 04:00:00	SPY	ETF	150.93	151.01	150.93	151.01	590.0
2013-02-07 04:30:00	SPY	ETF	150.98	151.06	150.98	151.06	3200.0
2013-02-07 05:00:00	SPY	ETF	151.22	151.28	151.22	151.28	32700.0
2013-02-07 05:30:00	SPY	ETF	151.29	151.38	151.29	151.36	11152.0
2013-02-07 06:00:00	SPY	ETF	151.37	151.47	151.37	151.45	23100.0
2013-02-07 06:30:00	SPY	ETF	151.44	151.45	151.26	151.27	45198.0
2013-02-07 07:00:00	SPY	ETF	151.27	151.38	151.24	151.37	74448.0
2013-02-07 07:30:00	SPY	ETF	151.37	151.37	151.12	151.17	110220.0
2013-02-07 08:00:00	SPY	ETF	151.18	151.3	151.11	151.2	732576.0
2013-02-07 08:30:00	SPY	ETF	151.18	151.4	150.99	151.23	1196170.0
2013-02-07 09:00:00	SPY	ETF	151.22	151.45	151.15	151.21	768871.0
2013-02-07 09:30:00	SPY	ETF	151.205	151.35	150.92	151.03	10870274.0
2013-02-07 10:00:00	SPY	ETF	151.03	151.09	150.19	150.33	15696600.0
2013-02-07 10:30:00	SPY	ETF	150.32	150.395	149.92	150.27	16692752.0
2013-02-07 11:00:00	SPY	ETF	150.28	150.37	150.12	150.21	8766636.0
2013-02-07 11:30:00	SPY	ETF	150.21	150.24	149.86	150.05	9932554.0
2013-02-07 12:00:00	SPY	ETF	150.05	151.2591	150.02	150.31	9405674.0
2013-02-07 12:30:00	SPY	ETF	150.32	151.2591	150.29	150.39	9874662.0
2013-02-07 13:00:00	SPY	ETF	150.4	150.58	150.29	150.57	4349617.0
2013-02-07 13:30:00	SPY	ETF	150.562	150.77	150.45	150.75	6450981.0
2013-02-07 14:00:00	SPY	ETF	150.75	150.89	150.62	150.7299	7676856.0
2013-02-07 14:30:00	SPY	ETF	150.725	150.84	150.48	150.8	6249523.0
2013-02-07 15:00:00	SPY	ETF	150.8	150.89	150.7	150.78	7879051.0
2013-02-07 15:30:00	SPY	ETF	150.78	150.99	150.62	150.94	21468878.0
2013-02-07 16:00:00	SPY	ETF	150.97	150.99	150.7	150.89	18543048.0
2013-02-07 16:30:00	SPY	ETF	150.9	151.06	150.9	150.99	1447504.0
2013-02-07 17:00:00	SPY	ETF	150.99	150.99	150.86	150.86	95546.0
2013-02-07 17:30:00	SPY	ETF	150.87	150.92	150.87	150.9	12650.0
2013-02-07 18:00:00	SPY	ETF	150.9	150.9	150.82	150.85	76304.0
2013-02-07 18:30:00	SPY	ETF	150.84	150.89	150.83	150.88	6300.0
2013-02-07 19:00:00	SPY	ETF	150.86	150.94	150.85	150.92	8250.0
2013-02-07 19:30:00	SPY	ETF	150.94	151.0	150.91	150.93	23110.0
2013-02-07 04:00:00	QQQ	ETF	67.16	67.2	67.12	67.2	15800.0
2013-02-07 04:30:00	QQQ	ETF	67.2	67.2	67.2	67.2	800.0
2013-02-07 07:00:00	QQQ	ETF	67.23	67.23	67.23	67.23	100.0
2013-02-07 07:30:00	QQQ	ETF	67.24	67.24	67.15	67.16	78300.0
2013-02-07 08:00:00	QQQ	ETF	67.17	67.26	67.14	67.26	464335.0
2013-02-07 08:30:00	QQQ	ETF	67.21	67.39	67.12	67.35	309043.0
2013-02-07 09:00:00	QQQ	ETF	67.36	67.42	67.32	67.32	260511.0
2013-02-07 09:30:00	QQQ	ETF	67.33	67.371	67.13	67.22	3059153.0
2013-02-07 10:00:00	QQQ	ETF	67.23	67.25	66.64	66.76	5653590.0
2013-02-07 10:30:00	QQQ	ETF	66.76	66.81	66.56	66.7	4318629.0
2013-02-07 11:00:00	QQQ	ETF	66.71	66.8301	66.67	66.76	2199099.0
2013-02-07 11:30:00	QQQ	ETF	66.752	66.78	66.63	66.7	1636604.0
2013-02-07 12:00:00	QQQ	ETF	66.7	66.9	66.69	66.898	1169895.0
2013-02-07 12:30:00	QQQ	ETF	66.9	67.01	66.8999	66.949	1382588.0
2013-02-07 13:00:00	QQQ	ETF	66.94	66.97	66.83	66.95	1056357.0
2013-02-07 13:30:00	QQQ	ETF	66.95	67.03	66.84	67.01	1372280.0
2013-02-07 14:00:00	QQQ	ETF	67.01	67.09	66.86	66.93	2165395.0
2013-02-07 14:30:00	QQQ	ETF	66.93	67.015	66.82	67.0	1170619.0

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

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