PREVIEW / etf_daily / 2011-01-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-28.parquet
  size:    35 KB
  rows:    826

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2011-01-28	SPY	ETF	130.14	130.35	127.51	127.72	295637300.0
2011-01-28	QQQ	ETF	57.16	57.22	55.47	55.73	123359814.0
2011-01-28	IWM	ETF	79.31	79.45	77.33	77.41	91023700.0
2011-01-28	DIA	ETF	119.66	119.86	117.76	118.02	17156100.0
2011-01-28	GLD	ETF	127.97	131.48	127.95	130.28	28091500.0
2011-01-28	TLT	ETF	90.81	92.28	90.77	91.92	11993200.0
2011-01-28	AADR	ETF	30.1	30.1	30.06	30.06	700.0
2011-01-28	AAXJ	ETF	62.65	62.72	61.01	61.15	691400.0
2011-01-28	ACWI	ETF	47.89	47.89	46.81	46.83	443000.0
2011-01-28	ACWX	ETF	44.8	44.86	43.88	43.94	84252.0
2011-01-28	ADRE	ETF	46.85	46.85	45.6619	45.84	81519.0
2011-01-28	AFK	ETF	33.63	33.68	32.141	32.3	196508.0
2011-01-28	AGG	ETF	105.6	105.97	105.58	105.86	783100.0
2011-01-28	AGQ	ETF	234.98	257.96	234.44	255.98	868200.0
2011-01-28	AGZ	ETF	109.85	109.99	109.624	109.78	13583.0
2011-01-28	AIA	ETF	48.39	48.48	47.26	47.32	116184.0
2011-01-28	AIQ	ETF	21.65	21.65	20.8	20.8	26692.0
2011-01-28	AIS	ETF	1.61	1.61	1.56	1.56	373871.0
2011-01-28	AIVI	ETF	45.92	45.92	44.94	45.04	88400.0
2011-01-28	AMJ	ETF	37.52	37.6	37.042	37.11	633283.0
2011-01-28	AMLP	ETF	81.7	81.7	81.05	81.15	110400.0
2011-01-28	AOA	ETF	35.12	35.13	34.46	34.51	26600.0
2011-01-28	AOK	ETF	28.96	29.02	28.86	28.87	7909.0
2011-01-28	AOM	ETF	30.26	30.28	30.01	30.0101	39975.0
2011-01-28	AOR	ETF	32.05	32.05	31.67	31.694	14950.0
2011-01-28	ARB	ETF	41.3	41.34	40.29	40.5	145361.0
2011-01-28	BAB	ETF	24.97	25.1499	24.89	25.09	222527.0
2011-01-28	BAL	ETF	85.0	85.59	83.24	83.76	67611.0
2011-01-28	BALT	ETF	8.77	8.96	8.52	8.53	334699.0
2011-01-28	BBH	ETF	34.1433	34.38	33.5867	33.61	30900.0
2011-01-28	BIB	ETF	7.5637	7.5637	7.4287	7.4287	3200.0
2011-01-28	BICK	ETF	31.99	32.14	31.16	31.4	39236.0
2011-01-28	BIL	ETF	91.7	91.72	91.7	91.7	158550.0
2011-01-28	BIS	ETF	8022.4	8022.4	8022.4	8022.4	1.25
2011-01-28	BITS	ETF	28.56	28.56	27.92	28.0	1785.0
2011-01-28	BIV	ETF	82.7	83.31	82.7	83.24	137600.0
2011-01-28	BJK	ETF	32.65	32.65	31.83	31.85	45700.0
2011-01-28	BKF	ETF	48.01	48.1395	46.661	46.82	270318.0
2011-01-28	BLV	ETF	77.59	78.51	77.59	78.38	26000.0
2011-01-28	BMVP	ETF	15.15	15.17	14.86	14.87	21120.0
2011-01-28	BND	ETF	80.15	80.5	80.13	80.45	1006300.0
2011-01-28	BNO	ETF	32.455	33.17	32.455	33.105	41200.0
2011-01-28	BRF	ETF	53.4	53.4399	51.54	51.76	1464376.0
2011-01-28	BSCE	ETF	20.81	20.91	20.81	20.91	15057.0
2011-01-28	BSV	ETF	80.63	80.78	80.6	80.76	694200.0
2011-01-28	BTF	ETF	81.4	81.4	79.72999999999999	80.19999999999999	11429.6
2011-01-28	BWX	ETF	29.33	29.36	29.16	29.26	212014.0
2011-01-28	BWZ	ETF	37.78	38.148	37.531	37.71	29575.0
2011-01-28	BZQ	ETF	2611.2	2796.8	2609.6	2713.6	884.5
2011-01-28	CEF	ETF	17.99	18.96	17.98	18.86	1638400.0

> showing 50 of 826 rows — these rows as CSV

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