PREVIEW / etf_daily / 2009-05-04

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-04.parquet
  size:    29 KB
  rows:    655

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-04	SPY	ETF	88.55	90.94	88.38	90.88	287120000.0
2009-05-04	QQQ	ETF	34.67	35.09	34.52	35.05	119317320.0
2009-05-04	IWM	ETF	49.28	50.7	49.07	50.6	47528900.0
2009-05-04	DIA	ETF	82.74	84.3	82.6	84.24	13866800.0
2009-05-04	GLD	ETF	87.55	89.18	87.55	88.64	10813100.0
2009-05-04	TLT	ETF	97.36	97.82	96.79	97.43	2246700.0
2009-05-04	AAXJ	ETF	40.62	42.44	40.62	42.43	237800.0
2009-05-04	ACWI	ETF	32.51	33.64	32.51	33.61	182200.0
2009-05-04	ACWX	ETF	31.25	32.08	31.0	32.08	99128.0
2009-05-04	ADRE	ETF	32.14	33.9	32.14	33.8899	295739.0
2009-05-04	AFK	ETF	24.47	24.47	22.52	23.0	4849.0
2009-05-04	AGG	ETF	101.31	101.41	100.78	101.0	690600.0
2009-05-04	AGQ	ETF	72.2	78.52	72.2	76.9	137050.0
2009-05-04	AGZ	ETF	107.822	107.99	107.55	107.99	1979.0
2009-05-04	AIA	ETF	30.86	32.05	30.86	31.94	56973.0
2009-05-04	AIQ	ETF	40.35	41.1	39.0	39.95	50018.0
2009-05-04	AIS	ETF	0.42	0.4401	0.4057	0.4204	84040.0
2009-05-04	AIVI	ETF	32.97	33.83	32.65	33.83	29700.0
2009-05-04	AMJ	ETF	21.82	21.9	21.74	21.85	32185.0
2009-05-04	AOA	ETF	24.15	24.86	24.15	24.86	2000.0
2009-05-04	AOK	ETF	25.43	25.49	25.43	25.4568	1377.0
2009-05-04	AOM	ETF	25.0	25.35	25.0	25.35	4620.0
2009-05-04	AOR	ETF	24.9	25.13	24.7	25.13	7006.0
2009-05-04	ARB	ETF	20.71	21.03	20.25	20.9	317547.0
2009-05-04	BAL	ETF	32.23	32.3199	32.23	32.25	2450.0
2009-05-04	BBH	ETF	29.1667	29.9233	29.0867	29.2967	471600.0
2009-05-04	BIL	ETF	91.72	91.76	91.66	91.66	151350.0
2009-05-04	BITS	ETF	17.76	17.78	17.64	17.76	4910.0
2009-05-04	BIV	ETF	76.5	76.57	76.06	76.41	56800.0
2009-05-04	BJK	ETF	21.86	21.86	20.0	21.35	222900.0
2009-05-04	BKF	ETF	30.79	32.15	30.3	32.15	93135.0
2009-05-04	BLV	ETF	71.75	72.16	71.34	71.7	21100.0
2009-05-04	BMVP	ETF	10.57	10.74	10.57	10.73	23908.0
2009-05-04	BND	ETF	76.83	77.03	76.8	76.89	449600.0
2009-05-04	BNE	ETF	5.48	6.03	5.38	5.98	198635.0
2009-05-04	BOSS	ETF	14.63	15.51	14.63	15.51	100.0
2009-05-04	BSV	ETF	78.71	78.9	78.67	78.9	156100.0
2009-05-04	BTF	ETF	47.199999999999996	48.349999999999994	46.849999999999994	48.349999999999994	18106.2
2009-05-04	BWX	ETF	25.93	26.115	25.835	26.11	210230.0
2009-05-04	BWZ	ETF	33.64	33.66	33.62	33.66	471.0
2009-05-04	CBON	ETF	2.22	2.24	2.19	2.21	6668.0
2009-05-04	CEF	ETF	11.3	11.55	11.24	11.52	665500.0
2009-05-04	CGO	ETF	9.96	10.25	9.912	10.18	47213.0
2009-05-04	CGW	ETF	14.15	14.47	14.07	14.47	33411.0
2009-05-04	CHB	ETF	0.6	0.61	0.55	0.58	671904.0
2009-05-04	CHI	ETF	9.48	9.8	9.48	9.76	184000.0
2009-05-04	CHIC	ETF	12.64	12.78	12.28	12.74	343762.0
2009-05-04	CHW	ETF	6.63	6.67	6.54	6.667	177879.0
2009-05-04	CHY	ETF	9.24	9.48	9.24	9.48	307445.0
2009-05-04	CMF	ETF	52.885	52.885	52.4	52.45	6462.0

> showing 50 of 655 rows — these rows as CSV

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