PREVIEW / etf_daily / 2007-08-09

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-09.parquet
  size:    23 KB
  rows:    500

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-09	SPY	ETF	147.43	148.95	145.29	145.39	357622100.0
2007-08-09	QQQ	ETF	48.19	48.97	47.69	47.71	242869517.0
2007-08-09	IWM	ETF	77.65	79.41	77.6	77.69	204699000.0
2007-08-09	DIA	ETF	134.63	135.82	132.77	132.79	38884900.0
2007-08-09	GLD	ETF	65.95	65.95	65.24	65.46	9407200.0
2007-08-09	TLT	ETF	86.75	86.86	85.72	86.28	2637500.0
2007-08-09	ADRE	ETF	45.5	45.9487	44.48	44.66	315269.0
2007-08-09	AGG	ETF	98.46	98.57	98.32	98.48	271600.0
2007-08-09	AIQ	ETF	42.05	42.65	39.6	39.8	112480.0
2007-08-09	AIS	ETF	1.48	1.5	1.37	1.43	668700.0
2007-08-09	ARB	ETF	52.95	53.74	52.02	52.84	837200.0
2007-08-09	BBH	ETF	54.85	55.3433	54.3833	54.4933	1035600.0
2007-08-09	BIL	ETF	91.68	91.74	91.66	91.7	103150.0
2007-08-09	BITS	ETF	25.76	26.6	24.8	25.28	51400.0
2007-08-09	BIV	ETF	74.42	74.45	74.01	74.4	22000.0
2007-08-09	BLV	ETF	73.14	73.41	72.89	73.05	2300.0
2007-08-09	BMVP	ETF	16.3733	16.48	15.9367	15.9367	295800.0
2007-08-09	BND	ETF	74.62	74.7	74.33	74.53	44900.0
2007-08-09	BNE	ETF	15.25	15.25	14.07	14.29	940400.0
2007-08-09	BRF	ETF	14.49	14.54	14.49	14.54	1600.0
2007-08-09	BSV	ETF	75.22	75.26	75.17	75.25	92300.0
2007-08-09	BTF	ETF	102.14999999999999	103.245	101.75	103.2	1380.0
2007-08-09	CBON	ETF	22.76	23.72	22.6	23.49	178360.0
2007-08-09	CDL	ETF	4.35	4.62	4.31	4.53	7538359.0
2007-08-09	CEF	ETF	9.15	9.25	9.1	9.11	265000.0
2007-08-09	CGO	ETF	16.62	16.62	15.75	16.41	34500.0
2007-08-09	CGW	ETF	25.05	25.14	24.8	24.94	90600.0
2007-08-09	CHB	ETF	11.44	11.86	10.9	11.79	4539430.0
2007-08-09	CHI	ETF	16.9	17.15	16.72	16.99	172000.0
2007-08-09	CHIC	ETF	17.07	17.2	15.84	16.6	1720115.0
2007-08-09	CHW	ETF	13.9	14.38	13.65	13.9	114500.0
2007-08-09	CHY	ETF	14.6	14.9	14.3896	14.58	206700.0
2007-08-09	CN	ETF	48.24	48.7	47.5	47.54	173100.0
2007-08-09	CNXT	ETF	1.21	1.27	1.2	1.27	6954076.0
2007-08-09	CPST	ETF	0.9999	1.09	0.9809	1.05	2356291.0
2007-08-09	CSA	ETF	16.88	17.24	16.88	17.03	14500.0
2007-08-09	CSD	ETF	28.88	28.99	28.45	28.49	15200.0
2007-08-09	CSQ	ETF	14.1	14.25	14.03	14.06	283300.0
2007-08-09	CTEC	ETF	98.49999999999999	105.6	98.49999999999999	105.39999999999999	104653.20000000001
2007-08-09	CVY	ETF	25.83	25.96	25.57	25.6	30800.0
2007-08-09	CWI	ETF	26.5867	26.7867	26.4933	26.5267	111300.0
2007-08-09	CZA	ETF	24.75	24.75	24.75	24.75	100.0
2007-08-09	DBA	ETF	26.67	26.75	26.25	26.3	88500.0
2007-08-09	DBB	ETF	26.31	26.43	26.18	26.43	44100.0
2007-08-09	DBC	ETF	25.47	25.75	25.33	25.44	287500.0
2007-08-09	DBE	ETF	27.72	28.2	26.77	27.95	26100.0
2007-08-09	DBO	ETF	26.26	26.59	26.25	26.52	1004000.0
2007-08-09	DBP	ETF	25.77	25.87	25.72	25.75	4300.0
2007-08-09	DBS	ETF	25.14	25.14	24.81	24.881	4900.0
2007-08-09	DBV	ETF	28.58	28.71	28.4401	28.52	185400.0

> showing 50 of 500 rows — these rows as CSV

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