PREVIEW / etf_1hour / 2012-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-19.parquet
  size:    193 KB
  rows:    6,006

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-19 04:00:00	SPY	ETF	137.18	137.28	137.18	137.28	17921.0
2012-11-19 05:00:00	SPY	ETF	137.25	137.32	137.24	137.32	4100.0
2012-11-19 06:00:00	SPY	ETF	137.3	137.55	137.24	137.52	123970.0
2012-11-19 07:00:00	SPY	ETF	137.51	137.6	137.34	137.44	415813.0
2012-11-19 08:00:00	SPY	ETF	137.5295	137.9	137.34	137.85	4001516.0
2012-11-19 09:00:00	SPY	ETF	137.85	138.49	137.81	138.43	22090069.0
2012-11-19 10:00:00	SPY	ETF	138.43	138.63	138.19	138.45	30851799.0
2012-11-19 11:00:00	SPY	ETF	138.45	138.6	138.34	138.519	12663590.0
2012-11-19 12:00:00	SPY	ETF	138.52	138.75	138.51	138.61	14070670.0
2012-11-19 13:00:00	SPY	ETF	138.62	138.67	138.37	138.49	7753431.0
2012-11-19 14:00:00	SPY	ETF	138.49	138.85	138.47	138.78	12357236.0
2012-11-19 15:00:00	SPY	ETF	138.77	139.13	138.65	139.11	29613329.0
2012-11-19 16:00:00	SPY	ETF	139.11	139.13	136.4057	139.11	12774886.0
2012-11-19 17:00:00	SPY	ETF	139.11	139.21	138.72	138.73	792275.0
2012-11-19 18:00:00	SPY	ETF	138.71	138.83	138.65	138.72	233325.0
2012-11-19 19:00:00	SPY	ETF	138.76	138.87	138.74	138.8	66253.0
2012-11-19 04:00:00	QQQ	ETF	62.6	62.6	62.58	62.6	1100.0
2012-11-19 05:00:00	QQQ	ETF	62.62	62.63	62.57	62.63	1400.0
2012-11-19 06:00:00	QQQ	ETF	62.66	62.75	62.66	62.75	16200.0
2012-11-19 07:00:00	QQQ	ETF	62.75	62.76	62.67	62.76	83865.0
2012-11-19 08:00:00	QQQ	ETF	62.72	62.93	62.7	62.92	490134.0
2012-11-19 09:00:00	QQQ	ETF	62.92	63.289	62.88	63.22	8155313.0
2012-11-19 10:00:00	QQQ	ETF	63.23	63.42	63.05	63.325	7563719.0
2012-11-19 11:00:00	QQQ	ETF	63.33	63.41	63.29	63.378	2465462.0
2012-11-19 12:00:00	QQQ	ETF	63.37	63.57	63.37	63.5201	2269129.0
2012-11-19 13:00:00	QQQ	ETF	63.53	63.56	63.38	63.46	1391925.0
2012-11-19 14:00:00	QQQ	ETF	63.469	63.64	63.45	63.602	2872636.0
2012-11-19 15:00:00	QQQ	ETF	63.6	63.83	63.52	63.78	7473805.0
2012-11-19 16:00:00	QQQ	ETF	63.78	63.79	62.2973	63.73	9371738.0
2012-11-19 17:00:00	QQQ	ETF	63.75	63.78	63.59	63.65	47249.0
2012-11-19 18:00:00	QQQ	ETF	63.65	63.65	63.57	63.58	81147.0
2012-11-19 19:00:00	QQQ	ETF	63.62	63.62	63.59	63.61	5117.0
2012-11-19 04:00:00	IWM	ETF	77.83	77.83	77.83	77.83	100.0
2012-11-19 05:00:00	IWM	ETF	77.93	77.93	77.93	77.93	1000.0
2012-11-19 06:00:00	IWM	ETF	78.0	78.05	78.0	78.05	2600.0
2012-11-19 07:00:00	IWM	ETF	78.03	78.07	78.0	78.0	49995.0
2012-11-19 08:00:00	IWM	ETF	77.99	78.35	77.97	78.35	270525.0
2012-11-19 09:00:00	IWM	ETF	78.37	78.89	78.22	78.829	8771913.0
2012-11-19 10:00:00	IWM	ETF	78.83	78.94	78.37	78.54	7371588.0
2012-11-19 11:00:00	IWM	ETF	78.54	78.81	78.47	78.78	2882185.0
2012-11-19 12:00:00	IWM	ETF	78.785	78.91	78.74	78.75	1788529.0
2012-11-19 13:00:00	IWM	ETF	78.755	78.77	78.64	78.74	2815022.0
2012-11-19 14:00:00	IWM	ETF	78.75	78.93	78.72	78.89	2455953.0
2012-11-19 15:00:00	IWM	ETF	78.88	79.18	78.81	79.17	6739431.0
2012-11-19 16:00:00	IWM	ETF	79.18	79.28	78.69	79.27	2397829.0
2012-11-19 17:00:00	IWM	ETF	79.28	79.33	79.0	79.02	74369.0
2012-11-19 18:00:00	IWM	ETF	79.06	79.06	79.03	79.03	600.0
2012-11-19 19:00:00	IWM	ETF	79.06	79.06	79.03	79.03	4200.0
2012-11-19 06:00:00	DIA	ETF	126.35	126.4	126.35	126.4	2500.0
2012-11-19 07:00:00	DIA	ETF	126.43	126.43	126.31	126.37	3758.0

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

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