PREVIEW / etf_daily / 2007-03-08

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-08.parquet
  size:    21 KB
  rows:    438

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-08	SPY	ETF	140.54	141.16	140.07	140.74	117891600.0
2007-03-08	QQQ	ETF	43.13	43.24	42.84	42.97	121051587.0
2007-03-08	IWM	ETF	77.73	78.18	77.08	77.55	76876500.0
2007-03-08	DIA	ETF	122.73	123.08	122.28	122.8	7570300.0
2007-03-08	GLD	ETF	64.79	65.04	64.43	64.48	4285000.0
2007-03-08	TLT	ETF	90.29	90.42	90.11	90.35	574700.0
2007-03-08	AAA	ETF	60.1	60.5	60.0	60.44	4000.0
2007-03-08	ADRE	ETF	38.11	38.29	37.32	37.98	214751.0
2007-03-08	AGG	ETF	100.6	100.66	100.46	100.51	351700.0
2007-03-08	AIQ	ETF	37.7	38.55	37.25	38.05	41560.0
2007-03-08	AIS	ETF	1.15	1.2699	1.15	1.24	646800.0
2007-03-08	ARB	ETF	44.97	45.5	44.7	45.04	385800.0
2007-03-08	BAB	ETF	100.1	101.39	99.95	100.76	56600.0
2007-03-08	BBC	ETF	3.71	3.95	3.71	3.72	160900.0
2007-03-08	BBH	ETF	59.3	59.3	58.5933	58.8333	1168200.0
2007-03-08	BITS	ETF	29.16	29.76	28.8	29.32	42420.0
2007-03-08	BNE	ETF	14.95	15.02	14.87	14.98	139600.0
2007-03-08	BOSS	ETF	43.38	43.38	43.28	43.28	300.0
2007-03-08	BRF	ETF	14.55	14.55	14.55	14.55	100.0
2007-03-08	BTF	ETF	108.85	109.21499999999999	107.44999999999999	107.94999999999999	5000.0
2007-03-08	CBON	ETF	31.06	31.74	31.06	31.46	61101.0
2007-03-08	CDL	ETF	9.81	9.88	9.64	9.71	319000.0
2007-03-08	CEF	ETF	9.3	9.34	9.21	9.22	180300.0
2007-03-08	CGO	ETF	16.41	16.55	16.41	16.5001	11200.0
2007-03-08	CHB	ETF	7.78	7.86	7.53	7.69	2624700.0
2007-03-08	CHI	ETF	19.95	20.11	19.9	19.91	112100.0
2007-03-08	CHIC	ETF	28.78	29.55	28.65	29.12	411001.0
2007-03-08	CHY	ETF	16.56	16.65	16.5	16.5799	106500.0
2007-03-08	CIL	ETF	25.53	25.53	25.53	25.53	500.0
2007-03-08	CN	ETF	44.9	45.25	44.5	44.81	105300.0
2007-03-08	CNXT	ETF	1.9	1.91	1.78	1.79	20742782.0
2007-03-08	CPI	ETF	22.76	23.1	22.76	23.1	1300.0
2007-03-08	CPST	ETF	0.81	0.85	0.81	0.85	2963514.0
2007-03-08	CSA	ETF	21.3	21.3883	21.15	21.36	4900.0
2007-03-08	CSB	ETF	31.56	31.56	30.89	30.96	71900.0
2007-03-08	CSD	ETF	26.01	26.06	25.97	25.97	3000.0
2007-03-08	CSM	ETF	1.2375	1.3125	1.2375	1.3125	70800.0
2007-03-08	CSQ	ETF	14.7	14.72	14.6	14.69	305100.0
2007-03-08	CTEC	ETF	81.19999999999999	81.3	79.64999999999999	80.19999999999999	10000.400000000001
2007-03-08	CVY	ETF	26.28	26.46	26.27	26.36	18800.0
2007-03-08	CWI	ETF	24.56	24.6933	24.5533	24.6133	53550.0
2007-03-08	DBA	ETF	26.54	26.65	26.32	26.42	109600.0
2007-03-08	DBB	ETF	24.55	24.55	24.3	24.44	3700.0
2007-03-08	DBC	ETF	25.16	25.17	24.9	25.04	261400.0
2007-03-08	DBE	ETF	26.6	26.6	26.29	26.5	55000.0
2007-03-08	DBO	ETF	26.24	26.24	25.84	26.08	35800.0
2007-03-08	DBP	ETF	25.78	25.83	25.65	25.65	16500.0
2007-03-08	DBS	ETF	25.66	25.72	25.47	25.52	15100.0
2007-03-08	DBV	ETF	26.05	26.19	26.05	26.1	66300.0
2007-03-08	DDM	ETF	6.6467	6.685	6.5992	6.6417	1960800.0

> showing 50 of 438 rows — these rows as CSV

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