PREVIEW / etf_1hour / 2013-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-15.parquet
  size:    194 KB
  rows:    6,050

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-15 04:00:00	SPY	ETF	146.55	146.64	146.55	146.64	2100.0
2013-01-15 05:00:00	SPY	ETF	146.7	146.7	146.54	146.54	12806.0
2013-01-15 06:00:00	SPY	ETF	146.6	146.6	146.41	146.43	70475.0
2013-01-15 07:00:00	SPY	ETF	146.45	146.45	146.11	146.24	538919.0
2013-01-15 08:00:00	SPY	ETF	146.24	146.39	146.02	146.24	1101789.0
2013-01-15 09:00:00	SPY	ETF	146.23	146.5	146.2	146.46	13279000.0
2013-01-15 10:00:00	SPY	ETF	146.45	146.9315	146.36	146.62	13700103.0
2013-01-15 11:00:00	SPY	ETF	146.62	146.75	146.49	146.635	7993978.0
2013-01-15 12:00:00	SPY	ETF	146.63	146.93	146.63	146.805	6794892.0
2013-01-15 13:00:00	SPY	ETF	146.8	146.9315	146.59	146.65	8798046.0
2013-01-15 14:00:00	SPY	ETF	146.65	146.95	146.61	146.93	8311047.0
2013-01-15 15:00:00	SPY	ETF	146.93	147.21	146.925	147.04	18554672.0
2013-01-15 16:00:00	SPY	ETF	147.04	147.0879	146.35	147.03	10640679.0
2013-01-15 17:00:00	SPY	ETF	147.02	147.1	146.84	147.08	162752.0
2013-01-15 18:00:00	SPY	ETF	147.02	147.12	147.02	147.1	26603.0
2013-01-15 19:00:00	SPY	ETF	147.07	147.1	147.06	147.07	16461.0
2013-01-15 05:00:00	QQQ	ETF	66.85	66.86	66.85	66.86	2955.0
2013-01-15 06:00:00	QQQ	ETF	66.83	66.83	66.79	66.79	79450.0
2013-01-15 07:00:00	QQQ	ETF	66.75	66.76	66.68	66.72	43360.0
2013-01-15 08:00:00	QQQ	ETF	66.77	66.95	66.65	66.68	55785.0
2013-01-15 09:00:00	QQQ	ETF	66.69	66.71	66.3321	66.45	5045671.0
2013-01-15 10:00:00	QQQ	ETF	66.45	66.51	66.38	66.49	3157891.0
2013-01-15 11:00:00	QQQ	ETF	66.5	66.57	66.44	66.46	2842277.0
2013-01-15 12:00:00	QQQ	ETF	66.46	66.729	66.455	66.62	2532629.0
2013-01-15 13:00:00	QQQ	ETF	66.62	66.72	66.49	66.52	2898462.0
2013-01-15 14:00:00	QQQ	ETF	66.53	66.6	66.42	66.6	2318700.0
2013-01-15 15:00:00	QQQ	ETF	66.6	66.7	66.57	66.63	5528474.0
2013-01-15 16:00:00	QQQ	ETF	66.63	66.951	66.5756	66.64	4629504.0
2013-01-15 17:00:00	QQQ	ETF	66.65	67.0	66.63	66.75	223496.0
2013-01-15 18:00:00	QQQ	ETF	66.75	66.9	66.71	66.78	145125.0
2013-01-15 19:00:00	QQQ	ETF	66.76	66.77	66.72	66.72	16400.0
2013-01-15 04:00:00	IWM	ETF	86.88	86.88	86.86	86.86	299.0
2013-01-15 06:00:00	IWM	ETF	86.86	86.9	86.85	86.85	5500.0
2013-01-15 07:00:00	IWM	ETF	86.81	86.86	86.64	86.75	123570.0
2013-01-15 08:00:00	IWM	ETF	86.76	86.82	86.65	86.77	239751.0
2013-01-15 09:00:00	IWM	ETF	86.79	87.2	86.71	87.16	3914966.0
2013-01-15 10:00:00	IWM	ETF	87.15	87.42	87.09	87.37	3466537.0
2013-01-15 11:00:00	IWM	ETF	87.37	87.63	87.34	87.56	3047448.0
2013-01-15 12:00:00	IWM	ETF	87.57	87.77	87.57	87.64	1983158.0
2013-01-15 13:00:00	IWM	ETF	87.65	87.7101	87.49	87.54	1676115.0
2013-01-15 14:00:00	IWM	ETF	87.53	87.61	87.32	87.61	2733079.0
2013-01-15 15:00:00	IWM	ETF	87.61	87.885	87.61	87.74	6841416.0
2013-01-15 16:00:00	IWM	ETF	87.74	87.8268	87.7	87.79	1764301.0
2013-01-15 17:00:00	IWM	ETF	87.79	87.82	87.78	87.82	3910.0
2013-01-15 18:00:00	IWM	ETF	87.85	87.85	87.82	87.83	9530.0
2013-01-15 07:00:00	DIA	ETF	134.38	134.38	134.38	134.38	445.0
2013-01-15 08:00:00	DIA	ETF	134.34	134.45	134.34	134.36	2000.0
2013-01-15 09:00:00	DIA	ETF	134.36	134.66	134.24	134.56	496078.0
2013-01-15 10:00:00	DIA	ETF	134.6	134.72	134.48	134.65	394826.0
2013-01-15 11:00:00	DIA	ETF	134.67	134.78	134.6	134.71	225709.0

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

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