PREVIEW / etf_1hour / 2013-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-15.parquet
  size:    196 KB
  rows:    6,085

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-15 04:00:00	SPY	ETF	152.07	152.07	151.85	151.85	29350.0
2013-02-15 05:00:00	SPY	ETF	152.02	152.12	152.02	152.05	18132.0
2013-02-15 06:00:00	SPY	ETF	152.05	152.17	152.03	152.16	11030.0
2013-02-15 07:00:00	SPY	ETF	152.12	152.16	152.04	152.1	298221.0
2013-02-15 08:00:00	SPY	ETF	152.1	152.36	151.95	152.29	1396504.0
2013-02-15 09:00:00	SPY	ETF	152.29	152.54	152.17	152.49	13917457.0
2013-02-15 10:00:00	SPY	ETF	152.49	152.59	152.24	152.4887	13879333.0
2013-02-15 11:00:00	SPY	ETF	152.489	152.52	152.11	152.23	65565664.0
2013-02-15 12:00:00	SPY	ETF	152.24	152.24	151.94	152.15	17173380.0
2013-02-15 13:00:00	SPY	ETF	152.16	152.32	152.12	152.31	8592779.0
2013-02-15 14:00:00	SPY	ETF	152.31	152.32	151.55	151.66	32542070.0
2013-02-15 15:00:00	SPY	ETF	151.67	152.297	151.63	152.149	24297966.0
2013-02-15 16:00:00	SPY	ETF	152.15	152.297	151.68	152.12	9314818.0
2013-02-15 17:00:00	SPY	ETF	152.2974	152.2974	152.11	152.21	729581.0
2013-02-15 18:00:00	SPY	ETF	152.18	152.25	152.08	152.08	87057.0
2013-02-15 19:00:00	SPY	ETF	152.08	152.09	152.0	152.02	35597.0
2013-02-15 05:00:00	QQQ	ETF	67.85	67.85	67.81	67.81	300.0
2013-02-15 06:00:00	QQQ	ETF	67.8	67.84	67.8	67.84	400.0
2013-02-15 07:00:00	QQQ	ETF	67.82	67.83	67.82	67.83	11500.0
2013-02-15 08:00:00	QQQ	ETF	67.84	67.94	67.84	67.92	68525.0
2013-02-15 09:00:00	QQQ	ETF	67.91	68.05	67.89	68.025	3184285.0
2013-02-15 10:00:00	QQQ	ETF	68.03	68.11	67.95	68.025	3559295.0
2013-02-15 11:00:00	QQQ	ETF	68.0203	68.055	67.84	67.9	2560088.0
2013-02-15 12:00:00	QQQ	ETF	67.91	67.91	67.77	67.87	1986299.0
2013-02-15 13:00:00	QQQ	ETF	67.8791	67.939	67.8	67.93	1422093.0
2013-02-15 14:00:00	QQQ	ETF	67.93	67.95	67.56	67.61	4819167.0
2013-02-15 15:00:00	QQQ	ETF	67.6001	67.76	67.6	67.76	5168626.0
2013-02-15 16:00:00	QQQ	ETF	67.75	67.846	67.66	67.74	1513104.0
2013-02-15 17:00:00	QQQ	ETF	67.74	67.8142	67.71	67.71	186929.0
2013-02-15 19:00:00	QQQ	ETF	67.75	67.75	67.75	67.75	500.0
2013-02-15 06:00:00	IWM	ETF	91.6	91.6	91.6	91.6	100.0
2013-02-15 07:00:00	IWM	ETF	91.55	91.58	91.55	91.58	29400.0
2013-02-15 08:00:00	IWM	ETF	91.72	91.78	91.58	91.76	80167.0
2013-02-15 09:00:00	IWM	ETF	91.74	91.89	91.63	91.85	4114219.0
2013-02-15 10:00:00	IWM	ETF	91.85	91.98	91.74	91.97	3172365.0
2013-02-15 11:00:00	IWM	ETF	91.9696	91.99	91.74	91.861	2665083.0
2013-02-15 12:00:00	IWM	ETF	91.865	91.88	91.64	91.78	2300178.0
2013-02-15 13:00:00	IWM	ETF	91.78	92.03	91.775	91.99	2736697.0
2013-02-15 14:00:00	IWM	ETF	91.99	92.01	91.47	91.54	5485176.0
2013-02-15 15:00:00	IWM	ETF	91.54	91.8328	91.51	91.7	6313659.0
2013-02-15 16:00:00	IWM	ETF	91.7	91.79	91.684	91.74	1499659.0
2013-02-15 17:00:00	IWM	ETF	91.77	91.78	91.71	91.71	8864.0
2013-02-15 18:00:00	IWM	ETF	91.73	91.73	91.73	91.73	200.0
2013-02-15 05:00:00	DIA	ETF	139.32	139.32	139.32	139.32	300.0
2013-02-15 06:00:00	DIA	ETF	139.33	139.33	139.28	139.28	200.0
2013-02-15 07:00:00	DIA	ETF	139.36	139.36	139.32	139.32	2645.0
2013-02-15 08:00:00	DIA	ETF	139.3	139.45	139.3	139.41	42225.0
2013-02-15 09:00:00	DIA	ETF	139.38	139.62	139.32	139.58	705743.0
2013-02-15 10:00:00	DIA	ETF	139.59	139.71	139.46	139.63	1394303.0
2013-02-15 11:00:00	DIA	ETF	139.64	139.67	139.34	139.43	716120.0

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

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