PREVIEW / etf_daily / 2009-06-26

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-26.parquet
  size:    29 KB
  rows:    654

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-06-26	SPY	ETF	91.77	92.24	91.27	91.84	167579000.0
2009-06-26	QQQ	ETF	36.13	36.5	36.05	36.37	87677290.0
2009-06-26	IWM	ETF	50.79	51.56	50.57	51.23	60379100.0
2009-06-26	DIA	ETF	84.46	84.69	84.02	84.27	7779000.0
2009-06-26	GLD	ETF	92.81	92.93	91.93	92.29	10418500.0
2009-06-26	TLT	ETF	94.62	94.9	94.21	94.59	4050400.0
2009-06-26	AAXJ	ETF	44.48	44.63	44.2	44.26	543400.0
2009-06-26	ACWI	ETF	34.58	34.59	34.33	34.52	913300.0
2009-06-26	ACWX	ETF	33.24	33.34	33.0973	33.33	63369.0
2009-06-26	ADRE	ETF	34.75	34.9988	34.5201	34.86	155965.0
2009-06-26	AFK	ETF	26.28	26.45	26.14	26.45	2629.0
2009-06-26	AGG	ETF	102.09	102.22	101.92	102.22	471300.0
2009-06-26	AGQ	ETF	89.22	89.48	87.34	87.7	110250.0
2009-06-26	AGZ	ETF	107.13	107.64	107.11	107.54	7502.0
2009-06-26	AIA	ETF	32.04	32.25	31.78	31.91	68150.0
2009-06-26	AIQ	ETF	37.05	37.2	35.55	36.6	116873.0
2009-06-26	AIS	ETF	0.69	0.73	0.69	0.72	84100.0
2009-06-26	AIVI	ETF	34.43	35.05	34.43	34.66	8600.0
2009-06-26	AMJ	ETF	21.92	22.35	21.92	22.25	103414.0
2009-06-26	AOA	ETF	25.15	25.15	24.66	25.13	9000.0
2009-06-26	AOM	ETF	25.54	25.59	25.5215	25.59	1942.0
2009-06-26	AOR	ETF	25.41	25.45	25.34	25.45	7260.0
2009-06-26	ARB	ETF	16.15	16.26	15.79	16.09	379707.0
2009-06-26	BAL	ETF	29.61	29.61	29.61	29.61	900.0
2009-06-26	BBH	ETF	31.1667	31.6533	30.98	31.5067	646500.0
2009-06-26	BIL	ETF	91.74	91.76	91.72	91.76	127350.0
2009-06-26	BITS	ETF	19.2	19.2	18.68	19.2	2812.0
2009-06-26	BIV	ETF	76.83	77.23	76.83	77.13	71400.0
2009-06-26	BJK	ETF	20.96	21.4	20.85	21.21	2800.0
2009-06-26	BKF	ETF	35.51	35.81	35.29	35.72	418304.0
2009-06-26	BLV	ETF	74.52	74.74	74.19	74.55	10700.0
2009-06-26	BMVP	ETF	10.893	10.973	10.853	10.961	13264.0
2009-06-26	BND	ETF	77.74	77.75	77.6	77.68	383500.0
2009-06-26	BNE	ETF	6.5	6.77	6.3399	6.75	302699.0
2009-06-26	BRF	ETF	28.2	28.3	27.99	28.16	43159.0
2009-06-26	BSV	ETF	79.05	79.14	78.9	78.93	191100.0
2009-06-26	BTF	ETF	46.5	46.65	45.6505	46.25	2926.4
2009-06-26	BWX	ETF	27.285	27.445	27.2181	27.33	155388.0
2009-06-26	BWZ	ETF	35.29	35.37	35.29	35.36	6513.0
2009-06-26	BZQ	ETF	9224.0	9225.6	9156.8	9164.8	15.75
2009-06-26	CBON	ETF	1.11	1.42	0.93	0.93	95707.0
2009-06-26	CEF	ETF	12.09	12.09	11.91	11.99	375200.0
2009-06-26	CEW	ETF	20.86	20.88	20.78	20.78	10206.0
2009-06-26	CGO	ETF	11.63	11.73	11.53	11.62	20087.0
2009-06-26	CGW	ETF	15.51	15.59	15.28	15.59	20101.0
2009-06-26	CHB	ETF	0.35	0.369	0.3	0.3	7930001.0
2009-06-26	CHI	ETF	10.37	10.49	10.37	10.42	63719.0
2009-06-26	CHIC	ETF	12.14	12.61	11.87	12.48	665677.0
2009-06-26	CHW	ETF	6.77	6.92	6.65	6.9	170147.0
2009-06-26	CHY	ETF	10.26	10.2657	10.02	10.06	228370.0

> showing 50 of 654 rows — these rows as CSV

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