PREVIEW / etf_1hour / 2013-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-13.parquet
  size:    193 KB
  rows:    6,083

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-13 04:00:00	SPY	ETF	152.23	152.23	152.2	152.2	300.0
2013-02-13 05:00:00	SPY	ETF	152.11	152.18	152.1	152.13	50723.0
2013-02-13 06:00:00	SPY	ETF	152.13	152.34	152.13	152.32	60033.0
2013-02-13 07:00:00	SPY	ETF	152.31	152.4	152.28	152.35	345480.0
2013-02-13 08:00:00	SPY	ETF	152.33	152.41	152.23	152.3	603805.0
2013-02-13 09:00:00	SPY	ETF	152.3	152.51	152.13	152.47	11416960.0
2013-02-13 10:00:00	SPY	ETF	152.46	152.61	152.24	152.34	11897716.0
2013-02-13 11:00:00	SPY	ETF	152.33	152.36	151.9	152.0299	10550596.0
2013-02-13 12:00:00	SPY	ETF	152.03	152.22	152.01	152.11	7909467.0
2013-02-13 13:00:00	SPY	ETF	152.11	152.26	152.1	152.2099	4780332.0
2013-02-13 14:00:00	SPY	ETF	152.208	152.24	151.72	151.81	12617661.0
2013-02-13 15:00:00	SPY	ETF	151.81	152.17	151.81	152.16	15114888.0
2013-02-13 16:00:00	SPY	ETF	152.15	152.33	151.98	152.12	4942505.0
2013-02-13 17:00:00	SPY	ETF	152.13	152.14	152.04	152.07	155979.0
2013-02-13 18:00:00	SPY	ETF	152.05	152.07	151.97	152.02	52875.0
2013-02-13 19:00:00	SPY	ETF	152.02	152.05	151.97	151.99	52875.0
2013-02-13 06:00:00	QQQ	ETF	67.83	67.84	67.83	67.83	1200.0
2013-02-13 07:00:00	QQQ	ETF	67.91	67.95	67.9	67.9	54300.0
2013-02-13 08:00:00	QQQ	ETF	67.91	67.98	67.73	67.9	138334.0
2013-02-13 09:00:00	QQQ	ETF	67.9	68.1599	67.7845	68.15	3119469.0
2013-02-13 10:00:00	QQQ	ETF	68.155	68.23	68.06	68.13	4989863.0
2013-02-13 11:00:00	QQQ	ETF	68.13	68.14	67.77	67.8437	3694570.0
2013-02-13 12:00:00	QQQ	ETF	67.84	67.98	67.82	67.89	1962145.0
2013-02-13 13:00:00	QQQ	ETF	67.882	68.07	67.8748	68.02	1184774.0
2013-02-13 14:00:00	QQQ	ETF	68.02	68.05	67.765	67.8151	2725234.0
2013-02-13 15:00:00	QQQ	ETF	67.82	67.99	67.79	67.98	3448713.0
2013-02-13 16:00:00	QQQ	ETF	67.97	68.02	67.84	67.93	999847.0
2013-02-13 17:00:00	QQQ	ETF	67.93	67.93	67.86	67.9	36979.0
2013-02-13 18:00:00	QQQ	ETF	67.9	67.9	67.84	67.84	272.0
2013-02-13 19:00:00	QQQ	ETF	67.85	67.85	67.85	67.85	2500.0
2013-02-13 06:00:00	IWM	ETF	91.17	91.17	91.17	91.17	550.0
2013-02-13 07:00:00	IWM	ETF	91.18	91.26	91.18	91.26	53900.0
2013-02-13 08:00:00	IWM	ETF	91.24	91.26	91.16	91.16	35640.0
2013-02-13 09:00:00	IWM	ETF	91.2	91.3001	91.02	91.27	1928780.0
2013-02-13 10:00:00	IWM	ETF	91.28	91.55	91.25	91.4299	4497398.0
2013-02-13 11:00:00	IWM	ETF	91.42	91.46	91.02	91.135	2667320.0
2013-02-13 12:00:00	IWM	ETF	91.14	91.32	91.14	91.2	1197740.0
2013-02-13 13:00:00	IWM	ETF	91.19	91.31	91.17	91.27	762495.0
2013-02-13 14:00:00	IWM	ETF	91.25	91.29	90.98	91.02	2882411.0
2013-02-13 15:00:00	IWM	ETF	91.02	91.45	91.02	91.43	5642363.0
2013-02-13 16:00:00	IWM	ETF	91.43	91.56	91.42	91.47	1365686.0
2013-02-13 17:00:00	IWM	ETF	91.48	91.48	91.44	91.45	3025.0
2013-02-13 18:00:00	IWM	ETF	91.48	91.49	91.44	91.44	27662.0
2013-02-13 19:00:00	IWM	ETF	91.44	91.45	91.44	91.45	9138.0
2013-02-13 06:00:00	DIA	ETF	140.25	140.25	140.25	140.25	100.0
2013-02-13 07:00:00	DIA	ETF	140.27	140.27	140.17	140.24	1330.0
2013-02-13 08:00:00	DIA	ETF	140.2	140.26	140.11	140.14	25538.0
2013-02-13 09:00:00	DIA	ETF	140.16	140.36	140.05	140.16	418077.0
2013-02-13 10:00:00	DIA	ETF	140.16	140.29	139.94	139.98	516199.0
2013-02-13 11:00:00	DIA	ETF	139.98	139.99	139.58	139.68	526820.0

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

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