PREVIEW / etf_daily / 2007-04-11

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-11.parquet
  size:    21 KB
  rows:    446

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-04-11	SPY	ETF	144.82	144.86	143.54	144.02	106365700.0
2007-04-11	QQQ	ETF	44.64	44.66	44.07	44.21	116945047.0
2007-04-11	IWM	ETF	80.87	80.9	79.8	80.3	59019200.0
2007-04-11	DIA	ETF	125.76	125.78	124.53	124.9	9250600.0
2007-04-11	GLD	ETF	67.26	67.5	66.81	67.08	4357100.0
2007-04-11	TLT	ETF	87.47	87.58	87.28	87.37	476200.0
2007-04-11	AAA	ETF	66.91	67.0	66.7	67.0	18900.0
2007-04-11	ADRE	ETF	41.25	41.355	40.63	40.72	177252.0
2007-04-11	AGG	ETF	99.84	99.91	99.51	99.63	344200.0
2007-04-11	AIQ	ETF	46.05	46.7	46.0	46.3	40820.0
2007-04-11	AIS	ETF	1.63	1.63	1.48	1.49	901200.0
2007-04-11	ARB	ETF	47.8	47.8	47.0	47.16	113600.0
2007-04-11	BAB	ETF	101.23	101.23	99.58	99.99	45100.0
2007-04-11	BBH	ETF	59.4667	59.5867	58.8933	59.2067	352800.0
2007-04-11	BITS	ETF	31.12	31.12	30.36	30.36	19534.0
2007-04-11	BIV	ETF	75.02	75.05	74.94	74.95	14800.0
2007-04-11	BLV	ETF	74.85	74.94	74.81	74.84	25900.0
2007-04-11	BND	ETF	75.16	75.29	75.03	75.04	87700.0
2007-04-11	BNE	ETF	16.26	16.5	16.25	16.41	561300.0
2007-04-11	BRF	ETF	14.53	14.54	14.52	14.54	11400.0
2007-04-11	BSV	ETF	74.96	75.05	74.95	74.95	18500.0
2007-04-11	BTF	ETF	109.74999999999999	109.75049999999999	109.39999999999999	109.49999999999999	440.0
2007-04-11	CBON	ETF	29.73	29.75	29.3208	29.49	97935.0
2007-04-11	CDL	ETF	9.64	9.64	9.59	9.63	148800.0
2007-04-11	CEF	ETF	9.71	9.84	9.71	9.8	280000.0
2007-04-11	CGO	ETF	17.33	17.35	17.23	17.314	18000.0
2007-04-11	CHB	ETF	9.29	9.36	9.0	9.3	2253800.0
2007-04-11	CHI	ETF	20.28	20.35	20.16	20.33	90900.0
2007-04-11	CHIC	ETF	30.06	30.09	29.23	29.46	648350.0
2007-04-11	CHY	ETF	16.95	16.99	16.79	16.87	133000.0
2007-04-11	CN	ETF	52.6	52.73	51.64	52.13	64100.0
2007-04-11	CNXT	ETF	1.49	1.49	1.44	1.46	5929252.0
2007-04-11	CPI	ETF	21.41	21.41	21.4	21.4	600.0
2007-04-11	CPST	ETF	1.21	1.28	1.18	1.2	11702624.0
2007-04-11	CSA	ETF	21.3	21.3	21.11	21.29	9100.0
2007-04-11	CSB	ETF	33.35	33.44	33.27	33.37	6000.0
2007-04-11	CSD	ETF	27.91	27.91	27.72	27.8	6500.0
2007-04-11	CSM	ETF	1.365	1.365	1.365	1.365	400.0
2007-04-11	CSQ	ETF	15.28	15.3	15.07	15.11	354700.0
2007-04-11	CTEC	ETF	87.3	87.3	85.89999999999999	86.64999999999999	47041.8
2007-04-11	CVY	ETF	26.9	26.97	26.83	26.86	16900.0
2007-04-11	CWI	ETF	26.2	26.2	25.96	26.0333	57750.0
2007-04-11	CZA	ETF	25.45	25.45	25.333	25.333	1200.0
2007-04-11	DBA	ETF	25.78	25.79	25.4	25.57	153500.0
2007-04-11	DBB	ETF	27.15	27.16	26.72	26.93	47600.0
2007-04-11	DBC	ETF	25.44	25.55	24.8	25.41	340600.0
2007-04-11	DBE	ETF	27.79	28.04	27.68	27.85	43400.0
2007-04-11	DBO	ETF	26.36	26.68	26.3	26.3	11700.0
2007-04-11	DBP	ETF	26.95	27.0	26.72	26.85	6700.0
2007-04-11	DBS	ETF	27.57	27.57	27.1	27.21	10900.0

> showing 50 of 446 rows — these rows as CSV

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