PREVIEW / etf_daily / 2008-01-11

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-11.parquet
  size:    25 KB
  rows:    562

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-11	SPY	ETF	140.78	141.9	139.0	140.15	267076600.0
2008-01-11	QQQ	ETF	47.72	47.77	46.7	47.05	211685127.0
2008-01-11	IWM	ETF	71.28	71.5	69.91	70.22	120320000.0
2008-01-11	DIA	ETF	127.52	127.58	125.41	126.19	22464400.0
2008-01-11	GLD	ETF	88.04	88.76	87.85	88.58	6978800.0
2008-01-11	TLT	ETF	93.52	94.28	93.4	94.2	1872900.0
2008-01-11	ADRE	ETF	54.03	54.76	53.01	53.35	436564.0
2008-01-11	AGG	ETF	102.2	102.52	102.18	102.51	315700.0
2008-01-11	AIA	ETF	45.75	46.34	45.7	45.7	13700.0
2008-01-11	AIQ	ETF	48.6	49.3	47.9	48.7	28660.0
2008-01-11	AIS	ETF	1.0	1.01	0.97	1.0	16500.0
2008-01-11	AIVI	ETF	68.66	68.73	67.87	67.99	40500.0
2008-01-11	ARB	ETF	40.62	41.14	39.81	41.0	324800.0
2008-01-11	BBH	ETF	56.32	56.92	56.29	56.45	1451100.0
2008-01-11	BIL	ETF	91.64	91.7	91.6	91.62	41650.0
2008-01-11	BITS	ETF	22.52	23.36	21.64	22.32	7459.0
2008-01-11	BIV	ETF	78.29	78.49	78.02	78.43	18700.0
2008-01-11	BKF	ETF	59.32	60.702	58.38	58.6	34600.0
2008-01-11	BLV	ETF	77.03	77.54	76.85	77.54	16000.0
2008-01-11	BMVP	ETF	16.5233	16.6043	16.3767	16.416	39115.0
2008-01-11	BND	ETF	78.26	78.26	77.57	77.77	139200.0
2008-01-11	BNE	ETF	14.43	14.47	13.73	13.73	237600.0
2008-01-11	BRF	ETF	14.63	14.64	14.61	14.61	21300.0
2008-01-11	BSV	ETF	77.92	77.92	77.72	77.89	20700.0
2008-01-11	BTF	ETF	108.2	108.2	107.70049999999999	108.0	2860.0
2008-01-11	BWX	ETF	27.25	27.345	27.11	27.24	73000.0
2008-01-11	CBON	ETF	14.69	15.39	14.49	14.85	81910.0
2008-01-11	CDL	ETF	1.59	1.6	1.55	1.56	1167275.0
2008-01-11	CEF	ETF	11.3	11.47	11.23	11.38	493000.0
2008-01-11	CGO	ETF	19.09	19.45	18.98	18.99	18000.0
2008-01-11	CGW	ETF	24.78	24.84	23.98	24.3001	189239.0
2008-01-11	CHB	ETF	8.0	8.31	7.76	8.12	1211450.0
2008-01-11	CHI	ETF	15.73	15.78	15.57	15.6301	139217.0
2008-01-11	CHIC	ETF	15.26	15.36	14.25	14.56	768860.0
2008-01-11	CHW	ETF	12.92	13.05	12.8	12.93	151230.0
2008-01-11	CHY	ETF	14.1	14.1	13.88	13.97	200690.0
2008-01-11	CMF	ETF	52.79	52.845	52.5755	52.845	12400.0
2008-01-11	CN	ETF	64.61	64.71	63.01	63.7	206500.0
2008-01-11	CNXT	ETF	0.5701	0.7011	0.5701	0.65	11426395.0
2008-01-11	COW	ETF	45.97	45.97	45.13	45.5	28800.0
2008-01-11	CPI	ETF	22.7	22.85	22.7	22.85	1800.0
2008-01-11	CPST	ETF	1.67	1.76	1.56	1.6	3608357.0
2008-01-11	CSA	ETF	15.68	15.93	15.6	15.93	12000.0
2008-01-11	CSD	ETF	24.52	24.72	24.37	24.37	3100.0
2008-01-11	CSQ	ETF	14.08	14.29	14.0366	14.21	311300.0
2008-01-11	CUT	ETF	23.0	23.0	22.55	22.6	25300.0
2008-01-11	CVY	ETF	22.24	22.47	22.21	22.41	11000.0
2008-01-11	CWI	ETF	26.56	26.6133	26.2667	26.4667	27300.0
2008-01-11	CZA	ETF	24.31	24.31	24.31	24.31	100.0
2008-01-11	DBA	ETF	34.75	36.67	34.75	36.45	3238600.0

> showing 50 of 562 rows — these rows as CSV

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