PREVIEW / etf_daily / 2007-09-04

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-04.parquet
  size:    23 KB
  rows:    502

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-04	SPY	ETF	147.45	149.98	147.4	149.08	120062000.0
2007-09-04	QQQ	ETF	48.92	50.0	48.91	49.68	98481769.0
2007-09-04	IWM	ETF	78.68	80.32	78.58	79.75	61375400.0
2007-09-04	DIA	ETF	133.22	134.89	133.11	134.34	11602900.0
2007-09-04	GLD	ETF	66.74	67.66	66.59	67.44	6640300.0
2007-09-04	TLT	ETF	88.83	89.13	88.2	88.56	931000.0
2007-09-04	ADRE	ETF	46.59	47.74	46.4	47.44	257909.0
2007-09-04	AGG	ETF	99.98	101.0	99.1	99.28	554500.0
2007-09-04	AIQ	ETF	44.05	45.55	43.95	45.15	35500.0
2007-09-04	AIS	ETF	1.47	1.51	1.44	1.5	185600.0
2007-09-04	ARB	ETF	49.6	51.02	49.5	50.45	203200.0
2007-09-04	BBH	ETF	54.8133	56.3333	54.79	56.0433	553800.0
2007-09-04	BIL	ETF	91.62	91.66	91.54	91.64	10900.0
2007-09-04	BITS	ETF	26.96	27.8	26.52	27.8	14826.0
2007-09-04	BIV	ETF	75.39	75.39	75.21	75.3	17900.0
2007-09-04	BLV	ETF	74.67	74.67	74.09	74.34	11800.0
2007-09-04	BMVP	ETF	16.89	17.077	16.88	17.023	53200.0
2007-09-04	BND	ETF	75.29	75.32	75.05	75.19	85500.0
2007-09-04	BNE	ETF	16.94	17.11	16.86	17.0	196200.0
2007-09-04	BRF	ETF	14.65	14.65	14.57	14.57	2900.0
2007-09-04	BSV	ETF	75.65	75.66	75.56	75.62	28100.0
2007-09-04	BTF	ETF	106.85	107.5	106.85	107.2	340.0
2007-09-04	CBON	ETF	24.33	25.01	24.24	24.68	55554.0
2007-09-04	CDL	ETF	4.03	4.17	4.01	4.13	2429900.0
2007-09-04	CEF	ETF	9.15	9.33	9.15	9.33	254200.0
2007-09-04	CGO	ETF	16.91	17.14	16.74	17.1	37400.0
2007-09-04	CGW	ETF	24.85	25.17	24.77	25.17	153100.0
2007-09-04	CHB	ETF	11.49	12.31	11.39	12.03	1206800.0
2007-09-04	CHI	ETF	16.71	17.07	16.62	17.07	163200.0
2007-09-04	CHIC	ETF	17.47	17.47	16.95	16.95	1219016.0
2007-09-04	CHW	ETF	13.76	14.04	13.62	13.99	108900.0
2007-09-04	CHY	ETF	14.5	14.86	14.41	14.86	349600.0
2007-09-04	CN	ETF	48.95	49.8099	48.76	49.71	183400.0
2007-09-04	CNXT	ETF	1.11	1.15	1.11	1.14	7260677.0
2007-09-04	CPI	ETF	24.1	24.45	24.0	24.11	5400.0
2007-09-04	CPST	ETF	1.11	1.14	1.11	1.1399	917578.0
2007-09-04	CSA	ETF	17.89	18.37	17.89	18.22	39900.0
2007-09-04	CSD	ETF	29.02	29.5	29.02	29.4	24200.0
2007-09-04	CSQ	ETF	14.36	14.5399	14.3	14.42	268100.0
2007-09-04	CTEC	ETF	103.1	105.0	102.69999999999999	104.04999999999998	22190.800000000003
2007-09-04	CVY	ETF	26.1	26.46	26.1	26.36	39800.0
2007-09-04	CWI	ETF	26.68	27.0467	26.68	26.9533	19950.0
2007-09-04	DBA	ETF	26.97	27.5	26.97	27.34	155300.0
2007-09-04	DBB	ETF	24.9	25.05	24.77	25.05	22900.0
2007-09-04	DBC	ETF	25.79	26.09	25.69	25.98	305200.0
2007-09-04	DBE	ETF	28.31	28.62	28.31	28.58	15300.0
2007-09-04	DBO	ETF	26.7	27.48	24.71	26.92	24900.0
2007-09-04	DBP	ETF	25.87	26.27	25.87	26.25	11000.0
2007-09-04	DBS	ETF	23.76	24.1901	23.72	24.11	30800.0
2007-09-04	DBV	ETF	27.65	27.8	27.61	27.6816	216000.0

> showing 50 of 502 rows — these rows as CSV

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