PREVIEW / etf_daily / 2008-06-05

all etf daily files

  file:    by_date/etf_daily/2008/2008-06-05.parquet
  size:    26 KB
  rows:    589

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-06-05	SPY	ETF	138.58	140.89	138.32	140.78	237867100.0
2008-06-05	QQQ	ETF	49.87	50.61	49.7	50.55	126653645.0
2008-06-05	IWM	ETF	74.43	76.23	74.25	76.2	106082100.0
2008-06-05	DIA	ETF	124.35	126.25	124.12	126.11	13042000.0
2008-06-05	GLD	ETF	85.97	86.81	85.66	86.45	14130900.0
2008-06-05	TLT	ETF	89.82	90.03	89.45	89.6	2632200.0
2008-06-05	ACWI	ETF	52.85	53.76	52.85	53.76	15500.0
2008-06-05	ACWX	ETF	54.2	54.71	54.153	54.71	1976.0
2008-06-05	ADRE	ETF	54.3	55.79	54.25	55.79	455676.0
2008-06-05	AGG	ETF	100.52	100.7	100.34	100.42	378000.0
2008-06-05	AIA	ETF	45.69	46.35	45.64	46.35	30134.0
2008-06-05	AIQ	ETF	44.0	45.25	43.8	45.2	40537.0
2008-06-05	AIS	ETF	0.84	0.84	0.79	0.81	26818.0
2008-06-05	AIVI	ETF	65.95	66.76	65.86	66.76	35700.0
2008-06-05	ARB	ETF	50.8	51.34	50.72	51.33	357232.0
2008-06-05	BBH	ETF	55.8833	56.6467	55.8833	56.5567	532200.0
2008-06-05	BIL	ETF	91.68	91.68	91.58	91.58	27800.0
2008-06-05	BITS	ETF	24.96	25.44	24.6	24.72	7175.0
2008-06-05	BIV	ETF	76.82	76.82	76.47	76.65	35600.0
2008-06-05	BKF	ETF	56.13	57.46	56.04	57.46	78118.0
2008-06-05	BLV	ETF	74.01	74.01	73.5	73.56	7700.0
2008-06-05	BMVP	ETF	16.1733	16.4633	16.1667	16.4587	104223.0
2008-06-05	BND	ETF	76.21	76.36	76.0	76.17	108200.0
2008-06-05	BNE	ETF	15.6	16.25	15.47	16.1	234578.0
2008-06-05	BRF	ETF	14.73	14.74	14.7	14.71	31700.0
2008-06-05	BSV	ETF	77.44	77.51	77.33	77.4	119600.0
2008-06-05	BTF	ETF	103.6	104.45	103.35000000000001	103.49999999999999	4990.0
2008-06-05	BWX	ETF	27.43	27.64	27.395	27.62	183052.0
2008-06-05	CBON	ETF	7.02	7.08	6.9	7.03	133958.0
2008-06-05	CDL	ETF	1.72	1.8	1.69	1.79	867422.0
2008-06-05	CEF	ETF	12.09	12.37	12.06	12.37	337700.0
2008-06-05	CGO	ETF	17.28	17.3	17.13	17.25	11087.0
2008-06-05	CGW	ETF	25.73	26.25	25.73	26.196	83201.0
2008-06-05	CHB	ETF	8.52	8.82	8.44	8.82	1174282.0
2008-06-05	CHI	ETF	15.8	15.88	15.76	15.86	111988.0
2008-06-05	CHIC	ETF	18.24	18.78	18.18	18.77	304989.0
2008-06-05	CHW	ETF	13.46	13.46	12.54	12.67	99957.0
2008-06-05	CHY	ETF	14.55	14.63	14.51	14.6	102316.0
2008-06-05	CMF	ETF	52.21	52.27	52.145	52.145	23958.0
2008-06-05	CN	ETF	58.66	60.92	58.66	60.76	386269.0
2008-06-05	CNXT	ETF	0.56	0.595	0.55	0.578	7538372.0
2008-06-05	COW	ETF	44.03	44.55	44.03	44.21	127389.0
2008-06-05	CPST	ETF	3.8	3.82	3.71	3.76	2351194.0
2008-06-05	CSA	ETF	18.17	19.24	17.95	18.71	56156.0
2008-06-05	CSB	ETF	22.59	22.9	21.525	22.2	21560.0
2008-06-05	CSD	ETF	24.26	24.6	24.23	24.6	11300.0
2008-06-05	CSQ	ETF	13.09	13.2	13.05	13.15	234919.0
2008-06-05	CUT	ETF	21.9	22.29	21.9	22.29	11800.0
2008-06-05	CVY	ETF	22.77	23.19	22.63	23.14	5000.0
2008-06-05	CWI	ETF	26.5867	27.1533	26.0667	27.1533	49950.0

> showing 50 of 589 rows — these rows as CSV

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