PREVIEW / etf_daily / 2009-02-18

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-18.parquet
  size:    28 KB
  rows:    634

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-02-18	SPY	ETF	79.79	79.94	78.28	79.03	362964800.0
2009-02-18	QQQ	ETF	29.41	29.6699	28.87	29.24	161268253.0
2009-02-18	IWM	ETF	43.25	43.34	42.13	42.29	78276200.0
2009-02-18	DIA	ETF	76.25	76.49	75.09	75.76	35793800.0
2009-02-18	GLD	ETF	95.23	97.15	94.67	96.91	29346300.0
2009-02-18	TLT	ETF	106.06	106.56	104.3	104.7	2768600.0
2009-02-18	AAXJ	ETF	30.04	30.04	29.31	29.53	36800.0
2009-02-18	ACWI	ETF	26.69	27.7	26.69	27.41	208200.0
2009-02-18	ACWX	ETF	25.62	25.62	24.96	25.18	71124.0
2009-02-18	ADRE	ETF	26.13	26.2	25.45	25.83	227771.0
2009-02-18	AFK	ETF	18.45	18.45	18.19	18.19	430.0
2009-02-18	AGG	ETF	101.89	102.1	101.59	101.66	495800.0
2009-02-18	AGQ	ETF	95.66	98.78	94.64	97.96	85500.0
2009-02-18	AGZ	ETF	107.87	107.87	107.3	107.3	2094.0
2009-02-18	AIA	ETF	23.57	23.57	22.62	22.96	16359.0
2009-02-18	AIQ	ETF	46.85	46.85	45.0	45.25	27076.0
2009-02-18	AIS	ETF	0.39	0.4	0.39	0.4	196280.0
2009-02-18	AIVI	ETF	27.17	27.3	26.67	27.17	19500.0
2009-02-18	AOA	ETF	21.57	21.57	21.42	21.42	7600.0
2009-02-18	AOK	ETF	24.7088	24.71	24.7088	24.71	800.0
2009-02-18	AOM	ETF	24.77	24.77	23.63	24.685	3320.0
2009-02-18	AOR	ETF	22.61	22.87	22.61	22.87	1520.0
2009-02-18	ARB	ETF	13.23	13.65	13.0	13.28	330613.0
2009-02-18	BBH	ETF	57.55	58.3867	57.35	58.1533	373500.0
2009-02-18	BIL	ETF	91.68	91.78	91.68	91.78	666500.0
2009-02-18	BITS	ETF	18.6	19.32	18.6	18.96	929.0
2009-02-18	BIV	ETF	77.55	77.96	77.15	77.33	77500.0
2009-02-18	BJK	ETF	14.8	15.0	14.8	15.0	1600.0
2009-02-18	BKF	ETF	23.26	23.26	22.31	22.7756	48897.0
2009-02-18	BLV	ETF	75.33	75.33	74.04	74.07	32200.0
2009-02-18	BMVP	ETF	9.94	9.953	9.797	9.872	37878.0
2009-02-18	BND	ETF	77.42	77.55	77.05	77.16	387400.0
2009-02-18	BNE	ETF	2.7	2.7	2.12	2.21	353774.0
2009-02-18	BSV	ETF	78.96	79.34	78.84	78.84	190400.0
2009-02-18	BTF	ETF	44.0	44.1995	41.050000000000004	41.74999999999999	21406.0
2009-02-18	BWX	ETF	24.82	24.82	24.595	24.675	220334.0
2009-02-18	CBON	ETF	1.5	1.65	1.12	1.34	87080.0
2009-02-18	CDL	ETF	0.12	0.15	0.12	0.14	499321.0
2009-02-18	CEF	ETF	12.16	12.46	11.8	12.41	3721300.0
2009-02-18	CGO	ETF	9.63	9.63	9.45	9.51	21060.0
2009-02-18	CGW	ETF	12.52	12.71	12.26	12.39	68128.0
2009-02-18	CHB	ETF	0.36	0.4	0.33	0.33	424807.0
2009-02-18	CHI	ETF	8.25	8.42	8.09	8.23	283871.0
2009-02-18	CHIC	ETF	5.01	5.08	4.91	4.95	99600.0
2009-02-18	CHW	ETF	6.19	6.19	5.75	5.85	363806.0
2009-02-18	CHY	ETF	8.12	8.27	7.8	7.91	467023.0
2009-02-18	CMF	ETF	51.91	52.035	51.255	51.475	26372.0
2009-02-18	CNXT	ETF	0.65	0.65	0.57	0.589	319937.0
2009-02-18	COW	ETF	31.13	31.3	30.66	30.73	15622.0
2009-02-18	CPST	ETF	0.7	0.7	0.62	0.6389	1394428.0

> showing 50 of 634 rows — these rows as CSV

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