PREVIEW / etf_daily / 2008-04-25

all etf daily files

  file:    by_date/etf_daily/2008/2008-04-25.parquet
  size:    26 KB
  rows:    587

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-04-25	SPY	ETF	139.4	139.89	137.91	139.6	190788100.0
2008-04-25	QQQ	ETF	47.31	47.35	46.57	47.15	121945352.0
2008-04-25	IWM	ETF	71.81	72.27	70.81	71.9	56252000.0
2008-04-25	DIA	ETF	128.91	128.94	127.32	128.8	12363400.0
2008-04-25	GLD	ETF	88.33	88.42	87.19	87.27	11179900.0
2008-04-25	TLT	ETF	92.14	92.25	91.5	91.82	1742000.0
2008-04-25	ACWI	ETF	52.88	52.88	52.57	52.72	1700.0
2008-04-25	ACWX	ETF	53.65	53.65	53.55	53.55	2800.0
2008-04-25	ADRE	ETF	54.8	54.8	53.07	53.7	285805.0
2008-04-25	AGG	ETF	101.52	101.67	101.34	101.58	507900.0
2008-04-25	AIA	ETF	48.05	49.23	46.64	46.64	58705.0
2008-04-25	AIQ	ETF	41.25	41.25	39.8	40.45	31635.0
2008-04-25	AIS	ETF	0.9	0.9	0.87	0.88	126300.0
2008-04-25	AIVI	ETF	66.9	66.93	66.46	66.83	29300.0
2008-04-25	ARB	ETF	49.25	49.25	48.1355	48.78	160122.0
2008-04-25	BBH	ETF	56.23	56.23	55.3367	55.6967	245400.0
2008-04-25	BIL	ETF	91.72	91.76	91.7	91.76	39700.0
2008-04-25	BITS	ETF	24.24	24.72	24.08	24.2	4111.0
2008-04-25	BIV	ETF	77.83	78.06	77.53	77.72	53800.0
2008-04-25	BJK	ETF	38.6	38.6	38.0	38.0	500.0
2008-04-25	BKF	ETF	55.96	56.27	55.1	56.21	52984.0
2008-04-25	BLV	ETF	75.5	75.59	75.12	75.58	52500.0
2008-04-25	BMVP	ETF	16.0767	16.1947	16.05	16.18	32290.0
2008-04-25	BND	ETF	76.67	76.77	76.54	76.73	134300.0
2008-04-25	BNE	ETF	16.67	16.67	16.36	16.61	281653.0
2008-04-25	BOSS	ETF	31.35	33.09	31.35	33.09	100.0
2008-04-25	BRF	ETF	14.66	14.71	14.65	14.67	8900.0
2008-04-25	BSV	ETF	77.71	78.0	77.71	77.92	142000.0
2008-04-25	BTF	ETF	102.5	102.5	101.5	101.8	7116.400000000001
2008-04-25	BWX	ETF	28.165	28.165	27.81	27.83	390440.0
2008-04-25	CBON	ETF	11.62	13.1	11.02	12.32	173920.0
2008-04-25	CDL	ETF	1.23	1.34	1.2	1.26	1669027.0
2008-04-25	CEF	ETF	12.2	12.32	12.13	12.25	636100.0
2008-04-25	CGO	ETF	16.7	16.7	16.5	16.65	13075.0
2008-04-25	CGW	ETF	24.76	25.0	24.46	24.74	80677.0
2008-04-25	CHB	ETF	10.5	10.69	10.03	10.4	933001.0
2008-04-25	CHI	ETF	15.39	15.53	15.25	15.4	116671.0
2008-04-25	CHIC	ETF	16.54	16.65	15.66	16.23	957395.0
2008-04-25	CHW	ETF	11.85	11.89	11.748	11.81	91231.0
2008-04-25	CHY	ETF	14.25	14.33	14.04	14.17	120070.0
2008-04-25	CMF	ETF	52.245	52.28	52.195	52.195	9200.0
2008-04-25	CN	ETF	59.6	60.13	58.59	59.46	246482.0
2008-04-25	CNXT	ETF	0.46	0.48	0.45	0.464	2009693.0
2008-04-25	COW	ETF	43.8	43.96	43.484	43.96	98068.0
2008-04-25	CPI	ETF	19.1	19.1	19.1	19.1	200.0
2008-04-25	CPST	ETF	2.8	2.84	2.69	2.74	2484612.0
2008-04-25	CSA	ETF	16.55	16.67	16.24	16.6	45194.0
2008-04-25	CSB	ETF	22.5	22.89	22.26	22.5	19750.0
2008-04-25	CSD	ETF	23.5	23.53	23.23	23.53	2900.0
2008-04-25	CSQ	ETF	12.53	12.66	12.4716	12.6	251896.0

> showing 50 of 587 rows — these rows as CSV

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