PREVIEW / etf_1hour / 2012-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-25.parquet
  size:    183 KB
  rows:    5,699

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-04-25 04:00:00	SPY	ETF	138.3	138.7	138.3	138.6	21756.0
2012-04-25 05:00:00	SPY	ETF	138.54	138.54	138.31	138.4	7300.0
2012-04-25 06:00:00	SPY	ETF	138.42	138.47	138.42	138.45	12190.0
2012-04-25 07:00:00	SPY	ETF	138.45	138.57	138.37	138.37	482845.0
2012-04-25 08:00:00	SPY	ETF	138.45	138.57	138.05	138.36	1527538.0
2012-04-25 09:00:00	SPY	ETF	138.35	139.19	138.32	139.05	21497485.0
2012-04-25 10:00:00	SPY	ETF	139.05	139.09	138.7	138.7399	22384066.0
2012-04-25 11:00:00	SPY	ETF	138.73	138.82	138.57	138.68	13477353.0
2012-04-25 12:00:00	SPY	ETF	138.6707	138.91	138.53	138.91	13612645.0
2012-04-25 13:00:00	SPY	ETF	138.9	139.08	138.85	138.92	12536010.0
2012-04-25 14:00:00	SPY	ETF	138.91	139.22	138.61	139.1123	25505752.0
2012-04-25 15:00:00	SPY	ETF	139.11	139.25	138.94	139.19	26527290.0
2012-04-25 16:00:00	SPY	ETF	139.2	139.29	137.29	139.28	11381866.0
2012-04-25 17:00:00	SPY	ETF	139.28	139.3	139.2	139.28	232463.0
2012-04-25 18:00:00	SPY	ETF	139.25	139.28	139.24	139.24	80966.0
2012-04-25 19:00:00	SPY	ETF	139.26	139.3	139.19	139.21	30662.0
2012-04-25 04:00:00	QQQ	ETF	65.73	65.91	65.73	65.91	9382.0
2012-04-25 05:00:00	QQQ	ETF	65.87	65.91	65.84	65.91	1700.0
2012-04-25 06:00:00	QQQ	ETF	65.86	65.92	65.86	65.92	2513.0
2012-04-25 07:00:00	QQQ	ETF	65.93	65.97	65.91	65.96	98540.0
2012-04-25 08:00:00	QQQ	ETF	65.95	66.03	65.72	65.9	1105513.0
2012-04-25 09:00:00	QQQ	ETF	65.9	66.49	65.89	66.455	12571103.0
2012-04-25 10:00:00	QQQ	ETF	66.45	66.46	66.16	66.21	10245893.0
2012-04-25 11:00:00	QQQ	ETF	66.21	66.29	66.14	66.1699	5550141.0
2012-04-25 12:00:00	QQQ	ETF	66.17	66.3	66.11	66.27	3827396.0
2012-04-25 13:00:00	QQQ	ETF	66.2678	66.38	66.23	66.31	3616937.0
2012-04-25 14:00:00	QQQ	ETF	66.3	66.44	66.18	66.385	6042548.0
2012-04-25 15:00:00	QQQ	ETF	66.38	66.47	66.34	66.46	8638902.0
2012-04-25 16:00:00	QQQ	ETF	66.46	66.4862	64.7085	66.48	4508808.0
2012-04-25 17:00:00	QQQ	ETF	66.48	66.49	66.44	66.46	14642.0
2012-04-25 18:00:00	QQQ	ETF	66.46	66.47	66.42	66.42	10090.0
2012-04-25 19:00:00	QQQ	ETF	66.45	66.48	66.45	66.48	5620.0
2012-04-25 04:00:00	IWM	ETF	80.48	80.71	80.48	80.71	200.0
2012-04-25 06:00:00	IWM	ETF	80.69	80.8	80.69	80.8	16500.0
2012-04-25 07:00:00	IWM	ETF	80.76	80.77	80.59	80.6	73411.0
2012-04-25 08:00:00	IWM	ETF	80.64	80.69	80.41	80.56	407629.0
2012-04-25 09:00:00	IWM	ETF	80.55	81.37	80.53	81.25	9016029.0
2012-04-25 10:00:00	IWM	ETF	81.25	81.27	80.86	80.89	6489055.0
2012-04-25 11:00:00	IWM	ETF	80.89	80.9	80.525	80.6025	3898006.0
2012-04-25 12:00:00	IWM	ETF	80.6	80.97	80.59	80.94	4918656.0
2012-04-25 13:00:00	IWM	ETF	80.95	81.11	80.88	81.04	3162712.0
2012-04-25 14:00:00	IWM	ETF	81.03	81.17	80.76	81.02	5278517.0
2012-04-25 15:00:00	IWM	ETF	81.02	81.1	80.82	80.98	7451623.0
2012-04-25 16:00:00	IWM	ETF	81.0	81.07	80.92	81.01	1331870.0
2012-04-25 17:00:00	IWM	ETF	81.02	81.11	81.01	81.11	6300.0
2012-04-25 07:00:00	DIA	ETF	130.76	130.76	130.23	130.23	1500.0
2012-04-25 08:00:00	DIA	ETF	130.3	130.35	130.1	130.27	17160.0
2012-04-25 09:00:00	DIA	ETF	130.28	130.83	130.26	130.75	975808.0
2012-04-25 10:00:00	DIA	ETF	130.7407	130.76	130.46	130.56	1013480.0
2012-04-25 11:00:00	DIA	ETF	130.5701	130.61	130.41	130.45	523475.0

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

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