PREVIEW / etf_daily / 2007-10-31

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-31.parquet
  size:    24 KB
  rows:    530

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
2007-10-31	SPY	ETF	153.98	155.27	152.84	154.65	220954400.0
2007-10-31	QQQ	ETF	54.47	55.07	54.04	55.03	148431832.0
2007-10-31	IWM	ETF	81.63	82.8	80.77	82.32	107684000.0
2007-10-31	DIA	ETF	138.44	139.53	137.26	138.95	19378200.0
2007-10-31	GLD	ETF	77.78	78.95	76.89	78.62	8872900.0
2007-10-31	TLT	ETF	90.5	90.7	89.75	89.98	2498500.0
2007-10-31	ADRE	ETF	59.5	60.31	58.99	59.97	522959.0
2007-10-31	AGG	ETF	100.56	100.86	100.41	100.61	767000.0
2007-10-31	AIQ	ETF	47.65	49.55	47.1	49.55	42240.0
2007-10-31	AIS	ETF	1.22	1.25	1.22	1.25	116600.0
2007-10-31	AIVI	ETF	77.19	78.06	77.04	77.95	54800.0
2007-10-31	ARB	ETF	50.15	50.94	49.73	50.62	282900.0
2007-10-31	BBH	ETF	59.7433	60.5367	58.67	60.4667	833700.0
2007-10-31	BIL	ETF	91.86	91.88	91.82	91.84	13200.0
2007-10-31	BITS	ETF	25.96	27.04	25.8804	27.0396	7641.0
2007-10-31	BIV	ETF	76.32	76.43	76.03	76.04	14000.0
2007-10-31	BLV	ETF	76.38	76.47	75.9	76.12	5800.0
2007-10-31	BMVP	ETF	17.5433	17.7733	17.49	17.7067	64600.0
2007-10-31	BND	ETF	76.27	76.35	76.0	76.1	116100.0
2007-10-31	BNE	ETF	17.14	17.45	16.94	17.38	128000.0
2007-10-31	BRF	ETF	14.7	14.75	14.62	14.68	8800.0
2007-10-31	BSV	ETF	76.36	76.44	76.23	76.26	31900.0
2007-10-31	BTF	ETF	116.8	118.39999999999999	116.14999999999999	118.14999999999999	3560.0
2007-10-31	BWX	ETF	26.5	26.63	26.485	26.575	74000.0
2007-10-31	CBON	ETF	20.09	20.34	20.0	20.27	131974.0
2007-10-31	CDL	ETF	4.36	4.41	4.25	4.4	2082300.0
2007-10-31	CEF	ETF	10.33	10.5	10.3	10.41	327500.0
2007-10-31	CGO	ETF	19.3	19.51	19.3	19.51	11600.0
2007-10-31	CGW	ETF	26.48	26.6	26.25	26.54	85000.0
2007-10-31	CHB	ETF	11.72	12.04	11.6	11.86	4072100.0
2007-10-31	CHI	ETF	16.91	16.99	16.8	16.9	133400.0
2007-10-31	CHIC	ETF	14.81	14.81	14.25	14.49	542746.0
2007-10-31	CHW	ETF	13.1	13.21	12.91	13.09	245900.0
2007-10-31	CHY	ETF	14.72	14.73	14.62	14.67	138000.0
2007-10-31	CMF	ETF	51.995	51.995	51.955	51.955	2400.0
2007-10-31	CN	ETF	60.6	62.74	60.53	62.39	152400.0
2007-10-31	CNXT	ETF	1.25	1.28	1.23	1.28	5635883.0
2007-10-31	COW	ETF	48.72	48.72	48.72	48.72	200.0
2007-10-31	CPI	ETF	23.5	24.25	23.5	24.25	400.0
2007-10-31	CPST	ETF	1.13	1.15	1.1	1.14	1262621.0
2007-10-31	CSA	ETF	17.1	17.21	16.81	17.14	74500.0
2007-10-31	CSD	ETF	28.91	29.2	28.78	29.2	38400.0
2007-10-31	CSM	ETF	1.47	1.47	1.47	1.47	32000.0
2007-10-31	CSQ	ETF	14.66	14.75	14.63	14.7	206100.0
2007-10-31	CVY	ETF	25.93	26.17	25.89	26.01	71300.0
2007-10-31	CWI	ETF	29.86	30.26	29.7733	30.1533	55500.0
2007-10-31	CZA	ETF	27.01	27.01	27.01	27.01	100.0
2007-10-31	DBA	ETF	29.33	29.61	29.27	29.27	491500.0
2007-10-31	DBB	ETF	25.78	25.83	25.57	25.57	35200.0
2007-10-31	DBC	ETF	29.89	30.5	29.78	30.5	402000.0

> showing 50 of 530 rows — these rows as CSV

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