PREVIEW / etf_daily / 2008-07-21

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-21.parquet
  size:    27 KB
  rows:    606

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-21	SPY	ETF	126.51	126.8	125.19	126.05	222863000.0
2008-07-21	QQQ	ETF	45.0	45.19	44.49	44.78	128107755.0
2008-07-21	IWM	ETF	69.37	69.75	68.98	69.72	70224400.0
2008-07-21	DIA	ETF	115.41	115.51	114.14	114.65	16267700.0
2008-07-21	GLD	ETF	94.75	95.15	94.45	95.12	7323800.0
2008-07-21	TLT	ETF	90.45	90.9	90.25	90.8	3657200.0
2008-07-21	ACWI	ETF	49.15	49.15	48.14	48.15	306900.0
2008-07-21	ACWX	ETF	49.29	49.32	49.18	49.21	13625.0
2008-07-21	ADRE	ETF	48.1	48.73	48.1	48.53	351093.0
2008-07-21	AFK	ETF	41.65	41.65	40.95	41.1	3532.0
2008-07-21	AGG	ETF	99.33	99.5	99.12	99.5	317500.0
2008-07-21	AIA	ETF	41.19	42.36	41.05	41.26	133866.0
2008-07-21	AIQ	ETF	43.3	43.9	43.15	43.45	17439.0
2008-07-21	AIS	ETF	0.68	0.7	0.68	0.7	12400.0
2008-07-21	AIVI	ETF	60.79	60.8	60.36	60.54	14000.0
2008-07-21	ARB	ETF	47.57	48.03	47.31	47.73	621123.0
2008-07-21	BAL	ETF	45.26	45.28	45.26	45.28	2500.0
2008-07-21	BBH	ETF	63.3567	64.1067	63.26	63.75	2338800.0
2008-07-21	BIL	ETF	91.86	91.86	91.76	91.76	43200.0
2008-07-21	BITS	ETF	23.64	23.96	23.12	23.52	1500.0
2008-07-21	BIV	ETF	75.66	75.93	75.55	75.93	45300.0
2008-07-21	BJK	ETF	30.96	30.96	29.95	30.7	2600.0
2008-07-21	BKF	ETF	50.48	50.48	49.57	49.89	23799.0
2008-07-21	BLV	ETF	73.0	73.24	72.86	73.24	4000.0
2008-07-21	BMVP	ETF	14.777	14.831	14.74	14.817	25555.0
2008-07-21	BND	ETF	75.3	75.45	75.15	75.45	84300.0
2008-07-21	BNE	ETF	11.7	11.84	11.6	11.83	86569.0
2008-07-21	BRF	ETF	14.73	14.74	14.73	14.73	8200.0
2008-07-21	BSV	ETF	76.91	77.05	76.81	77.04	78100.0
2008-07-21	BTF	ETF	86.19999999999999	86.54999999999998	85.74999999999999	85.89999999999999	11077.6
2008-07-21	BWX	ETF	27.845	27.95	27.75	27.95	268692.0
2008-07-21	CBON	ETF	3.72	4.75	3.63	4.39	337224.0
2008-07-21	CDL	ETF	0.8	0.95	0.8	0.83	501267.0
2008-07-21	CEF	ETF	13.42	13.44	13.29	13.43	536800.0
2008-07-21	CGO	ETF	15.12	15.12	14.89	14.956	26625.0
2008-07-21	CGW	ETF	23.49	23.51	23.07	23.51	31683.0
2008-07-21	CHB	ETF	2.98	3.21	2.91	2.97	3115975.0
2008-07-21	CHI	ETF	13.27	13.57	13.26	13.42	261273.0
2008-07-21	CHIC	ETF	14.81	14.87	12.69	13.46	2196053.0
2008-07-21	CHW	ETF	10.99	10.99	10.76	10.9	122890.0
2008-07-21	CHY	ETF	12.77	12.85	12.57	12.75	222615.0
2008-07-21	CMF	ETF	51.51	51.54	51.415	51.54	5580.0
2008-07-21	CN	ETF	60.05	62.95	60.05	62.53	225871.0
2008-07-21	COW	ETF	43.15	43.38	42.85	43.36	38390.0
2008-07-21	CPST	ETF	3.6	3.65	3.42	3.48	3115704.0
2008-07-21	CSA	ETF	18.38	18.45	17.98	18.1	31125.0
2008-07-21	CSB	ETF	16.97	17.786	16.85	17.25	18349.0
2008-07-21	CSD	ETF	21.0	21.0	20.91	20.91	1600.0
2008-07-21	CSQ	ETF	10.72	10.89	10.72	10.85	285852.0
2008-07-21	CUT	ETF	18.18	18.75	18.18	18.64	10500.0

> showing 50 of 606 rows — these rows as CSV

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