PREVIEW / etf_daily / 2007-08-06

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-06.parquet
  size:    23 KB
  rows:    497

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-06	SPY	ETF	144.21	146.83	142.53	146.21	324980000.0
2007-08-06	QQQ	ETF	47.46	48.02	47.03	47.97	190963808.0
2007-08-06	IWM	ETF	75.62	76.43	73.92	76.03	208307700.0
2007-08-06	DIA	ETF	132.4	134.61	131.54	134.2	31192300.0
2007-08-06	GLD	ETF	66.66	66.67	66.21	66.52	2973200.0
2007-08-06	TLT	ETF	87.7	87.72	87.17	87.29	1298400.0
2007-08-06	ADRE	ETF	44.35	44.95	43.45	44.91	369069.0
2007-08-06	AGG	ETF	98.86	98.86	98.45	98.55	231000.0
2007-08-06	AIQ	ETF	43.3	43.75	42.8	43.4	135280.0
2007-08-06	AIS	ETF	1.5	1.55	1.48	1.51	368300.0
2007-08-06	ARB	ETF	51.36	52.09	50.24	52.0	507000.0
2007-08-06	BBH	ETF	54.2333	54.9567	53.9533	54.83	702900.0
2007-08-06	BIL	ETF	91.64	91.66	91.6	91.64	22300.0
2007-08-06	BITS	ETF	23.84	24.08	23.2	23.84	29782.0
2007-08-06	BIV	ETF	74.63	74.66	74.4	74.44	7000.0
2007-08-06	BLV	ETF	74.05	74.11	73.72	73.72	5600.0
2007-08-06	BMVP	ETF	16.563	16.81	16.363	16.773	161300.0
2007-08-06	BND	ETF	74.8	74.8	74.49	74.56	34100.0
2007-08-06	BNE	ETF	17.32	17.32	15.75	15.84	413800.0
2007-08-06	BRF	ETF	14.52	14.52	14.48	14.52	17500.0
2007-08-06	BSV	ETF	75.19	75.35	75.13	75.15	30900.0
2007-08-06	BTF	ETF	103.2	103.2	99.86999999999999	101.54999999999998	3460.0
2007-08-06	CBON	ETF	22.36	23.34	21.97	23.19	87837.0
2007-08-06	CDL	ETF	4.6	4.71	4.2912	4.56	5029840.0
2007-08-06	CEF	ETF	9.18	9.28	9.05	9.11	509600.0
2007-08-06	CGO	ETF	16.62	16.74	16.28	16.7	45000.0
2007-08-06	CGW	ETF	24.75	24.95	24.5	24.8	79700.0
2007-08-06	CHB	ETF	11.54	11.54	10.26	10.88	3486000.0
2007-08-06	CHI	ETF	17.41	17.446	16.65	17.3	172300.0
2007-08-06	CHIC	ETF	16.56	16.58	15.56	16.2	1399354.0
2007-08-06	CHW	ETF	14.05	14.14	13.4	13.75	171200.0
2007-08-06	CHY	ETF	15.1	15.25	14.5	15.15	322400.0
2007-08-06	CN	ETF	49.25	49.57	47.75	49.48	118400.0
2007-08-06	CNXT	ETF	1.24	1.24	1.13	1.15	10897094.0
2007-08-06	CPST	ETF	1.01	1.02	0.95	0.96	2073897.0
2007-08-06	CSA	ETF	16.67	16.68	16.19	16.64	179600.0
2007-08-06	CSD	ETF	28.34	28.41	27.88	28.41	64100.0
2007-08-06	CSQ	ETF	14.05	14.25	13.87	14.25	334100.0
2007-08-06	CTEC	ETF	98.24999999999999	102.10000000000001	98.24999999999999	100.5	37012.4
2007-08-06	CVY	ETF	25.27	25.6	24.73	25.6	41200.0
2007-08-06	CWI	ETF	26.52	26.78	26.3467	26.78	16650.0
2007-08-06	CZA	ETF	25.1	25.43	25.03	25.35	12900.0
2007-08-06	DBA	ETF	25.86	26.09	25.61	26.09	183200.0
2007-08-06	DBB	ETF	26.68	26.95	26.53	26.95	57600.0
2007-08-06	DBC	ETF	25.68	25.73	25.28	25.54	267900.0
2007-08-06	DBE	ETF	28.49	28.8	27.95	28.17	221800.0
2007-08-06	DBO	ETF	26.74	27.31	25.7	26.76	66400.0
2007-08-06	DBP	ETF	26.3	26.3	26.07	26.23	10600.0
2007-08-06	DBS	ETF	25.72	25.72	25.3901	25.47	5000.0
2007-08-06	DBV	ETF	28.42	28.7	28.15	28.56	337300.0

> showing 50 of 497 rows — these rows as CSV

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