PREVIEW / etf_1hour / 2013-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-21.parquet
  size:    207 KB
  rows:    6,475

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
2013-02-21 04:00:00	SPY	ETF	151.05	151.05	150.52	150.78	301921.0
2013-02-21 05:00:00	SPY	ETF	150.71	150.79	150.51	150.58	421797.0
2013-02-21 06:00:00	SPY	ETF	150.59	150.83	150.59	150.81	171940.0
2013-02-21 07:00:00	SPY	ETF	150.82	150.93	150.66	150.82	325881.0
2013-02-21 08:00:00	SPY	ETF	150.85	151.04	150.71	150.92	7424064.0
2013-02-21 09:00:00	SPY	ETF	150.92	151.1	150.3	150.48	27256642.0
2013-02-21 10:00:00	SPY	ETF	150.48	150.86	150.17	150.645	28562786.0
2013-02-21 11:00:00	SPY	ETF	150.65	150.73	150.36	150.56	12168835.0
2013-02-21 12:00:00	SPY	ETF	150.56	150.6	150.13	150.42	13212666.0
2013-02-21 13:00:00	SPY	ETF	150.42	150.5	150.15	150.25	12107503.0
2013-02-21 14:00:00	SPY	ETF	150.26	151.4218	149.94	150.455	17779994.0
2013-02-21 15:00:00	SPY	ETF	150.4501	150.9	150.32	150.41	36413346.0
2013-02-21 16:00:00	SPY	ETF	150.41	151.4218	150.4	150.64	15256312.0
2013-02-21 17:00:00	SPY	ETF	150.64	150.65	150.4	150.6	358341.0
2013-02-21 18:00:00	SPY	ETF	150.61	150.75	150.6	150.67	1785871.0
2013-02-21 19:00:00	SPY	ETF	150.66	150.8	150.65	150.67	74549.0
2013-02-21 04:00:00	QQQ	ETF	66.9	66.9	66.88	66.9	625.0
2013-02-21 05:00:00	QQQ	ETF	66.92	66.92	66.82	66.82	10800.0
2013-02-21 06:00:00	QQQ	ETF	66.87	66.87	66.86	66.86	13000.0
2013-02-21 07:00:00	QQQ	ETF	66.88	66.92	66.86	66.92	23530.0
2013-02-21 08:00:00	QQQ	ETF	66.93	67.01	66.87	66.94	411452.0
2013-02-21 09:00:00	QQQ	ETF	66.95	67.02	66.61	66.71	6799610.0
2013-02-21 10:00:00	QQQ	ETF	66.73	66.9	66.53	66.77	6310517.0
2013-02-21 11:00:00	QQQ	ETF	66.77	66.805	66.55	66.6001	3168489.0
2013-02-21 12:00:00	QQQ	ETF	66.6	66.61	66.34	66.4801	4426880.0
2013-02-21 13:00:00	QQQ	ETF	66.4881	66.55	66.3	66.39	3422294.0
2013-02-21 14:00:00	QQQ	ETF	66.38	66.52	66.23	66.52	4361096.0
2013-02-21 15:00:00	QQQ	ETF	66.52	66.716	66.45	66.48	8267615.0
2013-02-21 16:00:00	QQQ	ETF	66.48	66.6699	66.47	66.62	1444516.0
2013-02-21 17:00:00	QQQ	ETF	66.63	66.64	66.63	66.64	24292.0
2013-02-21 18:00:00	QQQ	ETF	66.64	66.67	66.63	66.66	46802.0
2013-02-21 19:00:00	QQQ	ETF	66.66	66.73	66.66	66.69	25030.0
2013-02-21 04:00:00	IWM	ETF	90.55	90.55	90.55	90.55	260.0
2013-02-21 05:00:00	IWM	ETF	90.45	90.45	90.45	90.45	298.0
2013-02-21 06:00:00	IWM	ETF	90.57	90.64	90.57	90.64	1100.0
2013-02-21 07:00:00	IWM	ETF	90.68	90.7	90.6	90.7	62000.0
2013-02-21 08:00:00	IWM	ETF	90.59	90.83	90.59	90.75	181334.0
2013-02-21 09:00:00	IWM	ETF	90.74	90.88	90.22	90.35	7096952.0
2013-02-21 10:00:00	IWM	ETF	90.36	90.74	90.1	90.49	7311964.0
2013-02-21 11:00:00	IWM	ETF	90.495	90.5	90.11	90.125	4180313.0
2013-02-21 12:00:00	IWM	ETF	90.12	90.12	89.64	89.93	4917946.0
2013-02-21 13:00:00	IWM	ETF	89.92	90.0	89.68	89.788	2436780.0
2013-02-21 14:00:00	IWM	ETF	89.79	89.805	89.37	89.73	5768994.0
2013-02-21 15:00:00	IWM	ETF	89.73	90.28	89.66	89.93	9475248.0
2013-02-21 16:00:00	IWM	ETF	89.93	90.16	89.92	90.12	1452072.0
2013-02-21 17:00:00	IWM	ETF	90.11	90.11	89.92	90.1	58207.0
2013-02-21 18:00:00	IWM	ETF	90.1	90.15	90.07	90.15	43170.0
2013-02-21 19:00:00	IWM	ETF	90.15	90.17	90.14	90.15	16246.0
2013-02-21 04:00:00	DIA	ETF	138.53	138.53	138.37	138.37	500.0
2013-02-21 05:00:00	DIA	ETF	138.47	138.47	138.47	138.47	1000.0

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

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