PREVIEW / etf_daily / 2005-08-19

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-19.parquet
  size:    15 KB
  rows:    276

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-08-19	SPY	ETF	122.63	122.82	122.2	122.47	39842100.0
2005-08-19	QQQ	ETF	38.89	39.001	38.79	38.82	52177680.0
2005-08-19	IWM	ETF	65.05	65.16	64.71	65.11	20511600.0
2005-08-19	DIA	ETF	105.87	106.2	105.52	105.73	4033600.0
2005-08-19	GLD	ETF	43.77	43.88	43.49	43.6	811800.0
2005-08-19	TLT	ETF	93.36	93.84	93.34	93.78	439200.0
2005-08-19	AAA	ETF	56.4	56.4	56.03	56.04	1200.0
2005-08-19	ADRE	ETF	97.51	98.39	97.2	97.63	6828.0
2005-08-19	AFK	ETF	25.7	25.87	25.59	25.59	3900.0
2005-08-19	AGG	ETF	101.89	102.05	101.8	101.95	73700.0
2005-08-19	AIQ	ETF	45.15	45.35	43.9	45.1	30020.0
2005-08-19	AIS	ETF	0.88	0.93	0.87	0.88	53000.0
2005-08-19	ARB	ETF	42.7	42.8	42.39	42.65	181700.0
2005-08-19	BAB	ETF	51.4	51.48	51.2	51.35	5900.0
2005-08-19	BBH	ETF	62.9833	63.4333	62.9833	63.35	869100.0
2005-08-19	BCM	ETF	57.48	58.16	57.48	58.04	11900.0
2005-08-19	BIS	ETF	702.4	702.4	662.4	665.6	35.0
2005-08-19	BITS	ETF	12.6	12.6	11.2	11.44	11144.0
2005-08-19	BKF	ETF	30.79	31.17	30.79	30.95	17400.0
2005-08-19	BNE	ETF	13.85	13.9	13.75	13.75	84600.0
2005-08-19	BRF	ETF	15.57	15.6	15.5	15.51	11000.0
2005-08-19	BTF	ETF	85.95	86.4	85.95	86.35	1360.0
2005-08-19	CBON	ETF	32.5	32.75	32.5	32.5	11817.0
2005-08-19	CDC	ETF	3.7	3.7	3.25	3.45	18100.0
2005-08-19	CDL	ETF	13.49	13.49	13.3	13.4	635900.0
2005-08-19	CEF	ETF	5.36	5.39	5.35	5.37	104200.0
2005-08-19	CEW	ETF	26.95	27.01	26.95	27.01	700.0
2005-08-19	CHB	ETF	11.58	11.64	11.35	11.42	394100.0
2005-08-19	CHI	ETF	20.15	20.24	20.101	20.12	93000.0
2005-08-19	CHIC	ETF	13.85	13.85	13.5	13.6	163355.0
2005-08-19	CHIR	ETF	35.6001	36.2301	35.5599	35.8401	738229.0
2005-08-19	CHY	ETF	16.18	16.27	16.15	16.17	107100.0
2005-08-19	CIZ	ETF	23.45	23.5	23.3	23.5	3500.0
2005-08-19	CN	ETF	33.95	34.05	33.9	34.0	23800.0
2005-08-19	CNXT	ETF	1.63	1.67	1.59	1.6	1856535.0
2005-08-19	CPST	ETF	2.95	3.04	2.9	2.91	505628.0
2005-08-19	CSB	ETF	30.4	30.4	30.2	30.22	8500.0
2005-08-19	CSQ	ETF	14.14	14.14	14.02	14.09	261200.0
2005-08-19	CTEC	ETF	52.15	52.9	51.699999999999996	51.849999999999994	2356.4
2005-08-19	CURE	ETF	0.2375	0.2387	0.2213	0.2263	2767128.0
2005-08-19	CYA	ETF	67.8	70.0	67.8	70.0	340.0
2005-08-19	CYB	ETF	3.46	3.52	3.46	3.52	1200.0
2005-08-19	DGT	ETF	64.7	64.7	64.5	64.5	1100.0
2005-08-19	DIG	ETF	13.025	13.025	13.0	13.0	3200.0
2005-08-19	DIV	ETF	13.56	13.64	13.56	13.64	5100.0
2005-08-19	DRIV	ETF	38.45	39.07	38.201	38.85	411465.0
2005-08-19	DSI	ETF	5.78	5.78	5.775	5.775	1800.0
2005-08-19	DUSA	ETF	10.87	11.0	10.71	10.89	62292.0
2005-08-19	DVY	ETF	62.61	62.88	62.61	62.8	287700.0
2005-08-19	EDEN	ETF	0.83	0.84	0.81	0.84	12993.0

> showing 50 of 276 rows — these rows as CSV

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