PREVIEW / etf_daily / 2010-12-17

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-17.parquet
  size:    35 KB
  rows:    820

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-17	SPY	ETF	124.08	124.46	123.82	124.3	141075300.0
2010-12-17	QQQ	ETF	54.54	54.68	54.41	54.52	36849556.0
2010-12-17	IWM	ETF	77.86	78.17	77.29	78.02	40362300.0
2010-12-17	DIA	ETF	114.93	114.99	114.48	114.95	4621200.0
2010-12-17	GLD	ETF	133.97	134.63	133.22	134.2	17213000.0
2010-12-17	TLT	ETF	91.88	93.77	91.86	93.24	16849700.0
2010-12-17	AADR	ETF	29.55	29.55	29.52	29.54	800.0
2010-12-17	AAXJ	ETF	62.8	62.82	62.51	62.79	119700.0
2010-12-17	ACWI	ETF	46.3	46.42	46.12	46.42	1282300.0
2010-12-17	ACWX	ETF	43.55	43.55	43.26	43.5	54260.0
2010-12-17	ADRE	ETF	46.13	46.44	46.071	46.43	52947.0
2010-12-17	AFK	ETF	34.28	34.4	34.2	34.3094	13897.0
2010-12-17	AGG	ETF	104.83	105.41	104.83	105.37	1579300.0
2010-12-17	AGQ	ETF	279.74	286.26	274.8	284.14	419450.0
2010-12-17	AGZ	ETF	109.4	109.563	109.2576	109.5	19011.0
2010-12-17	AIA	ETF	45.83	45.98	45.75	45.97	37735.0
2010-12-17	AIQ	ETF	18.75	19.3	18.25	19.3	96210.0
2010-12-17	AIS	ETF	1.47	1.65	1.45	1.65	2501039.0
2010-12-17	AIVI	ETF	43.63	43.63	43.17	43.39	24100.0
2010-12-17	AMJ	ETF	35.09	35.23	34.95	35.0	1284881.0
2010-12-17	AMLP	ETF	78.7	78.75	78.3	78.6	116660.0
2010-12-17	AOA	ETF	34.0	34.18	33.96	34.09	10100.0
2010-12-17	AOK	ETF	28.5587	28.67	28.55	28.67	10343.0
2010-12-17	AOM	ETF	29.77	29.84	29.42	29.83	12139.0
2010-12-17	AOR	ETF	31.26	31.4	31.26	31.366	10693.0
2010-12-17	ARB	ETF	40.68	41.11	40.12	41.05	591930.0
2010-12-17	BAB	ETF	24.94	25.08	24.79	25.024	797553.0
2010-12-17	BAL	ETF	73.21	76.659	72.79	76.32	61492.0
2010-12-17	BALT	ETF	10.95	11.06	10.89	10.89	118970.0
2010-12-17	BBH	ETF	34.02	34.1133	33.8133	34.0067	63600.0
2010-12-17	BIB	ETF	7.445	7.6625	7.445	7.6387	77288.0
2010-12-17	BICK	ETF	31.82	31.89	31.709	31.88	14908.0
2010-12-17	BIL	ETF	91.7	91.72	91.7	91.72	241750.0
2010-12-17	BIS	ETF	8024.0	8024.0	8024.0	8024.0	0.625
2010-12-17	BITS	ETF	29.12	29.8	28.6	28.8	7052.0
2010-12-17	BIV	ETF	82.46	82.96	82.43	82.85	130100.0
2010-12-17	BJK	ETF	31.47	31.61	31.28	31.51	33700.0
2010-12-17	BKF	ETF	48.23	48.49	48.124	48.31	137410.0
2010-12-17	BLV	ETF	78.15	79.35	78.11	79.01	69200.0
2010-12-17	BMVP	ETF	14.63	14.663	14.603	14.643	14397.0
2010-12-17	BND	ETF	80.0	80.48	80.0	80.44	868800.0
2010-12-17	BNO	ETF	30.48	30.665	30.48	30.49	4400.0
2010-12-17	BRF	ETF	57.4	57.81	57.26	57.81	255616.0
2010-12-17	BSCE	ETF	20.5627	20.59	20.534	20.534	848.0
2010-12-17	BSV	ETF	80.65	80.8	80.59	80.74	890300.0
2010-12-17	BTF	ETF	77.69999999999999	78.15	77.3	77.3	3408.8
2010-12-17	BWX	ETF	28.545	28.685	28.521	28.665	504288.0
2010-12-17	BWZ	ETF	36.1424	36.22	35.97	36.22	55140.0
2010-12-17	BZQ	ETF	2760.0	2771.2	2713.6	2716.8	274.5
2010-12-17	CEF	ETF	19.8	19.96	19.66	19.85	684300.0

> showing 50 of 820 rows — these rows as CSV

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