PREVIEW / etf_daily / 2009-11-11

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-11.parquet
  size:    30 KB
  rows:    676

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
2009-11-11	SPY	ETF	110.31	110.82	109.62	110.15	169466200.0
2009-11-11	QQQ	ETF	43.94	44.14	43.61	43.9	84676105.0
2009-11-11	IWM	ETF	59.3	59.84	58.8	59.26	50320800.0
2009-11-11	DIA	ETF	103.11	103.62	102.64	103.13	10532400.0
2009-11-11	GLD	ETF	109.49	109.71	109.0	109.6	17670800.0
2009-11-11	TLT	ETF	93.63	94.16	93.48	93.66	1771100.0
2009-11-11	AAXJ	ETF	55.0	55.56	55.0	55.39	149300.0
2009-11-11	ACWI	ETF	42.52	42.8	42.25	42.45	723200.0
2009-11-11	ACWX	ETF	41.65	41.74	41.22	41.4	144015.0
2009-11-11	ADRE	ETF	44.76	44.91	44.1206	44.42	189811.0
2009-11-11	AFK	ETF	29.15	29.35	28.8515	29.19	19502.0
2009-11-11	AGG	ETF	104.5	104.81	104.46	104.58	509800.0
2009-11-11	AGQ	ETF	126.56	126.82	122.46	124.88	284950.0
2009-11-11	AGZ	ETF	108.76	108.93	108.3329	108.56	16142.0
2009-11-11	AIA	ETF	39.84	39.911	39.5	39.51	78573.0
2009-11-11	AIQ	ETF	27.1	27.45	26.8	27.15	49487.0
2009-11-11	AIS	ETF	1.05	1.14	1.01	1.11	351204.0
2009-11-11	AIVI	ETF	44.12	44.37	43.81	43.89	15800.0
2009-11-11	AMJ	ETF	26.5	26.72	26.35	26.72	202825.0
2009-11-11	AOA	ETF	29.75	29.85	29.55	29.68	5600.0
2009-11-11	AOK	ETF	27.414	27.42	27.4055	27.42	1120.0
2009-11-11	AOM	ETF	28.28	28.31	28.19	28.26	12891.0
2009-11-11	AOR	ETF	28.98	29.06	28.845	28.91	14544.0
2009-11-11	ARB	ETF	22.7	22.78	22.14	22.37	195075.0
2009-11-11	BAL	ETF	36.2	36.53	34.7537	34.89	69283.0
2009-11-11	BBH	ETF	32.17	32.33	32.0667	32.2967	133500.0
2009-11-11	BIL	ETF	91.72	91.72	91.7	91.7	196250.0
2009-11-11	BITS	ETF	27.6	28.2	27.08	27.56	8626.0
2009-11-11	BIV	ETF	80.35	80.59	80.25	80.51	194100.0
2009-11-11	BJK	ETF	25.61	25.73	25.22	25.37	12800.0
2009-11-11	BKF	ETF	46.91	47.19	46.39	46.74	222875.0
2009-11-11	BLV	ETF	77.53	77.65	77.14	77.36	35000.0
2009-11-11	BMVP	ETF	12.38	12.4578	12.3167	12.36	21365.0
2009-11-11	BND	ETF	79.32	79.54	79.3	79.47	681700.0
2009-11-11	BNE	ETF	6.65	6.79	6.37	6.73	195703.0
2009-11-11	BRF	ETF	47.04	47.04	46.02	46.27	426105.0
2009-11-11	BSV	ETF	80.16	80.22	79.96	80.2	355400.0
2009-11-11	BTF	ETF	62.9	63.7005	62.9	63.349999999999994	3425.4
2009-11-11	BWX	ETF	29.7	29.825	29.68	29.79	366194.0
2009-11-11	BWZ	ETF	37.91	38.11	37.9	37.95	38236.0
2009-11-11	BZQ	ETF	3780.8	3980.8	3779.2	3916.8	87.0
2009-11-11	CEF	ETF	13.9	14.14	13.73	13.95	2333000.0
2009-11-11	CEW	ETF	22.25	22.36	22.17	22.27	150794.0
2009-11-11	CGO	ETF	13.62	13.82	13.55	13.82	104325.0
2009-11-11	CGW	ETF	18.22	18.29	18.061	18.15	73061.0
2009-11-11	CHB	ETF	0.212	0.2386	0.21	0.21	936498.0
2009-11-11	CHI	ETF	12.18	12.26	12.1034	12.25	176019.0
2009-11-11	CHW	ETF	7.58	7.68	7.56	7.62	303567.0
2009-11-11	CHY	ETF	11.56	11.7	11.56	11.64	194957.0
2009-11-11	CMF	ETF	52.98	52.98	52.625	52.975	11338.0

> showing 50 of 676 rows — these rows as CSV

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