PREVIEW / etf_daily / 2008-01-17

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-17.parquet
  size:    25 KB
  rows:    560

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-01-17	SPY	ETF	137.81	137.88	132.93	133.43	397892600.0
2008-01-17	QQQ	ETF	46.24	46.58	45.2	45.41	254455987.0
2008-01-17	IWM	ETF	69.98	70.1	67.68	67.88	123268100.0
2008-01-17	DIA	ETF	125.05	125.2	121.27	121.77	30879600.0
2008-01-17	GLD	ETF	87.5	87.98	86.47	86.5	13592300.0
2008-01-17	TLT	ETF	94.96	96.29	94.93	96.15	2940500.0
2008-01-17	ADRE	ETF	50.01	50.36	47.64	47.86	1180278.0
2008-01-17	AGG	ETF	102.77	103.27	102.58	103.27	807500.0
2008-01-17	AIA	ETF	44.17	44.17	42.64	42.64	9200.0
2008-01-17	AIQ	ETF	49.75	51.15	49.55	50.0	70946.0
2008-01-17	AIS	ETF	0.98	0.99	0.94	0.97	60000.0
2008-01-17	AIVI	ETF	66.38	66.7	64.34	64.46	78500.0
2008-01-17	ARB	ETF	41.6	41.74	40.24	40.55	197900.0
2008-01-17	BBH	ETF	56.0233	56.3433	55.5967	55.8067	904200.0
2008-01-17	BIL	ETF	91.66	91.72	91.62	91.64	380400.0
2008-01-17	BITS	ETF	22.64	23.08	21.2	21.2	7050.0
2008-01-17	BIV	ETF	78.81	79.33	78.72	79.31	28400.0
2008-01-17	BKF	ETF	53.86	54.21	51.57	51.79	49200.0
2008-01-17	BLV	ETF	77.72	78.49	77.72	78.43	9800.0
2008-01-17	BMVP	ETF	16.12	16.19	15.59	15.59	106385.0
2008-01-17	BND	ETF	77.94	78.32	77.94	78.32	131700.0
2008-01-17	BNE	ETF	13.3	13.33	12.89	12.97	449200.0
2008-01-17	BRF	ETF	14.61	14.61	14.61	14.61	7300.0
2008-01-17	BSV	ETF	78.04	78.29	78.03	78.22	87200.0
2008-01-17	BTF	ETF	104.74999999999999	104.74999999999999	102.6	102.6	4020.0
2008-01-17	BWX	ETF	27.31	27.37	27.25	27.34	634800.0
2008-01-17	CBON	ETF	15.03	15.08	14.26	14.39	92268.0
2008-01-17	CDL	ETF	1.62	1.69	1.53	1.64	2129330.0
2008-01-17	CEF	ETF	11.31	11.53	11.2	11.25	579900.0
2008-01-17	CGO	ETF	18.14	18.5	17.73	17.73	22911.0
2008-01-17	CGW	ETF	23.5	23.95	23.0	23.0	117294.0
2008-01-17	CHB	ETF	7.74	7.99	7.39	7.67	1343400.0
2008-01-17	CHI	ETF	15.83	15.87	14.94	15.0	186550.0
2008-01-17	CHIC	ETF	14.64	14.85	14.46	14.56	1235059.0
2008-01-17	CHW	ETF	12.86	12.87	12.3868	12.45	187800.0
2008-01-17	CHY	ETF	14.22	14.25	13.53	13.65	199850.0
2008-01-17	CMF	ETF	52.985	53.235	52.95	53.235	32600.0
2008-01-17	CN	ETF	63.61	64.35	61.05	61.22	348343.0
2008-01-17	CNXT	ETF	0.72	0.72	0.68	0.68	2958164.0
2008-01-17	COW	ETF	44.53	45.16	44.01	45.04	13000.0
2008-01-17	CPI	ETF	22.2	22.55	22.04	22.2	3000.0
2008-01-17	CPST	ETF	1.55	1.65	1.42	1.44	3147955.0
2008-01-17	CSA	ETF	15.98	16.0	15.62	15.62	6600.0
2008-01-17	CSD	ETF	24.1	24.15	23.36	23.39	12700.0
2008-01-17	CSQ	ETF	13.75	13.87	13.52	13.69	320516.0
2008-01-17	CUT	ETF	21.44	21.6	20.9	21.07	14200.0
2008-01-17	CVY	ETF	22.13	22.13	21.42	21.46	20000.0
2008-01-17	CWI	ETF	25.5667	25.5667	24.72	24.8133	243600.0
2008-01-17	CZA	ETF	23.53	23.53	23.53	23.53	800.0
2008-01-17	DBA	ETF	36.93	37.57	36.86	37.5	3430200.0

> showing 50 of 560 rows — these rows as CSV

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