PREVIEW / etf_30min / 2013-02-12

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-12.parquet
  size:    303 KB
  rows:    10,284

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-12 04:00:00	SPY	ETF	151.49	151.54	151.41	151.54	7900.0
2013-02-12 04:30:00	SPY	ETF	151.55	151.57	151.41	151.41	1700.0
2013-02-12 05:00:00	SPY	ETF	151.45	151.59	151.45	151.56	17210.0
2013-02-12 05:30:00	SPY	ETF	151.54	151.72	151.54	151.65	50925.0
2013-02-12 06:00:00	SPY	ETF	151.64	151.74	151.64	151.71	15550.0
2013-02-12 06:30:00	SPY	ETF	151.73	151.74	151.67	151.68	8001.0
2013-02-12 07:00:00	SPY	ETF	151.68	151.72	151.57	151.58	16137.0
2013-02-12 07:30:00	SPY	ETF	151.58	151.72	151.56	151.67	35465.0
2013-02-12 08:00:00	SPY	ETF	151.64	151.87	151.36	151.8	411483.0
2013-02-12 08:30:00	SPY	ETF	151.81	151.99	151.75	151.82	586654.0
2013-02-12 09:00:00	SPY	ETF	151.81	151.85	151.74	151.79	334545.0
2013-02-12 09:30:00	SPY	ETF	151.78	151.9	151.61	151.762	9935005.0
2013-02-12 10:00:00	SPY	ETF	151.76	152.03	151.75	151.95	6426904.0
2013-02-12 10:30:00	SPY	ETF	151.94	151.96	151.75	151.902	4385344.0
2013-02-12 11:00:00	SPY	ETF	151.91	151.98	151.8	151.87	3534185.0
2013-02-12 11:30:00	SPY	ETF	151.88	152.0	151.84	151.91	3106200.0
2013-02-12 12:00:00	SPY	ETF	151.915	152.07	151.89	151.97	2900370.0
2013-02-12 12:30:00	SPY	ETF	151.96	152.18	151.94	152.15	3251183.0
2013-02-12 13:00:00	SPY	ETF	152.15	152.3	152.15	152.28	3577675.0
2013-02-12 13:30:00	SPY	ETF	152.28	152.29	152.13	152.14	1928197.0
2013-02-12 14:00:00	SPY	ETF	152.14	152.16	152.05	152.071	2513034.0
2013-02-12 14:30:00	SPY	ETF	152.071	152.15	152.07	152.07	2773077.0
2013-02-12 15:00:00	SPY	ETF	152.08	152.1	152.0	152.05	3538384.0
2013-02-12 15:30:00	SPY	ETF	152.05	152.09	151.91	152.01	8590149.0
2013-02-12 16:00:00	SPY	ETF	152.0	152.13	152.0	152.04	4151303.0
2013-02-12 16:30:00	SPY	ETF	152.05	152.12	152.0033	152.1	980358.0
2013-02-12 17:00:00	SPY	ETF	152.11	152.2	152.11	152.14	1109213.0
2013-02-12 17:30:00	SPY	ETF	152.15	152.18	152.14	152.16	25937.0
2013-02-12 18:00:00	SPY	ETF	152.16	152.19	152.15	152.17	4854.0
2013-02-12 18:30:00	SPY	ETF	152.17	152.18	152.16	152.17	22487.0
2013-02-12 19:00:00	SPY	ETF	152.18	152.18	152.13	152.14	16735.0
2013-02-12 19:30:00	SPY	ETF	152.13	152.2	152.13	152.19	37499.0
2013-02-12 04:30:00	QQQ	ETF	67.86	67.86	67.86	67.86	100.0
2013-02-12 05:00:00	QQQ	ETF	67.89	67.9	67.89	67.9	350.0
2013-02-12 06:30:00	QQQ	ETF	67.92	67.92	67.92	67.92	300.0
2013-02-12 07:00:00	QQQ	ETF	67.85	67.85	67.85	67.85	300.0
2013-02-12 07:30:00	QQQ	ETF	67.85	67.88	67.85	67.86	36645.0
2013-02-12 08:00:00	QQQ	ETF	67.87	67.9	67.83	67.9	153395.0
2013-02-12 08:30:00	QQQ	ETF	67.92	67.99	67.92	67.92	39187.0
2013-02-12 09:00:00	QQQ	ETF	67.93	67.97	67.91	67.93	87608.0
2013-02-12 09:30:00	QQQ	ETF	67.92	67.97	67.82	67.84	3063815.0
2013-02-12 10:00:00	QQQ	ETF	67.85	68.05	67.8401	67.97	2212345.0
2013-02-12 10:30:00	QQQ	ETF	67.97	67.97	67.75	67.91	2081984.0
2013-02-12 11:00:00	QQQ	ETF	67.92	67.94	67.73	67.79	1365812.0
2013-02-12 11:30:00	QQQ	ETF	67.79	67.87	67.66	67.77	1654287.0
2013-02-12 12:00:00	QQQ	ETF	67.765	67.85	67.715	67.805	998704.0
2013-02-12 12:30:00	QQQ	ETF	67.81	67.96	67.79	67.92	940414.0
2013-02-12 13:00:00	QQQ	ETF	67.93	67.98	67.909	67.97	1519790.0
2013-02-12 13:30:00	QQQ	ETF	67.97	67.98	67.82	67.83	395268.0
2013-02-12 14:00:00	QQQ	ETF	67.83	67.87	67.8	67.845	784028.0

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

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