PREVIEW / etf_1hour / 2014-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-12.parquet
  size:    216 KB
  rows:    6,823

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
2014-02-12 04:00:00	SPY	ETF	182.16	182.33	182.15	182.33	61246.0
2014-02-12 05:00:00	SPY	ETF	182.29	182.36	182.16	182.23	45617.0
2014-02-12 06:00:00	SPY	ETF	182.14	182.15	181.81	181.82	38280.0
2014-02-12 07:00:00	SPY	ETF	181.82	181.98	181.74	181.84	237769.0
2014-02-12 08:00:00	SPY	ETF	182.25	182.25	181.7	181.96	458466.0
2014-02-12 09:00:00	SPY	ETF	181.95	182.81	181.95	182.77	14337431.0
2014-02-12 10:00:00	SPY	ETF	182.78	182.83	181.92	182.06	19023516.0
2014-02-12 11:00:00	SPY	ETF	182.06	182.318	181.705	181.91	11926165.0
2014-02-12 12:00:00	SPY	ETF	181.91	182.24	181.82	182.15	8352038.0
2014-02-12 13:00:00	SPY	ETF	182.15	182.396	182.05	182.24	8497596.0
2014-02-12 14:00:00	SPY	ETF	182.25	182.335	181.76	181.88	8692178.0
2014-02-12 15:00:00	SPY	ETF	181.88	182.14	181.775	182.08	16525713.0
2014-02-12 16:00:00	SPY	ETF	182.08	182.351	182.0653	182.17	5161857.0
2014-02-12 17:00:00	SPY	ETF	182.16	182.19	182.065	182.15	219401.0
2014-02-12 18:00:00	SPY	ETF	182.15	182.16	182.0	182.03	53844.0
2014-02-12 19:00:00	SPY	ETF	182.05	182.13	181.94	181.99	225803.0
2014-02-12 04:00:00	QQQ	ETF	88.8	88.93	88.8	88.93	4890.0
2014-02-12 05:00:00	QQQ	ETF	88.93	88.93	88.88	88.88	14800.0
2014-02-12 06:00:00	QQQ	ETF	88.85	88.89	88.75	88.75	5200.0
2014-02-12 07:00:00	QQQ	ETF	88.71	88.77	88.69	88.71	41702.0
2014-02-12 08:00:00	QQQ	ETF	88.71	88.81	88.67	88.8	152556.0
2014-02-12 09:00:00	QQQ	ETF	88.8	89.15	88.8	89.15	7795659.0
2014-02-12 10:00:00	QQQ	ETF	89.15	89.1695	88.7877	88.81	5779592.0
2014-02-12 11:00:00	QQQ	ETF	88.81	89.01	88.7	88.8	3019300.0
2014-02-12 12:00:00	QQQ	ETF	88.79	89.0	88.74	88.951	2004526.0
2014-02-12 13:00:00	QQQ	ETF	88.96	89.09	88.93	89.029	1923272.0
2014-02-12 14:00:00	QQQ	ETF	89.03	89.08	88.83	88.89	2116577.0
2014-02-12 15:00:00	QQQ	ETF	88.89	88.96	88.7975	88.96	5246316.0
2014-02-12 16:00:00	QQQ	ETF	88.95	89.056	88.87	88.91	1316437.0
2014-02-12 17:00:00	QQQ	ETF	88.79	88.9	88.79	88.86	8977.0
2014-02-12 18:00:00	QQQ	ETF	88.87	88.87	88.81	88.83	11085.0
2014-02-12 19:00:00	QQQ	ETF	88.85	88.89	88.8	88.83	13850.0
2014-02-12 04:00:00	IWM	ETF	112.2	112.2	112.2	112.2	100.0
2014-02-12 07:00:00	IWM	ETF	112.0	112.03	111.86	111.91	71700.0
2014-02-12 08:00:00	IWM	ETF	111.92	111.97	111.81	111.97	178883.0
2014-02-12 09:00:00	IWM	ETF	112.0	113.01	112.0	112.91	5077641.0
2014-02-12 10:00:00	IWM	ETF	112.91	113.0	112.24	112.31	10122425.0
2014-02-12 11:00:00	IWM	ETF	112.31	112.545	111.972	112.17	4332357.0
2014-02-12 12:00:00	IWM	ETF	112.17	112.49	112.11	112.41	2468630.0
2014-02-12 13:00:00	IWM	ETF	112.42	112.67	112.32	112.49	2645727.0
2014-02-12 14:00:00	IWM	ETF	112.48	112.57	112.049	112.14	4406641.0
2014-02-12 15:00:00	IWM	ETF	112.14	112.49	112.06	112.46	4409384.0
2014-02-12 16:00:00	IWM	ETF	112.45	112.51	112.261	112.44	4358511.0
2014-02-12 17:00:00	IWM	ETF	112.39	112.39	112.39	112.39	5200.0
2014-02-12 18:00:00	IWM	ETF	112.44	112.44	112.39	112.39	6900.0
2014-02-12 19:00:00	IWM	ETF	112.44	112.44	112.34	112.34	9775.0
2014-02-12 07:00:00	DIA	ETF	159.79	159.79	159.6	159.72	2400.0
2014-02-12 08:00:00	DIA	ETF	159.61	159.75	159.57	159.75	2019.0
2014-02-12 09:00:00	DIA	ETF	159.78	160.45	159.78	160.38	962752.0
2014-02-12 10:00:00	DIA	ETF	160.38	160.44	159.61	159.67	1233024.0

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

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