PREVIEW / etf_daily / 2007-08-14

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-14.parquet
  size:    23 KB
  rows:    498

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-08-14	SPY	ETF	145.7	146.06	142.72	143.01	264134500.0
2007-08-14	QQQ	ETF	47.69	47.74	46.73	46.79	153543997.0
2007-08-14	IWM	ETF	77.97	78.18	75.94	76.31	113169000.0
2007-08-14	DIA	ETF	132.54	132.9	130.29	130.49	20864000.0
2007-08-14	GLD	ETF	66.25	66.5	65.95	66.29	4749600.0
2007-08-14	TLT	ETF	86.02	86.78	86.01	86.56	1314700.0
2007-08-14	ADRE	ETF	44.3	44.83	42.97	43.028	320099.0
2007-08-14	AGG	ETF	98.29	98.68	98.29	98.6	250900.0
2007-08-14	AIQ	ETF	44.1	46.3	42.85	44.0	27940.0
2007-08-14	AIS	ETF	1.3	1.41	1.25	1.29	1107200.0
2007-08-14	ARB	ETF	51.63	51.86	50.9	51.27	295800.0
2007-08-14	BBH	ETF	54.1067	54.8333	54.04	54.5267	531300.0
2007-08-14	BIL	ETF	91.76	91.8	91.74	91.76	130650.0
2007-08-14	BITS	ETF	26.12	27.84	26.12	26.8	18992.0
2007-08-14	BIV	ETF	74.14	74.61	74.14	74.61	4600.0
2007-08-14	BLV	ETF	73.0	73.5	73.0	73.43	5000.0
2007-08-14	BMVP	ETF	16.59	16.59	16.29	16.29	55700.0
2007-08-14	BND	ETF	74.41	74.65	74.37	74.64	38900.0
2007-08-14	BNE	ETF	17.1	17.17	16.0	16.85	596700.0
2007-08-14	BOSS	ETF	47.86	47.86	47.86	47.86	100.0
2007-08-14	BRF	ETF	14.46	14.4801	14.45	14.45	13400.0
2007-08-14	BSV	ETF	75.22	75.37	75.21	75.31	11200.0
2007-08-14	BTF	ETF	102.69999999999999	102.69999999999999	101.19999999999999	101.75	700.0
2007-08-14	CBON	ETF	23.48	23.77	23.01	23.2	21378.0
2007-08-14	CDL	ETF	4.81	4.82	4.39	4.41	2756850.0
2007-08-14	CEF	ETF	9.39	9.4	9.11	9.33	513300.0
2007-08-14	CGO	ETF	16.17	16.21	15.78	15.78	27000.0
2007-08-14	CGW	ETF	24.38	24.5	23.64	23.88	103200.0
2007-08-14	CHB	ETF	11.19	11.24	10.28	10.55	2102500.0
2007-08-14	CHI	ETF	16.75	16.75	15.5	15.86	371500.0
2007-08-14	CHIC	ETF	17.44	17.46	16.97	17.01	630340.0
2007-08-14	CHW	ETF	13.56	13.69	12.61	12.9	199900.0
2007-08-14	CHY	ETF	14.1	14.17	13.35	13.7985	453200.0
2007-08-14	CN	ETF	48.45	48.6	47.21	47.21	126700.0
2007-08-14	CNXT	ETF	1.29	1.32	1.25	1.28	6389181.0
2007-08-14	CPI	ETF	28.0	32.85	27.97	27.97	17900.0
2007-08-14	CPST	ETF	1.02	1.07	1.02	1.02	860183.0
2007-08-14	CSA	ETF	16.3	16.58	16.1	16.43	64800.0
2007-08-14	CSD	ETF	28.85	28.85	28.26	28.26	154100.0
2007-08-14	CSQ	ETF	13.92	13.92	13.56	13.77	435600.0
2007-08-14	CTEC	ETF	101.19999999999999	104.25	100.95	101.14999999999999	27169.600000000002
2007-08-14	CVY	ETF	25.59	25.59	24.92	24.92	56300.0
2007-08-14	CWI	ETF	26.3333	26.3333	25.7467	25.7467	111300.0
2007-08-14	CZA	ETF	25.48	25.48	25.01	25.01	1500.0
2007-08-14	DBA	ETF	26.69	26.69	26.22	26.36	79000.0
2007-08-14	DBB	ETF	26.26	26.34	25.82	25.97	50500.0
2007-08-14	DBC	ETF	26.0	26.33	25.25	25.4338	169800.0
2007-08-14	DBE	ETF	28.1	28.21	27.67	28.12	26800.0
2007-08-14	DBO	ETF	26.38	26.54	26.01	26.37	14100.0
2007-08-14	DBP	ETF	26.13	26.13	25.97	25.97	6200.0

> showing 50 of 498 rows — these rows as CSV

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