PREVIEW / etf_daily / 2009-03-27

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-27.parquet
  size:    28 KB
  rows:    641

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
2009-03-27	SPY	ETF	82.05	82.53	81.31	81.61	322332300.0
2009-03-27	QQQ	ETF	31.07	31.18	30.71	30.82	156108009.0
2009-03-27	IWM	ETF	43.62	44.0	42.83	42.89	78132900.0
2009-03-27	DIA	ETF	78.14	78.42	77.33	77.81	19994100.0
2009-03-27	GLD	ETF	90.83	91.26	90.41	90.69	11596000.0
2009-03-27	TLT	ETF	104.15	104.93	103.56	104.56	1853900.0
2009-03-27	AAXJ	ETF	34.96	34.96	34.14	34.28	165500.0
2009-03-27	ACWI	ETF	29.07	29.2	28.85	28.9	58400.0
2009-03-27	ACWX	ETF	27.27	27.3125	26.98	26.98	71609.0
2009-03-27	ADRE	ETF	28.79	28.79	28.26	28.4	266734.0
2009-03-27	AFK	ETF	20.4	20.4	19.89	19.89	5100.0
2009-03-27	AGG	ETF	100.62	100.89	100.14	100.48	1303900.0
2009-03-27	AGQ	ETF	82.16	83.32	81.84	82.68	43000.0
2009-03-27	AGZ	ETF	107.728	107.87	107.48	107.64	6856.0
2009-03-27	AIA	ETF	26.22	26.32	25.95	26.05	10784.0
2009-03-27	AIQ	ETF	36.1	37.25	35.25	35.25	42623.0
2009-03-27	AIS	ETF	0.45	0.45	0.41	0.43	54190.0
2009-03-27	AIVI	ETF	28.48	28.7	28.4	28.5	11000.0
2009-03-27	AOA	ETF	22.25	22.27	22.1	22.1	6800.0
2009-03-27	AOK	ETF	24.9799	25.09	24.6028	24.99	2217.0
2009-03-27	AOM	ETF	24.06	24.15	24.06	24.15	1199.0
2009-03-27	AOR	ETF	23.364	23.364	23.22	23.22	480.0
2009-03-27	ARB	ETF	14.25	16.06	14.25	15.26	521017.0
2009-03-27	BAL	ETF	25.14	25.18	24.63	24.6301	5150.0
2009-03-27	BBH	ETF	58.23	58.8333	58.1567	58.2833	301500.0
2009-03-27	BIL	ETF	91.76	91.78	91.74	91.78	191750.0
2009-03-27	BITS	ETF	17.76	17.92	16.8	17.92	350.0
2009-03-27	BIV	ETF	76.5	76.59	76.2	76.35	125900.0
2009-03-27	BJK	ETF	16.39	16.45	15.07	15.07	7200.0
2009-03-27	BKF	ETF	26.38	26.38	25.08	25.96	80545.0
2009-03-27	BLV	ETF	73.47	73.77	73.29	73.76	7200.0
2009-03-27	BMVP	ETF	10.1133	10.1133	9.9104	9.9133	21096.0
2009-03-27	BND	ETF	77.0	77.09	76.82	76.97	411900.0
2009-03-27	BNE	ETF	3.83	3.83	3.55	3.59	127418.0
2009-03-27	BSV	ETF	78.43	78.51	78.3	78.3	212600.0
2009-03-27	BTF	ETF	40.75	40.75	40.25	40.475	5319.8
2009-03-27	BWX	ETF	25.605	25.655	25.5405	25.65	172328.0
2009-03-27	BWZ	ETF	32.76	32.76	32.7	32.73	450.0
2009-03-27	CBON	ETF	1.48	1.5	1.42	1.42	2495.0
2009-03-27	CEF	ETF	12.08	12.15	11.95	12.04	980900.0
2009-03-27	CGO	ETF	9.23	9.37	9.1797	9.3	16365.0
2009-03-27	CGW	ETF	12.26	12.5001	12.09	12.18	54069.0
2009-03-27	CHB	ETF	0.62	0.62	0.5	0.54	1122850.0
2009-03-27	CHI	ETF	8.83	8.83	8.64	8.74	115227.0
2009-03-27	CHIC	ETF	7.95	8.18	7.55	7.95	217426.0
2009-03-27	CHW	ETF	5.46	5.6	5.436	5.57	163382.0
2009-03-27	CHY	ETF	8.46	8.51	8.26	8.46	214833.0
2009-03-27	CMF	ETF	52.085	52.085	51.7295	51.98	7822.0
2009-03-27	CNXT	ETF	0.73	0.74	0.7099	0.73	231670.0
2009-03-27	COW	ETF	30.93	31.01	30.7	30.7092	3313.0

> showing 50 of 641 rows — these rows as CSV

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