PREVIEW / etf_1hour / 2011-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-08.parquet
  size:    178 KB
  rows:    5,470

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-09-08 04:00:00	SPY	ETF	120.01	120.4	119.88	120.4	10531.0
2011-09-08 05:00:00	SPY	ETF	120.4	120.52	120.4	120.52	400.0
2011-09-08 06:00:00	SPY	ETF	120.65	120.8	120.4	120.6	32600.0
2011-09-08 07:00:00	SPY	ETF	120.42	120.59	119.87	119.97	915010.0
2011-09-08 08:00:00	SPY	ETF	119.99	120.5	119.16	119.53	6620460.0
2011-09-08 09:00:00	SPY	ETF	119.52	120.37	119.41	119.77	29431063.0
2011-09-08 10:00:00	SPY	ETF	119.77	120.76	119.38	120.73	32155785.0
2011-09-08 11:00:00	SPY	ETF	120.73	120.94	119.91	120.021	32196950.0
2011-09-08 12:00:00	SPY	ETF	120.02	120.35	119.79	120.31	17282728.0
2011-09-08 13:00:00	SPY	ETF	120.32	120.39	119.1	119.41	34654646.0
2011-09-08 14:00:00	SPY	ETF	119.41	119.72	119.0	119.32	32243438.0
2011-09-08 15:00:00	SPY	ETF	119.33	119.59	118.77	119.03	47023066.0
2011-09-08 16:00:00	SPY	ETF	119.02	120.783	118.89	119.09	9705577.0
2011-09-08 17:00:00	SPY	ETF	119.1	119.22	119.06	119.07	846360.0
2011-09-08 18:00:00	SPY	ETF	119.07	119.38	119.02	119.32	398819.0
2011-09-08 19:00:00	SPY	ETF	119.31	119.39	118.53	118.8	645001.0
2011-09-08 05:00:00	QQQ	ETF	54.81	54.85	54.81	54.83	1400.0
2011-09-08 07:00:00	QQQ	ETF	54.75	54.83	54.53	54.54	41900.0
2011-09-08 08:00:00	QQQ	ETF	54.57	54.58	54.22	54.38	1115357.0
2011-09-08 09:00:00	QQQ	ETF	54.36	54.75	54.33	54.53	7768705.0
2011-09-08 10:00:00	QQQ	ETF	54.52	55.1	54.33	55.08	7699259.0
2011-09-08 11:00:00	QQQ	ETF	55.08	55.1684	54.67	54.71	6381710.0
2011-09-08 12:00:00	QQQ	ETF	54.71	54.86	54.56	54.8	4319173.0
2011-09-08 13:00:00	QQQ	ETF	54.8	54.85	54.33	54.5	6873155.0
2011-09-08 14:00:00	QQQ	ETF	54.4901	54.64	54.33	54.51	6164046.0
2011-09-08 15:00:00	QQQ	ETF	54.501	54.62	54.21	54.41	8335027.0
2011-09-08 16:00:00	QQQ	ETF	54.39	54.53	54.36	54.45	1309774.0
2011-09-08 17:00:00	QQQ	ETF	54.44	54.48	54.38	54.38	34102.0
2011-09-08 18:00:00	QQQ	ETF	54.43	54.54	54.38	54.52	33494.0
2011-09-08 19:00:00	QQQ	ETF	54.5	54.54	54.14	54.32	165177.0
2011-09-08 04:00:00	IWM	ETF	70.57	70.6	70.57	70.6	700.0
2011-09-08 05:00:00	IWM	ETF	70.97	71.22	70.97	71.22	700.0
2011-09-08 06:00:00	IWM	ETF	71.37	71.37	70.95	70.95	4200.0
2011-09-08 07:00:00	IWM	ETF	71.1	71.1	70.96	70.97	107700.0
2011-09-08 08:00:00	IWM	ETF	71.3	71.31	70.16	70.41	1252194.0
2011-09-08 09:00:00	IWM	ETF	70.41	71.24	70.18	70.59	8231632.0
2011-09-08 10:00:00	IWM	ETF	70.5802	71.18	70.28	71.15	9408069.0
2011-09-08 11:00:00	IWM	ETF	71.15	71.3	70.46	70.5	6297404.0
2011-09-08 12:00:00	IWM	ETF	70.5	70.72	70.34	70.6915	4412916.0
2011-09-08 13:00:00	IWM	ETF	70.7	70.8	69.79	70.02	7292648.0
2011-09-08 14:00:00	IWM	ETF	70.02	70.19	69.5	69.65	8016710.0
2011-09-08 15:00:00	IWM	ETF	69.66	70.01	69.18	69.58	13325749.0
2011-09-08 16:00:00	IWM	ETF	69.58	69.81	69.5	69.7	6174759.0
2011-09-08 17:00:00	IWM	ETF	69.7	69.82	69.63	69.63	44848.0
2011-09-08 18:00:00	IWM	ETF	69.7	70.2514	69.64	69.73	33135.0
2011-09-08 19:00:00	IWM	ETF	69.76	69.87	69.39	69.45	33200.0
2011-09-08 05:00:00	DIA	ETF	114.8	114.8	114.8	114.8	100.0
2011-09-08 07:00:00	DIA	ETF	115.0	115.0	115.0	115.0	2500.0
2011-09-08 08:00:00	DIA	ETF	113.76	113.79	113.13	113.39	97301.0
2011-09-08 09:00:00	DIA	ETF	113.37	114.07	113.28	113.795	1076102.0

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

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