PREVIEW / etf_1hour / 2013-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-17.parquet
  size:    208 KB
  rows:    6,435

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-04-17 04:00:00	SPY	ETF	156.61	156.67	156.34	156.66	53224.0
2013-04-17 05:00:00	SPY	ETF	156.61	156.64	156.44	156.59	23290.0
2013-04-17 06:00:00	SPY	ETF	156.59	156.59	156.02	156.1	205818.0
2013-04-17 07:00:00	SPY	ETF	156.13	156.31	156.0	156.23	1126958.0
2013-04-17 08:00:00	SPY	ETF	156.23	156.52	156.03	156.13	2684646.0
2013-04-17 09:00:00	SPY	ETF	156.13	156.38	155.67	155.97	23201918.0
2013-04-17 10:00:00	SPY	ETF	155.96	156.08	154.72	154.74	36843466.0
2013-04-17 11:00:00	SPY	ETF	154.73	155.17	154.52	154.93	35793053.0
2013-04-17 12:00:00	SPY	ETF	154.93	155.07	154.28	154.78	22502437.0
2013-04-17 13:00:00	SPY	ETF	154.79	155.39	154.63	155.1	23466392.0
2013-04-17 14:00:00	SPY	ETF	155.1	155.39	154.74	155.08	20060645.0
2013-04-17 15:00:00	SPY	ETF	155.07	155.49	154.92	155.06	37290567.0
2013-04-17 16:00:00	SPY	ETF	155.04	157.4028	154.97	155.07	16291304.0
2013-04-17 17:00:00	SPY	ETF	155.06	155.08	154.86	154.9	386385.0
2013-04-17 18:00:00	SPY	ETF	154.91	155.11	154.9	155.11	203284.0
2013-04-17 19:00:00	SPY	ETF	155.1	155.26	155.1	155.26	71119.0
2013-04-17 04:00:00	QQQ	ETF	69.07	69.07	69.0	69.02	17446.0
2013-04-17 05:00:00	QQQ	ETF	69.05	69.05	69.05	69.05	300.0
2013-04-17 06:00:00	QQQ	ETF	69.03	69.03	68.94	68.94	10800.0
2013-04-17 07:00:00	QQQ	ETF	68.88	68.94	68.77	68.9	57576.0
2013-04-17 08:00:00	QQQ	ETF	68.85	69.03	68.83	68.85	1520471.0
2013-04-17 09:00:00	QQQ	ETF	68.84	68.93	68.6	68.7001	5998594.0
2013-04-17 10:00:00	QQQ	ETF	68.7	68.76	67.96	67.97	8750200.0
2013-04-17 11:00:00	QQQ	ETF	67.97	68.27	67.87	68.052	6179941.0
2013-04-17 12:00:00	QQQ	ETF	68.05	68.131	67.71	68.01	5234027.0
2013-04-17 13:00:00	QQQ	ETF	68.011	68.3601	67.95	68.21	5153615.0
2013-04-17 14:00:00	QQQ	ETF	68.2198	68.31	67.92	68.06	4464658.0
2013-04-17 15:00:00	QQQ	ETF	68.069	68.25	67.999	68.12	9186723.0
2013-04-17 16:00:00	QQQ	ETF	68.11	68.2329	68.0	68.08	2535416.0
2013-04-17 17:00:00	QQQ	ETF	68.08	68.1	67.95	67.97	125635.0
2013-04-17 18:00:00	QQQ	ETF	67.99	68.1	67.99	68.1	68110.0
2013-04-17 19:00:00	QQQ	ETF	68.12	68.21	68.12	68.21	14933.0
2013-04-17 05:00:00	IWM	ETF	91.19	91.19	91.11	91.11	300.0
2013-04-17 06:00:00	IWM	ETF	91.24	91.24	90.83	90.83	41700.0
2013-04-17 07:00:00	IWM	ETF	90.91	90.96	90.77	90.87	141140.0
2013-04-17 08:00:00	IWM	ETF	90.9	91.07	90.83	90.83	318157.0
2013-04-17 09:00:00	IWM	ETF	90.81	91.02	90.35	90.61	7783123.0
2013-04-17 10:00:00	IWM	ETF	90.61	90.82	89.4	89.41	12918701.0
2013-04-17 11:00:00	IWM	ETF	89.4	89.8701	89.23	89.78	9967393.0
2013-04-17 12:00:00	IWM	ETF	89.775	89.87	89.35	89.68	6061182.0
2013-04-17 13:00:00	IWM	ETF	89.68	89.969	89.49	89.74	6894611.0
2013-04-17 14:00:00	IWM	ETF	89.74	89.96	89.53	89.79	5130325.0
2013-04-17 15:00:00	IWM	ETF	89.79	90.27	89.67	90.07	11128162.0
2013-04-17 16:00:00	IWM	ETF	90.07	91.6955	90.0	90.06	4242654.0
2013-04-17 17:00:00	IWM	ETF	90.07	90.07	90.0	90.05	16440.0
2013-04-17 18:00:00	IWM	ETF	90.1	90.1	90.1	90.1	838.0
2013-04-17 19:00:00	IWM	ETF	90.14	90.14	90.14	90.14	660.0
2013-04-17 06:00:00	DIA	ETF	146.5	146.5	146.35	146.35	300.0
2013-04-17 07:00:00	DIA	ETF	146.35	146.35	146.28	146.29	8000.0
2013-04-17 08:00:00	DIA	ETF	146.25	146.61	146.25	146.38	7636.0

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

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