PREVIEW / etf_daily / 2008-06-09

all etf daily files

  file:    by_date/etf_daily/2008/2008-06-09.parquet
  size:    26 KB
  rows:    586

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-09	SPY	ETF	136.86	137.5	135.41	136.62	228263900.0
2008-06-09	QQQ	ETF	49.11	49.19	47.95	48.77	208897240.0
2008-06-09	IWM	ETF	74.12	74.39	72.78	73.68	98998100.0
2008-06-09	DIA	ETF	122.39	123.44	122.08	122.96	16553700.0
2008-06-09	GLD	ETF	88.54	89.24	87.84	87.99	9172100.0
2008-06-09	TLT	ETF	90.48	91.39	90.19	90.76	1812000.0
2008-06-09	ACWI	ETF	52.33	52.49	52.0	52.02	4300.0
2008-06-09	ACWX	ETF	53.65	53.65	53.03	53.1	2422.0
2008-06-09	ADRE	ETF	54.06	54.27	53.23	53.82	400866.0
2008-06-09	AGG	ETF	100.5	100.74	100.36	100.47	555500.0
2008-06-09	AIA	ETF	45.12	45.12	44.5	44.61	39189.0
2008-06-09	AIQ	ETF	42.7	43.55	42.0	42.95	26433.0
2008-06-09	AIS	ETF	0.83	0.83	0.76	0.78	115287.0
2008-06-09	AIVI	ETF	65.37	65.37	64.09	64.51	61000.0
2008-06-09	ARB	ETF	51.25	51.46	50.71	51.23	229503.0
2008-06-09	BBH	ETF	55.8867	55.96	55.3333	55.7133	639000.0
2008-06-09	BIL	ETF	91.66	91.68	91.6	91.64	43850.0
2008-06-09	BITS	ETF	25.88	25.88	23.48	24.76	7970.0
2008-06-09	BIV	ETF	76.81	76.96	76.5	76.7	36700.0
2008-06-09	BJK	ETF	39.29	39.29	36.32	36.32	1300.0
2008-06-09	BKF	ETF	56.29	56.29	54.6401	55.39	94385.0
2008-06-09	BLV	ETF	74.47	74.74	74.2	74.51	7600.0
2008-06-09	BMVP	ETF	16.1067	16.1333	15.9594	16.0067	31537.0
2008-06-09	BND	ETF	76.04	76.32	75.89	75.93	127400.0
2008-06-09	BNE	ETF	15.45	15.81	15.26	15.59	290244.0
2008-06-09	BRF	ETF	14.73	14.73	14.73	14.73	5800.0
2008-06-09	BSV	ETF	77.35	77.44	77.14	77.17	65600.0
2008-06-09	BTF	ETF	102.39999999999999	102.75	101.3	101.69999999999999	4859.400000000001
2008-06-09	BWX	ETF	27.775	27.775	27.525	27.5475	298268.0
2008-06-09	CBON	ETF	6.47	6.5099	5.99	6.01	103453.0
2008-06-09	CDL	ETF	1.74	1.75	1.61	1.63	1680185.0
2008-06-09	CEF	ETF	12.6	12.8	12.4	12.41	385100.0
2008-06-09	CGO	ETF	16.88	16.92	16.49	16.87	28012.0
2008-06-09	CGW	ETF	25.96	25.98	25.56	25.67	68510.0
2008-06-09	CHB	ETF	8.11	8.62	7.91	8.08	1485255.0
2008-06-09	CHI	ETF	15.86	15.97	15.72	15.7434	87516.0
2008-06-09	CHIC	ETF	18.33	18.6	17.9	17.95	265543.0
2008-06-09	CHW	ETF	12.6	12.68	12.25	12.31	142614.0
2008-06-09	CHY	ETF	14.69	14.69	14.48	14.54	98911.0
2008-06-09	CMF	ETF	52.07	52.275	52.07	52.11	5116.0
2008-06-09	CN	ETF	56.86	59.02	55.57	56.35	394019.0
2008-06-09	CNXT	ETF	0.55	0.57	0.53	0.55	5819509.0
2008-06-09	COW	ETF	43.72	43.72	43.0	43.1	230299.0
2008-06-09	CPST	ETF	3.71	3.74	3.39	3.41	4945974.0
2008-06-09	CSA	ETF	18.05	18.32	17.84	18.07	184119.0
2008-06-09	CSB	ETF	21.6	22.0	20.75	20.91	27045.0
2008-06-09	CSD	ETF	23.94	23.94	23.64	23.64	15100.0
2008-06-09	CSQ	ETF	12.98	12.98	12.8	12.96	239494.0
2008-06-09	CUT	ETF	21.75	21.75	21.31	21.47	14200.0
2008-06-09	CVY	ETF	22.48	22.78	22.44	22.44	23100.0

> showing 50 of 586 rows — these rows as CSV

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