PREVIEW / etf_1hour / 2012-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-22.parquet
  size:    188 KB
  rows:    5,887

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-03-22 04:00:00	SPY	ETF	140.2	140.2	139.4	139.4	10146.0
2012-03-22 05:00:00	SPY	ETF	139.45	139.45	139.2	139.35	11430.0
2012-03-22 06:00:00	SPY	ETF	139.35	139.45	139.26	139.45	73706.0
2012-03-22 07:00:00	SPY	ETF	139.4	139.49	139.27	139.27	343001.0
2012-03-22 08:00:00	SPY	ETF	139.3	140.16	139.26	139.49	1803531.0
2012-03-22 09:00:00	SPY	ETF	139.49	139.53	139.1	139.33	22624143.0
2012-03-22 10:00:00	SPY	ETF	139.33	139.55	138.89	138.95	25987092.0
2012-03-22 11:00:00	SPY	ETF	138.96	139.18	138.75	139.12	13476543.0
2012-03-22 12:00:00	SPY	ETF	139.125	139.38	139.12	139.38	10355955.0
2012-03-22 13:00:00	SPY	ETF	139.38	139.39	139.16	139.2308	11568742.0
2012-03-22 14:00:00	SPY	ETF	139.24	139.27	139.03	139.075	12272279.0
2012-03-22 15:00:00	SPY	ETF	139.08	139.36	138.74	139.17	31007112.0
2012-03-22 16:00:00	SPY	ETF	139.18	139.43	139.15	139.43	4905341.0
2012-03-22 17:00:00	SPY	ETF	139.42	139.49	139.42	139.45	200423.0
2012-03-22 18:00:00	SPY	ETF	139.46	139.47	139.39	139.39	110935.0
2012-03-22 19:00:00	SPY	ETF	139.39	139.46	139.34	139.44	70756.0
2012-03-22 04:00:00	QQQ	ETF	67.04	67.04	66.84	66.86	2615.0
2012-03-22 06:00:00	QQQ	ETF	66.77	66.88	66.76	66.84	36900.0
2012-03-22 07:00:00	QQQ	ETF	66.84	66.88	66.77	66.77	172998.0
2012-03-22 08:00:00	QQQ	ETF	66.79	66.92	66.77	66.88	492200.0
2012-03-22 09:00:00	QQQ	ETF	66.87	66.99	66.68	66.92	12793933.0
2012-03-22 10:00:00	QQQ	ETF	66.91	67.06	66.77	66.8	8554273.0
2012-03-22 11:00:00	QQQ	ETF	66.8	66.955	66.71	66.93	4326282.0
2012-03-22 12:00:00	QQQ	ETF	66.94	67.14	66.935	67.13	3890633.0
2012-03-22 13:00:00	QQQ	ETF	67.13	67.13	66.97	67.0299	5222742.0
2012-03-22 14:00:00	QQQ	ETF	67.03	67.0384	66.885	66.9	4679750.0
2012-03-22 15:00:00	QQQ	ETF	66.89	67.07	66.68	66.97	10373240.0
2012-03-22 16:00:00	QQQ	ETF	66.97	67.11	66.97	67.1	1513906.0
2012-03-22 17:00:00	QQQ	ETF	67.11	67.12	67.03	67.06	144191.0
2012-03-22 18:00:00	QQQ	ETF	67.06	67.11	67.03	67.07	168757.0
2012-03-22 19:00:00	QQQ	ETF	67.04	67.11	67.03	67.11	6819.0
2012-03-22 04:00:00	IWM	ETF	82.43	82.43	82.41	82.41	900.0
2012-03-22 05:00:00	IWM	ETF	82.12	82.12	82.06	82.12	6200.0
2012-03-22 06:00:00	IWM	ETF	82.1	82.12	82.08	82.08	2033.0
2012-03-22 07:00:00	IWM	ETF	82.1	82.2	82.04	82.04	88674.0
2012-03-22 08:00:00	IWM	ETF	82.06	82.32	82.06	82.27	376398.0
2012-03-22 09:00:00	IWM	ETF	82.26	82.46	81.95	82.27	10118509.0
2012-03-22 10:00:00	IWM	ETF	82.27	82.4399	81.7	81.77	8542400.0
2012-03-22 11:00:00	IWM	ETF	81.77	82.0	81.62	81.95	5782035.0
2012-03-22 12:00:00	IWM	ETF	81.95	82.18	81.94	82.17	3264933.0
2012-03-22 13:00:00	IWM	ETF	82.17	82.18	81.91	82.0514	3452777.0
2012-03-22 14:00:00	IWM	ETF	82.06	82.11	81.92	81.995	3442958.0
2012-03-22 15:00:00	IWM	ETF	82.0	82.22	81.67	82.15	11031867.0
2012-03-22 16:00:00	IWM	ETF	82.16	83.0108	82.1206	82.28	6911135.0
2012-03-22 17:00:00	IWM	ETF	82.3	82.34	82.25	82.26	4254.0
2012-03-22 19:00:00	IWM	ETF	82.2	82.2	82.2	82.2	950.0
2012-03-22 04:00:00	DIA	ETF	130.81	130.81	130.45	130.45	43498.0
2012-03-22 05:00:00	DIA	ETF	130.43	130.43	130.26	130.26	57960.0
2012-03-22 07:00:00	DIA	ETF	130.4	130.42	130.33	130.35	2330.0
2012-03-22 08:00:00	DIA	ETF	130.36	130.55	130.33	130.5	29656.0

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

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