PREVIEW / etf_1hour / 2011-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-20.parquet
  size:    179 KB
  rows:    5,476

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-10-20 04:00:00	SPY	ETF	121.18	121.39	121.15	121.19	24459.0
2011-10-20 05:00:00	SPY	ETF	121.14	122.11	121.06	121.71	157074.0
2011-10-20 06:00:00	SPY	ETF	121.78	122.13	121.69	121.95	158268.0
2011-10-20 07:00:00	SPY	ETF	121.9	121.95	121.38	121.76	608738.0
2011-10-20 08:00:00	SPY	ETF	121.76	121.98	121.62	121.78	1503183.0
2011-10-20 09:00:00	SPY	ETF	121.77	121.94	120.87	121.04	33553499.0
2011-10-20 10:00:00	SPY	ETF	121.04	121.81	120.64	120.641	46286613.0
2011-10-20 11:00:00	SPY	ETF	120.64	120.82	120.09	120.27	33693677.0
2011-10-20 12:00:00	SPY	ETF	120.27	120.8	119.82	120.68	23865874.0
2011-10-20 13:00:00	SPY	ETF	120.69	121.71	120.6	121.18	45896923.0
2011-10-20 14:00:00	SPY	ETF	121.18	122.1	120.87	121.88	32862940.0
2011-10-20 15:00:00	SPY	ETF	121.88	121.96	121.2	121.63	33596615.0
2011-10-20 16:00:00	SPY	ETF	121.64	121.75	121.1022	121.56	7948629.0
2011-10-20 17:00:00	SPY	ETF	121.54	121.56	121.46	121.5	114149.0
2011-10-20 18:00:00	SPY	ETF	121.49	121.69	121.49	121.57	125506.0
2011-10-20 19:00:00	SPY	ETF	121.55	121.61	121.46	121.6	125778.0
2011-10-20 05:00:00	QQQ	ETF	56.9	57.25	56.9	57.1	3200.0
2011-10-20 06:00:00	QQQ	ETF	57.25	57.27	57.24	57.27	2800.0
2011-10-20 07:00:00	QQQ	ETF	57.25	57.25	56.97	57.16	115199.0
2011-10-20 08:00:00	QQQ	ETF	57.16	57.24	57.08	57.13	359461.0
2011-10-20 09:00:00	QQQ	ETF	57.12	57.16	56.44	56.57	9837505.0
2011-10-20 10:00:00	QQQ	ETF	56.555	56.86	56.37	56.38	10791726.0
2011-10-20 11:00:00	QQQ	ETF	56.38	56.38	56.0	56.1	7587879.0
2011-10-20 12:00:00	QQQ	ETF	56.1084	56.27	55.79	56.25	9914660.0
2011-10-20 13:00:00	QQQ	ETF	56.25	56.71	56.22	56.52	12958969.0
2011-10-20 14:00:00	QQQ	ETF	56.52	56.82	56.41	56.75	7280400.0
2011-10-20 15:00:00	QQQ	ETF	56.76	56.79	56.45	56.6	7628675.0
2011-10-20 16:00:00	QQQ	ETF	56.61	56.63	56.44	56.5	1201369.0
2011-10-20 17:00:00	QQQ	ETF	56.5	56.52	56.49	56.52	23590.0
2011-10-20 18:00:00	QQQ	ETF	56.5	56.54	56.48	56.53	45001.0
2011-10-20 19:00:00	QQQ	ETF	56.51	56.58	56.5	56.57	8740.0
2011-10-20 05:00:00	IWM	ETF	69.49	70.03	69.49	70.03	1500.0
2011-10-20 07:00:00	IWM	ETF	69.85	70.03	69.45	69.95	91200.0
2011-10-20 08:00:00	IWM	ETF	69.94	70.04	69.5	69.84	275362.0
2011-10-20 09:00:00	IWM	ETF	69.84	69.92	68.6	68.7	13434106.0
2011-10-20 10:00:00	IWM	ETF	68.7	69.51	68.53	68.53	14647888.0
2011-10-20 11:00:00	IWM	ETF	68.53	68.65	68.09	68.2	9059826.0
2011-10-20 12:00:00	IWM	ETF	68.21	68.5	67.745	68.46	8396790.0
2011-10-20 13:00:00	IWM	ETF	68.47	69.63	68.33	69.0899	14529590.0
2011-10-20 14:00:00	IWM	ETF	69.08	69.71	68.78	69.5754	8169941.0
2011-10-20 15:00:00	IWM	ETF	69.58	69.64	69.0	69.61	10361406.0
2011-10-20 16:00:00	IWM	ETF	69.61	69.62	69.31	69.39	4847195.0
2011-10-20 17:00:00	IWM	ETF	69.35	69.46	69.35	69.39	61987.0
2011-10-20 18:00:00	IWM	ETF	69.41	69.51	69.35	69.46	3173.0
2011-10-20 19:00:00	IWM	ETF	69.44	69.49	69.43	69.49	1067.0
2011-10-20 07:00:00	DIA	ETF	115.44	115.44	115.21	115.21	600.0
2011-10-20 08:00:00	DIA	ETF	115.45	115.84	115.32	115.38	12425.0
2011-10-20 09:00:00	DIA	ETF	115.44	115.47	114.77	114.9	957971.0
2011-10-20 10:00:00	DIA	ETF	114.9	115.61	114.6	114.6	1549577.0
2011-10-20 11:00:00	DIA	ETF	114.58	114.74	114.15	114.26	974467.0

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

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