PREVIEW / etf_daily / 2008-04-07

all etf daily files

  file:    by_date/etf_daily/2008/2008-04-07.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-04-07	SPY	ETF	137.87	138.57	136.74	136.96	154245500.0
2008-04-07	QQQ	ETF	46.15	46.41	45.65	45.76	102610742.0
2008-04-07	IWM	ETF	71.66	71.86	70.78	71.04	40283000.0
2008-04-07	DIA	ETF	126.76	127.22	125.75	126.05	12892400.0
2008-04-07	GLD	ETF	90.73	91.75	90.6	91.17	8196200.0
2008-04-07	TLT	ETF	94.62	94.78	93.9	94.7	2231800.0
2008-04-07	ACWI	ETF	52.99	52.99	51.25	51.77	11300.0
2008-04-07	ACWX	ETF	52.21	52.71	50.82	52.71	776.0
2008-04-07	ADRE	ETF	52.33	52.7999	51.74	51.97	272881.0
2008-04-07	AGG	ETF	102.25	102.48	102.04	102.45	417000.0
2008-04-07	AIA	ETF	46.77	46.77	46.03	46.03	50800.0
2008-04-07	AIQ	ETF	43.55	44.4	43.4	43.85	34900.0
2008-04-07	AIS	ETF	0.98	0.98	0.91	0.93	45400.0
2008-04-07	AIVI	ETF	66.95	67.09	66.62	66.73	10700.0
2008-04-07	ARB	ETF	45.27	45.27	44.27	44.47	127500.0
2008-04-07	BBH	ETF	58.1	58.1	57.53	57.6467	665100.0
2008-04-07	BIL	ETF	91.74	91.76	91.68	91.7	46450.0
2008-04-07	BITS	ETF	24.04	24.2	23.2	24.16	7094.0
2008-04-07	BIV	ETF	78.84	79.02	78.51	78.51	54200.0
2008-04-07	BJK	ETF	40.88	41.0	40.82	41.0	1800.0
2008-04-07	BKF	ETF	53.41	53.74	52.72	52.89	14700.0
2008-04-07	BLV	ETF	76.52	76.59	75.9	76.44	6900.0
2008-04-07	BMVP	ETF	15.88	15.9133	15.7667	15.7667	20200.0
2008-04-07	BND	ETF	77.53	77.53	77.05	77.31	105600.0
2008-04-07	BNE	ETF	15.7	15.7	15.36	15.46	136600.0
2008-04-07	BRF	ETF	14.63	14.654	14.62	14.64	6100.0
2008-04-07	BSV	ETF	78.44	78.47	78.2	78.39	96900.0
2008-04-07	BTF	ETF	104.49999999999999	104.6505	103.64999999999999	103.64999999999999	3760.0
2008-04-07	BWX	ETF	28.8	28.8	28.625	28.695	259108.0
2008-04-07	CBON	ETF	12.85	13.3	12.62	12.93	53739.0
2008-04-07	CDL	ETF	1.94	1.94	1.768	1.78	799432.0
2008-04-07	CEF	ETF	12.99	13.1	12.86	12.9	682000.0
2008-04-07	CGO	ETF	16.86	16.88	16.45	16.6	25630.0
2008-04-07	CGW	ETF	24.53	24.75	24.46	24.52	90900.0
2008-04-07	CHB	ETF	11.03	11.2	10.77	10.89	964727.0
2008-04-07	CHI	ETF	14.56	14.75	14.51	14.64	93671.0
2008-04-07	CHIC	ETF	17.37	17.44	17.18	17.22	368887.0
2008-04-07	CHW	ETF	11.71	11.85	11.6864	11.79	81622.0
2008-04-07	CHY	ETF	13.32	13.6	13.3	13.47	129100.0
2008-04-07	CMF	ETF	51.8	51.835	51.66	51.83	34402.0
2008-04-07	CN	ETF	58.8	59.06	58.19	58.66	386100.0
2008-04-07	CNXT	ETF	0.62	0.65	0.61	0.6185	2087022.0
2008-04-07	COW	ETF	41.67	41.75	41.3	41.66	28100.0
2008-04-07	CPI	ETF	18.9	18.95	17.77	17.8	1900.0
2008-04-07	CPST	ETF	2.58	2.63	2.45	2.46	4242274.0
2008-04-07	CSA	ETF	16.67	17.22	16.5	16.52	68400.0
2008-04-07	CSB	ETF	21.75	22.05	21.0	22.0	25500.0
2008-04-07	CSD	ETF	23.83	24.04	23.77	23.77	3800.0
2008-04-07	CSQ	ETF	12.5	12.6599	12.5	12.55	174200.0
2008-04-07	CUT	ETF	22.1	23.01	22.1	22.65	98200.0

> showing 50 of 586 rows — these rows as CSV

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