PREVIEW / etf_daily / 2006-06-01

all etf daily files

  file:    by_date/etf_daily/2006/2006-06-01.parquet
  size:    17 KB
  rows:    325

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-06-01	SPY	ETF	127.38	128.94	127.27	128.73	73721700.0
2006-06-01	QQQ	ETF	38.91	39.74	38.84	39.74	119438755.0
2006-06-01	IWM	ETF	71.88	73.34	71.65	73.27	49499200.0
2006-06-01	DIA	ETF	111.59	112.66	111.47	112.4	5982200.0
2006-06-01	GLD	ETF	62.15	62.97	61.8	62.56	11751400.0
2006-06-01	TLT	ETF	83.4	83.84	83.35	83.71	1561100.0
2006-06-01	AAA	ETF	58.2	59.5	58.18	59.46	6400.0
2006-06-01	ADRE	ETF	124.32	125.79	122.45	125.7	95616.0
2006-06-01	AFK	ETF	25.27	25.27	25.18	25.25	4000.0
2006-06-01	AGG	ETF	97.64	97.72	97.41	97.52	461500.0
2006-06-01	AIQ	ETF	29.0	30.0	28.5	30.0	17380.0
2006-06-01	AIS	ETF	1.4	1.4	1.26	1.34	493100.0
2006-06-01	AOM	ETF	7.24	7.33	7.24	7.27	40400.0
2006-06-01	ARB	ETF	39.91	40.36	39.74	40.36	301400.0
2006-06-01	BAB	ETF	62.76	63.85	62.71	63.85	37600.0
2006-06-01	BBC	ETF	11.29	11.62	10.9	11.05	267900.0
2006-06-01	BBH	ETF	59.1867	59.72	59.0	59.64	1133700.0
2006-06-01	BCM	ETF	71.7	72.09	71.41	71.89	35500.0
2006-06-01	BITS	ETF	25.56	25.72	24.96	25.6	29906.0
2006-06-01	BKF	ETF	7.04	7.34	7.0	7.27	172300.0
2006-06-01	BNE	ETF	14.36	14.86	14.36	14.84	242700.0
2006-06-01	BRF	ETF	13.96	13.98	13.94	13.98	6400.0
2006-06-01	BTF	ETF	89.19999999999999	89.19999999999999	88.8005	89.0	1180.0
2006-06-01	CBON	ETF	31.99	31.99	31.4	31.72	38122.0
2006-06-01	CDL	ETF	9.5	9.68	9.5	9.57	350800.0
2006-06-01	CEF	ETF	9.01	9.31	8.88	9.22	972000.0
2006-06-01	CFO	ETF	10.15	10.15	10.15	10.15	3000.0
2006-06-01	CGO	ETF	14.22	14.36	14.22	14.3	22100.0
2006-06-01	CHB	ETF	11.9	12.23	11.55	12.19	1964000.0
2006-06-01	CHI	ETF	19.75	19.93	19.72	19.93	49100.0
2006-06-01	CHIC	ETF	21.26	21.67	20.86	21.54	295063.0
2006-06-01	CHY	ETF	16.51	16.75	16.51	16.74	132100.0
2006-06-01	CIL	ETF	25.15	25.15	25.15	25.15	200.0
2006-06-01	CIZ	ETF	23.15	23.15	23.15	23.15	200.0
2006-06-01	CN	ETF	32.9	33.78	32.76	33.55	105400.0
2006-06-01	CNXT	ETF	2.955	2.9701	2.88	2.96	14774512.0
2006-06-01	COMB	ETF	10.14	10.2	10.02	10.2	16463.0
2006-06-01	CPST	ETF	3.17	3.17	2.95	3.02	2954211.0
2006-06-01	CSA	ETF	18.77	18.77	18.57	18.62	1800.0
2006-06-01	CSB	ETF	28.68	28.98	28.68	28.97	4000.0
2006-06-01	CSQ	ETF	13.97	14.01	13.91	14.01	224500.0
2006-06-01	CTEC	ETF	68.64999999999999	69.25	68.0	69.25	19565.4
2006-06-01	CYB	ETF	6.05	6.24	6.03	6.15	49300.0
2006-06-01	DBC	ETF	25.2	25.52	24.9	25.2092	584800.0
2006-06-01	DGT	ETF	66.85	67.55	66.85	67.54	1300.0
2006-06-01	DIG	ETF	17.8625	17.8625	17.8625	17.8625	320.0
2006-06-01	DIV	ETF	11.9	11.95	11.86	11.89	62900.0
2006-06-01	DRIV	ETF	43.76	45.33	43.45	45.01	721542.0
2006-06-01	DUSA	ETF	5.91	5.95	5.7399	5.76	59519.0
2006-06-01	DVY	ETF	63.18	63.92	63.12	63.87	221000.0

> showing 50 of 325 rows — these rows as CSV

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