PREVIEW / etf_daily / 2009-01-14

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-14.parquet
  size:    27 KB
  rows:    621

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-01-14	SPY	ETF	85.54	85.75	83.16	84.37	435491600.0
2009-01-14	QQQ	ETF	29.17	29.28	28.47	28.63	137103247.0
2009-01-14	IWM	ETF	46.32	46.67	45.12	45.24	74519500.0
2009-01-14	DIA	ETF	83.16	83.36	81.48	82.08	38850600.0
2009-01-14	GLD	ETF	80.57	81.09	79.36	79.79	15600000.0
2009-01-14	TLT	ETF	114.65	116.04	114.65	115.9	2494800.0
2009-01-14	AAXJ	ETF	32.46	32.46	30.52	30.97	106700.0
2009-01-14	ACWI	ETF	30.0	30.0	29.34	29.59	121100.0
2009-01-14	ACWX	ETF	27.99	28.03	27.2	27.41	239942.0
2009-01-14	ADRE	ETF	26.44	26.44	25.25	25.45	97740.0
2009-01-14	AFK	ETF	19.5	19.5	18.75	18.76	19074.0
2009-01-14	AGG	ETF	103.45	103.45	102.61	103.08	951900.0
2009-01-14	AGQ	ETF	53.88	54.56	52.0	53.7	12700.0
2009-01-14	AGZ	ETF	109.16	109.16	108.734	108.864	43739.0
2009-01-14	AIA	ETF	23.374	23.737	23.14	23.416	22458.0
2009-01-14	AIQ	ETF	41.35	42.5	40.25	40.5	75141.0
2009-01-14	AIS	ETF	0.48	0.48	0.45	0.47	210077.0
2009-01-14	AIVI	ETF	31.0	31.0	30.29	30.37	28000.0
2009-01-14	AOA	ETF	23.65	23.65	22.5	22.95	5500.0
2009-01-14	AOK	ETF	25.1	25.33	25.1	25.286	8854.0
2009-01-14	AOM	ETF	25.81	25.81	24.5	24.63	10202.0
2009-01-14	AOR	ETF	23.67	24.35	22.51	23.05	16451.0
2009-01-14	ARB	ETF	15.08	15.31	14.18	14.47	280902.0
2009-01-14	BAL	ETF	26.95	26.98	26.95	26.98	1000.0
2009-01-14	BBH	ETF	56.84	57.98	56.84	57.24	468000.0
2009-01-14	BIL	ETF	91.84	91.84	91.76	91.82	4573650.0
2009-01-14	BITS	ETF	19.56	19.56	18.2	19.48	3325.0
2009-01-14	BIV	ETF	79.19	79.49	78.98	79.17	96800.0
2009-01-14	BJK	ETF	16.57	16.57	16.33	16.34	900.0
2009-01-14	BKF	ETF	22.93	23.06	22.08	22.275	87896.0
2009-01-14	BLV	ETF	78.25	79.34	78.0	79.06	30600.0
2009-01-14	BMVP	ETF	10.2233	10.2392	10.0847	10.1567	31235.0
2009-01-14	BND	ETF	78.42	78.64	77.99	78.64	230600.0
2009-01-14	BNE	ETF	3.83	3.89	3.07	3.21	361935.0
2009-01-14	BSV	ETF	80.2	80.56	79.55	80.56	158200.0
2009-01-14	BTF	ETF	50.65	50.65	47.5	48.15	13233.800000000001
2009-01-14	BWX	ETF	26.045	26.075	25.9402	26.06	154012.0
2009-01-14	CBON	ETF	2.5	2.5	2.13	2.24	62112.0
2009-01-14	CDL	ETF	0.21	0.23	0.2	0.21	612709.0
2009-01-14	CEF	ETF	9.99	10.11	9.88	9.93	595700.0
2009-01-14	CGO	ETF	10.25	10.25	9.63	9.64	10071.0
2009-01-14	CGW	ETF	13.09	13.412	13.05	13.11	54512.0
2009-01-14	CHB	ETF	0.64	0.68	0.6	0.6	561477.0
2009-01-14	CHI	ETF	9.3	9.3	8.46	8.63	278725.0
2009-01-14	CHIC	ETF	5.38	5.42	4.8	4.88	304647.0
2009-01-14	CHW	ETF	6.2	6.2	5.91	5.99	317828.0
2009-01-14	CHY	ETF	9.0	9.08	8.35	8.39	473511.0
2009-01-14	CMF	ETF	51.915	52.4	51.8975	52.215	12460.0
2009-01-14	CNXT	ETF	0.75	0.75	0.6801	0.6802	510335.0
2009-01-14	COW	ETF	32.79	32.92	31.78	32.78	30186.0

> showing 50 of 621 rows — these rows as CSV

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