PREVIEW / etf_1hour / 2012-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-02.parquet
  size:    187 KB
  rows:    5,736

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-02 04:00:00	SPY	ETF	142.82	142.86	142.69	142.69	28440.0
2012-11-02 05:00:00	SPY	ETF	142.74	142.76	142.68	142.76	1200.0
2012-11-02 06:00:00	SPY	ETF	142.93	142.98	142.93	142.96	1200.0
2012-11-02 07:00:00	SPY	ETF	142.98	143.01	142.92	142.94	97980.0
2012-11-02 08:00:00	SPY	ETF	142.94	143.76	142.8	143.63	5132092.0
2012-11-02 09:00:00	SPY	ETF	143.62	143.74	143.0	143.21	13534257.0
2012-11-02 10:00:00	SPY	ETF	143.2	143.25	142.53	142.63	19416419.0
2012-11-02 11:00:00	SPY	ETF	142.625	142.84	142.47	142.72	12742913.0
2012-11-02 12:00:00	SPY	ETF	142.72	142.86	142.58	142.68	8479774.0
2012-11-02 13:00:00	SPY	ETF	142.68	142.75	142.33	142.3532	10204751.0
2012-11-02 14:00:00	SPY	ETF	142.35	142.36	141.74	141.97	17481289.0
2012-11-02 15:00:00	SPY	ETF	141.97	142.06	141.41	141.54	32683530.0
2012-11-02 16:00:00	SPY	ETF	141.54	142.5553	141.11	141.34	17053463.0
2012-11-02 17:00:00	SPY	ETF	141.33	141.38	141.32	141.32	315986.0
2012-11-02 18:00:00	SPY	ETF	141.33	141.37	141.32	141.37	18999.0
2012-11-02 19:00:00	SPY	ETF	141.34	141.35	141.29	141.3	31207.0
2012-11-02 06:00:00	QQQ	ETF	66.0	66.0	66.0	66.0	100.0
2012-11-02 07:00:00	QQQ	ETF	66.01	66.04	65.99	66.0	137112.0
2012-11-02 08:00:00	QQQ	ETF	66.01	66.23	65.92	66.19	2766792.0
2012-11-02 09:00:00	QQQ	ETF	66.19	66.23	65.85	66.03	4878645.0
2012-11-02 10:00:00	QQQ	ETF	66.03	66.04	65.8	65.88	4817227.0
2012-11-02 11:00:00	QQQ	ETF	65.88	65.92	65.7417	65.84	2790411.0
2012-11-02 12:00:00	QQQ	ETF	65.83	65.93	65.7801	65.84	1931582.0
2012-11-02 13:00:00	QQQ	ETF	65.85	65.88	65.65	65.67	2601224.0
2012-11-02 14:00:00	QQQ	ETF	65.67	65.67	65.311	65.45	4803404.0
2012-11-02 15:00:00	QQQ	ETF	65.45	65.52	65.11	65.13	7176965.0
2012-11-02 16:00:00	QQQ	ETF	65.12	65.9098	64.97	65.06	6743921.0
2012-11-02 17:00:00	QQQ	ETF	65.04	65.11	65.03	65.08	10822.0
2012-11-02 18:00:00	QQQ	ETF	65.09	65.11	65.04	65.09	6077.0
2012-11-02 19:00:00	QQQ	ETF	65.03	65.09	65.01	65.02	9700.0
2012-11-02 07:00:00	IWM	ETF	82.52	82.52	82.49	82.49	5800.0
2012-11-02 08:00:00	IWM	ETF	82.47	82.98	82.38	82.87	787897.0
2012-11-02 09:00:00	IWM	ETF	82.9	82.95	82.25	82.36	4646906.0
2012-11-02 10:00:00	IWM	ETF	82.37	82.39	81.78	81.8999	5059157.0
2012-11-02 11:00:00	IWM	ETF	81.89	82.06	81.79	81.93	2867856.0
2012-11-02 12:00:00	IWM	ETF	81.93	82.0355	81.86	81.91	1853735.0
2012-11-02 13:00:00	IWM	ETF	81.92	81.98	81.63	81.649	2478206.0
2012-11-02 14:00:00	IWM	ETF	81.65	81.7	81.35	81.435	5004605.0
2012-11-02 15:00:00	IWM	ETF	81.44	81.53	81.17	81.24	9099992.0
2012-11-02 16:00:00	IWM	ETF	81.24	82.5792	80.96	81.04	2056677.0
2012-11-02 17:00:00	IWM	ETF	81.04	81.06	81.03	81.06	12363.0
2012-11-02 18:00:00	IWM	ETF	81.06	81.06	81.04	81.04	750.0
2012-11-02 19:00:00	IWM	ETF	81.06	81.06	81.05	81.05	1300.0
2012-11-02 08:00:00	DIA	ETF	131.92	132.53	131.88	132.49	8000.0
2012-11-02 09:00:00	DIA	ETF	132.5	132.61	131.91	132.0836	356931.0
2012-11-02 10:00:00	DIA	ETF	132.09	132.1	131.4	131.57	591031.0
2012-11-02 11:00:00	DIA	ETF	131.5	131.79	131.41	131.67	382070.0
2012-11-02 12:00:00	DIA	ETF	131.66	131.8	131.56	131.64	173996.0
2012-11-02 13:00:00	DIA	ETF	131.65	131.68	131.28	131.33	365833.0
2012-11-02 14:00:00	DIA	ETF	131.32	131.32	130.79	130.97	1152553.0

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

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