PREVIEW / etf_daily / 2008-02-14

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-14.parquet
  size:    26 KB
  rows:    568

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
2008-02-14	SPY	ETF	136.95	137.0	134.79	135.17	215207200.0
2008-02-14	QQQ	ETF	44.84	44.85	43.89	43.97	170868895.0
2008-02-14	IWM	ETF	72.1	72.18	70.02	70.18	78328200.0
2008-02-14	DIA	ETF	125.69	125.7	123.75	124.01	11294600.0
2008-02-14	GLD	ETF	89.37	90.11	89.35	89.71	6882500.0
2008-02-14	TLT	ETF	91.8	92.1	90.66	91.18	7505000.0
2008-02-14	ADRE	ETF	51.99	52.0	50.83	50.92	417283.0
2008-02-14	AGG	ETF	102.14	102.33	101.74	102.0	578800.0
2008-02-14	AIA	ETF	43.54	43.97	43.35	43.35	2000.0
2008-02-14	AIQ	ETF	54.5	54.75	50.5	50.5	51775.0
2008-02-14	AIS	ETF	0.98	1.0	0.97	0.98	56050.0
2008-02-14	AIVI	ETF	63.08	63.13	62.26	62.26	39400.0
2008-02-14	ARB	ETF	42.75	46.24	41.7	42.4	961800.0
2008-02-14	BBH	ETF	55.32	55.4933	54.8	54.8267	390300.0
2008-02-14	BIL	ETF	91.72	91.76	91.68	91.76	51200.0
2008-02-14	BITS	ETF	22.84	22.84	22.16	22.44	20423.0
2008-02-14	BIV	ETF	78.58	78.72	78.15	78.39	18100.0
2008-02-14	BJK	ETF	43.34	43.35	43.2	43.2	3400.0
2008-02-14	BKF	ETF	53.5184	53.54	52.24	52.29	13800.0
2008-02-14	BLV	ETF	75.97	75.97	75.13	75.4	76300.0
2008-02-14	BMVP	ETF	16.17	16.1867	16.01	16.0233	66642.0
2008-02-14	BND	ETF	77.3	77.37	76.99	77.09	144900.0
2008-02-14	BNE	ETF	13.26	13.44	13.0	13.01	181200.0
2008-02-14	BRF	ETF	14.69	14.7	14.68	14.69	6700.0
2008-02-14	BSV	ETF	78.67	78.7	78.54	78.59	76700.0
2008-02-14	BTF	ETF	112.6	113.35000000000001	111.44999999999999	111.54999999999998	5220.0
2008-02-14	BWX	ETF	27.125	27.22	27.05	27.195	135400.0
2008-02-14	CBON	ETF	15.14	15.28	14.42	14.42	60853.0
2008-02-14	CDL	ETF	1.43	1.45	1.4	1.41	616103.0
2008-02-14	CEF	ETF	12.45	12.63	12.45	12.51	320200.0
2008-02-14	CGO	ETF	16.31	16.406	15.64	15.67	77966.0
2008-02-14	CGW	ETF	23.99	23.99	23.2	23.2	61526.0
2008-02-14	CHB	ETF	9.03	9.05	8.47	8.53	2117914.0
2008-02-14	CHI	ETF	15.31	15.31	14.01	14.62	473279.0
2008-02-14	CHIC	ETF	19.08	19.21	18.33	18.65	419576.0
2008-02-14	CHW	ETF	12.25	12.25	11.43	11.51	282450.0
2008-02-14	CHY	ETF	13.7	13.71	12.92	13.36	415559.0
2008-02-14	CMF	ETF	52.54	52.54	52.28	52.39	7000.0
2008-02-14	CN	ETF	63.22	64.77	62.47	62.7	493074.0
2008-02-14	CNXT	ETF	0.63	0.6397	0.6	0.6025	2209581.0
2008-02-14	COW	ETF	45.67	45.8	45.48	45.72	7200.0
2008-02-14	CPI	ETF	19.35	19.35	19.0	19.0	3300.0
2008-02-14	CPST	ETF	1.58	1.6	1.56	1.56	643204.0
2008-02-14	CSA	ETF	15.8	15.92	15.42	15.59	239700.0
2008-02-14	CSD	ETF	24.49	24.49	24.08	24.09	45400.0
2008-02-14	CSQ	ETF	13.07	13.07	12.39	12.39	876182.0
2008-02-14	CUT	ETF	21.63	21.63	21.09	21.1	45400.0
2008-02-14	CVY	ETF	23.16	23.16	22.8	22.83	22000.0
2008-02-14	CWI	ETF	24.1733	25.2333	24.1733	24.9667	240900.0
2008-02-14	CZA	ETF	24.0	24.0	24.0	24.0	200.0

> showing 50 of 568 rows — these rows as CSV

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