PREVIEW / etf_daily / 2009-05-29

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-29.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-05-29	SPY	ETF	91.42	93.7	90.68	92.53	258641500.0
2009-05-29	QQQ	ETF	34.98	35.5	34.76	35.38	111535656.0
2009-05-29	IWM	ETF	49.39	50.27	49.08	50.17	51665800.0
2009-05-29	DIA	ETF	84.39	85.76	83.76	85.39	15275000.0
2009-05-29	GLD	ETF	95.7	96.35	95.58	96.2	18137800.0
2009-05-29	TLT	ETF	91.7	94.23	91.64	94.17	4746700.0
2009-05-29	AAXJ	ETF	44.88	45.05	44.29	45.05	404000.0
2009-05-29	ACWI	ETF	35.09	35.3	34.79	35.3	89900.0
2009-05-29	ACWX	ETF	34.35	34.49	34.09	34.49	50272.0
2009-05-29	ADRE	ETF	36.37	36.37	35.63	36.0	122820.0
2009-05-29	AFK	ETF	27.93	27.95	27.6399	27.9068	11156.0
2009-05-29	AGG	ETF	100.8	102.15	100.8	102.03	1142100.0
2009-05-29	AGQ	ETF	107.06	110.26	105.92	110.2	184050.0
2009-05-29	AGZ	ETF	106.72	107.73	106.72	107.73	4733.0
2009-05-29	AIA	ETF	33.08	33.27	32.7364	33.27	26958.0
2009-05-29	AIQ	ETF	34.25	35.0	33.65	34.5	44896.0
2009-05-29	AIS	ETF	0.56	0.58	0.54	0.575	49840.0
2009-05-29	AIVI	ETF	36.14	36.25	35.9	36.15	10200.0
2009-05-29	AMJ	ETF	22.34	22.66	22.33	22.66	96611.0
2009-05-29	AOA	ETF	25.1	25.35	25.1	25.35	6300.0
2009-05-29	AOK	ETF	25.75	25.78	25.75	25.78	2620.0
2009-05-29	AOM	ETF	25.89	25.89	25.62	25.69	19426.0
2009-05-29	AOR	ETF	25.05	25.69	25.05	25.69	9620.0
2009-05-29	ARB	ETF	20.04	20.04	19.31	19.91	230945.0
2009-05-29	BAL	ETF	32.96	32.96	31.62	32.06	21900.0
2009-05-29	BBH	ETF	29.5933	30.0467	29.4433	30.0467	413700.0
2009-05-29	BIL	ETF	91.74	91.76	91.74	91.76	105750.0
2009-05-29	BITS	ETF	19.0	19.6	18.32	18.56	4345.0
2009-05-29	BIV	ETF	75.98	76.7	75.98	76.6	98600.0
2009-05-29	BJK	ETF	21.54	21.94	21.48	21.7	7200.0
2009-05-29	BKF	ETF	37.19	37.19	35.9	36.68	276795.0
2009-05-29	BLV	ETF	71.76	72.86	71.6	72.7	44600.0
2009-05-29	BMVP	ETF	10.79	10.88	10.71	10.88	26128.0
2009-05-29	BND	ETF	76.89	77.56	76.85	77.48	360300.0
2009-05-29	BNE	ETF	5.67	5.86	5.3	5.37	243959.0
2009-05-29	BOSS	ETF	15.3	15.64	15.3	15.64	100.0
2009-05-29	BRF	ETF	28.18	28.18	27.482	27.866	117051.0
2009-05-29	BSV	ETF	79.19	79.29	79.0	79.27	228400.0
2009-05-29	BTF	ETF	47.300000000000004	47.699999999999996	47.0	47.699999999999996	7770.400000000001
2009-05-29	BWX	ETF	27.105	27.195	27.046	27.1899	283036.0
2009-05-29	BWZ	ETF	35.23	35.23	35.12	35.12	16398.0
2009-05-29	CBON	ETF	1.2	1.23	1.13	1.15	35785.0
2009-05-29	CEF	ETF	12.84	12.84	12.32	12.65	1346900.0
2009-05-29	CEW	ETF	20.83	20.83	20.68	20.8	54605.0
2009-05-29	CGO	ETF	11.2	11.2	10.9	11.13	23725.0
2009-05-29	CGW	ETF	15.12	15.17	14.94	15.17	35162.0
2009-05-29	CHB	ETF	0.41	0.44	0.32	0.44	2247143.0
2009-05-29	CHI	ETF	10.47	10.5899	10.36	10.5332	335390.0
2009-05-29	CHIC	ETF	9.91	10.23	9.76	10.15	185229.0
2009-05-29	CHW	ETF	7.18	7.32	6.9	7.25	278917.0

> showing 50 of 654 rows — these rows as CSV

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