PREVIEW / etf_daily / 2007-09-14

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-14.parquet
  size:    22 KB
  rows:    492

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-09-14	SPY	ETF	147.96	149.09	147.74	148.9	121911000.0
2007-09-14	QQQ	ETF	48.8	49.31	48.73	49.22	99801165.0
2007-09-14	IWM	ETF	76.9	78.28	76.78	78.09	61830800.0
2007-09-14	DIA	ETF	133.54	134.69	133.35	134.46	10337200.0
2007-09-14	GLD	ETF	69.9	70.97	69.86	69.99	7733200.0
2007-09-14	TLT	ETF	90.58	90.59	89.62	89.91	1357200.0
2007-09-14	ADRE	ETF	47.5	48.1	47.3701	47.84	220817.0
2007-09-14	AGG	ETF	100.1	100.13	99.7	99.9	320600.0
2007-09-14	AIQ	ETF	43.25	44.6	43.2	43.6	22620.0
2007-09-14	AIS	ETF	1.4	1.42	1.38	1.4	81500.0
2007-09-14	ARB	ETF	45.43	46.27	45.27	46.17	216300.0
2007-09-14	BBH	ETF	57.5067	57.9633	57.2833	57.8067	234600.0
2007-09-14	BIL	ETF	91.74	91.84	91.74	91.82	32650.0
2007-09-14	BITS	ETF	28.4	28.4	27.04	27.68	11409.0
2007-09-14	BIV	ETF	75.9	75.9	75.38	75.48	17100.0
2007-09-14	BLV	ETF	75.57	75.69	75.13	75.23	13100.0
2007-09-14	BMVP	ETF	16.62	16.809	16.62	16.763	49300.0
2007-09-14	BND	ETF	75.84	75.84	75.44	75.55	45800.0
2007-09-14	BNE	ETF	15.69	15.91	15.63	15.8	182300.0
2007-09-14	BRF	ETF	14.73	14.73	14.58	14.62	8000.0
2007-09-14	BSV	ETF	75.96	75.97	75.78	75.89	27200.0
2007-09-14	BTF	ETF	103.55	104.8	103.55	104.8	3000.0
2007-09-14	CBON	ETF	23.79	23.92	23.6	23.88	17915.0
2007-09-14	CDL	ETF	4.04	4.12	4.03	4.09	1256600.0
2007-09-14	CEF	ETF	9.38	9.44	9.31	9.32	501300.0
2007-09-14	CGO	ETF	16.89	17.03	16.88	17.03	9600.0
2007-09-14	CGW	ETF	24.66	24.71	24.51	24.71	46000.0
2007-09-14	CHB	ETF	10.91	11.51	10.69	11.48	1128800.0
2007-09-14	CHI	ETF	16.3	16.43	16.19	16.27	77600.0
2007-09-14	CHIC	ETF	16.75	17.19	16.75	17.15	271145.0
2007-09-14	CHW	ETF	13.21	13.35	13.0	13.34	105600.0
2007-09-14	CHY	ETF	14.39	14.49	14.23	14.31	123500.0
2007-09-14	CN	ETF	46.65	47.64	46.65	47.41	192000.0
2007-09-14	CNXT	ETF	1.23	1.24	1.22	1.23	3193114.0
2007-09-14	CPST	ETF	1.12	1.2	1.08	1.2	2277708.0
2007-09-14	CSA	ETF	18.58	18.77	18.45	18.71	49700.0
2007-09-14	CSD	ETF	28.29	28.57	28.29	28.56	18600.0
2007-09-14	CSQ	ETF	14.01	14.06	13.95	14.05	196773.0
2007-09-14	CVY	ETF	25.7	25.93	25.7	25.91	15800.0
2007-09-14	CWI	ETF	26.68	26.8533	26.68	26.8533	13650.0
2007-09-14	DBA	ETF	27.15	27.4	26.96	27.37	181800.0
2007-09-14	DBB	ETF	24.91	25.3	24.86	24.98	18800.0
2007-09-14	DBC	ETF	26.39	26.6	26.33	26.44	191900.0
2007-09-14	DBE	ETF	29.83	29.93	29.64	29.75	14600.0
2007-09-14	DBO	ETF	28.09	28.35	27.99	28.16	10500.0
2007-09-14	DBP	ETF	27.32	27.45	27.1	27.13	18200.0
2007-09-14	DBS	ETF	24.77	25.0	24.65	24.656	5900.0
2007-09-14	DBV	ETF	27.5	27.68	27.45	27.52	86000.0
2007-09-14	DDM	ETF	7.615	7.7583	7.6067	7.7408	3718800.0
2007-09-14	DEEP	ETF	11.75	12.1213	11.7	11.77	188802.0

> showing 50 of 492 rows — these rows as CSV

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