PREVIEW / etf_daily / 2007-10-16

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-16.parquet
  size:    23 KB
  rows:    516

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-10-16	SPY	ETF	154.41	154.52	153.47	153.78	166525700.0
2007-10-16	QQQ	ETF	52.79	53.28	52.68	52.87	193676504.0
2007-10-16	IWM	ETF	82.37	84.18	81.88	81.9	59345400.0
2007-10-16	DIA	ETF	139.6	139.65	138.72	139.16	13953500.0
2007-10-16	GLD	ETF	74.87	75.45	73.78	75.12	6622900.0
2007-10-16	TLT	ETF	87.65	87.98	87.54	87.68	855500.0
2007-10-16	ADRE	ETF	56.6	56.6	55.22	55.51	279346.0
2007-10-16	AGG	ETF	99.66	99.72	99.45	99.64	266400.0
2007-10-16	AIQ	ETF	46.85	47.35	46.35	46.35	19040.0
2007-10-16	AIS	ETF	1.38	1.41	1.35	1.39	49000.0
2007-10-16	AIVI	ETF	74.37	74.37	73.85	74.0	20800.0
2007-10-16	ARB	ETF	43.8	45.02	43.75	44.63	479200.0
2007-10-16	BBH	ETF	60.1	60.3267	59.4267	59.6433	862800.0
2007-10-16	BIL	ETF	91.7	91.74	91.68	91.72	14350.0
2007-10-16	BITS	ETF	26.2004	26.4	25.76	26.04	9680.0
2007-10-16	BIV	ETF	75.3	75.35	75.25	75.25	4200.0
2007-10-16	BLV	ETF	74.6	74.7	74.49	74.63	32900.0
2007-10-16	BMVP	ETF	17.5567	17.5833	17.4534	17.4733	36900.0
2007-10-16	BND	ETF	75.43	75.46	75.37	75.45	107100.0
2007-10-16	BNE	ETF	17.72	17.89	17.63	17.75	97700.0
2007-10-16	BOSS	ETF	46.27	47.92	46.27	47.92	300.0
2007-10-16	BRF	ETF	14.6	14.606	14.59	14.6	9600.0
2007-10-16	BSV	ETF	75.65	75.85	75.65	75.84	30700.0
2007-10-16	BTF	ETF	110.74999999999999	110.74999999999999	110.0	110.0	300.0
2007-10-16	BWX	ETF	25.885	25.9	25.86	25.885	40400.0
2007-10-16	CBON	ETF	24.96	24.96	23.32	23.35	92155.0
2007-10-16	CDL	ETF	4.41	4.46	4.18	4.23	3794200.0
2007-10-16	CEF	ETF	10.15	10.15	9.92	9.96	346500.0
2007-10-16	CGO	ETF	18.47	18.59	18.34	18.45	40200.0
2007-10-16	CGW	ETF	26.29	26.29	25.85	25.95	58400.0
2007-10-16	CHB	ETF	11.94	12.27	11.69	12.25	1956200.0
2007-10-16	CHI	ETF	17.01	17.01	16.85	16.9	125920.0
2007-10-16	CHIC	ETF	14.6	15.28	14.37	15.16	732484.0
2007-10-16	CHW	ETF	13.37	13.37	13.14	13.29	169700.0
2007-10-16	CHY	ETF	15.18	15.18	15.0	15.0	166300.0
2007-10-16	CMF	ETF	51.705	51.705	51.68	51.685	6600.0
2007-10-16	CN	ETF	62.79	63.44	61.7	62.07	315700.0
2007-10-16	CNXT	ETF	1.44	1.45	1.4	1.44	6236067.0
2007-10-16	CPI	ETF	24.5	24.5	24.25	24.25	200.0
2007-10-16	CPST	ETF	1.1	1.11	1.07	1.08	1543347.0
2007-10-16	CSA	ETF	17.46	17.87	17.44	17.78	33300.0
2007-10-16	CSD	ETF	29.46	29.49	29.31	29.38	30200.0
2007-10-16	CSQ	ETF	14.77	14.8	14.63	14.79	327200.0
2007-10-16	CVY	ETF	26.12	26.2	25.97	25.99	7600.0
2007-10-16	CWI	ETF	28.8867	28.8867	28.6733	28.74	19200.0
2007-10-16	CZA	ETF	27.12	27.12	26.97	27.0	18400.0
2007-10-16	DBA	ETF	29.11	29.12	28.75	29.04	438200.0
2007-10-16	DBB	ETF	26.43	26.43	26.15	26.37	25000.0
2007-10-16	DBC	ETF	28.38	28.64	28.3301	28.63	290400.0
2007-10-16	DBE	ETF	31.75	32.06	31.67	32.0	16800.0

> showing 50 of 516 rows — these rows as CSV

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