PREVIEW / etf_daily / 2008-02-27

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-27.parquet
  size:    26 KB
  rows:    572

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-27	SPY	ETF	137.56	139.14	137.41	138.22	168395800.0
2008-02-27	QQQ	ETF	43.77	44.46	43.67	44.29	125682592.0
2008-02-27	IWM	ETF	70.84	72.24	70.71	71.4	85186500.0
2008-02-27	DIA	ETF	126.22	127.57	126.11	126.83	11539600.0
2008-02-27	GLD	ETF	94.56	94.94	93.97	94.78	9926500.0
2008-02-27	TLT	ETF	91.43	91.57	90.61	91.19	2494400.0
2008-02-27	ADRE	ETF	54.0	55.08	53.86	54.81	621292.0
2008-02-27	AGG	ETF	101.92	101.97	101.66	101.93	633000.0
2008-02-27	AIA	ETF	43.64	45.63	43.64	45.3999	25200.0
2008-02-27	AIQ	ETF	49.2	50.5	48.7	50.0	68340.0
2008-02-27	AIS	ETF	1.05	1.07	1.02	1.04	50000.0
2008-02-27	AIVI	ETF	65.2	66.22	65.14	66.0	40700.0
2008-02-27	ARB	ETF	42.4	43.74	42.29	42.6	322962.0
2008-02-27	BBH	ETF	56.05	56.51	55.9567	56.0	512400.0
2008-02-27	BIL	ETF	91.72	91.84	91.72	91.84	84550.0
2008-02-27	BITS	ETF	20.8	21.24	20.64	20.9204	4439.0
2008-02-27	BIV	ETF	78.44	78.47	78.02	78.22	37100.0
2008-02-27	BJK	ETF	43.0	43.5	43.0	43.35	2200.0
2008-02-27	BKF	ETF	54.58	56.29	54.58	55.61	66900.0
2008-02-27	BLV	ETF	75.33	75.44	74.98	75.26	10000.0
2008-02-27	BMVP	ETF	16.3667	16.5433	16.3333	16.4033	28100.0
2008-02-27	BND	ETF	77.21	77.21	76.91	77.06	221900.0
2008-02-27	BNE	ETF	13.49	13.75	13.22	13.55	124500.0
2008-02-27	BRF	ETF	14.67	14.67	14.658	14.66	7900.0
2008-02-27	BSV	ETF	78.63	78.7	78.43	78.54	65500.0
2008-02-27	BTF	ETF	109.35	109.8	109.04999999999998	109.7	4560.0
2008-02-27	BWX	ETF	27.795	27.83	27.715	27.77	464980.0
2008-02-27	CBON	ETF	13.12	13.26	12.81	13.0	50571.0
2008-02-27	CDL	ETF	1.56	1.63	1.53	1.56	926216.0
2008-02-27	CEF	ETF	13.29	13.49	13.24	13.31	2004900.0
2008-02-27	CGO	ETF	17.04	17.09	16.8999	16.93	18550.0
2008-02-27	CGW	ETF	24.0	24.5499	24.0	24.47	206313.0
2008-02-27	CHB	ETF	9.41	9.66	9.22	9.46	2127727.0
2008-02-27	CHI	ETF	15.05	15.16	14.78	15.0701	108548.0
2008-02-27	CHIC	ETF	20.12	20.4	19.82	20.02	657962.0
2008-02-27	CHW	ETF	11.77	12.14	11.77	12.08	155694.0
2008-02-27	CHY	ETF	13.72	13.93	13.65	13.93	116680.0
2008-02-27	CMF	ETF	51.55	51.55	51.3	51.46	61800.0
2008-02-27	CN	ETF	64.5	66.05	63.99	65.41	351526.0
2008-02-27	CNXT	ETF	0.57	0.6	0.56	0.6	2933417.0
2008-02-27	COW	ETF	45.44	45.49	44.9	45.0	36100.0
2008-02-27	CPI	ETF	19.8	19.8	19.7	19.7	1300.0
2008-02-27	CPST	ETF	1.8	1.95	1.76	1.89	4042085.0
2008-02-27	CSA	ETF	14.87	15.36	14.78	15.0	424900.0
2008-02-27	CSD	ETF	24.11	24.24	23.94	24.0	2300.0
2008-02-27	CSQ	ETF	12.91	13.06	12.89	12.95	296911.0
2008-02-27	CUT	ETF	23.27	23.27	21.85	22.6	42800.0
2008-02-27	CVY	ETF	23.44	23.63	23.33	23.4	22800.0
2008-02-27	CWI	ETF	26.0267	26.3333	26.0267	26.1667	94800.0
2008-02-27	DBA	ETF	41.2	43.5	41.01	42.46	6901800.0

> showing 50 of 572 rows — these rows as CSV

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