PREVIEW / etf_1hour / 2013-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-01.parquet
  size:    199 KB
  rows:    6,278

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-01 04:00:00	SPY	ETF	150.3	150.3	150.27	150.27	2499.0
2013-02-01 05:00:00	SPY	ETF	150.3	150.34	150.21	150.22	24473.0
2013-02-01 06:00:00	SPY	ETF	150.13	150.16	149.99	150.12	55763.0
2013-02-01 07:00:00	SPY	ETF	150.09	150.25	150.06	150.21	223543.0
2013-02-01 08:00:00	SPY	ETF	150.12	150.92	149.7	150.76	4764364.0
2013-02-01 09:00:00	SPY	ETF	150.77	150.8	150.39	150.44	18724643.0
2013-02-01 10:00:00	SPY	ETF	150.57	151.12	150.43	150.99	30579057.0
2013-02-01 11:00:00	SPY	ETF	150.99	151.24	150.93	151.215	14411195.0
2013-02-01 12:00:00	SPY	ETF	151.22	151.28	151.15	151.25	7685361.0
2013-02-01 13:00:00	SPY	ETF	151.25	151.42	151.17	151.36	8675847.0
2013-02-01 14:00:00	SPY	ETF	151.355	151.37	151.12	151.1498	8859458.0
2013-02-01 15:00:00	SPY	ETF	151.15	151.36	151.03	151.22	22073129.0
2013-02-01 16:00:00	SPY	ETF	151.2	151.29	151.02	151.18	10856066.0
2013-02-01 17:00:00	SPY	ETF	151.16	151.38	151.13	151.27	340817.0
2013-02-01 18:00:00	SPY	ETF	151.27	151.27	151.17	151.25	51180.0
2013-02-01 19:00:00	SPY	ETF	151.25	151.26	151.2	151.24	17907.0
2013-02-01 06:00:00	QQQ	ETF	66.96	67.06	66.96	67.04	1860.0
2013-02-01 07:00:00	QQQ	ETF	67.05	67.13	67.05	67.13	18900.0
2013-02-01 08:00:00	QQQ	ETF	67.06	67.4	67.06	67.36	1428721.0
2013-02-01 09:00:00	QQQ	ETF	67.37	67.38	67.07	67.1	5919277.0
2013-02-01 10:00:00	QQQ	ETF	67.12	67.47	67.1	67.33	6943059.0
2013-02-01 11:00:00	QQQ	ETF	67.33	67.62	67.32	67.609	4203154.0
2013-02-01 12:00:00	QQQ	ETF	67.61	67.74	67.56	67.69	3627730.0
2013-02-01 13:00:00	QQQ	ETF	67.68	67.78	67.63	67.74	2806520.0
2013-02-01 14:00:00	QQQ	ETF	67.74	67.749	67.6	67.625	2583446.0
2013-02-01 15:00:00	QQQ	ETF	67.63	67.66	67.52	67.64	4382857.0
2013-02-01 16:00:00	QQQ	ETF	67.65	67.6681	66.857	67.65	15432545.0
2013-02-01 17:00:00	QQQ	ETF	67.64	67.64	66.857	67.64	1505467.0
2013-02-01 18:00:00	QQQ	ETF	67.63	67.63	67.5499	67.5499	600.0
2013-02-01 19:00:00	QQQ	ETF	67.68	67.77	67.64	67.64	3800.0
2013-02-01 04:00:00	IWM	ETF	89.99	89.99	89.99	89.99	129.0
2013-02-01 06:00:00	IWM	ETF	89.92	89.92	89.6	89.6	200.0
2013-02-01 07:00:00	IWM	ETF	89.95	90.0	89.92	90.0	58885.0
2013-02-01 08:00:00	IWM	ETF	90.0	90.19	89.58	90.13	1191393.0
2013-02-01 09:00:00	IWM	ETF	90.13	90.13	89.62	89.93	4360795.0
2013-02-01 10:00:00	IWM	ETF	89.93	90.31	89.9	90.2	6809228.0
2013-02-01 11:00:00	IWM	ETF	90.2	90.46	90.15	90.45	2983399.0
2013-02-01 12:00:00	IWM	ETF	90.46	90.68	90.44	90.61	3150250.0
2013-02-01 13:00:00	IWM	ETF	90.61	90.6301	90.54	90.6	2129059.0
2013-02-01 14:00:00	IWM	ETF	90.6	90.62	90.44	90.5	2173554.0
2013-02-01 15:00:00	IWM	ETF	90.5	90.7	90.37	90.38	6836434.0
2013-02-01 16:00:00	IWM	ETF	90.38	90.48	90.28	90.37	1810426.0
2013-02-01 17:00:00	IWM	ETF	90.37	90.39	90.36	90.39	6066.0
2013-02-01 18:00:00	IWM	ETF	90.35	90.35	90.35	90.35	400.0
2013-02-01 19:00:00	IWM	ETF	90.35	90.4	90.35	90.4	2000.0
2013-02-01 07:00:00	DIA	ETF	138.86	138.86	138.86	138.86	100.0
2013-02-01 08:00:00	DIA	ETF	138.81	139.44	138.81	139.36	27937.0
2013-02-01 09:00:00	DIA	ETF	139.35	139.38	139.04	139.21	874037.0
2013-02-01 10:00:00	DIA	ETF	139.21	139.716	139.16	139.68	1511536.0
2013-02-01 11:00:00	DIA	ETF	139.69	139.75	139.57	139.71	632610.0

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

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