PREVIEW / etf_1hour / 2011-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-07.parquet
  size:    177 KB
  rows:    5,410

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
2011-04-07 04:00:00	SPY	ETF	133.36	133.4	133.35	133.4	1100.0
2011-04-07 05:00:00	SPY	ETF	133.38	133.38	133.27	133.27	12880.0
2011-04-07 06:00:00	SPY	ETF	133.34	133.34	133.2	133.27	50250.0
2011-04-07 07:00:00	SPY	ETF	133.28	133.56	133.27	133.55	356241.0
2011-04-07 08:00:00	SPY	ETF	133.57	133.69	133.35	133.39	2086363.0
2011-04-07 09:00:00	SPY	ETF	133.38	133.9	133.26	133.865	15308498.0
2011-04-07 10:00:00	SPY	ETF	133.87	133.94	132.66	133.34	44716080.0
2011-04-07 11:00:00	SPY	ETF	133.349	133.47	132.74	133.26	32776822.0
2011-04-07 12:00:00	SPY	ETF	133.25	133.63	133.18	133.52	16918002.0
2011-04-07 13:00:00	SPY	ETF	133.52	133.53	132.95	133.075	13539169.0
2011-04-07 14:00:00	SPY	ETF	133.08	133.29	132.96	133.26	13222552.0
2011-04-07 15:00:00	SPY	ETF	133.25	133.41	133.08	133.36	26650698.0
2011-04-07 16:00:00	SPY	ETF	133.36	133.4066	133.24	133.28	4673261.0
2011-04-07 17:00:00	SPY	ETF	133.28	133.38	133.28	133.35	61066.0
2011-04-07 18:00:00	SPY	ETF	133.35	133.42	133.24	133.27	108172.0
2011-04-07 19:00:00	SPY	ETF	133.3	133.36	133.28	133.31	28618.0
2011-04-07 05:00:00	QQQ	ETF	57.08	57.08	57.08	57.08	1100.0
2011-04-07 06:00:00	QQQ	ETF	57.09	57.09	57.09	57.09	800.0
2011-04-07 07:00:00	QQQ	ETF	57.14	57.24	57.12	57.24	130273.0
2011-04-07 08:00:00	QQQ	ETF	57.22	57.29	57.17	57.18	2728861.0
2011-04-07 09:00:00	QQQ	ETF	57.17	57.6	57.13	57.54	9662410.0
2011-04-07 10:00:00	QQQ	ETF	57.5425	57.57	56.81	57.17	14704775.0
2011-04-07 11:00:00	QQQ	ETF	57.17	57.24	56.92	57.16	10208816.0
2011-04-07 12:00:00	QQQ	ETF	57.16	57.48	57.11	57.43	7545956.0
2011-04-07 13:00:00	QQQ	ETF	57.435	57.44	57.06	57.15	4896260.0
2011-04-07 14:00:00	QQQ	ETF	57.16	57.23	57.08	57.2	2488998.0
2011-04-07 15:00:00	QQQ	ETF	57.2	57.25	57.1	57.23	4719785.0
2011-04-07 16:00:00	QQQ	ETF	57.22	57.29	57.1643	57.27	1500016.0
2011-04-07 17:00:00	QQQ	ETF	57.26	57.3	57.26	57.29	3723.0
2011-04-07 18:00:00	QQQ	ETF	57.29	57.3	57.24	57.24	7100.0
2011-04-07 19:00:00	QQQ	ETF	57.26	57.3	57.24	57.3	7190.0
2011-04-07 04:00:00	IWM	ETF	85.25	85.25	85.25	85.25	149.0
2011-04-07 05:00:00	IWM	ETF	85.26	85.26	85.2	85.2	2884.0
2011-04-07 06:00:00	IWM	ETF	85.11	85.11	85.1	85.1	200.0
2011-04-07 07:00:00	IWM	ETF	85.2	85.39	85.2	85.39	36983.0
2011-04-07 08:00:00	IWM	ETF	85.44	85.63	85.33	85.36	2389777.0
2011-04-07 09:00:00	IWM	ETF	85.34	85.775	85.29	85.75	7747526.0
2011-04-07 10:00:00	IWM	ETF	85.75	85.775	84.696	85.04	13807924.0
2011-04-07 11:00:00	IWM	ETF	85.04	85.35	84.6175	84.93	11517804.0
2011-04-07 12:00:00	IWM	ETF	84.93	85.35	84.81	85.329	6774446.0
2011-04-07 13:00:00	IWM	ETF	85.32	85.37	84.86	85.011	5393252.0
2011-04-07 14:00:00	IWM	ETF	85.02	85.1	84.87	85.005	2655908.0
2011-04-07 15:00:00	IWM	ETF	85.0	85.09	84.82	84.87	6554684.0
2011-04-07 16:00:00	IWM	ETF	84.86	85.3017	84.77	84.89	4112978.0
2011-04-07 17:00:00	IWM	ETF	84.89	84.9	84.88	84.88	1800.0
2011-04-07 18:00:00	IWM	ETF	84.89	84.89	84.87	84.89	12575.0
2011-04-07 19:00:00	IWM	ETF	84.89	84.89	84.85	84.86	1600.0
2011-04-07 07:00:00	DIA	ETF	123.95	124.1	123.95	124.1	2270.0
2011-04-07 08:00:00	DIA	ETF	124.18	124.25	124.0	124.0	8430.0
2011-04-07 09:00:00	DIA	ETF	123.97	124.22	123.9	124.21	558673.0

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

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