PREVIEW / etf_daily / 2007-05-07

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-07.parquet
  size:    21 KB
  rows:    454

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-05-07	SPY	ETF	150.88	151.2	150.81	150.95	63461400.0
2007-05-07	QQQ	ETF	46.65	46.78	46.57	46.63	47686067.0
2007-05-07	IWM	ETF	82.7	83.0	82.47	82.58	40421400.0
2007-05-07	DIA	ETF	132.81	133.13	132.74	133.04	10477600.0
2007-05-07	GLD	ETF	68.42	68.46	68.02	68.25	1995100.0
2007-05-07	TLT	ETF	88.7	88.85	88.67	88.84	210200.0
2007-05-07	AAA	ETF	73.5	74.0	71.0	72.81	91300.0
2007-05-07	ADRE	ETF	42.53	42.559	42.16	42.25	102551.0
2007-05-07	AGG	ETF	100.05	100.17	99.97	100.17	301500.0
2007-05-07	AIQ	ETF	44.6	44.85	43.6	43.9	29120.0
2007-05-07	AIS	ETF	1.53	1.71	1.52	1.71	578800.0
2007-05-07	ARB	ETF	49.31	49.46	48.75	48.93	91100.0
2007-05-07	BAB	ETF	101.2	102.22	101.2	101.32	24500.0
2007-05-07	BBH	ETF	62.9467	63.0867	62.5467	62.6	220500.0
2007-05-07	BITS	ETF	33.16	35.04	33.04	33.68	45000.0
2007-05-07	BIV	ETF	75.42	75.42	75.33	75.41	14400.0
2007-05-07	BLV	ETF	75.8	75.87	75.77	75.83	15400.0
2007-05-07	BMVP	ETF	18.02	18.04	18.0	18.02	38600.0
2007-05-07	BND	ETF	75.36	75.52	75.34	75.39	135500.0
2007-05-07	BNE	ETF	16.73	16.83	16.73	16.75	116400.0
2007-05-07	BRF	ETF	14.51	14.54	14.5	14.54	14800.0
2007-05-07	BSV	ETF	75.23	75.25	75.22	75.24	18800.0
2007-05-07	BTF	ETF	112.69999999999999	113.75	112.65499999999999	113.14999999999999	1260.0
2007-05-07	CBON	ETF	31.16	31.22	30.526	30.78	22328.0
2007-05-07	CDL	ETF	9.05	9.18	9.04	9.05	129800.0
2007-05-07	CEF	ETF	9.59	9.59	9.5	9.52	236200.0
2007-05-07	CGO	ETF	17.92	18.04	17.89	17.89	29000.0
2007-05-07	CHB	ETF	10.65	10.76	10.44	10.61	1106000.0
2007-05-07	CHI	ETF	20.38	20.48	20.26	20.45	74900.0
2007-05-07	CHIC	ETF	26.61	27.17	26.61	27.01	355380.0
2007-05-07	CHY	ETF	17.21	17.24	17.17	17.22	108200.0
2007-05-07	CIL	ETF	25.9	25.95	25.9	25.95	1100.0
2007-05-07	CN	ETF	49.66	49.8	49.25	49.35	96100.0
2007-05-07	CNXT	ETF	1.51	1.53	1.49	1.51	4728362.0
2007-05-07	CPI	ETF	23.1	23.65	23.1	23.65	500.0
2007-05-07	CPST	ETF	0.98	1.0	0.95	0.9501	2313085.0
2007-05-07	CSA	ETF	20.86	20.99	20.83	20.94	10600.0
2007-05-07	CSB	ETF	31.99	32.24	31.89	32.13	13700.0
2007-05-07	CSD	ETF	29.15	29.22	29.12	29.19	20400.0
2007-05-07	CSM	ETF	1.375	1.375	1.375	1.375	18000.0
2007-05-07	CSQ	ETF	15.42	15.45	15.38	15.43	298500.0
2007-05-07	CTEC	ETF	89.04999999999998	91.3	89.04999999999998	91.19999999999999	8215.6
2007-05-07	CVY	ETF	28.01	28.01	27.94	28.0	19300.0
2007-05-07	CWI	ETF	27.0333	27.0467	27.0	27.0	21750.0
2007-05-07	CZA	ETF	26.52	26.53	26.52	26.53	500.0
2007-05-07	DBA	ETF	25.66	25.68	25.15	25.32	160700.0
2007-05-07	DBB	ETF	29.06	29.2	28.78	28.86	87500.0
2007-05-07	DBC	ETF	25.3	25.46	25.18	25.37	226100.0
2007-05-07	DBE	ETF	27.4	27.4	27.16	27.34	24400.0
2007-05-07	DBO	ETF	26.03	26.03	25.78	25.78	33300.0

> showing 50 of 454 rows — these rows as CSV

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