PREVIEW / etf_daily / 2007-05-22

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-22.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-05-22	SPY	ETF	152.7	153.16	152.38	152.42	82148800.0
2007-05-22	QQQ	ETF	47.04	47.28	46.87	47.05	98134419.0
2007-05-22	IWM	ETF	82.81	83.64	82.62	83.27	69634200.0
2007-05-22	DIA	ETF	135.37	135.73	135.12	135.16	11193000.0
2007-05-22	GLD	ETF	65.7	65.82	65.16	65.2	5886700.0
2007-05-22	TLT	ETF	87.18	87.2	86.68	86.74	920200.0
2007-05-22	ADRE	ETF	44.25	44.25	43.654	43.8	156006.0
2007-05-22	AGG	ETF	99.64	99.64	99.31	99.45	353000.0
2007-05-22	AIQ	ETF	41.3	42.85	40.0	42.35	48800.0
2007-05-22	AIS	ETF	1.81	1.81	1.67	1.74	480000.0
2007-05-22	ARB	ETF	50.4	51.11	49.91	50.21	208300.0
2007-05-22	BBH	ETF	59.06	59.6667	59.0133	59.5333	512400.0
2007-05-22	BITS	ETF	30.88	31.72	30.88	31.72	12680.0
2007-05-22	BIV	ETF	74.88	74.88	74.71	74.71	25400.0
2007-05-22	BLV	ETF	74.73	74.78	74.45	74.48	35200.0
2007-05-22	BMVP	ETF	18.17	18.24	18.16	18.18	29200.0
2007-05-22	BND	ETF	75.04	75.05	74.89	74.92	49800.0
2007-05-22	BNE	ETF	19.48	19.48	19.18	19.22	164000.0
2007-05-22	BRF	ETF	14.51	14.52	14.51	14.52	8700.0
2007-05-22	BSV	ETF	75.14	75.17	75.07	75.07	79000.0
2007-05-22	BTF	ETF	111.3	111.35	110.99999999999999	111.19949999999999	660.0
2007-05-22	CBON	ETF	29.25	29.61	29.21	29.56	29660.0
2007-05-22	CDL	ETF	8.67	8.67	8.44	8.47	409700.0
2007-05-22	CEF	ETF	9.16	9.18	9.03	9.04	201600.0
2007-05-22	CGO	ETF	18.1	18.11	17.81	18.0	33000.0
2007-05-22	CGW	ETF	24.84	25.1	24.84	25.1	427200.0
2007-05-22	CHB	ETF	11.38	11.65	11.32	11.58	1724600.0
2007-05-22	CHI	ETF	20.09	20.09	19.95	20.03	153400.0
2007-05-22	CHIC	ETF	27.0	27.0	26.42	26.63	382000.0
2007-05-22	CHY	ETF	17.12	17.17	17.12	17.16	105100.0
2007-05-22	CIL	ETF	25.94	25.94	25.91	25.94	2000.0
2007-05-22	CN	ETF	52.82	53.04	52.51	52.73	99900.0
2007-05-22	CNXT	ETF	1.38	1.4	1.35	1.35	6584638.0
2007-05-22	CPST	ETF	0.9	0.95	0.9	0.9152	1272150.0
2007-05-22	CSA	ETF	20.15	20.46	19.98	19.98	31900.0
2007-05-22	CSB	ETF	32.15	32.38	32.09	32.3	26500.0
2007-05-22	CSD	ETF	29.98	30.19	29.98	30.18	28200.0
2007-05-22	CSM	ETF	1.4	1.4	1.4	1.4	14000.0
2007-05-22	CSQ	ETF	15.7	15.74	15.65	15.74	351800.0
2007-05-22	CTEC	ETF	86.75	87.5	86.14999999999999	87.3	7349.8
2007-05-22	CVY	ETF	28.28	28.33	28.22	28.28	17400.0
2007-05-22	CWI	ETF	27.1	27.1133	26.98	27.0133	33900.0
2007-05-22	CZA	ETF	26.86	26.91	26.84	26.89	1600.0
2007-05-22	DBA	ETF	25.1	25.3	24.9	24.99	164200.0
2007-05-22	DBB	ETF	27.35	27.35	26.77	26.92	66800.0
2007-05-22	DBC	ETF	25.54	25.54	25.25	25.31	181200.0
2007-05-22	DBE	ETF	28.36	28.43	28.15	28.22	67000.0
2007-05-22	DBO	ETF	26.69	26.69	26.35	26.37	12200.0
2007-05-22	DBP	ETF	26.0	26.09	25.86	25.92	9000.0
2007-05-22	DBS	ETF	25.6	25.688	25.43	25.49	12400.0

> showing 50 of 481 rows — these rows as CSV

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