PREVIEW / etf_30min / 2012-07-02

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-02.parquet
  size:    284 KB
  rows:    9,572

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-07-02 04:00:00	SPY	ETF	136.01	136.36	136.01	136.36	5600.0
2012-07-02 04:30:00	SPY	ETF	136.66	136.71	136.6	136.63	2380.0
2012-07-02 05:00:00	SPY	ETF	136.65	136.66	136.51	136.51	2224.0
2012-07-02 05:30:00	SPY	ETF	136.48	136.48	136.31	136.33	19199.0
2012-07-02 06:00:00	SPY	ETF	136.3	136.37	136.26	136.27	31016.0
2012-07-02 06:30:00	SPY	ETF	136.3	136.4	136.26	136.38	35470.0
2012-07-02 07:00:00	SPY	ETF	136.36	136.63	136.36	136.48	330132.0
2012-07-02 07:30:00	SPY	ETF	136.55	136.55	136.35	136.48	216996.0
2012-07-02 08:00:00	SPY	ETF	136.48	136.68	136.1	136.25	1994877.0
2012-07-02 08:30:00	SPY	ETF	136.25	136.38	136.2	136.28	814719.0
2012-07-02 09:00:00	SPY	ETF	136.29	136.5	136.27	136.47	1055042.0
2012-07-02 09:30:00	SPY	ETF	136.48	136.65	136.31	136.36	14383172.0
2012-07-02 10:00:00	SPY	ETF	136.36	136.37	135.55	135.81	24454610.0
2012-07-02 10:30:00	SPY	ETF	135.8001	136.06	135.59	135.775	8529064.0
2012-07-02 11:00:00	SPY	ETF	135.78	135.85	135.52	135.66	8852548.0
2012-07-02 11:30:00	SPY	ETF	135.66	135.92	135.65	135.75	6123911.0
2012-07-02 12:00:00	SPY	ETF	135.75	135.92	135.7	135.86	4198894.0
2012-07-02 12:30:00	SPY	ETF	135.86	136.2	135.84	136.05	6382451.0
2012-07-02 13:00:00	SPY	ETF	136.05	136.12	135.97	136.12	3593140.0
2012-07-02 13:30:00	SPY	ETF	136.1187	136.17	135.98	136.0263	3458498.0
2012-07-02 14:00:00	SPY	ETF	136.025	136.4	135.89	136.245	6656460.0
2012-07-02 14:30:00	SPY	ETF	136.24	136.28	136.1	136.17	3183179.0
2012-07-02 15:00:00	SPY	ETF	136.17	136.21	135.99	136.15	5292664.0
2012-07-02 15:30:00	SPY	ETF	136.15	136.54	136.115	136.44	15677056.0
2012-07-02 16:00:00	SPY	ETF	136.45	136.54	136.0885	136.39	8181569.0
2012-07-02 16:30:00	SPY	ETF	136.38	136.38	136.24	136.27	340004.0
2012-07-02 17:00:00	SPY	ETF	136.26	136.45	136.24	136.45	72400.0
2012-07-02 17:30:00	SPY	ETF	136.42	136.43	136.4	136.42	67950.0
2012-07-02 18:00:00	SPY	ETF	136.43	136.52	136.42	136.52	280573.0
2012-07-02 18:30:00	SPY	ETF	136.51	136.59	136.42	136.42	27654.0
2012-07-02 19:00:00	SPY	ETF	136.42	136.45	136.32	136.33	60630.0
2012-07-02 19:30:00	SPY	ETF	136.35	136.35	136.29	136.31	106369.0
2012-07-02 05:00:00	QQQ	ETF	64.24	64.24	64.24	64.24	500.0
2012-07-02 06:00:00	QQQ	ETF	64.06	64.1	64.06	64.1	300.0
2012-07-02 07:00:00	QQQ	ETF	64.15	64.23	64.09	64.17	604822.0
2012-07-02 07:30:00	QQQ	ETF	64.17	64.25	64.14	64.18	172657.0
2012-07-02 08:00:00	QQQ	ETF	64.18	64.18	64.04	64.1	865290.0
2012-07-02 08:30:00	QQQ	ETF	64.07	64.17	64.06	64.11	448740.0
2012-07-02 09:00:00	QQQ	ETF	64.14	64.27	64.14	64.22	142125.0
2012-07-02 09:30:00	QQQ	ETF	64.23	64.38	64.04	64.229	4002734.0
2012-07-02 10:00:00	QQQ	ETF	64.22	64.3	63.87	64.16	5125218.0
2012-07-02 10:30:00	QQQ	ETF	64.15	64.22	63.96	64.09	3181459.0
2012-07-02 11:00:00	QQQ	ETF	64.08	64.13	63.94	63.99	1775582.0
2012-07-02 11:30:00	QQQ	ETF	63.9899	64.15	63.9899	64.04	1284921.0
2012-07-02 12:00:00	QQQ	ETF	64.04	64.12	63.98	64.07	977456.0
2012-07-02 12:30:00	QQQ	ETF	64.0741	64.26	64.065	64.19	2002388.0
2012-07-02 13:00:00	QQQ	ETF	64.19	64.2	64.12	64.19	1044478.0
2012-07-02 13:30:00	QQQ	ETF	64.19	64.22	64.12	64.1355	683703.0
2012-07-02 14:00:00	QQQ	ETF	64.1399	64.26	64.08	64.2209	1608184.0
2012-07-02 14:30:00	QQQ	ETF	64.23	64.24	64.17	64.2	797461.0

> showing 50 of 9,572 rows — these rows as CSV

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