PREVIEW / etf_daily / 2009-04-07

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-07.parquet
  size:    28 KB
  rows:    642

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-04-07	SPY	ETF	82.25	82.65	81.51	81.65	258947800.0
2009-04-07	QQQ	ETF	31.9	31.92	31.21	31.42	147531195.0
2009-04-07	IWM	ETF	44.08	44.46	43.12	43.26	48410400.0
2009-04-07	DIA	ETF	78.74	78.74	77.69	77.89	17326400.0
2009-04-07	GLD	ETF	86.27	88.26	86.17	86.74	11004600.0
2009-04-07	TLT	ETF	102.54	103.31	102.48	102.74	1312600.0
2009-04-07	AAXJ	ETF	35.38	35.71	35.15	35.4	72000.0
2009-04-07	ACWI	ETF	29.71	29.74	28.94	29.43	119700.0
2009-04-07	ACWX	ETF	27.97	28.0586	27.75	27.81	73443.0
2009-04-07	ADRE	ETF	29.04	29.32	28.86	29.04	115765.0
2009-04-07	AFK	ETF	20.35	20.35	20.2399	20.2399	400.0
2009-04-07	AGG	ETF	100.42	100.47	100.01	100.24	807100.0
2009-04-07	AGQ	ETF	68.62	70.7	68.2	69.5	55150.0
2009-04-07	AGZ	ETF	112.4	112.4	107.552	108.08	10212.0
2009-04-07	AIA	ETF	27.15	27.15	26.5	26.8344	18959.0
2009-04-07	AIQ	ETF	33.65	35.85	32.9	35.6	54869.0
2009-04-07	AIS	ETF	0.405	0.42	0.38	0.42	162482.0
2009-04-07	AIVI	ETF	29.6	29.9	29.51	29.81	5900.0
2009-04-07	AMJ	ETF	19.29	19.36	19.29	19.35	24800.0
2009-04-07	AOA	ETF	22.32	22.5	22.32	22.35	2800.0
2009-04-07	AOK	ETF	24.84	25.59	24.49	24.86	9412.0
2009-04-07	AOM	ETF	24.2	24.32	24.11	24.12	14782.0
2009-04-07	AOR	ETF	24.11	24.11	23.31	23.31	3077.0
2009-04-07	ARB	ETF	15.96	16.17	15.87	16.0	315540.0
2009-04-07	BAL	ETF	26.85	26.85	26.59	26.77	1035.0
2009-04-07	BBH	ETF	29.7767	30.3467	29.46	29.8967	452400.0
2009-04-07	BIL	ETF	91.68	91.72	91.68	91.7	153000.0
2009-04-07	BITS	ETF	18.4	18.4	17.44	18.24	1075.0
2009-04-07	BIV	ETF	75.61	75.72	75.4	75.72	70700.0
2009-04-07	BJK	ETF	17.24	17.48	16.55	16.56	2900.0
2009-04-07	BKF	ETF	27.27	27.31	26.908	27.03	60817.0
2009-04-07	BLV	ETF	72.56	72.64	71.89	72.45	16100.0
2009-04-07	BMVP	ETF	10.05	10.13	10.0	10.02	18138.0
2009-04-07	BND	ETF	76.75	76.85	76.57	76.7	274100.0
2009-04-07	BNE	ETF	3.3	3.34	3.02	3.04	217668.0
2009-04-07	BOSS	ETF	11.51	11.51	11.39	11.39	300.0
2009-04-07	BSV	ETF	78.35	78.36	78.26	78.28	153800.0
2009-04-07	BTF	ETF	42.949999999999996	43.2	42.05	42.949999999999996	8068.0
2009-04-07	BWX	ETF	25.505	25.569	25.47	25.55	167762.0
2009-04-07	BWZ	ETF	32.8042	32.92	32.8042	32.92	3414.0
2009-04-07	CBON	ETF	2.3	2.3	2.18	2.18	23295.0
2009-04-07	CEF	ETF	11.34	11.53	11.28	11.41	926000.0
2009-04-07	CGO	ETF	9.25	9.41	9.15	9.24	13735.0
2009-04-07	CGW	ETF	12.62	12.75	12.532	12.56	39874.0
2009-04-07	CHB	ETF	0.52	0.53	0.45	0.45	990139.0
2009-04-07	CHI	ETF	8.82	8.85	8.66	8.79	174304.0
2009-04-07	CHIC	ETF	9.27	9.27	8.82	8.83	362485.0
2009-04-07	CHW	ETF	5.74	5.77	5.59	5.76	148982.0
2009-04-07	CHY	ETF	8.37	8.51	8.32	8.5	176750.0
2009-04-07	CMF	ETF	51.75	51.878	51.735	51.8438	6288.0

> showing 50 of 642 rows — these rows as CSV

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