PREVIEW / etf_daily / 2008-07-01

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-01.parquet
  size:    27 KB
  rows:    609

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
2008-07-01	SPY	ETF	126.52	128.47	125.93	128.38	388622000.0
2008-07-01	QQQ	ETF	44.86	45.86	44.68	45.81	245494254.0
2008-07-01	IWM	ETF	68.24	69.26	67.62	69.1	150735900.0
2008-07-01	DIA	ETF	112.38	114.03	111.76	113.77	32398600.0
2008-07-01	GLD	ETF	92.53	93.35	92.34	92.66	15479800.0
2008-07-01	TLT	ETF	92.69	92.77	91.68	91.79	3805100.0
2008-07-01	ACWI	ETF	48.81	49.28	48.4	49.04	40100.0
2008-07-01	ACWX	ETF	49.71	49.82	49.36	49.66	17484.0
2008-07-01	ADRE	ETF	50.01	50.68	49.59	50.5	689061.0
2008-07-01	AGG	ETF	100.62	100.62	99.67	99.67	854500.0
2008-07-01	AIA	ETF	40.65	40.82	40.08	40.77	50258.0
2008-07-01	AIQ	ETF	42.75	43.55	42.5	43.2	50394.0
2008-07-01	AIS	ETF	0.7	0.7	0.64	0.67	112558.0
2008-07-01	AIVI	ETF	58.25	58.8	57.8	58.72	81300.0
2008-07-01	ARB	ETF	47.1	48.37	47.0	48.26	252766.0
2008-07-01	BAL	ETF	48.99	48.99	47.0	47.19	22000.0
2008-07-01	BBH	ETF	56.0933	57.6367	56.0933	57.5333	840000.0
2008-07-01	BIL	ETF	91.74	91.74	91.64	91.72	50700.0
2008-07-01	BITS	ETF	25.76	25.76	25.16	25.24	1675.0
2008-07-01	BIV	ETF	77.06	77.06	76.02	76.18	21300.0
2008-07-01	BJK	ETF	31.49	31.6	31.3	31.5	3500.0
2008-07-01	BKF	ETF	50.35	51.411	50.27	51.16	40717.0
2008-07-01	BLV	ETF	74.46	74.58	74.15	74.15	7000.0
2008-07-01	BMVP	ETF	15.21	15.3267	15.0867	15.2833	39880.0
2008-07-01	BND	ETF	75.84	76.18	75.54	75.9	255700.0
2008-07-01	BNE	ETF	12.55	12.55	11.99	12.46	378507.0
2008-07-01	BSV	ETF	76.99	77.45	76.99	77.13	91700.0
2008-07-01	BTF	ETF	89.45	89.49999999999999	85.7	88.0	14551.2
2008-07-01	BWX	ETF	27.605	27.745	27.44	27.525	591456.0
2008-07-01	CBON	ETF	5.04	5.08	4.97	4.97	144885.0
2008-07-01	CDL	ETF	1.22	1.24	1.12	1.17	1448139.0
2008-07-01	CEF	ETF	13.18	13.42	13.13	13.38	793200.0
2008-07-01	CGO	ETF	15.1	15.3599	14.86	15.28	19589.0
2008-07-01	CGW	ETF	23.5	23.73	22.9	23.35	72924.0
2008-07-01	CHB	ETF	5.7	5.9	5.51	5.84	2476273.0
2008-07-01	CHI	ETF	13.91	14.15	13.8	14.15	110494.0
2008-07-01	CHIC	ETF	17.61	17.98	17.19	17.95	388917.0
2008-07-01	CHW	ETF	10.94	11.09	10.84	11.04	125061.0
2008-07-01	CHY	ETF	13.07	13.42	13.03	13.42	103981.0
2008-07-01	CMF	ETF	51.095	51.395	51.01	51.06	12970.0
2008-07-01	CN	ETF	53.6	54.28	52.89	54.02	240314.0
2008-07-01	COW	ETF	43.68	43.79	43.1	43.28	168065.0
2008-07-01	CPI	ETF	22.1	22.15	22.1	22.15	336.0
2008-07-01	CPST	ETF	4.12	4.15	3.92	4.0	5733506.0
2008-07-01	CSA	ETF	16.05	17.06	16.04	16.72	125869.0
2008-07-01	CSB	ETF	18.1	18.75	18.0	18.58	24230.0
2008-07-01	CSD	ETF	21.53	21.63	21.18	21.51	9400.0
2008-07-01	CSQ	ETF	11.07	11.29	11.06	11.17	308583.0
2008-07-01	CUT	ETF	18.82	19.08	18.5	19.02	20800.0
2008-07-01	CVY	ETF	20.44	20.59	20.34	20.55	10800.0

> showing 50 of 609 rows — these rows as CSV

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