PREVIEW / etf_daily / 2005-07-01

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-01.parquet
  size:    15 KB
  rows:    272

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
2005-07-01	SPY	ETF	119.45	119.8	119.21	119.53	49737500.0
2005-07-01	QQQ	ETF	36.86	37.001	36.68	36.725	55292742.0
2005-07-01	IWM	ETF	63.7	64.05	63.44	63.98	14988200.0
2005-07-01	DIA	ETF	103.07	103.45	102.83	103.12	6487600.0
2005-07-01	GLD	ETF	43.4	43.4	42.59	42.7	1755100.0
2005-07-01	TLT	ETF	96.04	96.26	94.99	95.2	2222700.0
2005-07-01	AAA	ETF	48.86	49.37	47.7	48.05	155100.0
2005-07-01	ADRE	ETF	91.32	92.13	91.32	91.8	3504.0
2005-07-01	AFK	ETF	26.34	26.35	26.13	26.35	3800.0
2005-07-01	AGG	ETF	102.94	102.96	102.5	102.68	123100.0
2005-07-01	AIQ	ETF	52.15	52.75	51.35	51.75	8120.0
2005-07-01	AIS	ETF	1.04	1.09	0.97	1.03	162800.0
2005-07-01	ARB	ETF	42.95	43.57	42.94	43.55	219100.0
2005-07-01	BAB	ETF	47.29	47.44	46.94	47.1	30800.0
2005-07-01	BBH	ETF	55.75	56.1333	55.7	56.0967	593700.0
2005-07-01	BCM	ETF	61.7	61.7	61.5	61.55	1900.0
2005-07-01	BIS	ETF	625.6	625.6	593.6	593.6	142.5
2005-07-01	BITS	ETF	15.6	15.8	14.92	15.2	16307.0
2005-07-01	BKF	ETF	37.8	37.92	37.2	37.84	25500.0
2005-07-01	BNE	ETF	14.49	14.5	14.25	14.25	223400.0
2005-07-01	BOSS	ETF	26.85	27.35	26.85	27.35	100.0
2005-07-01	BRF	ETF	15.51	15.51	15.44	15.44	2400.0
2005-07-01	BTF	ETF	85.19999999999999	85.85000000000001	85.0	85.29999999999998	1620.0
2005-07-01	CBON	ETF	31.08	31.4	30.89	31.38	6151.0
2005-07-01	CDC	ETF	6.92	6.98	6.92	6.98	300.0
2005-07-01	CDL	ETF	11.45	11.75	11.09	11.75	526700.0
2005-07-01	CEF	ETF	5.29	5.3	5.2	5.21	367400.0
2005-07-01	CHB	ETF	9.94	10.01	9.76	9.91	239900.0
2005-07-01	CHI	ETF	19.43	19.7	19.43	19.68	55900.0
2005-07-01	CHIC	ETF	12.6	12.7	12.44	12.62	66602.0
2005-07-01	CHIR	ETF	34.8399	35.2299	34.7601	34.9599	658845.0
2005-07-01	CHY	ETF	16.44	16.5	16.39	16.476	103800.0
2005-07-01	CIZ	ETF	23.05	23.05	23.05	23.05	300.0
2005-07-01	CN	ETF	29.15	29.28	29.0	29.26	45000.0
2005-07-01	CNXT	ETF	1.6	1.69	1.57	1.65	7489686.0
2005-07-01	CPST	ETF	1.32	1.36	1.25	1.29	226906.0
2005-07-01	CSB	ETF	29.19	29.23	29.0	29.0	11700.0
2005-07-01	CSQ	ETF	13.93	13.97	13.9	13.95	211100.0
2005-07-01	CTEC	ETF	55.949999999999996	55.949999999999996	55.0	55.3	5840.0
2005-07-01	CURE	ETF	0.28	0.2908	0.2787	0.2787	372168.0
2005-07-01	CYA	ETF	139.8	140.0	139.8	140.0	85.0
2005-07-01	CYB	ETF	3.21	3.26	3.17	3.17	5700.0
2005-07-01	DGT	ETF	63.0	63.12	63.0	63.11	1300.0
2005-07-01	DIG	ETF	12.5375	12.5375	12.5375	12.5375	800.0
2005-07-01	DIV	ETF	13.72	13.8	13.72	13.8	14000.0
2005-07-01	DRIV	ETF	31.75	31.92	31.3	31.75	397601.0
2005-07-01	DSI	ETF	5.805	5.805	5.785	5.785	400.0
2005-07-01	DUSA	ETF	9.32	9.4	9.1	9.22	84721.0
2005-07-01	DVY	ETF	62.2	62.24	61.92	62.2	222500.0
2005-07-01	EDEN	ETF	0.8	0.8	0.76	0.77	4372.0

> showing 50 of 272 rows — these rows as CSV

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