PREVIEW / etf_daily / 2007-04-27

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-27.parquet
  size:    21 KB
  rows:    451

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-04-27	SPY	ETF	149.09	149.74	148.84	149.53	108191100.0
2007-04-27	QQQ	ETF	46.37	46.7	46.29	46.57	96607259.0
2007-04-27	IWM	ETF	82.52	82.64	82.02	82.52	56761000.0
2007-04-27	DIA	ETF	130.71	131.37	130.63	131.23	7526200.0
2007-04-27	GLD	ETF	66.84	67.57	66.84	67.56	5231700.0
2007-04-27	TLT	ETF	88.01	88.05	87.78	87.83	428700.0
2007-04-27	AAA	ETF	73.1	78.12	72.99	74.9	55300.0
2007-04-27	ADRE	ETF	41.5	41.74	41.0	41.55	142370.0
2007-04-27	AGG	ETF	100.16	100.21	100.03	100.12	169100.0
2007-04-27	AIQ	ETF	45.3	45.45	44.4	45.25	21516.0
2007-04-27	AIS	ETF	1.58	1.58	1.53	1.53	209000.0
2007-04-27	ARB	ETF	49.6	49.6	48.6	49.36	211900.0
2007-04-27	BAB	ETF	101.96	102.52	101.33	101.42	62800.0
2007-04-27	BBH	ETF	62.6633	62.7167	62.4	62.7167	164100.0
2007-04-27	BITS	ETF	36.0	36.48	34.56	34.56	34066.0
2007-04-27	BIV	ETF	75.36	75.36	75.24	75.24	8300.0
2007-04-27	BLV	ETF	75.47	75.49	75.3	75.33	8000.0
2007-04-27	BMVP	ETF	17.89	17.97	17.85	17.94	45100.0
2007-04-27	BND	ETF	75.28	75.29	75.21	75.24	44800.0
2007-04-27	BNE	ETF	16.83	16.9	16.63	16.7	200200.0
2007-04-27	BRF	ETF	14.5	14.502	14.49	14.5	12600.0
2007-04-27	BSV	ETF	75.28	75.29	75.19	75.21	22400.0
2007-04-27	BTF	ETF	112.55	112.55	112.24999999999999	112.35	400.0
2007-04-27	CBON	ETF	31.03	31.06	30.3	30.77	29243.0
2007-04-27	CDL	ETF	9.79	9.79	9.38	9.38	380900.0
2007-04-27	CEF	ETF	9.54	9.7	9.52	9.65	297000.0
2007-04-27	CGO	ETF	17.8	17.83	17.7	17.73	12100.0
2007-04-27	CHB	ETF	11.15	11.15	10.74	10.82	1508448.0
2007-04-27	CHI	ETF	20.21	20.29	20.18	20.24	76000.0
2007-04-27	CHIC	ETF	29.21	29.43	28.44	28.75	567528.0
2007-04-27	CHY	ETF	17.03	17.14	17.0	17.01	97600.0
2007-04-27	CIL	ETF	25.83	25.83	25.83	25.83	300.0
2007-04-27	CN	ETF	50.95	51.19	50.41	51.08	81500.0
2007-04-27	CNXT	ETF	1.45	1.49	1.43	1.47	13018978.0
2007-04-27	CPI	ETF	21.95	21.95	21.95	21.95	500.0
2007-04-27	CPST	ETF	1.11	1.12	1.02	1.04	3512823.0
2007-04-27	CSA	ETF	21.16	21.16	20.81	20.86	17500.0
2007-04-27	CSB	ETF	33.07	33.27	32.98	33.2	14700.0
2007-04-27	CSD	ETF	28.9	28.9	28.7	28.78	9000.0
2007-04-27	CSQ	ETF	15.52	15.55	15.45	15.55	349000.0
2007-04-27	CTEC	ETF	88.35000000000001	92.5	88.35000000000001	92.3	28392.4
2007-04-27	CVY	ETF	27.74	27.79	27.64	27.73	12400.0
2007-04-27	CWI	ETF	26.5467	26.6333	26.5	26.58	49650.0
2007-04-27	CZA	ETF	26.24	26.24	26.24	26.24	200.0
2007-04-27	DBA	ETF	25.37	25.37	25.0	25.11	326800.0
2007-04-27	DBB	ETF	27.23	27.62	27.19	27.62	26900.0
2007-04-27	DBC	ETF	25.46	25.8	25.46	25.8	216900.0
2007-04-27	DBE	ETF	27.91	28.41	27.91	28.41	24700.0
2007-04-27	DBO	ETF	26.22	26.8	26.22	26.64	40500.0
2007-04-27	DBP	ETF	26.73	26.86	26.59	26.85	4300.0

> showing 50 of 451 rows — these rows as CSV

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