PREVIEW / etf_1hour / 2013-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-10.parquet
  size:    196 KB
  rows:    6,171

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-01-10 04:00:00	SPY	ETF	146.19	146.42	146.19	146.41	33290.0
2013-01-10 05:00:00	SPY	ETF	146.45	146.45	146.35	146.38	18600.0
2013-01-10 06:00:00	SPY	ETF	146.35	146.36	146.29	146.35	49688.0
2013-01-10 07:00:00	SPY	ETF	146.33	146.48	146.28	146.48	265274.0
2013-01-10 08:00:00	SPY	ETF	146.48	146.86	146.29	146.72	1825072.0
2013-01-10 09:00:00	SPY	ETF	146.71	146.83	145.9517	146.65	15375988.0
2013-01-10 10:00:00	SPY	ETF	146.65	146.71	146.14	146.16	19136097.0
2013-01-10 11:00:00	SPY	ETF	146.16	146.32	145.97	146.31	14302396.0
2013-01-10 12:00:00	SPY	ETF	146.3	146.59	146.23	146.58	7900599.0
2013-01-10 13:00:00	SPY	ETF	146.58	146.62	146.42	146.54	8298428.0
2013-01-10 14:00:00	SPY	ETF	146.55	146.89	146.41	146.81	12120294.0
2013-01-10 15:00:00	SPY	ETF	146.82	147.09	146.819	147.07	29103958.0
2013-01-10 16:00:00	SPY	ETF	147.06	147.23	145.9518	147.22	17947327.0
2013-01-10 17:00:00	SPY	ETF	147.22	147.37	145.9518	147.29	1294156.0
2013-01-10 18:00:00	SPY	ETF	147.29	147.46	147.25	147.33	156266.0
2013-01-10 19:00:00	SPY	ETF	147.33	147.33	147.21	147.22	64382.0
2013-01-10 06:00:00	QQQ	ETF	66.92	66.92	66.91	66.92	1600.0
2013-01-10 07:00:00	QQQ	ETF	66.92	67.03	66.89	67.03	24900.0
2013-01-10 08:00:00	QQQ	ETF	67.01	67.29	67.01	67.23	255263.0
2013-01-10 09:00:00	QQQ	ETF	67.24	67.27	67.07	67.165	5411664.0
2013-01-10 10:00:00	QQQ	ETF	67.17	67.19	66.74	66.76	8087479.0
2013-01-10 11:00:00	QQQ	ETF	66.765	66.81	66.55	66.75	5199719.0
2013-01-10 12:00:00	QQQ	ETF	66.75	66.82	66.68	66.79	2424946.0
2013-01-10 13:00:00	QQQ	ETF	66.79	66.87	66.74	66.83	1862332.0
2013-01-10 14:00:00	QQQ	ETF	66.83	67.09	66.73	67.02	3924225.0
2013-01-10 15:00:00	QQQ	ETF	67.01	67.19	67.01	67.15	6757317.0
2013-01-10 16:00:00	QQQ	ETF	67.15	67.216	66.8017	67.18	1444900.0
2013-01-10 17:00:00	QQQ	ETF	67.19	67.25	67.16	67.23	18520.0
2013-01-10 18:00:00	QQQ	ETF	67.22	67.29	67.22	67.25	17600.0
2013-01-10 19:00:00	QQQ	ETF	67.24	67.25	67.19	67.21	5640.0
2013-01-10 04:00:00	IWM	ETF	87.49	87.61	87.49	87.61	543.0
2013-01-10 05:00:00	IWM	ETF	87.54	87.54	87.54	87.54	270.0
2013-01-10 06:00:00	IWM	ETF	87.54	87.55	87.54	87.55	3000.0
2013-01-10 07:00:00	IWM	ETF	87.51	87.65	87.51	87.65	147948.0
2013-01-10 08:00:00	IWM	ETF	87.66	89.74	87.55	87.66	479906.0
2013-01-10 09:00:00	IWM	ETF	87.69	87.69	87.0901	87.32	8632205.0
2013-01-10 10:00:00	IWM	ETF	87.32	87.42	86.975	87.05	4875315.0
2013-01-10 11:00:00	IWM	ETF	87.04	87.15	86.95	87.085	2824677.0
2013-01-10 12:00:00	IWM	ETF	87.085	87.19	87.015	87.19	1966197.0
2013-01-10 13:00:00	IWM	ETF	87.19	87.239	87.08	87.17	2090121.0
2013-01-10 14:00:00	IWM	ETF	87.1699	87.41	87.1	87.38	2485539.0
2013-01-10 15:00:00	IWM	ETF	87.39	87.55	87.37	87.44	5645255.0
2013-01-10 16:00:00	IWM	ETF	87.44	87.56	87.281	87.55	1781470.0
2013-01-10 17:00:00	IWM	ETF	87.54	87.59	87.5	87.55	94429.0
2013-01-10 18:00:00	IWM	ETF	87.6	87.6	87.6	87.6	130.0
2013-01-10 19:00:00	IWM	ETF	87.55	87.55	87.5	87.5	1079.0
2013-01-10 07:00:00	DIA	ETF	134.01	134.02	134.01	134.02	2100.0
2013-01-10 08:00:00	DIA	ETF	134.05	134.25	134.01	134.17	16850.0
2013-01-10 09:00:00	DIA	ETF	134.21	134.32	134.0	134.2	563021.0
2013-01-10 10:00:00	DIA	ETF	134.21	134.25	133.74	133.74	765613.0

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

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