PREVIEW / etf_daily / 2008-01-03

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-03.parquet
  size:    25 KB
  rows:    553

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-03	SPY	ETF	144.91	145.49	144.07	144.86	125133300.0
2008-01-03	QQQ	ETF	50.4	50.76	50.15	50.62	114105510.0
2008-01-03	IWM	ETF	75.27	75.62	74.03	74.33	78036800.0
2008-01-03	DIA	ETF	130.71	131.27	130.13	130.74	8206300.0
2008-01-03	GLD	ETF	84.87	85.94	84.6	85.57	9553900.0
2008-01-03	TLT	ETF	94.0	94.38	93.67	94.25	1256700.0
2008-01-03	ADRE	ETF	54.12	54.73	54.12	54.38	204105.0
2008-01-03	AGG	ETF	101.62	101.92	101.37	101.92	370600.0
2008-01-03	AIA	ETF	48.64	48.64	46.93	47.0	19400.0
2008-01-03	AIQ	ETF	46.3	48.0	46.0	46.75	43160.0
2008-01-03	AIS	ETF	0.99	0.99	0.95	0.972	106200.0
2008-01-03	AIVI	ETF	70.23	70.57	70.09	70.18	34400.0
2008-01-03	ARB	ETF	40.54	40.98	40.25	40.27	221400.0
2008-01-03	BBH	ETF	53.8633	54.24	53.5833	53.9	997500.0
2008-01-03	BIL	ETF	91.66	91.66	91.6	91.6	30500.0
2008-01-03	BITS	ETF	25.56	25.56	24.36	24.4	4862.0
2008-01-03	BIV	ETF	77.86	78.0	77.6	78.0	55300.0
2008-01-03	BKF	ETF	59.03	59.39	58.63	58.74	28500.0
2008-01-03	BLV	ETF	77.38	77.61	77.19	77.61	19600.0
2008-01-03	BMVP	ETF	17.0533	17.21	17.0333	17.0967	61100.0
2008-01-03	BND	ETF	78.05	78.05	77.13	77.46	281400.0
2008-01-03	BNE	ETF	16.96	17.06	16.3	16.3	217100.0
2008-01-03	BRF	ETF	14.71	14.71	14.63	14.63	7900.0
2008-01-03	BSV	ETF	77.97	77.97	77.33	77.49	39300.0
2008-01-03	BTF	ETF	110.05	110.64999999999999	109.8	110.29999999999998	4060.0
2008-01-03	BWX	ETF	27.075	27.16	27.05	27.145	221082.0
2008-01-03	CBON	ETF	16.5	16.76	14.78	15.13	155532.0
2008-01-03	CDL	ETF	2.07	2.07	1.88	1.93	3088308.0
2008-01-03	CEF	ETF	11.19	11.28	11.07	11.2	507100.0
2008-01-03	CGO	ETF	19.6	19.6	19.28	19.29	9400.0
2008-01-03	CGW	ETF	25.95	25.99	25.66	25.85	161400.0
2008-01-03	CHB	ETF	8.89	9.24	8.6	8.64	1106140.0
2008-01-03	CHI	ETF	14.74	15.11	14.74	15.0199	172806.0
2008-01-03	CHIC	ETF	15.27	15.85	15.27	15.68	924474.0
2008-01-03	CHW	ETF	12.85	13.14	12.71	13.07	169894.0
2008-01-03	CHY	ETF	13.56	13.72	13.4	13.72	189000.0
2008-01-03	CMF	ETF	52.165	52.45	52.165	52.45	11400.0
2008-01-03	CN	ETF	59.15	59.73	58.57	59.17	180001.0
2008-01-03	CNXT	ETF	0.8	0.8	0.75	0.75	5050332.0
2008-01-03	COW	ETF	47.31	47.32	46.64	46.86	42200.0
2008-01-03	CPI	ETF	23.25	23.45	23.1	23.15	5600.0
2008-01-03	CPST	ETF	1.65	1.79	1.65	1.76	4255552.0
2008-01-03	CSA	ETF	16.01	16.01	15.62	15.67	31000.0
2008-01-03	CSD	ETF	26.42	26.42	26.09	26.09	10700.0
2008-01-03	CSQ	ETF	13.78	14.21	13.78	14.11	242623.0
2008-01-03	CUT	ETF	24.04	24.05	23.95	23.95	24800.0
2008-01-03	CVY	ETF	23.28	23.28	22.98	23.0	10800.0
2008-01-03	CWI	ETF	27.3733	27.5	27.3467	27.4333	88050.0
2008-01-03	DBA	ETF	33.76	34.22	33.56	34.22	2211200.0
2008-01-03	DBB	ETF	22.65	23.39	22.65	23.38	36800.0

> showing 50 of 553 rows — these rows as CSV

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