PREVIEW / etf_1hour / 2013-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-04.parquet
  size:    207 KB
  rows:    6,463

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-09-04 04:00:00	SPY	ETF	164.34	164.48	164.22	164.35	18700.0
2013-09-04 05:00:00	SPY	ETF	164.36	164.51	164.27	164.29	38300.0
2013-09-04 06:00:00	SPY	ETF	164.27	164.47	164.27	164.44	32525.0
2013-09-04 07:00:00	SPY	ETF	164.47	164.58	164.34	164.4	143249.0
2013-09-04 08:00:00	SPY	ETF	164.46	164.5	164.13	164.28	909119.0
2013-09-04 09:00:00	SPY	ETF	164.3	164.96	164.135	164.85	12900743.0
2013-09-04 10:00:00	SPY	ETF	164.845	165.38	164.84	165.33	14337369.0
2013-09-04 11:00:00	SPY	ETF	165.33	165.92	165.3	165.9	12917119.0
2013-09-04 12:00:00	SPY	ETF	165.9001	165.94	165.78	165.83	7232963.0
2013-09-04 13:00:00	SPY	ETF	165.831	166.03	165.72	165.77	6511735.0
2013-09-04 14:00:00	SPY	ETF	165.78	165.94	165.68	165.88	8305901.0
2013-09-04 15:00:00	SPY	ETF	165.88	166.0	165.54	165.76	22348723.0
2013-09-04 16:00:00	SPY	ETF	165.75	166.03	165.73	166.02	6495930.0
2013-09-04 17:00:00	SPY	ETF	166.02	166.09	166.01	166.05	121510.0
2013-09-04 18:00:00	SPY	ETF	166.06	166.06	165.78	166.01	119687.0
2013-09-04 19:00:00	SPY	ETF	166.02	166.08	166.01	166.04	48095.0
2013-09-04 04:00:00	QQQ	ETF	75.81	75.89	75.75	75.81	29800.0
2013-09-04 05:00:00	QQQ	ETF	75.79	75.83	75.77	75.77	10100.0
2013-09-04 06:00:00	QQQ	ETF	75.75	75.87	75.74	75.87	13500.0
2013-09-04 07:00:00	QQQ	ETF	75.88	76.0	75.87	75.96	30145.0
2013-09-04 08:00:00	QQQ	ETF	75.99	75.99	75.86	75.97	244282.0
2013-09-04 09:00:00	QQQ	ETF	75.99	76.32	75.93	76.27	3349757.0
2013-09-04 10:00:00	QQQ	ETF	76.28	76.54	76.27	76.51	3765758.0
2013-09-04 11:00:00	QQQ	ETF	76.51	76.81	76.49	76.78	3422249.0
2013-09-04 12:00:00	QQQ	ETF	76.78	76.79	76.64	76.71	4627444.0
2013-09-04 13:00:00	QQQ	ETF	76.71	76.84	76.69	76.73	1318108.0
2013-09-04 14:00:00	QQQ	ETF	76.73	76.81	76.69	76.78	1584925.0
2013-09-04 15:00:00	QQQ	ETF	76.78	76.83	76.58	76.72	4746267.0
2013-09-04 16:00:00	QQQ	ETF	76.73	76.89	75.921	76.87	2010913.0
2013-09-04 17:00:00	QQQ	ETF	76.87	76.91	76.87	76.91	2930.0
2013-09-04 18:00:00	QQQ	ETF	76.89	76.89	76.87	76.87	3950.0
2013-09-04 19:00:00	QQQ	ETF	76.88	76.93	76.87	76.92	20800.0
2013-09-04 07:00:00	IWM	ETF	101.21	101.22	101.08	101.08	10500.0
2013-09-04 08:00:00	IWM	ETF	101.07	101.07	100.87	100.97	59610.0
2013-09-04 09:00:00	IWM	ETF	101.03	101.4	100.745	101.22	3112943.0
2013-09-04 10:00:00	IWM	ETF	101.22	101.8	101.22	101.68	3235098.0
2013-09-04 11:00:00	IWM	ETF	101.68	102.0	101.65	102.0	3414672.0
2013-09-04 12:00:00	IWM	ETF	101.99	102.01	101.71	101.76	2336087.0
2013-09-04 13:00:00	IWM	ETF	101.76	101.97	101.7	101.74	1423266.0
2013-09-04 14:00:00	IWM	ETF	101.74	101.91	101.7	101.83	2381474.0
2013-09-04 15:00:00	IWM	ETF	101.83	101.96	101.63	101.95	5126626.0
2013-09-04 16:00:00	IWM	ETF	101.95	102.07	101.8495	102.05	1034575.0
2013-09-04 17:00:00	IWM	ETF	102.04	102.09	102.03	102.07	17404.0
2013-09-04 18:00:00	IWM	ETF	102.07	102.09	102.07	102.09	400.0
2013-09-04 19:00:00	IWM	ETF	102.09	102.09	102.09	102.09	1000.0
2013-09-04 07:00:00	DIA	ETF	148.1	148.1	148.1	148.1	5500.0
2013-09-04 08:00:00	DIA	ETF	148.0	148.0	147.89	147.95	2551.0
2013-09-04 09:00:00	DIA	ETF	148.05	148.41	147.76	148.34	412899.0
2013-09-04 10:00:00	DIA	ETF	148.36	148.89	148.36	148.87	635657.0
2013-09-04 11:00:00	DIA	ETF	148.88	149.32	148.85	149.3	531200.0

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

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