PREVIEW / etf_daily / 2010-12-07

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-07.parquet
  size:    35 KB
  rows:    814

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
2010-12-07	SPY	ETF	123.94	124.01	122.76	122.83	206581000.0
2010-12-07	QQQ	ETF	54.49	54.52	53.82	53.88	59067227.0
2010-12-07	IWM	ETF	77.06	77.24	76.41	76.58	66769100.0
2010-12-07	DIA	ETF	114.62	114.71	113.67	113.73	7617300.0
2010-12-07	GLD	ETF	139.46	139.54	136.46	136.5	26490400.0
2010-12-07	TLT	ETF	94.72	94.92	93.16	94.17	18533100.0
2010-12-07	AADR	ETF	29.44	29.44	29.37	29.37	10400.0
2010-12-07	AAXJ	ETF	64.17	64.19	63.38	63.38	334800.0
2010-12-07	ACWI	ETF	46.47	46.5	45.8	45.8	482200.0
2010-12-07	ACWX	ETF	43.95	43.95	43.34	43.34	72324.0
2010-12-07	ADRE	ETF	47.77	47.77	46.77	46.8	36639.0
2010-12-07	AFK	ETF	34.25	34.29	33.654	33.86	40528.0
2010-12-07	AGG	ETF	106.26	106.33	105.68	105.82	1214600.0
2010-12-07	AGQ	ETF	315.84	316.46	274.28	276.08	1377100.0
2010-12-07	AGZ	ETF	110.4	110.51	109.938	110.065	76154.0
2010-12-07	AIA	ETF	46.36	46.38	45.9286	45.97	66875.0
2010-12-07	AIQ	ETF	19.05	19.05	18.65	18.75	27047.0
2010-12-07	AIS	ETF	1.46	1.55	1.45	1.5	594032.0
2010-12-07	AIVI	ETF	43.5	43.59	42.99	42.99	73400.0
2010-12-07	AMJ	ETF	36.08	36.08	35.73	35.77	636060.0
2010-12-07	AMLP	ETF	79.85	79.85	79.25	79.35	135260.0
2010-12-07	AOA	ETF	34.09	34.09	33.75	33.77	12200.0
2010-12-07	AOK	ETF	28.75	28.77	28.62	28.62	51332.0
2010-12-07	AOM	ETF	29.94	29.94	29.7499	29.76	28871.0
2010-12-07	AOR	ETF	31.41	31.41	31.13	31.142	10798.0
2010-12-07	ARB	ETF	31.0	31.63	30.91	31.27	134231.0
2010-12-07	BAB	ETF	25.23	25.309	24.92	25.0	476206.0
2010-12-07	BAL	ETF	67.13	67.1499	64.99	65.94	56251.0
2010-12-07	BALT	ETF	11.64	11.7	11.49	11.59	143124.0
2010-12-07	BBH	ETF	33.0233	33.13	32.8667	32.9067	53400.0
2010-12-07	BICK	ETF	33.06	33.1	32.59	32.59	57303.0
2010-12-07	BIL	ETF	91.7	91.72	91.7	91.7	176500.0
2010-12-07	BIS	ETF	8966.4	8966.4	8966.4	8966.4	0.625
2010-12-07	BITS	ETF	28.88	28.92	28.2	28.76	1901.0
2010-12-07	BIV	ETF	84.49	84.49	83.53	83.67	364400.0
2010-12-07	BJK	ETF	32.4	32.4	31.85	31.85	15600.0
2010-12-07	BKF	ETF	50.25	50.25	49.29	49.29	219065.0
2010-12-07	BLV	ETF	79.94	80.14	78.86	79.5	128700.0
2010-12-07	BMVP	ETF	14.6567	14.7033	14.5979	14.6	31064.0
2010-12-07	BND	ETF	81.24	81.27	80.78	80.93	990300.0
2010-12-07	BNO	ETF	30.815	30.815	30.345	30.345	14400.0
2010-12-07	BRF	ETF	61.33	61.33	59.4	59.54	957089.0
2010-12-07	BSCE	ETF	20.74	20.78	20.74	20.7566	5600.0
2010-12-07	BSV	ETF	81.24	81.25	80.96	80.98	465500.0
2010-12-07	BTF	ETF	78.75	78.75	77.999	78.0	1172.8
2010-12-07	BWX	ETF	29.005	29.08	28.695	28.79	520620.0
2010-12-07	BWZ	ETF	37.0359	37.0359	36.76	36.805	2982.0
2010-12-07	BZQ	ETF	2486.4	2649.6	2486.4	2630.4	275.0
2010-12-07	CEF	ETF	20.72	20.75	19.92	19.92	1836200.0
2010-12-07	CEW	ETF	23.07	23.11	23.0	23.01	70108.0

> showing 50 of 814 rows — these rows as CSV

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