PREVIEW / etf_daily / 2008-07-07

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-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-07-07	SPY	ETF	126.79	127.34	123.92	125.02	372427300.0
2008-07-07	QQQ	ETF	45.05	45.46	44.24	44.9	181011239.0
2008-07-07	IWM	ETF	66.73	67.04	64.94	65.69	125544000.0
2008-07-07	DIA	ETF	113.17	113.92	111.14	112.21	27897300.0
2008-07-07	GLD	ETF	90.57	91.65	90.16	91.23	12300200.0
2008-07-07	TLT	ETF	92.07	93.15	91.58	92.49	3528400.0
2008-07-07	ACWI	ETF	47.01	50.7	47.0	48.26	14900.0
2008-07-07	ACWX	ETF	49.09	49.38	48.46	48.68	11549.0
2008-07-07	ADRE	ETF	48.71	49.5	47.96	48.36	577742.0
2008-07-07	AGG	ETF	99.59	100.09	99.34	99.93	603100.0
2008-07-07	AIA	ETF	40.61	40.75	39.74	40.265	10898.0
2008-07-07	AIQ	ETF	41.0	42.05	40.4	41.25	41289.0
2008-07-07	AIS	ETF	0.65	0.72	0.65	0.71	173285.0
2008-07-07	AIVI	ETF	58.26	58.92	57.73	58.25	42300.0
2008-07-07	ARB	ETF	47.0	47.59	46.55	47.09	202338.0
2008-07-07	BAL	ETF	46.09	46.15	44.81	45.21	22325.0
2008-07-07	BBH	ETF	57.6733	57.7333	56.6733	56.9367	1474800.0
2008-07-07	BIL	ETF	91.72	91.74	91.62	91.7	87900.0
2008-07-07	BITS	ETF	24.4	24.96	23.8	24.16	5516.0
2008-07-07	BIV	ETF	76.32	76.7	76.06	76.4	43900.0
2008-07-07	BJK	ETF	31.78	31.78	30.85	31.02	2000.0
2008-07-07	BKF	ETF	50.0	50.01	48.44	49.07	59472.0
2008-07-07	BLV	ETF	74.36	74.47	74.08	74.45	3900.0
2008-07-07	BMVP	ETF	14.92	15.02	14.64	14.77	48504.0
2008-07-07	BND	ETF	75.7	75.95	75.26	75.74	216700.0
2008-07-07	BNE	ETF	11.87	11.92	11.19	11.36	238684.0
2008-07-07	BRF	ETF	14.7	14.7154	14.67	14.67	14400.0
2008-07-07	BSV	ETF	77.28	77.47	77.11	77.36	77000.0
2008-07-07	BTF	ETF	85.85000000000001	86.25	82.89999999999999	83.14999999999999	7462.0
2008-07-07	BWX	ETF	27.585	27.765	27.5	27.725	433490.0
2008-07-07	CBON	ETF	4.33	4.58	4.25	4.41	184591.0
2008-07-07	CDL	ETF	1.08	1.13	1.04	1.08	2321736.0
2008-07-07	CEF	ETF	13.29	13.35	13.08	13.18	726200.0
2008-07-07	CGO	ETF	15.06	15.09	14.93	15.08	18649.0
2008-07-07	CGW	ETF	22.72	22.8	22.4	22.45	116880.0
2008-07-07	CHB	ETF	5.37	5.45	4.97	5.05	1699313.0
2008-07-07	CHI	ETF	13.65	13.65	13.1	13.16	177823.0
2008-07-07	CHIC	ETF	17.98	18.44	16.31	16.77	546883.0
2008-07-07	CHW	ETF	11.04	11.05	10.67	10.79	96816.0
2008-07-07	CHY	ETF	12.81	12.93	12.27	12.43	255187.0
2008-07-07	CMF	ETF	52.5	52.5	51.555	51.585	9500.0
2008-07-07	CN	ETF	56.5	57.34	54.99	56.26	212407.0
2008-07-07	COW	ETF	43.66	43.66	42.83	43.06	125425.0
2008-07-07	CPI	ETF	22.01	22.01	22.0	22.0	290.0
2008-07-07	CPST	ETF	3.33	3.6008	3.3	3.41	4859059.0
2008-07-07	CSA	ETF	16.3	16.49	16.03	16.12	54700.0
2008-07-07	CSB	ETF	18.4	18.5	17.03	17.74	34120.0
2008-07-07	CSD	ETF	20.45	21.19	20.45	20.94	18200.0
2008-07-07	CSQ	ETF	10.95	11.07	10.71	10.94	345753.0
2008-07-07	CUT	ETF	18.5	18.65	18.17	18.2	41900.0

> showing 50 of 608 rows — these rows as CSV

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