PREVIEW / etf_daily / 2007-03-27

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-27.parquet
  size:    21 KB
  rows:    439

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-03-27	SPY	ETF	143.12	143.16	142.39	142.86	99864600.0
2007-03-27	QQQ	ETF	44.23	44.24	43.95	43.99	76681320.0
2007-03-27	IWM	ETF	80.01	80.07	79.35	79.7	40734900.0
2007-03-27	DIA	ETF	124.21	124.23	123.66	123.89	7691500.0
2007-03-27	GLD	ETF	65.88	65.97	65.5	65.7	3261700.0
2007-03-27	TLT	ETF	88.64	88.81	88.56	88.75	619800.0
2007-03-27	AAA	ETF	64.14	64.4899	64.02	64.2601	6800.0
2007-03-27	ADRE	ETF	39.49	39.53	39.173	39.26	122788.0
2007-03-27	AGG	ETF	100.45	100.49	100.27	100.37	275600.0
2007-03-27	AIQ	ETF	40.8	41.4	40.2	41.35	19080.0
2007-03-27	AIS	ETF	1.21	1.24	1.1794	1.19	128500.0
2007-03-27	ARB	ETF	47.63	47.63	47.03	47.14	90000.0
2007-03-27	BAB	ETF	98.03	98.97	97.82	98.36	37800.0
2007-03-27	BBH	ETF	59.2433	59.34	58.7433	58.8233	342600.0
2007-03-27	BITS	ETF	33.12	33.48	33.0	33.16	10129.0
2007-03-27	BNE	ETF	15.87	15.88	15.2	15.57	207300.0
2007-03-27	BRF	ETF	14.51	14.54	14.47	14.54	19400.0
2007-03-27	BTF	ETF	108.75	108.75	107.79999999999998	108.0	680.0
2007-03-27	CBON	ETF	31.13	31.49	30.31	30.65	76005.0
2007-03-27	CDL	ETF	9.65	9.65	9.56	9.59	83600.0
2007-03-27	CEF	ETF	9.54	9.54	9.38	9.39	142000.0
2007-03-27	CGO	ETF	16.92	17.28	16.91	17.22	26100.0
2007-03-27	CHB	ETF	9.6	9.61	9.03	9.29	2327200.0
2007-03-27	CHI	ETF	20.1	20.29	20.08	20.29	82700.0
2007-03-27	CHIC	ETF	28.88	28.96	28.21	28.59	445669.0
2007-03-27	CHY	ETF	16.9	16.99	16.82	16.88	118700.0
2007-03-27	CN	ETF	48.1	48.1	47.33	47.45	56300.0
2007-03-27	CNXT	ETF	1.71	1.71	1.67	1.67	5320240.0
2007-03-27	CPI	ETF	22.25	22.25	22.25	22.25	500.0
2007-03-27	CPST	ETF	0.97	0.99	0.93	0.98	12692778.0
2007-03-27	CSA	ETF	20.74	20.97	20.6	20.81	56700.0
2007-03-27	CSB	ETF	32.83	32.96	32.7	32.77	18800.0
2007-03-27	CSD	ETF	27.08	27.13	27.04	27.13	11500.0
2007-03-27	CSM	ETF	1.345	1.345	1.3425	1.3425	3600.0
2007-03-27	CSQ	ETF	15.15	15.19	15.04	15.09	384800.0
2007-03-27	CTEC	ETF	89.04999999999998	89.1	86.75	88.8	22180.600000000002
2007-03-27	CVY	ETF	26.66	26.68	26.57	26.64	25700.0
2007-03-27	CWI	ETF	25.3733	25.42	25.3333	25.4	9000.0
2007-03-27	DBA	ETF	25.89	25.95	25.78	25.92	96200.0
2007-03-27	DBB	ETF	24.89	24.89	24.21	24.48	23200.0
2007-03-27	DBC	ETF	24.9	25.03	24.8	25.03	418400.0
2007-03-27	DBE	ETF	26.73	27.05	26.7	27.05	48200.0
2007-03-27	DBO	ETF	26.01	26.08	25.88	26.0	12000.0
2007-03-27	DBP	ETF	26.24	26.28	26.15	26.18	11500.0
2007-03-27	DBS	ETF	26.2	26.2	25.97	26.03	6800.0
2007-03-27	DBV	ETF	27.0	27.0	26.89	26.92	84700.0
2007-03-27	DDM	ETF	6.7708	6.7783	6.7233	6.7458	740400.0
2007-03-27	DEF	ETF	26.02	26.02	25.88	25.94	8300.0
2007-03-27	DES	ETF	19.2667	19.2667	19.1067	19.1433	91500.0
2007-03-27	DEW	ETF	63.07	63.3	63.01	63.23	7500.0

> showing 50 of 439 rows — these rows as CSV

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