PREVIEW / etf_1hour / 2012-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-07.parquet
  size:    198 KB
  rows:    6,176

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-11-07 04:00:00	SPY	ETF	143.36	143.48	143.28	143.48	49924.0
2012-11-07 05:00:00	SPY	ETF	143.45	143.63	143.43	143.45	16354.0
2012-11-07 06:00:00	SPY	ETF	143.35	143.4	143.04	143.08	201414.0
2012-11-07 07:00:00	SPY	ETF	143.04	143.04	142.05	142.21	2177207.0
2012-11-07 08:00:00	SPY	ETF	142.2	142.21	141.8	141.88	3068504.0
2012-11-07 09:00:00	SPY	ETF	141.87	141.96	140.82	141.09	27293623.0
2012-11-07 10:00:00	SPY	ETF	141.09	141.1	139.72	139.76	41006094.0
2012-11-07 11:00:00	SPY	ETF	139.76	140.14	139.06	139.87	44552917.0
2012-11-07 12:00:00	SPY	ETF	139.87	140.14	139.6228	139.98	31751505.0
2012-11-07 13:00:00	SPY	ETF	139.98	140.5	139.92	140.205	21972868.0
2012-11-07 14:00:00	SPY	ETF	140.24	140.53	139.93	140.31	20828285.0
2012-11-07 15:00:00	SPY	ETF	140.3	140.59	139.7	139.72	41982954.0
2012-11-07 16:00:00	SPY	ETF	139.73	143.1152	139.45	139.78	18019966.0
2012-11-07 17:00:00	SPY	ETF	139.77	139.93	139.63	139.91	3386104.0
2012-11-07 18:00:00	SPY	ETF	139.91	140.81	139.91	140.0	1803783.0
2012-11-07 19:00:00	SPY	ETF	139.97	140.04	139.84	140.04	74418.0
2012-11-07 04:00:00	QQQ	ETF	65.86	65.93	65.86	65.93	469.0
2012-11-07 05:00:00	QQQ	ETF	66.01	66.01	66.01	66.01	1100.0
2012-11-07 06:00:00	QQQ	ETF	65.8	65.8	65.76	65.76	300.0
2012-11-07 07:00:00	QQQ	ETF	65.76	65.76	65.25	65.26	66793.0
2012-11-07 08:00:00	QQQ	ETF	65.28	65.97	65.1	65.13	805576.0
2012-11-07 09:00:00	QQQ	ETF	65.12	65.16	64.8	64.97	7978849.0
2012-11-07 10:00:00	QQQ	ETF	64.97	64.98	64.17	64.18	8542166.0
2012-11-07 11:00:00	QQQ	ETF	64.1817	64.39	63.9	64.26	9512267.0
2012-11-07 12:00:00	QQQ	ETF	64.2801	64.37	64.11	64.1599	4447356.0
2012-11-07 13:00:00	QQQ	ETF	64.16	64.52	64.11	64.32	6762329.0
2012-11-07 14:00:00	QQQ	ETF	64.32	64.45	64.14	64.44	4101458.0
2012-11-07 15:00:00	QQQ	ETF	64.43	64.57	64.17	64.18	9216435.0
2012-11-07 16:00:00	QQQ	ETF	64.17	65.8312	64.17	64.27	10018325.0
2012-11-07 17:00:00	QQQ	ETF	64.28	65.8313	64.22	64.34	5374264.0
2012-11-07 18:00:00	QQQ	ETF	64.33	64.42	64.33	64.42	17660.0
2012-11-07 19:00:00	QQQ	ETF	64.33	64.4	64.32	64.39	17810.0
2012-11-07 04:00:00	IWM	ETF	82.5	82.5	82.5	82.5	538.0
2012-11-07 06:00:00	IWM	ETF	82.35	82.35	82.35	82.35	200.0
2012-11-07 07:00:00	IWM	ETF	82.24	82.24	81.53	81.57	133607.0
2012-11-07 08:00:00	IWM	ETF	81.57	82.17	81.35	81.46	935575.0
2012-11-07 09:00:00	IWM	ETF	81.46	81.46	81.03	81.15	7403092.0
2012-11-07 10:00:00	IWM	ETF	81.15	81.15	80.13	80.15	10196675.0
2012-11-07 11:00:00	IWM	ETF	80.15	80.46	79.91	80.26	7785927.0
2012-11-07 12:00:00	IWM	ETF	80.22	80.38	80.19	80.26	4285607.0
2012-11-07 13:00:00	IWM	ETF	80.26	80.67	80.25	80.34	4118064.0
2012-11-07 14:00:00	IWM	ETF	80.35	80.52	80.23	80.41	3828991.0
2012-11-07 15:00:00	IWM	ETF	80.41	80.52	80.2	80.36	8804827.0
2012-11-07 16:00:00	IWM	ETF	80.36	82.3959	79.92	80.15	7251842.0
2012-11-07 17:00:00	IWM	ETF	80.12	80.33	80.04	80.1	21162.0
2012-11-07 18:00:00	IWM	ETF	80.23	80.29	80.23	80.29	1050.0
2012-11-07 19:00:00	IWM	ETF	80.28	80.3	80.25	80.28	5700.0
2012-11-07 07:00:00	DIA	ETF	132.19	132.19	131.45	131.45	1275.0
2012-11-07 08:00:00	DIA	ETF	131.43	131.43	131.14	131.14	7473.0
2012-11-07 09:00:00	DIA	ETF	131.14	131.18	130.22	130.39	1334175.0

> showing 50 of 6,176 rows — these rows as CSV

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