PREVIEW / etf_1hour / 2011-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-22.parquet
  size:    181 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-11-22 04:00:00	SPY	ETF	120.07	120.12	119.7	119.7	2684.0
2011-11-22 05:00:00	SPY	ETF	119.99	120.15	119.99	120.15	10100.0
2011-11-22 06:00:00	SPY	ETF	120.15	120.47	120.15	120.3	90144.0
2011-11-22 07:00:00	SPY	ETF	120.29	120.4	119.7	119.93	422122.0
2011-11-22 08:00:00	SPY	ETF	119.9	120.44	118.99	119.3	3252952.0
2011-11-22 09:00:00	SPY	ETF	119.3	120.03	119.165	119.75	23909535.0
2011-11-22 10:00:00	SPY	ETF	119.76	119.9	118.75	118.92	35674036.0
2011-11-22 11:00:00	SPY	ETF	118.92	119.12	118.52	118.89	33256024.0
2011-11-22 12:00:00	SPY	ETF	118.9	119.83	118.89	119.725	36137303.0
2011-11-22 13:00:00	SPY	ETF	119.73	120.1	119.46	119.53	21173846.0
2011-11-22 14:00:00	SPY	ETF	119.52	119.68	119.01	119.16	17756537.0
2011-11-22 15:00:00	SPY	ETF	119.16	119.47	118.99	119.17	32677522.0
2011-11-22 16:00:00	SPY	ETF	119.18	119.6802	118.1846	118.86	11140918.0
2011-11-22 17:00:00	SPY	ETF	118.86	118.91	118.83	118.9	92569.0
2011-11-22 18:00:00	SPY	ETF	118.91	119.06	118.71	119.01	192214.0
2011-11-22 19:00:00	SPY	ETF	119.02	119.19	118.7	118.79	328614.0
2011-11-22 04:00:00	QQQ	ETF	54.39	54.39	54.19	54.19	2677.0
2011-11-22 06:00:00	QQQ	ETF	54.45	54.53	54.45	54.5	30600.0
2011-11-22 07:00:00	QQQ	ETF	54.49	54.5	54.26	54.35	130294.0
2011-11-22 08:00:00	QQQ	ETF	54.35	54.37	54.0	54.14	984656.0
2011-11-22 09:00:00	QQQ	ETF	54.14	54.59	54.1	54.47	5339368.0
2011-11-22 10:00:00	QQQ	ETF	54.47	54.54	53.95	54.03	9469149.0
2011-11-22 11:00:00	QQQ	ETF	54.03	54.1786	53.87	54.16	6964451.0
2011-11-22 12:00:00	QQQ	ETF	54.17	54.51	54.16	54.51	7963327.0
2011-11-22 13:00:00	QQQ	ETF	54.51	54.68	54.41	54.519	3492299.0
2011-11-22 14:00:00	QQQ	ETF	54.51	54.61	54.38	54.43	4464388.0
2011-11-22 15:00:00	QQQ	ETF	54.43	54.6171	54.32	54.51	8091683.0
2011-11-22 16:00:00	QQQ	ETF	54.51	54.52	54.31	54.45	1811317.0
2011-11-22 17:00:00	QQQ	ETF	54.45	54.46	54.4	54.45	6047.0
2011-11-22 18:00:00	QQQ	ETF	54.45	54.52	54.4	54.51	22036.0
2011-11-22 19:00:00	QQQ	ETF	54.48	54.48	54.42	54.42	13779.0
2011-11-22 05:00:00	IWM	ETF	70.52	70.52	70.52	70.52	100.0
2011-11-22 06:00:00	IWM	ETF	70.78	70.78	70.75	70.76	5300.0
2011-11-22 07:00:00	IWM	ETF	70.68	70.68	70.33	70.44	43999.0
2011-11-22 08:00:00	IWM	ETF	70.4	70.72	69.73	70.02	859476.0
2011-11-22 09:00:00	IWM	ETF	69.97	70.63	69.97	70.4	6046626.0
2011-11-22 10:00:00	IWM	ETF	70.4	70.53	69.53	69.63	8385696.0
2011-11-22 11:00:00	IWM	ETF	69.64	69.74	69.3	69.55	7484541.0
2011-11-22 12:00:00	IWM	ETF	69.55	70.12	69.53	70.1	8993054.0
2011-11-22 13:00:00	IWM	ETF	70.1059	70.56	69.98	70.03	5031291.0
2011-11-22 14:00:00	IWM	ETF	70.03	70.147	69.67	69.76	5598659.0
2011-11-22 15:00:00	IWM	ETF	69.76	69.9	69.59	69.66	10023816.0
2011-11-22 16:00:00	IWM	ETF	69.66	70.3	69.26	69.49	1213484.0
2011-11-22 17:00:00	IWM	ETF	69.51	69.55	69.5	69.55	27247.0
2011-11-22 18:00:00	IWM	ETF	69.57	69.61	69.57	69.61	5200.0
2011-11-22 19:00:00	IWM	ETF	69.6	69.6	69.47	69.47	7398.0
2011-11-22 05:00:00	DIA	ETF	115.3	115.3	115.3	115.3	849.0
2011-11-22 07:00:00	DIA	ETF	116.05	116.05	115.68	115.68	200.0
2011-11-22 08:00:00	DIA	ETF	115.53	115.53	114.76	114.95	4196.0
2011-11-22 09:00:00	DIA	ETF	114.89	115.35	114.69	115.13	695955.0

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

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