PREVIEW / etf_1hour / 2013-01-29

all etf 1-hour files

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

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-29 05:00:00	SPY	ETF	149.87	149.87	149.59	149.6	198485.0
2013-01-29 06:00:00	SPY	ETF	149.59	149.65	149.5	149.56	255179.0
2013-01-29 07:00:00	SPY	ETF	149.57	149.65	149.5	149.58	186991.0
2013-01-29 08:00:00	SPY	ETF	149.58	149.79	149.51	149.72	1389908.0
2013-01-29 09:00:00	SPY	ETF	149.73	150.18	149.65	149.99	11940724.0
2013-01-29 10:00:00	SPY	ETF	149.98	150.18	149.67	150.09	20126422.0
2013-01-29 11:00:00	SPY	ETF	150.1	150.48	150.02	150.4	13593430.0
2013-01-29 12:00:00	SPY	ETF	150.3902	150.58	150.31	150.505	9785599.0
2013-01-29 13:00:00	SPY	ETF	150.5	150.68	150.49	150.63	10314704.0
2013-01-29 14:00:00	SPY	ETF	150.625	150.71	150.54	150.58	6569432.0
2013-01-29 15:00:00	SPY	ETF	150.58	150.85	150.52	150.67	18791679.0
2013-01-29 16:00:00	SPY	ETF	150.67	150.92	149.919	150.86	7679517.0
2013-01-29 17:00:00	SPY	ETF	150.87	150.94	150.86	150.89	172042.0
2013-01-29 18:00:00	SPY	ETF	150.87	150.87	150.78	150.81	50888.0
2013-01-29 19:00:00	SPY	ETF	150.8	150.89	150.8	150.88	37014.0
2013-01-29 04:00:00	QQQ	ETF	67.05	67.05	67.05	67.05	800.0
2013-01-29 05:00:00	QQQ	ETF	66.95	66.95	66.95	66.95	100.0
2013-01-29 06:00:00	QQQ	ETF	66.9	66.92	66.87	66.92	2250.0
2013-01-29 07:00:00	QQQ	ETF	66.93	66.95	66.87	66.91	106265.0
2013-01-29 08:00:00	QQQ	ETF	66.91	67.05	66.9	66.99	188737.0
2013-01-29 09:00:00	QQQ	ETF	67.0	67.07	66.85	66.95	5772523.0
2013-01-29 10:00:00	QQQ	ETF	66.96	67.0	66.63	66.93	8205703.0
2013-01-29 11:00:00	QQQ	ETF	66.93	67.215	66.88	67.19	4858254.0
2013-01-29 12:00:00	QQQ	ETF	67.18	67.19	67.02	67.14	1629737.0
2013-01-29 13:00:00	QQQ	ETF	67.14	67.19	67.0602	67.1521	2249005.0
2013-01-29 14:00:00	QQQ	ETF	67.16	67.2	67.07	67.11	1856356.0
2013-01-29 15:00:00	QQQ	ETF	67.11	67.31	67.09	67.16	3974310.0
2013-01-29 16:00:00	QQQ	ETF	67.17	67.35	67.04	67.32	3943239.0
2013-01-29 17:00:00	QQQ	ETF	67.33	67.36	66.91	67.36	197258.0
2013-01-29 18:00:00	QQQ	ETF	67.34	67.34	67.29	67.32	28980.0
2013-01-29 19:00:00	QQQ	ETF	67.32	67.34	67.31	67.34	15050.0
2013-01-29 05:00:00	IWM	ETF	89.85	89.85	89.85	89.85	500.0
2013-01-29 06:00:00	IWM	ETF	89.76	89.79	89.75	89.79	5799.0
2013-01-29 07:00:00	IWM	ETF	89.77	89.78	89.74	89.75	139300.0
2013-01-29 08:00:00	IWM	ETF	89.74	89.97	89.74	89.88	117446.0
2013-01-29 09:00:00	IWM	ETF	89.87	90.06	89.78	89.89	2562067.0
2013-01-29 10:00:00	IWM	ETF	89.9	90.03	89.6499	89.98	4930951.0
2013-01-29 11:00:00	IWM	ETF	89.98	90.1601	89.91	89.99	3869698.0
2013-01-29 12:00:00	IWM	ETF	89.98	90.07	89.85	90.05	2186249.0
2013-01-29 13:00:00	IWM	ETF	90.05	90.07	89.89	89.96	2574003.0
2013-01-29 14:00:00	IWM	ETF	89.96	90.0	89.75	89.775	2547128.0
2013-01-29 15:00:00	IWM	ETF	89.775	90.1	89.72	90.05	6967701.0
2013-01-29 16:00:00	IWM	ETF	90.05	90.23	89.9576	90.15	1505446.0
2013-01-29 17:00:00	IWM	ETF	90.19	90.22	90.18	90.22	102400.0
2013-01-29 18:00:00	IWM	ETF	90.2	90.21	90.15	90.15	5507.0
2013-01-29 19:00:00	IWM	ETF	90.16	90.18	90.16	90.18	672.0
2013-01-29 08:00:00	DIA	ETF	138.29	138.45	138.28	138.45	6770.0
2013-01-29 09:00:00	DIA	ETF	138.41	138.9	138.4	138.73	329170.0
2013-01-29 10:00:00	DIA	ETF	138.71	138.91	138.4999	138.83	627877.0
2013-01-29 11:00:00	DIA	ETF	138.84	139.15	138.74	139.07	986902.0

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

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