PREVIEW / etf_1hour / 2013-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-06.parquet
  size:    197 KB
  rows:    6,169

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-06 04:00:00	SPY	ETF	151.29	151.29	151.24	151.24	2700.0
2013-02-06 05:00:00	SPY	ETF	151.19	151.25	151.02	151.08	111962.0
2013-02-06 06:00:00	SPY	ETF	151.09	151.2	151.0	151.05	62405.0
2013-02-06 07:00:00	SPY	ETF	151.09	151.13	150.7	150.7	1604077.0
2013-02-06 08:00:00	SPY	ETF	150.73	151.02	150.31	150.35	2104720.0
2013-02-06 09:00:00	SPY	ETF	150.36	150.9	150.35	150.83	18528524.0
2013-02-06 10:00:00	SPY	ETF	150.82	151.01	150.64	150.92	16404885.0
2013-02-06 11:00:00	SPY	ETF	150.92	151.18	150.92	151.098	10584837.0
2013-02-06 12:00:00	SPY	ETF	151.1	151.26	150.96	150.96	23575320.0
2013-02-06 13:00:00	SPY	ETF	150.97	150.99	150.57	150.66	11372086.0
2013-02-06 14:00:00	SPY	ETF	150.66	150.95	150.62	150.94	7886784.0
2013-02-06 15:00:00	SPY	ETF	150.94	151.18	150.87	151.17	25661889.0
2013-02-06 16:00:00	SPY	ETF	151.16	151.2015	150.9032	151.15	19925124.0
2013-02-06 17:00:00	SPY	ETF	151.15	151.15	151.03	151.07	157518.0
2013-02-06 18:00:00	SPY	ETF	151.07	151.11	151.03	151.03	104965.0
2013-02-06 19:00:00	SPY	ETF	151.02	151.1	151.02	151.1	20916.0
2013-02-06 04:00:00	QQQ	ETF	67.58	67.58	67.58	67.58	155.0
2013-02-06 05:00:00	QQQ	ETF	67.41	67.41	67.41	67.41	4000.0
2013-02-06 07:00:00	QQQ	ETF	67.43	67.43	67.21	67.21	168548.0
2013-02-06 08:00:00	QQQ	ETF	67.3	67.41	67.09	67.18	1341282.0
2013-02-06 09:00:00	QQQ	ETF	67.19	67.43	67.17	67.38	7632168.0
2013-02-06 10:00:00	QQQ	ETF	67.37	67.419	67.1	67.375	7041103.0
2013-02-06 11:00:00	QQQ	ETF	67.37	67.55	67.37	67.46	4099226.0
2013-02-06 12:00:00	QQQ	ETF	67.46	67.48	67.3	67.31	2868571.0
2013-02-06 13:00:00	QQQ	ETF	67.31	67.32	67.04	67.13	3884397.0
2013-02-06 14:00:00	QQQ	ETF	67.13	67.2	67.06	67.18	3973093.0
2013-02-06 15:00:00	QQQ	ETF	67.1801	67.25	67.1	67.24	5793685.0
2013-02-06 16:00:00	QQQ	ETF	67.24	67.4608	67.13	67.23	5390573.0
2013-02-06 17:00:00	QQQ	ETF	67.24	67.24	67.18	67.23	8500.0
2013-02-06 18:00:00	QQQ	ETF	67.21	67.21	67.18	67.18	3432.0
2013-02-06 19:00:00	QQQ	ETF	67.17	67.17	67.17	67.17	578.0
2013-02-06 07:00:00	IWM	ETF	90.1	90.1	89.77	89.77	400856.0
2013-02-06 08:00:00	IWM	ETF	89.77	89.91	89.48	89.57	1967484.0
2013-02-06 09:00:00	IWM	ETF	89.55	89.95	89.55	89.9	4712330.0
2013-02-06 10:00:00	IWM	ETF	89.9	89.96	89.77	89.86	3574969.0
2013-02-06 11:00:00	IWM	ETF	89.86	90.25	89.86	90.235	2113868.0
2013-02-06 12:00:00	IWM	ETF	90.23	90.35	90.0401	90.05	1717535.0
2013-02-06 13:00:00	IWM	ETF	90.05	90.06	89.77	89.87	2590594.0
2013-02-06 14:00:00	IWM	ETF	89.87	90.15	89.8499	90.15	1210539.0
2013-02-06 15:00:00	IWM	ETF	90.15	90.52	90.09	90.48	4941679.0
2013-02-06 16:00:00	IWM	ETF	90.48	90.49	90.38	90.43	434664.0
2013-02-06 17:00:00	IWM	ETF	90.44	90.44	90.4	90.4	15340.0
2013-02-06 18:00:00	IWM	ETF	90.43	90.43	90.31	90.4	4006.0
2013-02-06 19:00:00	IWM	ETF	90.4	90.4	90.36	90.36	2035.0
2013-02-06 08:00:00	DIA	ETF	139.19	139.19	138.82	138.88	17400.0
2013-02-06 09:00:00	DIA	ETF	138.9	139.28	138.87	139.24	546163.0
2013-02-06 10:00:00	DIA	ETF	139.23	139.38	139.09	139.31	464335.0
2013-02-06 11:00:00	DIA	ETF	139.32	139.54	139.32	139.54	360323.0
2013-02-06 12:00:00	DIA	ETF	139.5399	139.7	139.49	139.51	326273.0
2013-02-06 13:00:00	DIA	ETF	139.51	139.52	139.1798	139.23	351119.0

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

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