PREVIEW / etf_daily / 2008-07-11

all etf daily files

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

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-11	SPY	ETF	123.97	125.9	122.49	123.84	481124600.0
2008-07-11	QQQ	ETF	44.81	45.27	43.85	44.56	265514634.0
2008-07-11	IWM	ETF	66.25	67.78	65.67	67.27	131381400.0
2008-07-11	DIA	ETF	111.14	112.44	109.78	111.0	35470100.0
2008-07-11	GLD	ETF	95.03	95.5	94.25	95.16	25994600.0
2008-07-11	TLT	ETF	93.52	93.74	91.86	92.16	5466000.0
2008-07-11	ACWI	ETF	47.59	47.85	47.06	47.5	539500.0
2008-07-11	ACWX	ETF	48.43	48.43	47.34	48.254	4214.0
2008-07-11	ADRE	ETF	48.06	48.65	47.44	48.08	502131.0
2008-07-11	AGG	ETF	101.06	101.06	100.14	100.23	478200.0
2008-07-11	AIA	ETF	39.76	40.795	39.464	40.53	5226.0
2008-07-11	AIQ	ETF	42.3	42.85	41.7	42.4	56422.0
2008-07-11	AIS	ETF	0.71	0.73	0.7	0.72	34600.0
2008-07-11	AIVI	ETF	57.81	57.97	56.6	57.55	160000.0
2008-07-11	ARB	ETF	45.81	46.01	44.94	45.2	666787.0
2008-07-11	BAL	ETF	45.3	45.41	45.3	45.31	3600.0
2008-07-11	BBH	ETF	59.0033	59.0033	58.2267	58.6267	1019400.0
2008-07-11	BIL	ETF	91.8	91.84	91.76	91.82	54100.0
2008-07-11	BITS	ETF	23.52	24.0	23.24	23.948	2968.0
2008-07-11	BIV	ETF	77.19	77.19	76.19	76.42	34200.0
2008-07-11	BJK	ETF	31.74	31.74	30.04	30.15	2300.0
2008-07-11	BKF	ETF	49.92	49.92	49.0008	49.616	33725.0
2008-07-11	BLV	ETF	74.89	74.89	73.93	74.15	12800.0
2008-07-11	BMVP	ETF	14.8733	14.8937	14.3033	14.8233	34316.0
2008-07-11	BND	ETF	76.64	76.64	75.9	75.91	206100.0
2008-07-11	BNE	ETF	11.23	11.83	11.16	11.68	184118.0
2008-07-11	BRF	ETF	14.71	14.719	14.71	14.71	4880.0
2008-07-11	BSV	ETF	77.49	77.6	77.16	77.24	66700.0
2008-07-11	BTF	ETF	83.9	83.9	81.8	83.05	7004.400000000001
2008-07-11	BWX	ETF	28.1	28.125	27.93	27.93	503404.0
2008-07-11	CBON	ETF	3.29	3.75	2.84	3.41	218635.0
2008-07-11	CDL	ETF	0.8	0.98	0.8	0.83	1530350.0
2008-07-11	CEF	ETF	13.95	14.15	13.77	13.97	1397500.0
2008-07-11	CGO	ETF	14.78	14.8	14.5	14.69	24613.0
2008-07-11	CGW	ETF	22.48	22.48	21.77	22.24	109481.0
2008-07-11	CHB	ETF	4.64	5.05	4.41	4.67	2807506.0
2008-07-11	CHI	ETF	13.45	13.45	12.96	13.16	153459.0
2008-07-11	CHIC	ETF	15.74	15.95	15.38	15.84	459879.0
2008-07-11	CHW	ETF	10.73	10.73	10.41	10.63	115076.0
2008-07-11	CHY	ETF	12.58	12.58	12.03	12.18	171405.0
2008-07-11	CMF	ETF	51.8225	51.925	51.615	51.745	10990.0
2008-07-11	CN	ETF	59.0	59.27	57.55	58.56	490525.0
2008-07-11	COW	ETF	44.0	44.0	43.4201	43.6	57474.0
2008-07-11	CPST	ETF	3.45	3.64	3.45	3.62	3139699.0
2008-07-11	CSA	ETF	16.46	16.58	16.19	16.58	79196.0
2008-07-11	CSB	ETF	16.9001	17.05	15.3	16.08	60360.0
2008-07-11	CSD	ETF	20.41	20.76	20.3	20.58	12900.0
2008-07-11	CSQ	ETF	10.67	10.78	10.5	10.6	354336.0
2008-07-11	CUT	ETF	18.07	18.16	17.83	18.13	15500.0
2008-07-11	CVY	ETF	19.72	19.9	19.6	19.85	10100.0

> showing 50 of 604 rows — these rows as CSV

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