PREVIEW / etf_daily / 2007-11-19

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-19.parquet
  size:    24 KB
  rows:    539

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-11-19	SPY	ETF	145.28	145.36	143.19	143.76	267746000.0
2007-11-19	QQQ	ETF	50.17	50.45	49.41	49.7	198651025.0
2007-11-19	IWM	ETF	75.89	76.04	74.32	74.64	116186400.0
2007-11-19	DIA	ETF	131.02	131.66	129.27	129.6	21362600.0
2007-11-19	GLD	ETF	77.84	78.0	76.11	77.24	6088600.0
2007-11-19	TLT	ETF	92.54	93.42	92.41	93.01	1343900.0
2007-11-19	ADRE	ETF	54.1	54.122	52.41	52.71	364302.0
2007-11-19	AGG	ETF	100.81	101.38	100.81	101.21	416800.0
2007-11-19	AIA	ETF	50.9	50.9	46.53	46.75	15600.0
2007-11-19	AIQ	ETF	42.75	43.2	41.4	43.2	63880.0
2007-11-19	AIS	ETF	1.1	1.14	1.08	1.1	68700.0
2007-11-19	AIVI	ETF	73.65	73.65	70.74	70.99	62200.0
2007-11-19	ARB	ETF	51.43	52.15	50.92	51.36	273500.0
2007-11-19	BBH	ETF	58.7867	58.97	58.04	58.4	577500.0
2007-11-19	BIL	ETF	91.78	91.82	91.7	91.82	59150.0
2007-11-19	BITS	ETF	23.4	23.4	21.76	23.28	11690.0
2007-11-19	BIV	ETF	76.93	77.42	76.83	77.36	8600.0
2007-11-19	BKF	ETF	57.83	57.83	56.34	56.7	3100.0
2007-11-19	BLV	ETF	76.73	77.29	76.65	77.17	14900.0
2007-11-19	BMVP	ETF	16.8067	16.8248	16.6133	16.65	35300.0
2007-11-19	BND	ETF	76.45	76.86	76.45	76.7	144100.0
2007-11-19	BNE	ETF	16.97	17.05	16.61	16.73	152500.0
2007-11-19	BRF	ETF	14.64	14.66	14.61	14.61	2200.0
2007-11-19	BSV	ETF	76.9	77.19	76.86	77.18	44700.0
2007-11-19	BTF	ETF	111.89999999999999	111.89999999999999	110.1	111.05	1120.0
2007-11-19	BWX	ETF	27.89	27.89	26.965	27.19	315180.0
2007-11-19	CBON	ETF	18.63	18.85	18.06	18.45	97865.0
2007-11-19	CDL	ETF	2.39	2.43	2.21	2.24	1986750.0
2007-11-19	CEF	ETF	10.6	10.6	10.29	10.41	474200.0
2007-11-19	CGO	ETF	18.4	18.4	18.08	18.13	10800.0
2007-11-19	CGW	ETF	24.95	25.1	24.6001	24.75	49860.0
2007-11-19	CHB	ETF	8.94	9.06	8.51	8.59	2413213.0
2007-11-19	CHI	ETF	15.03	15.09	14.78	15.01	199800.0
2007-11-19	CHIC	ETF	14.91	14.91	14.29	14.31	583948.0
2007-11-19	CHW	ETF	12.36	12.36	11.95	12.05	336100.0
2007-11-19	CHY	ETF	13.5	13.5	13.0	13.14	184000.0
2007-11-19	CMF	ETF	51.875	51.875	51.37	51.74	75400.0
2007-11-19	CN	ETF	54.24	54.47	53.0	54.0	489800.0
2007-11-19	CNXT	ETF	1.17	1.1801	1.14	1.18	5223395.0
2007-11-19	COW	ETF	48.62	48.62	47.91	47.91	3300.0
2007-11-19	CPI	ETF	24.81	24.81	24.7	24.7	200.0
2007-11-19	CPST	ETF	1.24	1.24	1.21	1.23	960402.0
2007-11-19	CSA	ETF	16.83	17.44	16.37	17.28	68500.0
2007-11-19	CSD	ETF	26.92	26.92	26.46	26.46	9100.0
2007-11-19	CSQ	ETF	13.6	13.6	13.34	13.38	397428.0
2007-11-19	CUT	ETF	24.2	24.2	23.6	23.65	31900.0
2007-11-19	CVY	ETF	24.26	24.26	23.91	23.92	43500.0
2007-11-19	CWI	ETF	27.86	27.8867	27.3867	27.4933	151650.0
2007-11-19	DBA	ETF	30.02	30.02	29.7	29.7	224000.0
2007-11-19	DBB	ETF	24.03	24.03	22.71	23.05	57900.0

> showing 50 of 539 rows — these rows as CSV

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