PREVIEW / etf_daily / 2011-01-20

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-20.parquet
  size:    35 KB
  rows:    824

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-20	SPY	ETF	127.96	128.4	127.13	128.08	175745700.0
2011-01-20	QQQ	ETF	56.3	56.35	55.68	56.11	92357777.0
2011-01-20	IWM	ETF	78.14	78.54	77.34	77.71	79653000.0
2011-01-20	DIA	ETF	117.84	118.34	117.33	118.12	10935600.0
2011-01-20	GLD	ETF	131.76	132.1	131.04	131.2	24362900.0
2011-01-20	TLT	ETF	91.5	91.61	90.39	90.8	14203400.0
2011-01-20	AADR	ETF	29.77	29.77	29.51	29.57	300.0
2011-01-20	AAXJ	ETF	63.5	63.5	62.6	63.08	1063300.0
2011-01-20	ACWI	ETF	47.36	47.36	46.87	47.24	536400.0
2011-01-20	ACWX	ETF	44.32	44.348	43.89	44.22	80077.0
2011-01-20	ADRE	ETF	47.74	47.74	47.04	47.43	54839.0
2011-01-20	AFK	ETF	35.35	35.35	34.71	34.83	71518.0
2011-01-20	AGG	ETF	105.51	105.58	105.2	105.28	846300.0
2011-01-20	AGQ	ETF	256.22	256.48	247.6	249.24	674300.0
2011-01-20	AGZ	ETF	109.75	109.75	109.43	109.57	21849.0
2011-01-20	AIA	ETF	48.17	48.17	47.67	48.04	26736.0
2011-01-20	AIQ	ETF	20.0	20.45	20.0	20.25	25130.0
2011-01-20	AIS	ETF	1.59	1.611	1.53	1.57	549007.0
2011-01-20	AIVI	ETF	44.72	45.11	44.63	45.04	22500.0
2011-01-20	AMJ	ETF	36.67	36.78	35.68	36.07	2191008.0
2011-01-20	AMLP	ETF	80.5	80.7	79.3	79.9	118820.0
2011-01-20	AOA	ETF	34.7	34.71	34.43	34.61	23000.0
2011-01-20	AOK	ETF	28.88	28.88	28.8	28.8	6085.0
2011-01-20	AOM	ETF	30.01	30.108	29.94	29.98	16631.0
2011-01-20	AOR	ETF	31.73	31.73	31.595	31.6799	5696.0
2011-01-20	ARB	ETF	40.65	41.11	39.768	40.27	315367.0
2011-01-20	BAB	ETF	25.02	25.02	24.83	24.93	162623.0
2011-01-20	BAL	ETF	75.44	78.99	75.13	77.15	50757.0
2011-01-20	BALT	ETF	10.18	10.36	10.11	10.13	223864.0
2011-01-20	BBH	ETF	34.3333	34.5833	34.27	34.4967	26100.0
2011-01-20	BIB	ETF	7.6363	7.7	7.6363	7.685	12360.0
2011-01-20	BICK	ETF	32.43	32.595	32.18	32.496	13602.0
2011-01-20	BIL	ETF	91.72	91.72	91.7	91.72	99650.0
2011-01-20	BIS	ETF	7864.0	7864.0	7864.0	7864.0	3.94
2011-01-20	BITS	ETF	28.8	29.08	28.64	28.8	3645.0
2011-01-20	BIV	ETF	82.6	82.7	82.19	82.3	100000.0
2011-01-20	BJK	ETF	32.79	32.84	32.4	32.78	22000.0
2011-01-20	BKF	ETF	49.33	49.33	48.441	48.81	125291.0
2011-01-20	BLV	ETF	77.84	77.95	77.25	77.49	16000.0
2011-01-20	BMVP	ETF	14.73	14.77	14.69	14.74	8205.0
2011-01-20	BND	ETF	80.19	80.22	79.93	80.04	1012000.0
2011-01-20	BNO	ETF	32.065	32.195	31.865	32.17	10000.0
2011-01-20	BRF	ETF	57.33	57.47	56.52	56.65	359040.0
2011-01-20	BSCE	ETF	20.85	20.93	20.725	20.77	4667.0
2011-01-20	BSV	ETF	80.57	80.57	80.45	80.49	683200.0
2011-01-20	BTF	ETF	78.25	78.55	78.05	78.3055	7738.200000000001
2011-01-20	BWX	ETF	29.015	29.08	28.865	29.01	405272.0
2011-01-20	BWZ	ETF	37.04	37.1099	36.916	37.06	31922.0
2011-01-20	BZQ	ETF	2457.6	2531.2	2457.6	2497.6	372.5
2011-01-20	CEF	ETF	18.76	18.76	18.27	18.51	2675500.0

> showing 50 of 824 rows — these rows as CSV

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