PREVIEW / etf_daily / 2008-07-02

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-02.parquet
  size:    27 KB
  rows:    599

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-02	SPY	ETF	128.79	129.16	125.95	126.18	288064600.0
2008-07-02	QQQ	ETF	45.96	46.13	44.64	44.71	199725486.0
2008-07-02	IWM	ETF	68.92	69.18	66.85	66.89	148254900.0
2008-07-02	DIA	ETF	113.78	114.26	112.03	112.15	24730000.0
2008-07-02	GLD	ETF	92.28	93.33	92.13	93.17	11460400.0
2008-07-02	TLT	ETF	91.96	92.38	91.87	92.27	2413700.0
2008-07-02	ACWI	ETF	49.29	49.29	48.18	48.27	8100.0
2008-07-02	ACWX	ETF	49.31	49.3151	49.31	49.31	102275.0
2008-07-02	ADRE	ETF	50.34	51.05	48.84	48.84	726319.0
2008-07-02	AGG	ETF	100.01	100.04	99.55	99.55	812400.0
2008-07-02	AIA	ETF	40.78	40.95	40.0	40.0	6623.0
2008-07-02	AIQ	ETF	43.05	43.1	41.8	42.1	48065.0
2008-07-02	AIS	ETF	0.66	0.69	0.64	0.69	179976.0
2008-07-02	AIVI	ETF	59.45	59.71	58.0	58.0	26800.0
2008-07-02	ARB	ETF	48.16	48.21	46.88	47.01	251765.0
2008-07-02	BAL	ETF	46.96	47.072	46.87	47.072	2208.0
2008-07-02	BBH	ETF	57.6667	57.6667	56.98	57.17	468300.0
2008-07-02	BIL	ETF	91.74	91.74	91.64	91.72	41550.0
2008-07-02	BITS	ETF	25.24	25.4	23.5	24.56	3926.0
2008-07-02	BIV	ETF	76.01	76.36	75.74	76.28	23700.0
2008-07-02	BJK	ETF	32.39	32.5	31.6	31.74	7600.0
2008-07-02	BKF	ETF	52.04	52.04	49.39	49.39	55389.0
2008-07-02	BLV	ETF	74.24	74.48	74.16	74.46	9000.0
2008-07-02	BMVP	ETF	15.2433	15.4267	14.9571	14.9767	47004.0
2008-07-02	BND	ETF	75.85	75.85	75.5	75.64	118400.0
2008-07-02	BNE	ETF	12.44	12.52	11.66	11.66	241843.0
2008-07-02	BRF	ETF	14.74	14.74	14.7399	14.7399	5200.0
2008-07-02	BSV	ETF	77.18	77.26	77.03	77.2	71500.0
2008-07-02	BTF	ETF	87.69999999999999	88.45	86.44999999999999	86.44999999999999	2438.6
2008-07-02	BWX	ETF	27.73	27.76	27.64	27.76	272818.0
2008-07-02	CBON	ETF	5.0	5.06	4.75	4.95	189809.0
2008-07-02	CDL	ETF	1.14	1.18	1.1	1.11	1181697.0
2008-07-02	CEF	ETF	13.44	13.49	13.22	13.42	525100.0
2008-07-02	CGO	ETF	15.33	15.33	15.14	15.2	11215.0
2008-07-02	CGW	ETF	23.28	23.64	22.45	22.48	56968.0
2008-07-02	CHB	ETF	5.83	5.97	5.39	5.4	1733638.0
2008-07-02	CHI	ETF	14.15	14.17	13.94	13.98	115657.0
2008-07-02	CHIC	ETF	17.98	18.35	17.46	17.55	274565.0
2008-07-02	CHW	ETF	11.12	11.13	10.91	10.94	64664.0
2008-07-02	CHY	ETF	13.42	13.42	13.1701	13.18	81020.0
2008-07-02	CMF	ETF	51.73	51.73	51.1	51.115	3806.0
2008-07-02	CN	ETF	54.79	55.7	53.67	53.83	344515.0
2008-07-02	COW	ETF	43.5	43.75	43.3101	43.73	151775.0
2008-07-02	CPST	ETF	3.99	4.05	3.57	3.62	7032842.0
2008-07-02	CSA	ETF	16.7	16.76	16.23	16.37	129180.0
2008-07-02	CSB	ETF	18.6	19.06	18.6	18.75	16647.0
2008-07-02	CSD	ETF	21.54	21.54	21.0	21.0	8300.0
2008-07-02	CSQ	ETF	11.2	11.32	10.92	10.93	236432.0
2008-07-02	CUT	ETF	18.51	19.66	18.51	18.86	19300.0
2008-07-02	CVY	ETF	20.69	20.74	20.28	20.33	14700.0

> showing 50 of 599 rows — these rows as CSV

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