PREVIEW / etf_daily / 2007-11-05

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-05.parquet
  size:    24 KB
  rows:    531

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-05	SPY	ETF	149.64	151.16	148.97	150.05	226841000.0
2007-11-05	QQQ	ETF	53.86	54.4	53.59	54.07	150588814.0
2007-11-05	IWM	ETF	78.44	79.23	78.05	78.48	98542900.0
2007-11-05	DIA	ETF	134.84	136.11	134.4	135.21	13954800.0
2007-11-05	GLD	ETF	79.68	80.24	79.11	79.75	5025300.0
2007-11-05	TLT	ETF	91.16	91.39	90.8	91.0	1021500.0
2007-11-05	ADRE	ETF	55.83	56.25	54.79	55.55	507688.0
2007-11-05	AGG	ETF	100.77	100.77	100.46	100.46	509700.0
2007-11-05	AIQ	ETF	44.65	45.15	43.85	44.15	56080.0
2007-11-05	AIS	ETF	1.19	1.2	1.15	1.16	693800.0
2007-11-05	AIVI	ETF	75.02	75.64	74.63	75.4	110800.0
2007-11-05	ARB	ETF	49.31	50.08	49.15	49.62	272264.0
2007-11-05	BBH	ETF	59.35	60.5567	59.35	60.4667	225900.0
2007-11-05	BIL	ETF	91.66	91.68	91.6	91.66	16800.0
2007-11-05	BITS	ETF	25.88	26.2	25.6404	26.04	1350.0
2007-11-05	BIV	ETF	76.51	76.51	76.25	76.26	28900.0
2007-11-05	BLV	ETF	76.58	76.58	76.3	76.3	15200.0
2007-11-05	BMVP	ETF	17.2	17.3667	17.16	17.28	59900.0
2007-11-05	BND	ETF	76.43	76.43	76.05	76.12	63500.0
2007-11-05	BNE	ETF	16.46	16.57	16.19	16.28	191200.0
2007-11-05	BRF	ETF	14.41	14.71	14.41	14.62	10502.0
2007-11-05	BSV	ETF	76.49	76.49	76.35	76.37	26200.0
2007-11-05	BTF	ETF	115.0	115.89999999999999	113.85	115.89999999999999	5260.0
2007-11-05	BWX	ETF	28.065	28.065	26.57	26.665	145840.0
2007-11-05	CBON	ETF	19.49	19.49	18.97	18.97	32514.0
2007-11-05	CDL	ETF	4.15	4.25	4.1	4.12	1898113.0
2007-11-05	CEF	ETF	10.85	10.85	10.51	10.6	526800.0
2007-11-05	CGO	ETF	19.49	20.08	19.27	19.36	14000.0
2007-11-05	CGW	ETF	26.03	26.15	25.83	26.15	69800.0
2007-11-05	CHB	ETF	11.18	11.45	11.18	11.37	1685113.0
2007-11-05	CHI	ETF	16.18	16.18	15.85	15.92	157900.0
2007-11-05	CHIC	ETF	13.59	13.94	13.51	13.84	530204.0
2007-11-05	CHW	ETF	12.92	13.0	12.8	12.95	152600.0
2007-11-05	CHY	ETF	14.0	14.13	13.65	13.87	179401.0
2007-11-05	CMF	ETF	51.86	51.86	51.7404	51.775	4400.0
2007-11-05	CN	ETF	55.96	55.96	53.4	54.25	500293.0
2007-11-05	CNXT	ETF	1.24	1.28	1.22	1.28	7823490.0
2007-11-05	COW	ETF	48.18	48.32	48.13	48.32	1400.0
2007-11-05	CPST	ETF	1.2	1.25	1.15	1.23	4199671.0
2007-11-05	CSA	ETF	16.05	17.16	16.05	16.19	49500.0
2007-11-05	CSD	ETF	28.37	28.5	28.21	28.41	35400.0
2007-11-05	CSQ	ETF	14.26	14.55	14.16	14.54	300160.0
2007-11-05	CVY	ETF	24.58	25.15	24.58	25.04	18200.0
2007-11-05	CWI	ETF	29.0467	29.22	29.0	29.1867	24000.0
2007-11-05	CZA	ETF	26.48	26.48	26.48	26.48	200.0
2007-11-05	DBA	ETF	28.94	29.45	28.94	29.37	224900.0
2007-11-05	DBB	ETF	25.24	25.48	25.18	25.18	75000.0
2007-11-05	DBC	ETF	31.25	31.27	30.14	30.56	369030.0
2007-11-05	DBE	ETF	34.57	34.84	34.33	34.4	24800.0
2007-11-05	DBO	ETF	33.2	34.75	32.74	34.2	35500.0

> showing 50 of 531 rows — these rows as CSV

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