PREVIEW / etf_daily / 2007-06-15

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-15.parquet
  size:    22 KB
  rows:    480

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-06-15	SPY	ETF	153.14	153.66	152.93	153.07	154030800.0
2007-06-15	QQQ	ETF	47.75	47.87	47.65	47.73	100410121.0
2007-06-15	IWM	ETF	84.29	84.69	84.06	84.33	83706500.0
2007-06-15	DIA	ETF	136.36	136.85	136.18	136.19	10995200.0
2007-06-15	GLD	ETF	64.43	64.94	64.4	64.85	3032900.0
2007-06-15	TLT	ETF	83.42	83.73	83.2	83.69	5827200.0
2007-06-15	ADRE	ETF	45.68	45.96	45.52	45.8585	279548.0
2007-06-15	AGG	ETF	97.66	97.91	97.54	97.89	470200.0
2007-06-15	AIQ	ETF	44.6	45.5	43.8	45.2	55460.0
2007-06-15	AIS	ETF	1.95	2.04	1.93	2.04	406000.0
2007-06-15	ARB	ETF	51.5	51.58	50.92	51.1	296500.0
2007-06-15	BBH	ETF	60.45	60.6	60.2933	60.47	406500.0
2007-06-15	BIL	ETF	91.8	91.84	91.74	91.84	1050.0
2007-06-15	BITS	ETF	32.754	32.8	31.44	31.52	7957.0
2007-06-15	BIV	ETF	73.06	73.29	73.06	73.27	6900.0
2007-06-15	BLV	ETF	72.15	72.28	72.11	72.28	1000.0
2007-06-15	BMVP	ETF	18.14	18.17	18.06	18.06	32100.0
2007-06-15	BND	ETF	73.68	73.84	73.65	73.84	108600.0
2007-06-15	BNE	ETF	19.69	19.74	19.45	19.65	497400.0
2007-06-15	BRF	ETF	14.4701	14.5	14.4701	14.48	2800.0
2007-06-15	BSV	ETF	74.47	74.62	74.47	74.62	34300.0
2007-06-15	BTF	ETF	110.39999999999999	110.5	109.39999999999999	109.85	2760.0
2007-06-15	CBON	ETF	30.04	30.24	29.56	30.0	81128.0
2007-06-15	CDL	ETF	6.08	6.15	5.95	6.15	11443379.0
2007-06-15	CEF	ETF	9.23	9.24	9.05	9.19	283200.0
2007-06-15	CGO	ETF	18.29	18.41	18.2	18.34	25100.0
2007-06-15	CGW	ETF	25.34	25.5	25.34	25.46	201000.0
2007-06-15	CHB	ETF	10.64	10.94	10.46	10.5	2073200.0
2007-06-15	CHI	ETF	20.03	20.13	20.0	20.05	78900.0
2007-06-15	CHIC	ETF	27.95	28.19	27.43	27.74	740155.0
2007-06-15	CHY	ETF	16.53	16.56	16.31	16.41	227600.0
2007-06-15	CN	ETF	53.76	55.6	53.76	55.6	142500.0
2007-06-15	CNXT	ETF	1.28	1.28	1.25	1.26	5704701.0
2007-06-15	CPST	ETF	1.06	1.06	0.99	1.0	2531337.0
2007-06-15	CSA	ETF	19.959	20.15	19.88	19.88	21500.0
2007-06-15	CSB	ETF	31.7099	31.91	31.6	31.74	9800.0
2007-06-15	CSD	ETF	31.37	31.49	31.19	31.27	75600.0
2007-06-15	CSM	ETF	1.4175	1.4175	1.415	1.415	1600.0
2007-06-15	CSQ	ETF	15.29	15.34	15.2474	15.29	283000.0
2007-06-15	CTEC	ETF	109.85	114.55	107.5	110.35	108772.20000000001
2007-06-15	CVY	ETF	28.09	28.42	28.09	28.23	97400.0
2007-06-15	CWI	ETF	27.4267	27.5	27.4	27.4467	10500.0
2007-06-15	CZA	ETF	27.4	27.44	27.31	27.31	19200.0
2007-06-15	DBA	ETF	27.46	27.87	27.43	27.87	473800.0
2007-06-15	DBB	ETF	26.75	27.05	26.57	26.95	76700.0
2007-06-15	DBC	ETF	26.44	26.65	26.39	26.65	321500.0
2007-06-15	DBE	ETF	29.03	29.2	28.91	29.19	119400.0
2007-06-15	DBO	ETF	27.09	27.13	26.95	27.13	19900.0
2007-06-15	DBP	ETF	25.72	25.9	25.71	25.9	2000.0
2007-06-15	DBS	ETF	26.07	26.08	26.0	26.08	2300.0

> showing 50 of 480 rows — these rows as CSV

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