PREVIEW / etf_daily / 2008-09-18

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-18.parquet
  size:    28 KB
  rows:    620

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-09-18	SPY	ETF	118.05	121.79	113.8	120.07	776114700.0
2008-09-18	QQQ	ETF	41.12	41.97	39.5	41.57	423934463.0
2008-09-18	IWM	ETF	69.4	72.15	67.16	71.8	355117000.0
2008-09-18	DIA	ETF	107.42	111.0	104.86	109.97	65447400.0
2008-09-18	GLD	ETF	85.49	90.78	81.9	82.8	60589200.0
2008-09-18	TLT	ETF	97.95	98.49	96.92	97.05	4188300.0
2008-09-18	AAXJ	ETF	41.41	43.16	41.02	43.14	4500.0
2008-09-18	ACWI	ETF	42.64	42.96	40.64	42.7	25900.0
2008-09-18	ACWX	ETF	39.65	40.8301	38.97	40.8301	19236.0
2008-09-18	ADRE	ETF	35.93	38.56	35.3	38.05	1408169.0
2008-09-18	AFK	ETF	33.0	33.0	32.96	32.96	450.0
2008-09-18	AGG	ETF	100.5	101.19	100.25	100.55	1016900.0
2008-09-18	AIA	ETF	32.03	33.902	31.91	33.902	36464.0
2008-09-18	AIQ	ETF	52.65	55.65	51.75	55.15	109506.0
2008-09-18	AIS	ETF	0.53	0.66	0.53	0.66	108766.0
2008-09-18	AIVI	ETF	49.96	51.34	48.84	51.11	72400.0
2008-09-18	ARB	ETF	46.83	48.47	46.68	47.8	671015.0
2008-09-18	BAL	ETF	38.05	38.05	37.22	37.45	2300.0
2008-09-18	BBH	ETF	61.7033	62.2967	60.33	62.1667	830700.0
2008-09-18	BIL	ETF	92.0	92.8	91.84	92.08	916150.0
2008-09-18	BITS	ETF	19.92	21.92	18.66	21.6	58563.0
2008-09-18	BIV	ETF	76.34	76.64	75.0	75.54	96700.0
2008-09-18	BJK	ETF	25.78	25.78	25.78	25.78	100.0
2008-09-18	BKF	ETF	32.78	35.096	32.26	35.096	100580.0
2008-09-18	BLV	ETF	75.92	75.92	74.01	74.5	23000.0
2008-09-18	BMVP	ETF	13.75	14.1	13.22	14.01	94258.0
2008-09-18	BND	ETF	76.77	76.96	75.56	75.68	359200.0
2008-09-18	BNE	ETF	12.3	12.63	11.76	12.35	331017.0
2008-09-18	BRF	ETF	14.67	14.74	14.67	14.74	51900.0
2008-09-18	BSV	ETF	77.44	77.97	77.02	77.73	200300.0
2008-09-18	BTF	ETF	73.35	75.55	68.0	75.5	19119.600000000002
2008-09-18	BWX	ETF	25.745	26.0	24.325	25.535	609574.0
2008-09-18	CBON	ETF	4.49	5.17	4.49	5.0	154822.0
2008-09-18	CDL	ETF	0.88	0.88	0.72	0.8	1709248.0
2008-09-18	CEF	ETF	11.14	11.77	10.36	10.43	4322400.0
2008-09-18	CGO	ETF	10.81	11.24	10.01	11.24	41552.0
2008-09-18	CGW	ETF	20.11	21.6	20.11	21.37	118222.0
2008-09-18	CHB	ETF	5.17	6.47	4.55	6.24	3130648.0
2008-09-18	CHI	ETF	9.14	10.02	8.75	9.98	665819.0
2008-09-18	CHIC	ETF	11.73	12.09	10.435	11.52	1098279.0
2008-09-18	CHW	ETF	7.34	8.22	6.94	7.96	648918.0
2008-09-18	CHY	ETF	8.81	10.3	8.62	10.22	778483.0
2008-09-18	CMF	ETF	50.9	51.46	49.307	50.0	18574.0
2008-09-18	CN	ETF	41.98	46.77	40.92	46.75	558560.0
2008-09-18	CNXT	ETF	4.03	4.03	3.54	3.8	913607.0
2008-09-18	COW	ETF	41.4	41.5999	40.02	40.38	132580.0
2008-09-18	CPI	ETF	22.18	23.5	22.18	22.45	2890.0
2008-09-18	CPST	ETF	1.3	1.44	1.12	1.34	13877776.0
2008-09-18	CSA	ETF	16.77	17.03	16.34	16.7	163425.0
2008-09-18	CSB	ETF	15.0	16.34	14.4	16.33	33749.0

> showing 50 of 620 rows — these rows as CSV

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