PREVIEW / etf_daily / 2009-05-26

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-26.parquet
  size:    29 KB
  rows:    653

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-05-26	SPY	ETF	88.36	91.56	88.32	91.3	236318500.0
2009-05-26	QQQ	ETF	33.19	34.83	33.18	34.79	144857122.0
2009-05-26	IWM	ETF	47.37	50.16	47.32	50.07	73480700.0
2009-05-26	DIA	ETF	82.27	85.06	82.27	84.85	13636800.0
2009-05-26	GLD	ETF	92.95	93.84	92.85	93.76	12356100.0
2009-05-26	TLT	ETF	94.05	94.1	92.12	92.12	3633100.0
2009-05-26	AAXJ	ETF	42.67	44.7	42.02	43.36	621000.0
2009-05-26	ACWI	ETF	33.7	34.9	33.64	34.75	558400.0
2009-05-26	ACWX	ETF	32.93	33.98	32.8	33.83	44899.0
2009-05-26	ADRE	ETF	33.78	34.87	33.6	34.68	165059.0
2009-05-26	AFK	ETF	25.79	26.84	25.76	26.57	10905.0
2009-05-26	AGG	ETF	101.87	101.89	101.35	101.47	469300.0
2009-05-26	AGQ	ETF	93.68	96.64	93.26	95.66	91350.0
2009-05-26	AGZ	ETF	107.66	107.72	106.7842	107.12	45961.0
2009-05-26	AIA	ETF	31.0	32.08	31.0	31.94	47553.0
2009-05-26	AIQ	ETF	34.05	34.85	33.3	34.35	58697.0
2009-05-26	AIS	ETF	0.58	0.58	0.38	0.55	157426.0
2009-05-26	AIVI	ETF	34.66	36.01	34.66	35.86	9600.0
2009-05-26	AMJ	ETF	22.32	22.34	22.23	22.33	49129.0
2009-05-26	AOA	ETF	24.58	25.17	24.57	25.12	8600.0
2009-05-26	AOK	ETF	25.5899	25.75	25.55	25.75	4748.0
2009-05-26	AOM	ETF	25.39	25.8084	25.39	25.6	7108.0
2009-05-26	AOR	ETF	25.0499	25.5161	25.0499	25.45	3076.0
2009-05-26	ARB	ETF	19.98	21.33	19.89	20.95	259885.0
2009-05-26	BAL	ETF	32.0	32.0	31.4	31.4	6230.0
2009-05-26	BBH	ETF	29.16	29.9733	28.9867	29.93	697200.0
2009-05-26	BIL	ETF	91.74	91.76	91.7	91.76	113700.0
2009-05-26	BITS	ETF	18.12	18.52	18.0	18.44	32776.0
2009-05-26	BIV	ETF	76.93	76.93	76.0	76.08	81900.0
2009-05-26	BJK	ETF	21.5	22.5	20.76	21.64	19700.0
2009-05-26	BKF	ETF	33.57	34.6599	33.43	34.56	93509.0
2009-05-26	BLV	ETF	72.62	72.64	71.8	71.8	12600.0
2009-05-26	BMVP	ETF	10.41	10.81	10.41	10.79	23060.0
2009-05-26	BND	ETF	77.47	77.47	77.19	77.19	298900.0
2009-05-26	BNE	ETF	5.11	6.0	5.08	5.77	278622.0
2009-05-26	BOSS	ETF	15.55	15.81	15.55	15.55	200.0
2009-05-26	BRF	ETF	25.66	26.77	25.48	26.77	29337.0
2009-05-26	BSV	ETF	79.11	79.16	78.95	79.06	162400.0
2009-05-26	BTF	ETF	46.25	48.099999999999994	46.25	48.05	10473.6
2009-05-26	BWX	ETF	26.915	27.045	26.905	27.045	503644.0
2009-05-26	BWZ	ETF	35.0	35.1	34.96	35.0	10604.0
2009-05-26	CBON	ETF	1.3	1.3	1.2	1.28	26147.0
2009-05-26	CEF	ETF	12.21	12.29	12.06	12.15	869600.0
2009-05-26	CEW	ETF	20.48	20.63	20.43	20.61	68667.0
2009-05-26	CGO	ETF	10.72	11.06	10.639	11.01	53713.0
2009-05-26	CGW	ETF	14.53	15.19	14.51	15.05	63023.0
2009-05-26	CHB	ETF	0.46	0.47	0.43	0.44	602268.0
2009-05-26	CHI	ETF	10.44	10.49	10.29	10.45	231666.0
2009-05-26	CHIC	ETF	10.0	11.01	10.0	10.71	243042.0
2009-05-26	CHW	ETF	6.68	6.98	6.65	6.93	226022.0

> showing 50 of 653 rows — these rows as CSV

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