PREVIEW / etf_1hour / 2011-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-17.parquet
  size:    183 KB
  rows:    5,574

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
2011-05-17 04:00:00	SPY	ETF	133.09	133.5	133.09	133.31	4150.0
2011-05-17 05:00:00	SPY	ETF	133.31	133.61	133.31	133.44	44350.0
2011-05-17 06:00:00	SPY	ETF	133.5	133.67	133.46	133.46	27618.0
2011-05-17 07:00:00	SPY	ETF	133.5	133.5	133.15	133.2	544865.0
2011-05-17 08:00:00	SPY	ETF	133.16	133.37	132.63	132.75	2311939.0
2011-05-17 09:00:00	SPY	ETF	132.75	133.1	132.45	133.03	20919592.0
2011-05-17 10:00:00	SPY	ETF	133.02	133.35	132.65	132.8	29392609.0
2011-05-17 11:00:00	SPY	ETF	132.8	132.82	132.12	132.495	34293519.0
2011-05-17 12:00:00	SPY	ETF	132.491	132.85	132.35	132.48	17622632.0
2011-05-17 13:00:00	SPY	ETF	132.49	132.95	132.42	132.83	14812592.0
2011-05-17 14:00:00	SPY	ETF	132.83	133.22	132.565	133.2001	18975948.0
2011-05-17 15:00:00	SPY	ETF	133.2	133.22	132.86	133.19	37756397.0
2011-05-17 16:00:00	SPY	ETF	133.19	133.21	132.97	133.19	15403507.0
2011-05-17 17:00:00	SPY	ETF	133.18	133.22	133.15	133.15	221978.0
2011-05-17 18:00:00	SPY	ETF	133.17	133.26	133.14	133.2	88837.0
2011-05-17 19:00:00	SPY	ETF	133.25	133.27	133.18	133.25	50252.0
2011-05-17 04:00:00	QQQ	ETF	57.42	57.44	57.42	57.44	255.0
2011-05-17 05:00:00	QQQ	ETF	57.47	57.6	57.46	57.55	35900.0
2011-05-17 06:00:00	QQQ	ETF	57.57	57.57	57.52	57.52	9400.0
2011-05-17 07:00:00	QQQ	ETF	57.5	57.5	57.35	57.4	31382.0
2011-05-17 08:00:00	QQQ	ETF	57.4	57.53	57.18	57.18	522758.0
2011-05-17 09:00:00	QQQ	ETF	57.17	57.27	57.05	57.24	7450629.0
2011-05-17 10:00:00	QQQ	ETF	57.23	57.4899	57.1101	57.19	12239040.0
2011-05-17 11:00:00	QQQ	ETF	57.19	57.2	56.98	57.1401	11807111.0
2011-05-17 12:00:00	QQQ	ETF	57.15	57.38	57.1	57.17	7506152.0
2011-05-17 13:00:00	QQQ	ETF	57.17	57.39	57.15	57.33	6295249.0
2011-05-17 14:00:00	QQQ	ETF	57.33	57.51	57.215	57.5	5114986.0
2011-05-17 15:00:00	QQQ	ETF	57.509	57.57	57.42	57.56	8665076.0
2011-05-17 16:00:00	QQQ	ETF	57.55	57.61	57.45	57.61	2088700.0
2011-05-17 17:00:00	QQQ	ETF	57.61	57.63	57.58	57.6	33597.0
2011-05-17 18:00:00	QQQ	ETF	57.6	57.63	57.57	57.61	36577.0
2011-05-17 19:00:00	QQQ	ETF	57.63	57.63	57.6	57.6	5296.0
2011-05-17 04:00:00	IWM	ETF	82.3	82.3	82.28	82.28	500.0
2011-05-17 05:00:00	IWM	ETF	82.33	82.39	82.33	82.39	900.0
2011-05-17 06:00:00	IWM	ETF	82.41	82.43	82.35	82.35	400.0
2011-05-17 07:00:00	IWM	ETF	82.29	82.29	82.07	82.12	121837.0
2011-05-17 08:00:00	IWM	ETF	82.13	82.2799	81.61	81.67	691603.0
2011-05-17 09:00:00	IWM	ETF	81.67	82.18	81.5	82.06	9823628.0
2011-05-17 10:00:00	IWM	ETF	82.06	82.32	81.7	81.77	11641650.0
2011-05-17 11:00:00	IWM	ETF	81.7735	81.82	81.4	81.67	12949515.0
2011-05-17 12:00:00	IWM	ETF	81.6701	82.11	81.58	81.7	7582049.0
2011-05-17 13:00:00	IWM	ETF	81.7	81.96	81.64	81.88	4048905.0
2011-05-17 14:00:00	IWM	ETF	81.879	82.2	81.69	82.185	7603299.0
2011-05-17 15:00:00	IWM	ETF	82.19	82.21	81.85	82.04	10206993.0
2011-05-17 16:00:00	IWM	ETF	82.04	82.19	81.9359	82.17	1301433.0
2011-05-17 17:00:00	IWM	ETF	82.17	82.25	82.17	82.2	38400.0
2011-05-17 18:00:00	IWM	ETF	82.2	82.21	82.2	82.21	1600.0
2011-05-17 19:00:00	IWM	ETF	82.22	82.24	82.18	82.24	4000.0
2011-05-17 07:00:00	DIA	ETF	125.75	125.75	125.42	125.42	53500.0
2011-05-17 08:00:00	DIA	ETF	125.45	125.57	124.94	125.04	167774.0

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

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