PREVIEW / etf_30min / 2012-12-24

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-24.parquet
  size:    179 KB
  rows:    5,775

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-12-24 04:00:00	SPY	ETF	142.1	142.17	142.06	142.17	63301.0
2012-12-24 04:30:00	SPY	ETF	142.19	142.19	142.16	142.19	1553.0
2012-12-24 05:00:00	SPY	ETF	142.22	142.22	142.22	142.22	138.0
2012-12-24 05:30:00	SPY	ETF	142.24	142.27	142.24	142.27	251.0
2012-12-24 06:00:00	SPY	ETF	142.27	142.33	142.25	142.33	101012.0
2012-12-24 06:30:00	SPY	ETF	142.35	142.43	142.35	142.43	86029.0
2012-12-24 07:00:00	SPY	ETF	142.41	142.44	142.33	142.44	39276.0
2012-12-24 07:30:00	SPY	ETF	142.44	142.44	142.38	142.41	108291.0
2012-12-24 08:00:00	SPY	ETF	142.42	142.55	142.42	142.52	4760692.0
2012-12-24 08:30:00	SPY	ETF	142.52	142.6	142.49	142.6	190949.0
2012-12-24 09:00:00	SPY	ETF	142.6	142.72	142.46	142.48	604555.0
2012-12-24 09:30:00	SPY	ETF	142.48	142.555	142.24	142.26	8826783.0
2012-12-24 10:00:00	SPY	ETF	142.27	142.51	142.25	142.45	4621990.0
2012-12-24 10:30:00	SPY	ETF	142.46	142.56	142.29	142.3	4744585.0
2012-12-24 11:00:00	SPY	ETF	142.3	142.37	142.24	142.305	3515091.0
2012-12-24 11:30:00	SPY	ETF	142.31	142.4	142.29	142.3525	3338905.0
2012-12-24 12:00:00	SPY	ETF	142.35	142.39	142.19	142.27	3171194.0
2012-12-24 12:30:00	SPY	ETF	142.27	142.455	142.265	142.35	10534214.0
2012-12-24 13:00:00	SPY	ETF	142.35	142.46	142.17	142.18	3905757.0
2012-12-24 13:30:00	SPY	ETF	142.17	142.7529	142.12	142.16	771516.0
2012-12-24 14:00:00	SPY	ETF	142.18	142.18	142.07	142.11	116079.0
2012-12-24 14:30:00	SPY	ETF	142.11	142.14	142.1	142.14	14636.0
2012-12-24 15:00:00	SPY	ETF	142.14	142.1699	142.14	142.15	4388.0
2012-12-24 15:30:00	SPY	ETF	142.16	142.23	142.15	142.23	8072.0
2012-12-24 16:00:00	SPY	ETF	142.24	142.24	142.23	142.23	5548.0
2012-12-24 16:30:00	SPY	ETF	142.18	142.24	142.17	142.2	3590.0
2012-12-24 04:30:00	QQQ	ETF	64.91	64.91	64.91	64.91	19923.0
2012-12-24 06:00:00	QQQ	ETF	65.09	65.09	65.09	65.09	200.0
2012-12-24 06:30:00	QQQ	ETF	64.95	65.05	64.95	65.0	5600.0
2012-12-24 07:00:00	QQQ	ETF	64.98	65.01	64.95	65.0	13700.0
2012-12-24 07:30:00	QQQ	ETF	65.0	65.0	64.98	64.98	3300.0
2012-12-24 08:00:00	QQQ	ETF	65.01	65.08	64.99	65.07	25069.0
2012-12-24 08:30:00	QQQ	ETF	65.11	65.14	65.1	65.14	41600.0
2012-12-24 09:00:00	QQQ	ETF	65.13	65.19	65.05	65.05	446791.0
2012-12-24 09:30:00	QQQ	ETF	65.06	65.14	64.97	64.97	3268505.0
2012-12-24 10:00:00	QQQ	ETF	64.975	65.105	64.97	65.0699	1023362.0
2012-12-24 10:30:00	QQQ	ETF	65.06	65.13	64.92	64.94	620736.0
2012-12-24 11:00:00	QQQ	ETF	64.95	65.01	64.9359	65.0058	536420.0
2012-12-24 11:30:00	QQQ	ETF	65.01	65.05	64.98	65.02	730270.0
2012-12-24 12:00:00	QQQ	ETF	65.02	65.0585	64.96	65.0	679312.0
2012-12-24 12:30:00	QQQ	ETF	65.0	65.05	64.97	65.04	2097355.0
2012-12-24 13:00:00	QQQ	ETF	65.035	65.2044	64.98	65.0	1513134.0
2012-12-24 13:30:00	QQQ	ETF	64.98	65.04	64.98	65.04	3300.0
2012-12-24 14:00:00	QQQ	ETF	64.98	64.98	64.9	64.98	8350.0
2012-12-24 14:30:00	QQQ	ETF	64.98	64.98	64.98	64.98	2000.0
2012-12-24 04:00:00	IWM	ETF	83.83	83.83	83.83	83.83	757.0
2012-12-24 05:00:00	IWM	ETF	83.85	83.85	83.85	83.85	469.0
2012-12-24 05:30:00	IWM	ETF	83.9	83.9	83.9	83.9	500.0
2012-12-24 06:00:00	IWM	ETF	83.9	83.95	83.9	83.95	600.0
2012-12-24 06:30:00	IWM	ETF	84.04	84.04	84.04	84.04	1000.0

> showing 50 of 5,775 rows — these rows as CSV

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