PREVIEW / etf_daily / 2007-06-19

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-19.parquet
  size:    22 KB
  rows:    481

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-19	SPY	ETF	152.55	153.38	152.36	153.27	110851700.0
2007-06-19	QQQ	ETF	47.63	47.86	47.51	47.76	109680620.0
2007-06-19	IWM	ETF	83.81	84.51	83.49	84.39	65541300.0
2007-06-19	DIA	ETF	135.82	136.4	135.62	136.27	10656400.0
2007-06-19	GLD	ETF	64.79	65.56	64.75	65.48	2700900.0
2007-06-19	TLT	ETF	83.82	84.45	83.72	84.3	4620100.0
2007-06-19	ADRE	ETF	46.07	46.58	45.7	45.998	195610.0
2007-06-19	AGG	ETF	98.12	98.34	98.02	98.27	300900.0
2007-06-19	AIQ	ETF	44.05	46.05	43.85	45.8	71020.0
2007-06-19	AIS	ETF	2.04	2.04	1.94	2.0	196500.0
2007-06-19	ARB	ETF	50.0	50.54	49.55	50.5	252200.0
2007-06-19	BBH	ETF	59.9367	60.1733	59.87	60.0667	708300.0
2007-06-19	BIL	ETF	91.86	91.86	91.86	91.86	850.0
2007-06-19	BITS	ETF	32.0	32.2	31.64	31.96	7320.0
2007-06-19	BIV	ETF	73.4	73.67	73.39	73.67	10700.0
2007-06-19	BLV	ETF	72.32	72.7	72.32	72.7	10600.0
2007-06-19	BMVP	ETF	18.0367	18.1198	17.9803	18.1067	45100.0
2007-06-19	BND	ETF	74.02	74.2	73.94	74.11	73400.0
2007-06-19	BNE	ETF	19.85	20.09	19.74	20.07	261000.0
2007-06-19	BRF	ETF	14.52	14.52	14.48	14.48	4200.0
2007-06-19	BSV	ETF	74.5	74.74	74.5	74.74	104600.0
2007-06-19	BTF	ETF	109.4005	110.05	109.4005	109.74999999999999	1660.0
2007-06-19	CBON	ETF	29.79	30.14	29.76	29.91	80416.0
2007-06-19	CDL	ETF	6.75	6.785	6.5	6.64	9822877.0
2007-06-19	CEF	ETF	9.24	9.5	9.2	9.47	468300.0
2007-06-19	CGO	ETF	18.26	18.285	18.02	18.22	38100.0
2007-06-19	CGW	ETF	25.39	25.59	25.3	25.54	199300.0
2007-06-19	CHB	ETF	10.81	10.98	10.72	10.8	1077100.0
2007-06-19	CHI	ETF	20.06	20.08	19.93	19.99	91000.0
2007-06-19	CHIC	ETF	27.4	27.75	27.25	27.68	246761.0
2007-06-19	CHY	ETF	16.27	16.38	16.27	16.32	148100.0
2007-06-19	CN	ETF	55.2	55.38	54.68	55.12	117400.0
2007-06-19	CNXT	ETF	1.27	1.28	1.25	1.25	3732485.0
2007-06-19	CPST	ETF	1.01	1.06	1.0	1.05	2199537.0
2007-06-19	CSA	ETF	19.75	19.93	19.72	19.77	9000.0
2007-06-19	CSB	ETF	32.12	32.53	32.09	32.49	50100.0
2007-06-19	CSD	ETF	31.42	31.43	31.26	31.42	22400.0
2007-06-19	CSM	ETF	1.4175	1.4175	1.4175	1.4175	400.0
2007-06-19	CSQ	ETF	15.29	15.45	15.23	15.45	396400.0
2007-06-19	CTEC	ETF	107.85	113.05	105.64999999999999	111.85	130260.20000000001
2007-06-19	CVY	ETF	28.23	28.23	28.07	28.17	81800.0
2007-06-19	CWI	ETF	27.4133	27.5533	27.4133	27.54	32400.0
2007-06-19	CZA	ETF	27.15	27.3	27.15	27.3	1500.0
2007-06-19	DBA	ETF	28.1	28.1	27.05	27.12	836900.0
2007-06-19	DBB	ETF	26.59	26.74	26.45	26.65	66200.0
2007-06-19	DBC	ETF	26.6	26.69	26.3	26.39	347400.0
2007-06-19	DBE	ETF	29.2	29.25	29.01	29.17	295100.0
2007-06-19	DBO	ETF	27.36	27.38	27.1	27.24	11500.0
2007-06-19	DBP	ETF	25.92	26.13	25.92	26.07	3600.0
2007-06-19	DBS	ETF	25.98	26.25	25.98	26.25	5800.0

> showing 50 of 481 rows — these rows as CSV

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