PREVIEW / etf_daily / 2007-06-21

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-21.parquet
  size:    22 KB
  rows:    490

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-21	SPY	ETF	151.08	152.11	150.25	151.98	205262000.0
2007-06-21	QQQ	ETF	47.305	47.79	47.08	47.74	143198074.0
2007-06-21	IWM	ETF	82.82	83.59	82.32	83.58	97110200.0
2007-06-21	DIA	ETF	134.8	135.55	133.87	135.37	26946200.0
2007-06-21	GLD	ETF	64.73	65.02	64.13	64.56	2709200.0
2007-06-21	TLT	ETF	83.54	83.7	83.21	83.22	850400.0
2007-06-21	ADRE	ETF	45.92	46.39	45.39	46.383	241560.0
2007-06-21	AGG	ETF	97.94	98.05	97.78	97.85	340000.0
2007-06-21	AIQ	ETF	45.9	46.45	45.45	45.75	51400.0
2007-06-21	AIS	ETF	1.95	1.99	1.83	1.901	300000.0
2007-06-21	ARB	ETF	49.73	50.94	49.22	50.84	236100.0
2007-06-21	BBH	ETF	59.4667	59.7433	59.2167	59.5567	612300.0
2007-06-21	BIL	ETF	91.86	91.9	91.86	91.88	850.0
2007-06-21	BITS	ETF	31.88	32.28	31.0	31.04	7668.0
2007-06-21	BIV	ETF	73.44	73.46	73.27	73.28	14700.0
2007-06-21	BLV	ETF	72.29	72.29	71.98	71.98	18800.0
2007-06-21	BMVP	ETF	17.8167	17.9467	17.7667	17.9167	31100.0
2007-06-21	BND	ETF	73.93	73.94	73.73	73.79	38500.0
2007-06-21	BNE	ETF	19.73	19.79	19.46	19.48	220400.0
2007-06-21	BRF	ETF	14.49	14.49	14.49	14.49	700.0
2007-06-21	BSV	ETF	74.75	74.78	74.71	74.76	15100.0
2007-06-21	BTF	ETF	108.85	109.85	108.85	109.25	2660.0
2007-06-21	CBON	ETF	29.08	29.19	28.9	28.96	43477.0
2007-06-21	CDL	ETF	6.25	6.35	6.13	6.13	9473312.0
2007-06-21	CEF	ETF	9.2	9.31	9.15	9.23	160800.0
2007-06-21	CGO	ETF	18.25	18.35	18.02	18.05	56800.0
2007-06-21	CGW	ETF	25.44	25.65	25.01	25.43	230300.0
2007-06-21	CHB	ETF	10.33	10.62	10.15	10.62	1444500.0
2007-06-21	CHI	ETF	19.9	19.9112	19.75	19.87	90100.0
2007-06-21	CHIC	ETF	27.53	27.53	26.95	27.06	410157.0
2007-06-21	CHY	ETF	16.31	16.33	16.06	16.12	201400.0
2007-06-21	CN	ETF	58.38	58.74	57.11	58.46	121800.0
2007-06-21	CNXT	ETF	1.32	1.47	1.32	1.44	28077091.0
2007-06-21	CPI	ETF	22.76	22.76	22.76	22.76	500.0
2007-06-21	CPST	ETF	1.09	1.1	1.05	1.07	2002214.0
2007-06-21	CSA	ETF	19.74	19.74	19.45	19.66	47500.0
2007-06-21	CSB	ETF	32.34	32.66	32.29	32.54	14300.0
2007-06-21	CSD	ETF	31.15	31.15	30.83	31.12	35600.0
2007-06-21	CSM	ETF	1.42	1.42	1.42	1.42	12000.0
2007-06-21	CSQ	ETF	15.34	15.34	15.21	15.29	384800.0
2007-06-21	CTEC	ETF	111.99999999999999	112.2	109.89999999999999	111.19999999999999	82800.0
2007-06-21	CVY	ETF	27.89	27.99	27.71	27.98	21100.0
2007-06-21	CWI	ETF	27.2867	27.4533	27.1933	27.4267	13500.0
2007-06-21	CZA	ETF	27.14	27.14	27.14	27.14	200.0
2007-06-21	DBA	ETF	27.58	27.85	27.04	27.17	352900.0
2007-06-21	DBB	ETF	26.83	26.85	26.38	26.67	35900.0
2007-06-21	DBC	ETF	26.47	26.5199	26.07	26.3	238100.0
2007-06-21	DBE	ETF	29.18	29.18	28.75	28.85	34100.0
2007-06-21	DBO	ETF	27.26	27.26	26.88	26.91	15300.0
2007-06-21	DBP	ETF	25.82	25.83	25.54	25.72	9200.0

> showing 50 of 490 rows — these rows as CSV

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