PREVIEW / etf_1hour / 2012-11-28

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-28.parquet
  size:    190 KB
  rows:    5,843

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-28 04:00:00	SPY	ETF	140.26	140.26	140.12	140.13	6437.0
2012-11-28 05:00:00	SPY	ETF	140.11	140.26	140.11	140.24	58600.0
2012-11-28 06:00:00	SPY	ETF	140.13	140.17	139.91	139.91	295750.0
2012-11-28 07:00:00	SPY	ETF	139.91	140.09	139.87	139.89	569698.0
2012-11-28 08:00:00	SPY	ETF	139.9	140.01	139.75	139.82	1384761.0
2012-11-28 09:00:00	SPY	ETF	139.82	140.38	139.41	139.56	17545223.0
2012-11-28 10:00:00	SPY	ETF	139.56	140.34	139.0	140.09	39220856.0
2012-11-28 11:00:00	SPY	ETF	140.1	140.62	140.03	140.3001	19029411.0
2012-11-28 12:00:00	SPY	ETF	140.3	141.08	139.95	140.96	25831836.0
2012-11-28 13:00:00	SPY	ETF	140.95	141.11	140.67	140.94	12448620.0
2012-11-28 14:00:00	SPY	ETF	140.93	141.06	140.75	140.977	12121637.0
2012-11-28 15:00:00	SPY	ETF	140.975	141.54	140.92	141.46	30928389.0
2012-11-28 16:00:00	SPY	ETF	141.48	141.5	140.391	140.3911	13775767.0
2012-11-28 17:00:00	SPY	ETF	141.36	141.38	141.19	141.29	1384958.0
2012-11-28 18:00:00	SPY	ETF	141.29	141.48	141.12	141.19	500419.0
2012-11-28 19:00:00	SPY	ETF	141.18	141.32	141.18	141.3	119195.0
2012-11-28 04:00:00	QQQ	ETF	64.88	64.88	64.82	64.82	1656.0
2012-11-28 06:00:00	QQQ	ETF	64.85	64.85	64.85	64.85	100.0
2012-11-28 07:00:00	QQQ	ETF	64.8	64.85	64.77	64.77	56900.0
2012-11-28 08:00:00	QQQ	ETF	64.79	64.825	64.71	64.75	144932.0
2012-11-28 09:00:00	QQQ	ETF	64.74	64.78	64.44	64.54	4455081.0
2012-11-28 10:00:00	QQQ	ETF	64.54	64.97	64.25	64.848	7929817.0
2012-11-28 11:00:00	QQQ	ETF	64.85	65.1	64.82	64.96	4090591.0
2012-11-28 12:00:00	QQQ	ETF	64.95	65.29	64.78	65.23	4561095.0
2012-11-28 13:00:00	QQQ	ETF	65.24	65.39	65.1201	65.27	2555469.0
2012-11-28 14:00:00	QQQ	ETF	65.27	65.32	65.162	65.28	2879693.0
2012-11-28 15:00:00	QQQ	ETF	65.28	65.57	65.25	65.51	7022464.0
2012-11-28 16:00:00	QQQ	ETF	65.52	65.52	65.44	65.45	511866.0
2012-11-28 17:00:00	QQQ	ETF	65.48	65.5	65.48	65.5	22272.0
2012-11-28 18:00:00	QQQ	ETF	65.45	65.46	65.43	65.45	5290.0
2012-11-28 19:00:00	QQQ	ETF	65.46	65.51	65.44	65.51	5564.0
2012-11-28 08:00:00	IWM	ETF	80.4	80.46	80.33	80.37	149227.0
2012-11-28 09:00:00	IWM	ETF	80.35	80.35	79.82	80.04	4067970.0
2012-11-28 10:00:00	IWM	ETF	80.03	80.55	79.63	80.31	10910159.0
2012-11-28 11:00:00	IWM	ETF	80.32	80.89	80.27	80.6499	6168162.0
2012-11-28 12:00:00	IWM	ETF	80.64	81.0	80.445	80.9	5569788.0
2012-11-28 13:00:00	IWM	ETF	80.89	81.07	80.76	80.96	1577711.0
2012-11-28 14:00:00	IWM	ETF	80.96	81.02	80.77	80.92	3109113.0
2012-11-28 15:00:00	IWM	ETF	80.92	81.28	80.89	81.27	6937573.0
2012-11-28 16:00:00	IWM	ETF	81.28	81.36	79.8125	81.3	2601722.0
2012-11-28 17:00:00	IWM	ETF	81.29	81.3	81.29	81.3	1400.0
2012-11-28 18:00:00	IWM	ETF	81.27	81.31	81.15	81.31	19884.0
2012-11-28 19:00:00	IWM	ETF	81.24	81.4	81.24	81.24	1230.0
2012-11-28 04:00:00	DIA	ETF	128.48	128.48	128.48	128.48	100.0
2012-11-28 07:00:00	DIA	ETF	128.4	128.4	128.35	128.35	200.0
2012-11-28 08:00:00	DIA	ETF	128.42	128.42	128.27	128.31	10800.0
2012-11-28 09:00:00	DIA	ETF	128.28	128.32	127.9	127.96	524733.0
2012-11-28 10:00:00	DIA	ETF	127.95	128.76	127.47	128.58	1769395.0
2012-11-28 11:00:00	DIA	ETF	128.59	129.03	128.54	128.7899	794634.0
2012-11-28 12:00:00	DIA	ETF	128.76	129.46	128.48	129.38	1201681.0

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

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