PREVIEW / etf_daily / 2008-11-07

all etf daily files

  file:    by_date/etf_daily/2008/2008-11-07.parquet
  size:    27 KB
  rows:    608

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-11-07	SPY	ETF	91.65	94.0	90.5	93.86	380391000.0
2008-11-07	QQQ	ETF	30.92	31.48	30.59	31.19	176977636.0
2008-11-07	IWM	ETF	50.07	51.07	49.31	50.62	62313000.0
2008-11-07	DIA	ETF	87.96	90.16	87.4	90.13	30916600.0
2008-11-07	GLD	ETF	72.59	73.09	72.05	72.5	6052700.0
2008-11-07	TLT	ETF	94.52	94.52	93.55	94.26	1277100.0
2008-11-07	AAXJ	ETF	31.0	32.85	31.0	31.97	254300.0
2008-11-07	ACWI	ETF	31.76	32.81	31.76	32.81	36800.0
2008-11-07	ACWX	ETF	30.0	30.93	30.0	30.93	71188.0
2008-11-07	ADRE	ETF	26.08	27.05	25.99	27.03	590723.0
2008-11-07	AGG	ETF	96.87	97.14	95.23	97.09	878500.0
2008-11-07	AGZ	ETF	102.38	102.38	102.38	102.38	5000.0
2008-11-07	AIA	ETF	24.38	25.7699	24.38	24.9001	22765.0
2008-11-07	AIQ	ETF	45.0	45.0	43.858	44.55	59363.0
2008-11-07	AIS	ETF	0.5	0.52	0.49	0.52	28800.0
2008-11-07	AIVI	ETF	37.42	38.39	37.15	38.25	43200.0
2008-11-07	ARB	ETF	30.44	31.17	29.8	30.59	129535.0
2008-11-07	BAL	ETF	26.47	26.47	26.47	26.47	200.0
2008-11-07	BBH	ETF	56.4767	57.69	56.4767	57.69	1462200.0
2008-11-07	BIL	ETF	91.9	91.9	91.82	91.9	83900.0
2008-11-07	BITS	ETF	15.52	16.12	15.0	15.4	3050.0
2008-11-07	BIV	ETF	71.77	71.77	71.37	71.74	26300.0
2008-11-07	BJK	ETF	16.45	17.0	16.45	17.0	1000.0
2008-11-07	BKF	ETF	24.24	25.3	24.24	24.6934	79360.0
2008-11-07	BLV	ETF	67.59	67.59	66.92	67.37	13900.0
2008-11-07	BMVP	ETF	10.6	10.7369	10.5518	10.72	30512.0
2008-11-07	BND	ETF	74.6	74.74	74.29	74.6	223000.0
2008-11-07	BNE	ETF	8.25	8.56	8.03	8.29	94180.0
2008-11-07	BRF	ETF	14.9	14.9	14.8899	14.89	10511.0
2008-11-07	BSV	ETF	75.94	76.5	75.78	76.5	115300.0
2008-11-07	BTF	ETF	59.85	61.74999999999999	59.800000000000004	61.485	17153.2
2008-11-07	BWX	ETF	24.86	24.86	24.55	24.81	294590.0
2008-11-07	CBON	ETF	4.03	4.67	3.82	3.87	63689.0
2008-11-07	CDL	ETF	0.25	0.27	0.24	0.25	3384448.0
2008-11-07	CEF	ETF	9.25	9.41	9.18	9.27	710300.0
2008-11-07	CGO	ETF	9.25	9.73	9.25	9.51	19258.0
2008-11-07	CGW	ETF	15.27	16.0	15.27	15.687	39567.0
2008-11-07	CHB	ETF	1.85	1.89	1.66	1.7	765433.0
2008-11-07	CHI	ETF	9.0	9.0	8.59	8.89	147187.0
2008-11-07	CHIC	ETF	8.36	8.37	7.34	7.58	314007.0
2008-11-07	CHW	ETF	6.03	6.2	5.95	6.2	140366.0
2008-11-07	CHY	ETF	8.71	8.8	8.5	8.75	169487.0
2008-11-07	CMF	ETF	51.25	51.715	51.25	51.715	7614.0
2008-11-07	CNXT	ETF	1.58	1.616	1.56	1.6	242635.0
2008-11-07	COW	ETF	36.0	36.28	35.95	35.95	19591.0
2008-11-07	CPST	ETF	1.37	1.42	1.32	1.37	1739215.0
2008-11-07	CSA	ETF	11.71	12.11	11.25	11.71	126018.0
2008-11-07	CSB	ETF	16.24	16.9	15.62	15.9	47954.0
2008-11-07	CSD	ETF	12.89	12.98	12.89	12.89	5600.0
2008-11-07	CSQ	ETF	6.51	6.7	6.43	6.65	324134.0

> showing 50 of 608 rows — these rows as CSV

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