PREVIEW / etf_daily / 2006-07-31

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-31.parquet
  size:    18 KB
  rows:    354

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
2006-07-31	SPY	ETF	127.66	127.96	127.45	127.85	49593100.0
2006-07-31	QQQ	ETF	37.08	37.32	36.89	37.1	78096497.0
2006-07-31	IWM	ETF	69.43	69.83	69.06	69.68	37902900.0
2006-07-31	DIA	ETF	111.8	112.05	111.66	111.9	3906800.0
2006-07-31	GLD	ETF	63.12	63.35	62.44	63.16	3420200.0
2006-07-31	TLT	ETF	85.62	85.81	85.55	85.81	375100.0
2006-07-31	AAA	ETF	57.9	57.93	57.1	57.34	7600.0
2006-07-31	ADRE	ETF	32.03	32.03	31.78	31.94	211877.0
2006-07-31	AFK	ETF	25.08	25.13	25.07	25.11	4900.0
2006-07-31	AGG	ETF	98.5	98.61	98.4	98.4	491100.0
2006-07-31	AIQ	ETF	31.25	32.0	30.15	31.6	29000.0
2006-07-31	AIS	ETF	1.11	1.12	1.06	1.1	63600.0
2006-07-31	AOM	ETF	6.4	6.42	6.2	6.42	5300.0
2006-07-31	ARB	ETF	36.65	36.72	36.22	36.61	119800.0
2006-07-31	BAB	ETF	72.74	72.85	72.11	72.15	36000.0
2006-07-31	BBC	ETF	13.75	13.75	13.17	13.4	97000.0
2006-07-31	BBH	ETF	58.7533	59.4767	58.4267	59.3833	855000.0
2006-07-31	BITS	ETF	17.04	17.76	16.52	16.88	15070.0
2006-07-31	BKF	ETF	4.05	4.08	3.96	3.97	100200.0
2006-07-31	BNE	ETF	13.64	13.94	13.54	13.87	127100.0
2006-07-31	BRF	ETF	14.0	14.05	13.96	14.03	10200.0
2006-07-31	BTF	ETF	87.44999999999999	87.44999999999999	86.99999999999999	87.35	420.0
2006-07-31	CBON	ETF	33.35	33.7	33.3	33.68	22201.0
2006-07-31	CDL	ETF	9.23	9.29	9.18	9.27	297000.0
2006-07-31	CEF	ETF	8.71	8.74	8.68	8.72	301400.0
2006-07-31	CEW	ETF	26.05	26.05	26.05	26.05	300.0
2006-07-31	CFO	ETF	10.0	10.0	10.0	10.0	3300.0
2006-07-31	CGO	ETF	15.0	15.01	14.82	15.01	24400.0
2006-07-31	CHB	ETF	6.75	6.78	6.6	6.63	1520300.0
2006-07-31	CHI	ETF	19.85	19.92	19.81	19.82	54700.0
2006-07-31	CHIC	ETF	25.49	26.19	25.25	26.18	567078.0
2006-07-31	CHY	ETF	16.09	16.13	16.06	16.11	109600.0
2006-07-31	CIL	ETF	25.23	25.23	25.23	25.23	100.0
2006-07-31	CN	ETF	36.76	36.97	36.55	36.79	48000.0
2006-07-31	CNXT	ETF	1.73	1.88	1.72	1.79	23665505.0
2006-07-31	COMB	ETF	9.78	9.78	9.75	9.78	10500.0
2006-07-31	CPI	ETF	29.01	29.01	29.01	29.01	800.0
2006-07-31	CPST	ETF	1.83	1.84	1.77	1.83	904358.0
2006-07-31	CSA	ETF	18.44	18.75	18.26	18.55	12300.0
2006-07-31	CSB	ETF	27.65	27.74	27.55	27.6	8300.0
2006-07-31	CSQ	ETF	14.14	14.2	14.11	14.2	255000.0
2006-07-31	CTEC	ETF	57.64999999999999	57.64999999999999	53.25	53.699999999999996	89703.40000000001
2006-07-31	CYB	ETF	5.41	5.6499	5.41	5.51	25100.0
2006-07-31	DBC	ETF	25.7	25.87	25.44	25.86	241400.0
2006-07-31	DDM	ETF	6.0458	6.0808	6.0433	6.0542	562800.0
2006-07-31	DES	ETF	17.2667	17.2833	17.1667	17.28	58800.0
2006-07-31	DEW	ETF	52.9	53.3	52.9	53.3	600.0
2006-07-31	DFE	ETF	53.69	53.69	53.66	53.66	300.0
2006-07-31	DFJ	ETF	50.0	50.25	49.65	49.73	2000.0
2006-07-31	DGT	ETF	69.5	69.59	69.06	69.37	63800.0

> showing 50 of 354 rows — these rows as CSV

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