PREVIEW / etf_daily / 2008-07-30

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-30.parquet
  size:    27 KB
  rows:    613

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-30	SPY	ETF	127.11	128.6	126.28	128.53	354710000.0
2008-07-30	QQQ	ETF	45.46	45.82	44.88	45.57	165679874.0
2008-07-30	IWM	ETF	71.59	72.07	70.64	71.61	153225200.0
2008-07-30	DIA	ETF	114.59	115.93	114.02	115.82	24422400.0
2008-07-30	GLD	ETF	88.86	89.72	88.08	89.52	17379900.0
2008-07-30	TLT	ETF	90.09	91.29	90.03	90.77	1667500.0
2008-07-30	ACWI	ETF	47.95	48.24	47.68	47.98	39500.0
2008-07-30	ACWX	ETF	48.36	48.63	48.17	48.63	6676.0
2008-07-30	ADRE	ETF	47.59	48.24	47.47	48.24	634223.0
2008-07-30	AFK	ETF	41.51	41.51	40.0	40.82	6650.0
2008-07-30	AGG	ETF	99.87	99.98	99.48	99.9	403800.0
2008-07-30	AIA	ETF	41.5752	41.5752	41.13	41.4	35100.0
2008-07-30	AIQ	ETF	45.9	47.35	45.7	46.3	57875.0
2008-07-30	AIS	ETF	0.74	0.79	0.74	0.79	130500.0
2008-07-30	AIVI	ETF	59.05	59.34	58.81	59.34	21300.0
2008-07-30	ARB	ETF	46.18	47.21	46.18	46.83	222717.0
2008-07-30	BBH	ETF	67.2967	67.2967	66.42	67.0	465900.0
2008-07-30	BIL	ETF	91.84	91.86	91.78	91.86	36750.0
2008-07-30	BITS	ETF	22.8	22.8	22.04	22.04	1400.0
2008-07-30	BIV	ETF	75.81	76.09	75.58	75.97	34100.0
2008-07-30	BJK	ETF	31.25	31.25	30.75	30.75	1200.0
2008-07-30	BKF	ETF	48.23	49.35	48.21	49.35	51074.0
2008-07-30	BLV	ETF	73.02	73.66	72.94	73.43	3500.0
2008-07-30	BMVP	ETF	14.97	15.18	14.97	15.18	18144.0
2008-07-30	BND	ETF	75.59	75.8	75.35	75.71	77400.0
2008-07-30	BNE	ETF	13.12	13.51	12.87	13.08	104200.0
2008-07-30	BOSS	ETF	22.1	22.89	22.1	22.89	100.0
2008-07-30	BRF	ETF	14.78	14.78	14.73	14.73	12600.0
2008-07-30	BSV	ETF	77.14	77.28	77.04	77.24	89100.0
2008-07-30	BTF	ETF	82.5	83.24999999999999	81.99999999999999	83.2	3506.6000000000004
2008-07-30	BWX	ETF	27.65	27.87	27.5551	27.87	195734.0
2008-07-30	CBON	ETF	4.33	4.93	4.33	4.5	310391.0
2008-07-30	CDL	ETF	1.03	1.03	0.89	0.95	1342285.0
2008-07-30	CEF	ETF	12.77	12.95	12.34	12.85	836200.0
2008-07-30	CGO	ETF	15.2	15.22	14.95	15.2	15881.0
2008-07-30	CGW	ETF	23.23	23.61	23.22	23.48	28773.0
2008-07-30	CHB	ETF	3.88	4.245	3.85	3.99	2985666.0
2008-07-30	CHI	ETF	13.56	13.6246	13.29	13.36	129195.0
2008-07-30	CHIC	ETF	13.2	13.29	12.4	12.76	565850.0
2008-07-30	CHW	ETF	11.0	11.03	10.86	11.03	107373.0
2008-07-30	CHY	ETF	13.2	13.2	12.75	12.84	98402.0
2008-07-30	CMF	ETF	51.165	51.24	50.89	51.015	93224.0
2008-07-30	CN	ETF	60.95	61.79	60.49	61.7	178458.0
2008-07-30	COW	ETF	43.0	43.42	42.94	43.3	27265.0
2008-07-30	CPST	ETF	3.4	3.4	3.18	3.23	4288908.0
2008-07-30	CSA	ETF	18.88	19.52	18.535	18.7	83195.0
2008-07-30	CSB	ETF	18.65	18.65	18.13	18.51	15880.0
2008-07-30	CSD	ETF	21.22	21.22	21.07	21.07	3800.0
2008-07-30	CSQ	ETF	10.95	11.14	10.95	11.09	286407.0
2008-07-30	CUT	ETF	18.42	18.86	18.42	18.77	27200.0

> showing 50 of 613 rows — these rows as CSV

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