PREVIEW / etf_daily / 2007-12-26

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-26.parquet
  size:    25 KB
  rows:    550

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-26	SPY	ETF	148.65	149.68	148.5	149.55	67093100.0
2007-12-26	QQQ	ETF	52.15	52.63	52.0	52.5	58492079.0
2007-12-26	IWM	ETF	78.84	79.84	78.71	79.54	65572400.0
2007-12-26	DIA	ETF	135.01	135.5	134.79	135.42	5743000.0
2007-12-26	GLD	ETF	81.06	81.67	81.0	81.52	5896700.0
2007-12-26	TLT	ETF	91.02	91.63	90.28	90.44	674700.0
2007-12-26	ADRE	ETF	56.05	56.4699	55.56	56.41	288861.0
2007-12-26	AGG	ETF	100.75	100.94	100.35	100.46	259200.0
2007-12-26	AIA	ETF	49.31	49.31	48.97	48.97	5000.0
2007-12-26	AIQ	ETF	48.55	49.25	47.9	49.2	20620.0
2007-12-26	AIS	ETF	0.99	1.0	0.95	1.0	245500.0
2007-12-26	AIVI	ETF	70.33	71.31	70.19	71.06	55700.0
2007-12-26	ARB	ETF	41.57	42.82	41.57	42.54	160400.0
2007-12-26	BBH	ETF	54.7567	55.1633	54.6467	55.09	1137300.0
2007-12-26	BIL	ETF	91.8	91.88	91.8	91.82	17750.0
2007-12-26	BITS	ETF	24.6	24.68	23.8	24.36	3416.0
2007-12-26	BIV	ETF	76.06	76.41	75.9	75.95	18800.0
2007-12-26	BKF	ETF	60.39	60.85	60.14	60.84	7600.0
2007-12-26	BLV	ETF	75.12	75.37	74.67	74.68	10900.0
2007-12-26	BMVP	ETF	17.56	17.6833	17.56	17.6567	43389.0
2007-12-26	BND	ETF	76.24	76.33	76.0	76.04	130800.0
2007-12-26	BNE	ETF	18.38	18.55	18.1	18.43	108600.0
2007-12-26	BRF	ETF	14.74	14.74	14.62	14.63	8400.0
2007-12-26	BSV	ETF	76.41	76.69	76.41	76.53	23600.0
2007-12-26	BTF	ETF	109.85	110.7995	109.85	110.7995	2520.0
2007-12-26	BWX	ETF	26.3	26.45	26.255	26.45	239600.0
2007-12-26	CBON	ETF	18.05	18.64	17.94	18.25	102023.0
2007-12-26	CDL	ETF	2.14	2.24	2.1	2.1	1708836.0
2007-12-26	CEF	ETF	10.6	10.73	10.6	10.69	219500.0
2007-12-26	CGO	ETF	19.42	19.69	19.25	19.43	22317.0
2007-12-26	CGW	ETF	26.1	26.48	25.98	26.2499	272500.0
2007-12-26	CHB	ETF	9.87	10.02	9.59	9.93	724864.0
2007-12-26	CHI	ETF	15.51	15.51	14.92	15.24	253959.0
2007-12-26	CHIC	ETF	15.85	16.18	14.99	16.15	894268.0
2007-12-26	CHW	ETF	12.87	12.89	12.52	12.75	385100.0
2007-12-26	CHY	ETF	13.4	13.6376	13.25	13.53	367266.0
2007-12-26	CMF	ETF	51.89	52.075	51.89	52.075	50400.0
2007-12-26	CN	ETF	60.1	60.78	60.1	60.45	180164.0
2007-12-26	CNXT	ETF	0.911	0.94	0.91	0.9137	3680159.0
2007-12-26	COW	ETF	47.8	47.8	47.6092	47.63	30900.0
2007-12-26	CPST	ETF	1.54	1.79	1.5395	1.77	7056331.0
2007-12-26	CSA	ETF	16.29	16.56	16.19	16.46	25500.0
2007-12-26	CSD	ETF	27.19	27.3	27.19	27.28	9200.0
2007-12-26	CSQ	ETF	14.34	14.39	14.2	14.38	419739.0
2007-12-26	CUT	ETF	24.35	24.55	24.34	24.55	31000.0
2007-12-26	CVY	ETF	23.85	23.85	23.51	23.68	33500.0
2007-12-26	CWI	ETF	27.0667	27.8133	27.0667	27.8067	138300.0
2007-12-26	DBA	ETF	33.32	33.54	32.9	33.54	740900.0
2007-12-26	DBB	ETF	22.55	22.55	22.25	22.3	25100.0
2007-12-26	DBC	ETF	31.25	31.56	31.15	31.51	189300.0

> showing 50 of 550 rows — these rows as CSV

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