PREVIEW / etf_daily / 2007-11-29

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-29.parquet
  size:    24 KB
  rows:    534

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-11-29	SPY	ETF	146.62	147.72	146.1	147.18	199409900.0
2007-11-29	QQQ	ETF	51.27	51.89	51.2	51.7	172087257.0
2007-11-29	IWM	ETF	76.58	76.96	75.91	76.21	57418400.0
2007-11-29	DIA	ETF	132.49	133.48	132.18	133.17	15940400.0
2007-11-29	GLD	ETF	79.28	79.33	78.28	78.28	9306700.0
2007-11-29	TLT	ETF	94.82	95.42	94.66	94.84	1594500.0
2007-11-29	ADRE	ETF	54.5	55.21	54.0	54.47	191229.0
2007-11-29	AGG	ETF	101.86	102.08	101.51	101.79	1496800.0
2007-11-29	AIA	ETF	49.56	50.02	48.99	49.89	17800.0
2007-11-29	AIQ	ETF	49.25	50.1	47.2	47.4	30640.0
2007-11-29	AIS	ETF	1.03	1.05	1.02	1.05	130400.0
2007-11-29	AIVI	ETF	73.29	74.01	73.18	73.71	39000.0
2007-11-29	ARB	ETF	40.59	40.59	39.3601	39.58	664290.0
2007-11-29	BBH	ETF	59.85	60.1433	59.51	59.96	601500.0
2007-11-29	BIL	ETF	91.86	91.96	91.86	91.88	36550.0
2007-11-29	BITS	ETF	20.76	23.0	20.48	22.92	22545.0
2007-11-29	BIV	ETF	77.84	78.06	77.82	77.85	16400.0
2007-11-29	BKF	ETF	59.42	59.45	58.5	58.65	31600.0
2007-11-29	BLV	ETF	78.08	78.23	78.02	78.02	2100.0
2007-11-29	BMVP	ETF	16.833	17.068	16.833	17.0	26031.0
2007-11-29	BND	ETF	77.32	77.39	71.36	77.3	119500.0
2007-11-29	BNE	ETF	17.0	17.97	16.84	17.9	455200.0
2007-11-29	BRF	ETF	14.62	14.62	14.58	14.592	9400.0
2007-11-29	BSV	ETF	77.41	77.44	77.21	77.21	38900.0
2007-11-29	BTF	ETF	113.45	113.94999999999999	112.75	113.24299999999998	1420.0
2007-11-29	BWX	ETF	27.175	27.23	27.125	27.21	78600.0
2007-11-29	CBON	ETF	19.09	19.47	18.83	18.95	47755.0
2007-11-29	CDL	ETF	2.29	2.3	2.17	2.19	1845720.0
2007-11-29	CEF	ETF	10.63	10.69	10.46	10.5	305400.0
2007-11-29	CGO	ETF	18.25	18.81	18.12	18.81	22600.0
2007-11-29	CGW	ETF	25.65	26.1	25.28	25.54	202200.0
2007-11-29	CHB	ETF	9.09	9.12	8.67	8.8	986038.0
2007-11-29	CHI	ETF	14.02	14.55	14.02	14.32	210329.0
2007-11-29	CHIC	ETF	15.9	16.04	15.495	15.99	452197.0
2007-11-29	CHW	ETF	12.05	12.51	11.96	12.49	334400.0
2007-11-29	CHY	ETF	13.2	13.28	12.8	13.2	261623.0
2007-11-29	CMF	ETF	52.4	52.4	52.4	52.4	1000.0
2007-11-29	CN	ETF	62.58	63.51	61.78	62.77	453890.0
2007-11-29	CNXT	ETF	1.15	1.15	1.11	1.12	6188496.0
2007-11-29	COW	ETF	49.07	49.16	48.8	48.87	16500.0
2007-11-29	CPST	ETF	1.2	1.23	1.19	1.21	703848.0
2007-11-29	CSA	ETF	15.86	16.2	15.69	15.84	95400.0
2007-11-29	CSD	ETF	26.8	26.93	26.73	26.84	9600.0
2007-11-29	CSQ	ETF	13.58	13.75	13.58	13.7	297018.0
2007-11-29	CUT	ETF	24.5	24.65	24.35	24.6	9800.0
2007-11-29	CVY	ETF	24.56	24.56	23.84	24.36	38000.0
2007-11-29	CWI	ETF	29.3333	29.8933	28.3733	28.52	52650.0
2007-11-29	DBA	ETF	30.37	31.03	30.37	30.79	411600.0
2007-11-29	DBB	ETF	23.72	23.85	23.57	23.7	16900.0
2007-11-29	DBC	ETF	30.74	30.89	30.5	30.69	196942.0

> showing 50 of 534 rows — these rows as CSV

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