PREVIEW / etf_daily / 2010-10-04

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-04.parquet
  size:    34 KB
  rows:    794

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-10-04	SPY	ETF	114.37	114.85	113.18	113.75	166153200.0
2010-10-04	QQQ	ETF	48.86	49.05	48.2	48.48	71359478.0
2010-10-04	IWM	ETF	67.68	68.1	66.48	66.94	56292700.0
2010-10-04	DIA	ETF	108.16	108.55	107.07	107.57	5561600.0
2010-10-04	GLD	ETF	128.52	128.62	128.22	128.46	8368000.0
2010-10-04	TLT	ETF	104.62	104.93	104.41	104.88	4422700.0
2010-10-04	AADR	ETF	28.75	28.75	28.0	28.05	21500.0
2010-10-04	AAXJ	ETF	61.74	61.8	61.31	61.68	679000.0
2010-10-04	ACWI	ETF	43.52	43.52	42.94	43.16	186800.0
2010-10-04	ACWX	ETF	41.62	41.652	41.16	41.31	76454.0
2010-10-04	ADRE	ETF	45.64	45.88	45.42	45.64	93100.0
2010-10-04	AFK	ETF	32.5	32.92	32.5	32.69	27880.0
2010-10-04	AGG	ETF	108.29	108.51	108.26	108.44	772100.0
2010-10-04	AGQ	ETF	170.94	171.56	168.22	169.96	142100.0
2010-10-04	AGZ	ETF	111.3245	111.45	111.2	111.4044	8226.0
2010-10-04	AIA	ETF	42.9399	42.95	42.65	42.79	25992.0
2010-10-04	AIQ	ETF	23.75	24.1	23.6	23.6	25311.0
2010-10-04	AIS	ETF	1.45	1.45	1.42	1.44	135535.0
2010-10-04	AIVI	ETF	43.25	43.33	42.75	42.87	15400.0
2010-10-04	AMJ	ETF	34.12	34.15	33.87	34.09	618600.0
2010-10-04	AMLP	ETF	77.9	77.9	77.35	77.7	131620.0
2010-10-04	AOA	ETF	31.64	31.75	31.39	31.39	6600.0
2010-10-04	AOK	ETF	28.39	28.43	28.2801	28.318	4455.0
2010-10-04	AOM	ETF	29.13	29.13	29.0	29.0301	7744.0
2010-10-04	AOR	ETF	30.02	30.02	29.79	29.868	5613.0
2010-10-04	ARB	ETF	28.24	28.44	27.39	27.7	95191.0
2010-10-04	BAB	ETF	26.77	26.8	26.7	26.75	181537.0
2010-10-04	BAL	ETF	46.72	48.269	46.61	47.74	25883.0
2010-10-04	BALT	ETF	11.1	11.36	10.8	11.0	217666.0
2010-10-04	BBH	ETF	32.0267	32.1233	31.78	31.9	18300.0
2010-10-04	BIB	ETF	6.3213	6.33	6.2949	6.2975	27544.0
2010-10-04	BICK	ETF	32.39	32.41	31.91	32.09	3750923.0
2010-10-04	BIL	ETF	91.7	91.72	91.7	91.72	198550.0
2010-10-04	BIS	ETF	9915.2	9915.2	9904.0	9904.0	1.875
2010-10-04	BITS	ETF	28.0	28.0	27.12	27.2	825.0
2010-10-04	BIV	ETF	86.61	86.66	86.56	86.65	124800.0
2010-10-04	BJK	ETF	28.36	28.62	28.25	28.4	52600.0
2010-10-04	BKF	ETF	48.37	48.7301	48.31	48.55	124422.0
2010-10-04	BLV	ETF	85.3	85.55	85.15	85.51	26200.0
2010-10-04	BMVP	ETF	13.17	13.17	12.95	12.99	14631.0
2010-10-04	BND	ETF	82.46	82.59	82.39	82.58	571700.0
2010-10-04	BNE	ETF	11.36	11.37	11.34	11.35	485816.0
2010-10-04	BOSS	ETF	35.87	35.87	35.87	35.87	100.0
2010-10-04	BRF	ETF	57.7	57.8	57.13	57.46	306550.0
2010-10-04	BSCE	ETF	20.95	20.95	20.95	20.95	6300.0
2010-10-04	BSV	ETF	81.72	81.74	81.65	81.72	336700.0
2010-10-04	BTF	ETF	75.19999999999999	75.85	74.505	74.95049999999999	4680.0
2010-10-04	BWX	ETF	30.015	30.2691	30.015	30.1	170428.0
2010-10-04	BWZ	ETF	37.0	37.109	36.9	36.96	15866.0
2010-10-04	BZQ	ETF	2652.8	2689.6	2630.4	2646.4	1652.5

> showing 50 of 794 rows — these rows as CSV

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