PREVIEW / etf_daily / 2007-12-13

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-13.parquet
  size:    25 KB
  rows:    545

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-12-13	SPY	ETF	148.32	149.39	147.3	149.06	237551300.0
2007-12-13	QQQ	ETF	51.33	51.63	50.98	51.5	153682083.0
2007-12-13	IWM	ETF	76.27	76.89	75.64	76.49	89826800.0
2007-12-13	DIA	ETF	134.28	135.36	133.63	135.0	14104200.0
2007-12-13	GLD	ETF	79.59	79.62	78.3	78.5	9552200.0
2007-12-13	TLT	ETF	91.61	91.82	90.9	91.03	1222100.0
2007-12-13	ADRE	ETF	55.62	55.73	54.5	55.41	443216.0
2007-12-13	AGG	ETF	100.94	100.94	100.56	100.66	425500.0
2007-12-13	AIA	ETF	47.61	48.26	47.21	48.18	27200.0
2007-12-13	AIQ	ETF	46.8	46.95	45.7	46.6	16320.0
2007-12-13	AIS	ETF	1.05	1.05	1.03	1.05	60500.0
2007-12-13	AIVI	ETF	74.05	74.26	73.24	74.14	33300.0
2007-12-13	ARB	ETF	40.78	42.33	40.74	42.2	702540.0
2007-12-13	BBH	ETF	55.4333	55.8333	54.3367	55.5067	1689900.0
2007-12-13	BIL	ETF	91.32	91.82	91.32	91.8	27300.0
2007-12-13	BITS	ETF	23.68	24.32	22.8	23.2	10816.0
2007-12-13	BIV	ETF	76.8	76.88	76.6	76.6	15300.0
2007-12-13	BKF	ETF	61.03	61.05	58.0	59.4	19300.0
2007-12-13	BLV	ETF	75.66	75.81	75.31	75.33	8600.0
2007-12-13	BMVP	ETF	17.27	17.53	17.27	17.53	36444.0
2007-12-13	BND	ETF	76.45	76.55	76.26	76.34	62300.0
2007-12-13	BNE	ETF	17.88	18.13	17.68	18.11	159400.0
2007-12-13	BRF	ETF	14.61	14.61	14.59	14.59	11500.0
2007-12-13	BSV	ETF	77.09	77.09	76.87	77.0	72000.0
2007-12-13	BTF	ETF	114.64999999999999	115.64999999999999	114.25	114.3	2920.0
2007-12-13	BWX	ETF	27.39	27.39	26.6101	26.66	148588.0
2007-12-13	CBON	ETF	17.13	17.37	17.01	17.36	74638.0
2007-12-13	CDL	ETF	2.06	2.19	2.01	2.1	2064215.0
2007-12-13	CEF	ETF	10.92	10.92	10.41	10.45	392400.0
2007-12-13	CGO	ETF	19.35	19.51	19.35	19.45	10900.0
2007-12-13	CGW	ETF	25.25	25.65	25.25	25.55	89100.0
2007-12-13	CHB	ETF	8.82	8.97	8.57	8.82	859700.0
2007-12-13	CHI	ETF	13.95	14.24	13.89	14.21	358899.0
2007-12-13	CHIC	ETF	15.52	16.19	15.25	15.86	420738.0
2007-12-13	CHW	ETF	12.59	12.7	12.53	12.63	314700.0
2007-12-13	CHY	ETF	13.2	13.4	13.11	13.34	267400.0
2007-12-13	CMF	ETF	52.0	52.12	51.95	52.015	13200.0
2007-12-13	CN	ETF	60.8	61.08	59.55	60.88	228440.0
2007-12-13	CNXT	ETF	1.05	1.07	0.95	1.01	23382847.0
2007-12-13	COW	ETF	48.47	48.47	47.88	47.93	12400.0
2007-12-13	CPI	ETF	24.65	24.8	24.1	24.1	400.0
2007-12-13	CPST	ETF	1.43	1.65	1.37	1.5999	5532817.0
2007-12-13	CSA	ETF	16.03	16.22	15.92	15.97	16300.0
2007-12-13	CSD	ETF	27.34	27.42	27.23	27.42	6700.0
2007-12-13	CSQ	ETF	14.15	14.15	13.86	14.12	341800.0
2007-12-13	CUT	ETF	24.54	24.55	24.2	24.35	15300.0
2007-12-13	CVY	ETF	24.13	24.13	23.65	23.89	17700.0
2007-12-13	CWI	ETF	28.8667	28.8667	28.22	28.52	42600.0
2007-12-13	CZA	ETF	26.02	26.02	26.02	26.02	100.0
2007-12-13	DBA	ETF	32.7	32.7	32.12	32.28	647200.0

> showing 50 of 545 rows — these rows as CSV

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