PREVIEW / etf_daily / 2008-06-30

all etf daily files

  file:    by_date/etf_daily/2008/2008-06-30.parquet
  size:    27 KB
  rows:    607

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-30	SPY	ETF	127.89	128.91	127.3	127.98	258842600.0
2008-06-30	QQQ	ETF	45.53	45.83	45.15	45.17	132929401.0
2008-06-30	IWM	ETF	69.86	70.21	68.92	69.05	115067900.0
2008-06-30	DIA	ETF	113.48	114.27	112.75	113.42	21139100.0
2008-06-30	GLD	ETF	91.89	91.9	90.53	91.4	7289000.0
2008-06-30	TLT	ETF	92.41	92.82	92.08	92.34	3743000.0
2008-06-30	ACWI	ETF	49.41	49.86	49.41	49.42	61200.0
2008-06-30	ACWX	ETF	50.54	50.61	50.21	50.24	18681.0
2008-06-30	ADRE	ETF	51.03	51.5	51.0	51.15	513289.0
2008-06-30	AGG	ETF	100.66	100.76	100.36	100.4	639600.0
2008-06-30	AIA	ETF	41.294	41.43	41.1	41.43	2970.0
2008-06-30	AIQ	ETF	44.95	45.1	43.15	43.35	168696.0
2008-06-30	AIS	ETF	0.65	0.76	0.63	0.72	143100.0
2008-06-30	AIVI	ETF	59.91	60.27	59.71	59.71	24000.0
2008-06-30	ARB	ETF	47.95	48.38	47.48	47.5	187968.0
2008-06-30	BAL	ETF	49.78	49.78	48.88	49.24	27725.0
2008-06-30	BBH	ETF	55.4967	56.6767	55.4967	56.3267	545400.0
2008-06-30	BIL	ETF	91.86	91.86	91.74	91.8	40950.0
2008-06-30	BITS	ETF	26.0	26.6	25.36	26.2	4377.0
2008-06-30	BIV	ETF	76.69	76.7	76.45	76.66	18400.0
2008-06-30	BJK	ETF	32.0	33.0	31.57	31.57	5100.0
2008-06-30	BKF	ETF	52.64	52.64	52.03	52.14	62867.0
2008-06-30	BLV	ETF	74.88	74.91	74.6	74.75	4700.0
2008-06-30	BMVP	ETF	15.3633	15.4633	15.31	15.31	44502.0
2008-06-30	BND	ETF	76.29	76.29	75.98	76.25	180900.0
2008-06-30	BNE	ETF	13.21	13.27	12.53	12.75	340446.0
2008-06-30	BOSS	ETF	23.82	23.82	23.82	23.82	100.0
2008-06-30	BRF	ETF	14.72	14.72	14.7	14.72	4000.0
2008-06-30	BSV	ETF	77.08	77.39	77.08	77.37	93100.0
2008-06-30	BTF	ETF	91.8	91.8	89.64999999999999	90.25	6405.400000000001
2008-06-30	BWX	ETF	27.67	27.7099	27.5405	27.55	260978.0
2008-06-30	CBON	ETF	5.26	5.9199	5.0	5.01	278773.0
2008-06-30	CDL	ETF	1.23	1.3	1.2	1.22	2321903.0
2008-06-30	CEF	ETF	13.2	13.2	12.9	12.95	1118900.0
2008-06-30	CGO	ETF	15.07	15.29	15.03	15.22	22293.0
2008-06-30	CGW	ETF	23.16	23.71	23.16	23.5432	71941.0
2008-06-30	CHB	ETF	6.1	6.22	5.84	5.85	1565173.0
2008-06-30	CHI	ETF	13.61	14.16	13.51	14.08	277853.0
2008-06-30	CHIC	ETF	17.5	18.66	17.5	17.76	423599.0
2008-06-30	CHW	ETF	10.71	11.0874	10.41	10.97	196102.0
2008-06-30	CHY	ETF	12.92	13.3	12.83	13.25	183998.0
2008-06-30	CMF	ETF	51.295	51.42	51.295	51.4	9124.0
2008-06-30	CN	ETF	54.21	55.35	54.21	54.59	281048.0
2008-06-30	COW	ETF	44.3	44.35	42.99	43.34	777276.0
2008-06-30	CPST	ETF	4.16	4.29	4.08	4.19	6736775.0
2008-06-30	CSA	ETF	15.79	16.69	15.79	16.25	106422.0
2008-06-30	CSB	ETF	19.33	20.25	18.0	18.0	33080.0
2008-06-30	CSD	ETF	21.71	21.78	21.65	21.71	30900.0
2008-06-30	CSQ	ETF	11.55	11.558	11.31	11.32	292013.0
2008-06-30	CUT	ETF	20.32	20.32	19.16	19.16	33100.0

> showing 50 of 607 rows — these rows as CSV

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