PREVIEW / etf_1hour / 2013-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-09.parquet
  size:    190 KB
  rows:    5,998

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-09 04:00:00	SPY	ETF	145.88	145.88	145.63	145.63	10344.0
2013-01-09 05:00:00	SPY	ETF	145.59	145.69	145.56	145.66	20300.0
2013-01-09 06:00:00	SPY	ETF	145.59	145.64	145.57	145.64	45200.0
2013-01-09 07:00:00	SPY	ETF	145.62	145.87	145.6	145.84	204322.0
2013-01-09 08:00:00	SPY	ETF	145.85	145.9	145.62	145.87	437933.0
2013-01-09 09:00:00	SPY	ETF	145.88	146.2	145.8	146.16	12128820.0
2013-01-09 10:00:00	SPY	ETF	146.15	146.32	146.0101	146.1181	13773256.0
2013-01-09 11:00:00	SPY	ETF	146.11	146.23	146.0	146.08	8662497.0
2013-01-09 12:00:00	SPY	ETF	146.08	146.18	145.74	145.91	9136296.0
2013-01-09 13:00:00	SPY	ETF	145.9	146.0	145.78	145.91	9720248.0
2013-01-09 14:00:00	SPY	ETF	145.9099	146.03	145.7	145.74	7423852.0
2013-01-09 15:00:00	SPY	ETF	145.73	145.98	145.64	145.95	16658958.0
2013-01-09 16:00:00	SPY	ETF	145.96	146.0595	145.5653	146.0	9420414.0
2013-01-09 17:00:00	SPY	ETF	145.99	146.07	145.98	146.06	251047.0
2013-01-09 18:00:00	SPY	ETF	146.04	146.05	145.89	145.91	120359.0
2013-01-09 19:00:00	SPY	ETF	145.91	145.97	145.9	145.94	38750.0
2013-01-09 04:00:00	QQQ	ETF	66.6	66.6	66.6	66.6	250.0
2013-01-09 05:00:00	QQQ	ETF	66.58	66.58	66.58	66.58	100.0
2013-01-09 06:00:00	QQQ	ETF	66.56	66.56	66.56	66.56	5000.0
2013-01-09 07:00:00	QQQ	ETF	66.53	66.54	66.53	66.54	2400.0
2013-01-09 08:00:00	QQQ	ETF	66.62	66.67	66.56	66.66	152105.0
2013-01-09 09:00:00	QQQ	ETF	66.65	66.8	66.55	66.749	3184879.0
2013-01-09 10:00:00	QQQ	ETF	66.75	66.95	66.67	66.87	3294143.0
2013-01-09 11:00:00	QQQ	ETF	66.87	66.92	66.79	66.81	1856468.0
2013-01-09 12:00:00	QQQ	ETF	66.81	66.86	66.65	66.74	2456879.0
2013-01-09 13:00:00	QQQ	ETF	66.735	66.85	66.68	66.8021	1576429.0
2013-01-09 14:00:00	QQQ	ETF	66.81	66.88	66.7	66.73	2313224.0
2013-01-09 15:00:00	QQQ	ETF	66.72	66.78	66.62	66.76	5144000.0
2013-01-09 16:00:00	QQQ	ETF	66.77	66.8	66.5376	66.79	2965344.0
2013-01-09 17:00:00	QQQ	ETF	66.7646	66.79	66.7646	66.78	200920.0
2013-01-09 18:00:00	QQQ	ETF	66.78	66.78	66.74	66.74	3760.0
2013-01-09 19:00:00	QQQ	ETF	66.76	66.77	66.75	66.77	7942.0
2013-01-09 05:00:00	IWM	ETF	87.0	87.0	87.0	87.0	170.0
2013-01-09 07:00:00	IWM	ETF	86.99	87.09	86.99	87.09	24250.0
2013-01-09 08:00:00	IWM	ETF	87.09	87.1	87.0	87.07	96141.0
2013-01-09 09:00:00	IWM	ETF	87.09	87.27	86.96	87.235	2846841.0
2013-01-09 10:00:00	IWM	ETF	87.23	87.35	87.16	87.25	3647259.0
2013-01-09 11:00:00	IWM	ETF	87.24	87.35	87.2	87.26	1725484.0
2013-01-09 12:00:00	IWM	ETF	87.26	87.32	87.07	87.17	1890080.0
2013-01-09 13:00:00	IWM	ETF	87.17	87.3	87.11	87.25	1761853.0
2013-01-09 14:00:00	IWM	ETF	87.25	87.34	87.18	87.19	2007809.0
2013-01-09 15:00:00	IWM	ETF	87.19	87.32	87.14	87.26	5228478.0
2013-01-09 16:00:00	IWM	ETF	87.27	87.41	87.22	87.37	1153264.0
2013-01-09 17:00:00	IWM	ETF	87.39	87.43	87.39	87.4	4658.0
2013-01-09 18:00:00	IWM	ETF	87.28	87.34	87.28	87.34	599.0
2013-01-09 19:00:00	IWM	ETF	87.34	87.34	87.34	87.34	1000.0
2013-01-09 07:00:00	DIA	ETF	133.22	133.38	133.22	133.38	400.0
2013-01-09 08:00:00	DIA	ETF	133.37	133.42	133.3	133.4	11899.0
2013-01-09 09:00:00	DIA	ETF	133.41	133.84	133.39	133.8	395274.0
2013-01-09 10:00:00	DIA	ETF	133.808	133.94	133.74	133.839	362299.0

> showing 50 of 5,998 rows — these rows as CSV

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