PREVIEW / etf_daily / 2007-12-31

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-31.parquet
  size:    25 KB
  rows:    556

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-31	SPY	ETF	147.1	147.61	146.06	146.21	108126800.0
2007-12-31	QQQ	ETF	51.56	51.68	51.21	51.22	70137773.0
2007-12-31	IWM	ETF	76.45	76.8	75.58	75.9	73932400.0
2007-12-31	DIA	ETF	133.13	133.24	132.16	132.55	6463400.0
2007-12-31	GLD	ETF	82.74	82.83	81.98	82.46	3815600.0
2007-12-31	TLT	ETF	92.78	93.28	92.6	93.04	1647600.0
2007-12-31	ADRE	ETF	55.6	55.6	54.8	55.04	266080.0
2007-12-31	AGG	ETF	101.32	101.38	100.85	101.17	708000.0
2007-12-31	AIA	ETF	49.7	49.7	47.95	48.09	14900.0
2007-12-31	AIQ	ETF	46.15	48.6	45.8	48.1	42720.0
2007-12-31	AIS	ETF	0.97	0.99	0.92	0.98	682930.0
2007-12-31	AIVI	ETF	71.02	71.02	69.75	69.76	49000.0
2007-12-31	ARB	ETF	41.9	42.29	41.57	41.57	169000.0
2007-12-31	BBH	ETF	54.1233	54.4367	53.92	53.92	634200.0
2007-12-31	BIL	ETF	91.66	91.66	91.58	91.58	31700.0
2007-12-31	BITS	ETF	24.24	25.64	24.2	25.64	10517.0
2007-12-31	BIV	ETF	77.45	77.45	77.03	77.32	22300.0
2007-12-31	BKF	ETF	59.42	62.06	58.75	59.5	20000.0
2007-12-31	BLV	ETF	76.66	76.83	76.55	76.8	3900.0
2007-12-31	BMVP	ETF	17.36	17.4233	17.2867	17.2867	30606.0
2007-12-31	BND	ETF	76.92	77.38	76.8	77.38	140500.0
2007-12-31	BNE	ETF	17.67	17.87	17.26	17.6	158500.0
2007-12-31	BRF	ETF	14.61	14.69	14.61	14.69	10700.0
2007-12-31	BSV	ETF	76.89	77.09	76.88	77.05	12600.0
2007-12-31	BTF	ETF	109.49999999999999	109.8	108.69999999999999	109.45	3140.0
2007-12-31	BWX	ETF	26.84	26.9	26.505	26.9	433638.0
2007-12-31	CBON	ETF	16.81	17.49	16.54	17.37	54656.0
2007-12-31	CDL	ETF	2.06	2.08	2.02	2.06	2127968.0
2007-12-31	CEF	ETF	10.92	10.92	10.76	10.81	199000.0
2007-12-31	CGO	ETF	19.32	19.3599	18.64	19.1	17800.0
2007-12-31	CGW	ETF	26.23	26.62	25.77	25.88	412500.0
2007-12-31	CHB	ETF	9.24	9.71	9.1	9.42	1553108.0
2007-12-31	CHI	ETF	14.58	14.7	14.15	14.5501	492904.0
2007-12-31	CHIC	ETF	15.84	16.2	15.68	16.15	920585.0
2007-12-31	CHW	ETF	12.66	12.88	12.39	12.68	532425.0
2007-12-31	CHY	ETF	13.08	13.2	12.856	13.15	640844.0
2007-12-31	CMF	ETF	52.25	52.5	52.165	52.17	32400.0
2007-12-31	CN	ETF	59.55	60.2	59.04	59.4	170200.0
2007-12-31	CNXT	ETF	0.81	0.9	0.8	0.83	8538871.0
2007-12-31	COW	ETF	47.2	47.49	47.2	47.49	1600.0
2007-12-31	CPST	ETF	1.65	1.66	1.58	1.63	2037791.0
2007-12-31	CSA	ETF	15.79	16.0	15.51	15.96	38000.0
2007-12-31	CSD	ETF	26.63	26.84	26.6	26.84	35200.0
2007-12-31	CSQ	ETF	14.02	14.03	13.8	14.0	428123.0
2007-12-31	CUT	ETF	24.28	24.3	24.23	24.25	20900.0
2007-12-31	CVY	ETF	23.17	23.41	23.12	23.27	37700.0
2007-12-31	CWI	ETF	28.0267	28.0267	27.4267	27.5067	116700.0
2007-12-31	CZA	ETF	25.99	25.99	25.83	25.84	1500.0
2007-12-31	DBA	ETF	32.8	32.99	32.61	32.99	356500.0
2007-12-31	DBB	ETF	22.07	22.07	21.85	21.9	30200.0

> showing 50 of 556 rows — these rows as CSV

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