PREVIEW / etf_daily / 2007-06-07

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-07.parquet
  size:    22 KB
  rows:    484

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-06-07	SPY	ETF	151.56	152.5	149.06	149.1	232414600.0
2007-06-07	QQQ	ETF	46.91	47.21	46.32	46.3399	221628265.0
2007-06-07	IWM	ETF	83.26	83.45	81.78	81.78	113824100.0
2007-06-07	DIA	ETF	134.28	134.79	132.37	132.53	26022900.0
2007-06-07	GLD	ETF	66.27	66.4	65.16	65.26	6394300.0
2007-06-07	TLT	ETF	84.63	84.71	83.73	83.87	5010400.0
2007-06-07	ADRE	ETF	44.2	44.4	42.95	43.12	350944.0
2007-06-07	AGG	ETF	98.23	98.23	97.7	97.83	319500.0
2007-06-07	AIQ	ETF	44.95	44.95	44.05	44.35	35800.0
2007-06-07	AIS	ETF	1.96	2.0	1.91	1.97	304700.0
2007-06-07	ARB	ETF	51.82	51.82	51.19	51.25	151500.0
2007-06-07	BBH	ETF	59.5433	59.5433	58.6433	58.82	627300.0
2007-06-07	BIL	ETF	91.64	91.66	91.64	91.66	12150.0
2007-06-07	BITS	ETF	32.8	32.8	32.04	32.2	7810.0
2007-06-07	BIV	ETF	73.69	73.69	73.36	73.41	27400.0
2007-06-07	BLV	ETF	73.08	73.09	72.34	72.49	58500.0
2007-06-07	BMVP	ETF	18.067	18.08	17.774	17.79	51500.0
2007-06-07	BND	ETF	74.1	74.1	73.74	73.85	75500.0
2007-06-07	BNE	ETF	18.8	19.25	18.8	19.15	315900.0
2007-06-07	BRF	ETF	14.51	14.59	14.5	14.5	24700.0
2007-06-07	BSV	ETF	74.65	74.75	74.53	74.55	109200.0
2007-06-07	BTF	ETF	109.49999999999999	109.85	108.6	109.35	980.0
2007-06-07	CBON	ETF	29.5	29.5	29.14	29.24	31086.0
2007-06-07	CDL	ETF	8.47	8.48	8.34	8.38	1460900.0
2007-06-07	CEF	ETF	9.26	9.34	9.06	9.15	321900.0
2007-06-07	CGO	ETF	17.95	17.95	17.7	17.74	30100.0
2007-06-07	CGW	ETF	25.24	25.25	24.83	24.83	160300.0
2007-06-07	CHB	ETF	10.59	10.59	10.14	10.24	2230600.0
2007-06-07	CHI	ETF	19.94	20.07	19.51	19.7	170200.0
2007-06-07	CHIC	ETF	29.01	29.01	28.2	28.46	898386.0
2007-06-07	CHY	ETF	16.85	16.94	16.2498	16.25	269800.0
2007-06-07	CN	ETF	50.92	51.64	50.0401	50.19	89100.0
2007-06-07	CNXT	ETF	1.26	1.28	1.24	1.25	3769391.0
2007-06-07	CPST	ETF	1.03	1.04	0.9651	0.97	2017518.0
2007-06-07	CSA	ETF	20.25	20.32	19.6	19.61	44900.0
2007-06-07	CSB	ETF	31.67	31.79	31.35	31.42	47700.0
2007-06-07	CSD	ETF	30.77	30.84	30.09	30.17	33800.0
2007-06-07	CSM	ETF	1.3975	1.3975	1.3975	1.3975	4000.0
2007-06-07	CSQ	ETF	15.5	15.5	14.78	14.98	761900.0
2007-06-07	CTEC	ETF	101.6	103.39999999999999	100.74999999999999	102.10000000000001	178641.0
2007-06-07	CVY	ETF	28.09	28.09	27.56	27.6	179300.0
2007-06-07	CWI	ETF	26.8667	26.98	26.56	26.5733	36750.0
2007-06-07	CZA	ETF	26.86	26.86	26.52	26.56	2400.0
2007-06-07	DBA	ETF	26.07	26.57	25.97	26.56	163900.0
2007-06-07	DBB	ETF	26.7	26.89	26.5	26.72	34700.0
2007-06-07	DBC	ETF	25.7	26.07	25.7	25.95	291800.0
2007-06-07	DBE	ETF	28.57	28.81	28.53	28.66	61300.0
2007-06-07	DBO	ETF	26.9	27.06	26.79	26.79	23600.0
2007-06-07	DBP	ETF	26.42	26.46	26.03	26.03	21200.0
2007-06-07	DBS	ETF	26.94	27.05	26.42	26.5199	30700.0

> showing 50 of 484 rows — these rows as CSV

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