PREVIEW / etf_1hour / 2011-11-28

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-28.parquet
  size:    186 KB
  rows:    5,822

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-28 04:00:00	SPY	ETF	118.53	119.32	118.53	119.24	47557.0
2011-11-28 05:00:00	SPY	ETF	119.28	119.48	119.0	119.11	264876.0
2011-11-28 06:00:00	SPY	ETF	119.16	119.22	118.98	119.1	288127.0
2011-11-28 07:00:00	SPY	ETF	119.1	119.23	118.9	119.09	1671154.0
2011-11-28 08:00:00	SPY	ETF	119.08	119.38	118.6	119.32	3295042.0
2011-11-28 09:00:00	SPY	ETF	119.32	120.0	119.31	119.93	33188998.0
2011-11-28 10:00:00	SPY	ETF	119.92	120.18	119.76	119.82	27734164.0
2011-11-28 11:00:00	SPY	ETF	119.81	120.12	119.47	119.88	19487840.0
2011-11-28 12:00:00	SPY	ETF	119.87	119.94	119.46	119.51	17682690.0
2011-11-28 13:00:00	SPY	ETF	119.5	119.97	119.41	119.51	21541925.0
2011-11-28 14:00:00	SPY	ETF	119.51	119.88	119.24	119.36	19179468.0
2011-11-28 15:00:00	SPY	ETF	119.37	119.75	118.82	119.71	45796514.0
2011-11-28 16:00:00	SPY	ETF	119.71	119.84	119.1946	119.71	15758192.0
2011-11-28 17:00:00	SPY	ETF	119.7	119.79	119.6775	119.75	269009.0
2011-11-28 18:00:00	SPY	ETF	119.73	119.74	119.54	119.61	450512.0
2011-11-28 19:00:00	SPY	ETF	119.57	119.6	119.28	119.41	465245.0
2011-11-28 04:00:00	QQQ	ETF	53.82	54.16	53.82	54.15	11826.0
2011-11-28 05:00:00	QQQ	ETF	54.17	54.21	54.08	54.09	5100.0
2011-11-28 06:00:00	QQQ	ETF	54.1	54.15	54.07	54.15	19708.0
2011-11-28 07:00:00	QQQ	ETF	54.13	54.13	54.03	54.08	73424.0
2011-11-28 08:00:00	QQQ	ETF	54.05	54.2	54.04	54.16	440653.0
2011-11-28 09:00:00	QQQ	ETF	54.17	54.67	54.13	54.6195	8695173.0
2011-11-28 10:00:00	QQQ	ETF	54.61	54.77	54.55	54.64	5905525.0
2011-11-28 11:00:00	QQQ	ETF	54.64	54.79	54.6	54.69	3703524.0
2011-11-28 12:00:00	QQQ	ETF	54.69	54.76	54.53	54.56	3285506.0
2011-11-28 13:00:00	QQQ	ETF	54.55	54.76	54.5	54.566	3999444.0
2011-11-28 14:00:00	QQQ	ETF	54.57	54.73	54.47	54.54	3906569.0
2011-11-28 15:00:00	QQQ	ETF	54.535	54.71	54.29	54.71	11005565.0
2011-11-28 16:00:00	QQQ	ETF	54.71	54.74	54.62	54.65	1562743.0
2011-11-28 17:00:00	QQQ	ETF	54.63	54.67	54.63	54.67	15473.0
2011-11-28 18:00:00	QQQ	ETF	54.65	54.65	54.58	54.63	80756.0
2011-11-28 19:00:00	QQQ	ETF	54.61	54.61	54.5	54.57	18260.0
2011-11-28 04:00:00	IWM	ETF	68.61	68.61	68.61	68.61	2039.0
2011-11-28 05:00:00	IWM	ETF	68.74	68.79	68.74	68.79	200.0
2011-11-28 06:00:00	IWM	ETF	68.75	68.75	68.6	68.6	17900.0
2011-11-28 07:00:00	IWM	ETF	68.7	68.75	68.6	68.67	205104.0
2011-11-28 08:00:00	IWM	ETF	68.65	68.86	68.57	68.81	806581.0
2011-11-28 09:00:00	IWM	ETF	68.81	69.67	68.79	69.48	12553080.0
2011-11-28 10:00:00	IWM	ETF	69.47	69.8357	69.4	69.65	7583151.0
2011-11-28 11:00:00	IWM	ETF	69.65	69.92	69.54	69.83	3719955.0
2011-11-28 12:00:00	IWM	ETF	69.83	69.89	69.42	69.426	3484078.0
2011-11-28 13:00:00	IWM	ETF	69.42	69.75	69.29	69.37	3799229.0
2011-11-28 14:00:00	IWM	ETF	69.36	69.69	69.32	69.4	3252213.0
2011-11-28 15:00:00	IWM	ETF	69.41	69.8	68.95	69.76	14516500.0
2011-11-28 16:00:00	IWM	ETF	69.77	69.91	69.65	69.75	4542595.0
2011-11-28 17:00:00	IWM	ETF	69.76	69.76	69.7	69.72	5060.0
2011-11-28 18:00:00	IWM	ETF	69.74	69.8	69.74	69.74	7845.0
2011-11-28 19:00:00	IWM	ETF	69.74	69.74	69.59	69.64	11220.0
2011-11-28 05:00:00	DIA	ETF	114.4	114.4	114.4	114.4	100.0
2011-11-28 07:00:00	DIA	ETF	114.5	114.5	114.3	114.45	26810.0

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

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