PREVIEW / etf_daily / 2007-03-22

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-22.parquet
  size:    21 KB
  rows:    434

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
2007-03-22	SPY	ETF	143.48	143.68	142.79	143.18	118942200.0
2007-03-22	QQQ	ETF	44.44	44.45	44.09	44.26	114906756.0
2007-03-22	IWM	ETF	80.56	80.6	79.91	80.27	40940200.0
2007-03-22	DIA	ETF	124.46	124.64	123.98	124.45	6477800.0
2007-03-22	GLD	ETF	65.78	66.13	65.6	65.76	4719700.0
2007-03-22	TLT	ETF	89.48	89.48	88.83	89.04	1484300.0
2007-03-22	AAA	ETF	64.31	64.85	64.21	64.45	17200.0
2007-03-22	ADRE	ETF	40.09	40.09	39.54	39.61	92020.0
2007-03-22	AGG	ETF	100.69	100.71	100.4	100.55	210200.0
2007-03-22	AIQ	ETF	40.35	42.1	40.2	41.8	28920.0
2007-03-22	AIS	ETF	1.17	1.2	1.16	1.18	48600.0
2007-03-22	ARB	ETF	47.89	48.67	47.71	47.95	191000.0
2007-03-22	BAB	ETF	103.72	104.03	103.04	103.2	71600.0
2007-03-22	BBH	ETF	60.6	60.6733	60.3067	60.61	569400.0
2007-03-22	BITS	ETF	34.16	34.16	33.2	33.92	13288.0
2007-03-22	BNE	ETF	15.98	16.11	15.82	16.1	129900.0
2007-03-22	BOSS	ETF	45.01	45.39	45.01	45.39	100.0
2007-03-22	BRF	ETF	14.5	14.57	14.5	14.54	6500.0
2007-03-22	BTF	ETF	108.8	109.3	108.60049999999998	108.75	1400.0
2007-03-22	CBON	ETF	31.15	31.15	30.76	30.93	53803.0
2007-03-22	CDL	ETF	9.88	9.88	9.73	9.75	259700.0
2007-03-22	CEF	ETF	9.49	9.55	9.43	9.44	275300.0
2007-03-22	CGO	ETF	16.98	17.0	16.87	17.0	18700.0
2007-03-22	CHB	ETF	9.88	10.07	9.62	9.89	1458200.0
2007-03-22	CHI	ETF	20.11	20.15	20.03	20.08	92500.0
2007-03-22	CHIC	ETF	28.35	28.45	28.16	28.25	376489.0
2007-03-22	CHY	ETF	16.6	16.76	16.57	16.73	162300.0
2007-03-22	CN	ETF	46.91	47.8	46.85	47.49	74600.0
2007-03-22	CNXT	ETF	1.75	1.76	1.71	1.71	4377401.0
2007-03-22	CPST	ETF	0.865	0.9598	0.865	0.916	7339024.0
2007-03-22	CSA	ETF	20.97	21.35	20.93	20.93	220900.0
2007-03-22	CSB	ETF	32.7601	32.92	32.72	32.92	5800.0
2007-03-22	CSD	ETF	27.02	27.08	26.91	27.06	34800.0
2007-03-22	CSM	ETF	1.34	1.34	1.34	1.34	1200.0
2007-03-22	CSQ	ETF	15.24	15.35	15.21	15.34	333600.0
2007-03-22	CTEC	ETF	85.8	86.54999999999998	84.45	86.5	8430.4
2007-03-22	CVY	ETF	27.01	27.12	26.98	27.07	62300.0
2007-03-22	CWI	ETF	25.46	25.4667	25.3267	25.4333	72000.0
2007-03-22	DBA	ETF	26.21	26.39	26.14	26.35	103400.0
2007-03-22	DBB	ETF	24.47	24.86	24.46	24.7	5000.0
2007-03-22	DBC	ETF	24.47	24.84	24.47	24.84	252300.0
2007-03-22	DBE	ETF	25.75	26.22	25.75	26.17	27800.0
2007-03-22	DBO	ETF	25.15	25.74	25.01	25.52	17000.0
2007-03-22	DBP	ETF	26.28	26.39	26.22	26.24	11500.0
2007-03-22	DBS	ETF	26.33	26.486	26.288	26.44	9000.0
2007-03-22	DBV	ETF	26.85	26.85	26.71	26.82	169400.0
2007-03-22	DDM	ETF	6.8258	6.8567	6.7892	6.8492	1658400.0
2007-03-22	DEF	ETF	26.16	26.18	26.04	26.07	58200.0
2007-03-22	DES	ETF	19.46	19.49	19.38	19.3967	60600.0
2007-03-22	DEW	ETF	63.36	63.49	63.17	63.32	9500.0

> showing 50 of 434 rows — these rows as CSV

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