PREVIEW / etf_daily / 2007-07-11

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-11.parquet
  size:    22 KB
  rows:    491

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-07-11	SPY	ETF	150.75	152.05	150.52	151.99	175607600.0
2007-07-11	QQQ	ETF	48.37	48.81	48.32	48.81	99637596.0
2007-07-11	IWM	ETF	83.17	83.87	82.9	83.83	82880600.0
2007-07-11	DIA	ETF	134.89	135.93	134.75	135.9	16698200.0
2007-07-11	GLD	ETF	65.82	65.82	65.34	65.44	3647000.0
2007-07-11	TLT	ETF	84.95	85.09	84.32	84.32	1191300.0
2007-07-11	ADRE	ETF	47.11	47.75	47.01	47.75	145285.0
2007-07-11	AGG	ETF	98.21	98.21	97.76	97.88	233300.0
2007-07-11	AIQ	ETF	50.0	50.6	49.0	49.35	98860.0
2007-07-11	AIS	ETF	1.7	1.73	1.68	1.71	308200.0
2007-07-11	ARB	ETF	52.78	53.36	52.59	53.34	181800.0
2007-07-11	BBH	ETF	55.72	56.3233	55.6467	56.2933	916200.0
2007-07-11	BIL	ETF	91.7	91.7	91.62	91.7	9100.0
2007-07-11	BITS	ETF	27.32	27.76	26.8	27.28	20549.0
2007-07-11	BIV	ETF	73.63	73.63	73.42	73.43	14500.0
2007-07-11	BLV	ETF	72.87	72.93	72.55	72.55	3200.0
2007-07-11	BMVP	ETF	17.95	18.06	17.91	18.06	22300.0
2007-07-11	BND	ETF	74.05	74.09	73.82	73.91	37300.0
2007-07-11	BNE	ETF	19.45	19.65	19.28	19.64	227900.0
2007-07-11	BRF	ETF	14.52	14.52	14.52	14.52	800.0
2007-07-11	BSV	ETF	74.89	74.89	74.78	74.81	44600.0
2007-07-11	BTF	ETF	107.69999999999999	107.79999999999998	107.69999999999999	107.79999999999998	160.0
2007-07-11	CBON	ETF	26.89	27.25	26.89	27.04	64904.0
2007-07-11	CDL	ETF	6.3	6.3	6.16	6.2	3413700.0
2007-07-11	CEF	ETF	9.29	9.29	9.2	9.25	145400.0
2007-07-11	CGO	ETF	18.18	18.18	18.02	18.13	14300.0
2007-07-11	CGW	ETF	25.8	25.9	25.7	25.83	391500.0
2007-07-11	CHB	ETF	9.16	9.29	9.05	9.27	1929200.0
2007-07-11	CHI	ETF	19.0	19.15	18.91	19.08	120200.0
2007-07-11	CHIC	ETF	24.78	24.84	24.02	24.23	1219132.0
2007-07-11	CHY	ETF	16.04	16.04	15.8	15.95	178000.0
2007-07-11	CN	ETF	54.1	54.74	53.91	54.4	47200.0
2007-07-11	CNXT	ETF	1.52	1.53	1.46	1.46	7220851.0
2007-07-11	CPST	ETF	1.21	1.36	1.19	1.33	15580722.0
2007-07-11	CSA	ETF	19.01	19.2	18.56	18.56	46000.0
2007-07-11	CSB	ETF	32.26	32.42	32.11	32.3	25100.0
2007-07-11	CSD	ETF	31.09	31.16	30.98	31.12	15500.0
2007-07-11	CSQ	ETF	15.18	15.26	15.1	15.16	279200.0
2007-07-11	CTEC	ETF	108.0	110.05	108.0	109.60000000000001	7641.200000000001
2007-07-11	CVY	ETF	27.65	27.69	27.55	27.66	67300.0
2007-07-11	CWI	ETF	27.8667	28.0533	27.8333	27.9867	151500.0
2007-07-11	CZA	ETF	27.42	27.42	27.42	27.42	900.0
2007-07-11	DBA	ETF	27.09	27.2	27.0	27.18	277900.0
2007-07-11	DBB	ETF	27.62	27.77	27.52	27.68	42400.0
2007-07-11	DBC	ETF	26.34	26.63	26.33	26.54	194400.0
2007-07-11	DBE	ETF	29.66	29.74	29.46	29.54	95300.0
2007-07-11	DBO	ETF	27.76	27.9	27.7	27.7	15900.0
2007-07-11	DBP	ETF	26.01	26.01	25.88	25.91	11400.0
2007-07-11	DBS	ETF	25.42	25.42	25.31	25.33	8900.0
2007-07-11	DBV	ETF	29.03	29.09	29.0	29.09	137500.0

> showing 50 of 491 rows — these rows as CSV

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