PREVIEW / etf_daily / 2010-05-18

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-18.parquet
  size:    33 KB
  rows:    757

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
2010-05-18	SPY	ETF	114.88	115.22	112.03	112.4	360556800.0
2010-05-18	QQQ	ETF	47.47	47.58	46.22	46.43	153072092.0
2010-05-18	IWM	ETF	70.6	70.8	68.13	68.35	87146900.0
2010-05-18	DIA	ETF	107.29	107.51	105.14	105.39	19213400.0
2010-05-18	GLD	ETF	118.86	120.32	118.5	119.49	26595300.0
2010-05-18	TLT	ETF	94.9	96.17	94.77	95.98	9904100.0
2010-05-18	AAXJ	ETF	54.06	54.16	52.67	52.8	184200.0
2010-05-18	ACWI	ETF	41.22	41.36	40.1	40.25	340600.0
2010-05-18	ACWX	ETF	38.23	38.23	36.85	37.08	105348.0
2010-05-18	ADRE	ETF	40.99	41.3	39.77	39.92	537076.0
2010-05-18	AFK	ETF	30.02	30.216	29.38	29.38	9760.0
2010-05-18	AGG	ETF	105.28	105.54	105.16	105.49	572400.0
2010-05-18	AGQ	ETF	131.92	135.22	130.66	132.7	213700.0
2010-05-18	AGZ	ETF	108.74	109.11	108.74	109.0275	11891.0
2010-05-18	AIA	ETF	38.71	38.77	37.76	37.8201	22466.0
2010-05-18	AIQ	ETF	29.0	29.25	28.375	28.8	29419.0
2010-05-18	AIS	ETF	1.69	1.7	1.6	1.65	497050.0
2010-05-18	AIVI	ETF	38.96	39.11	37.56	37.67	27000.0
2010-05-18	AMJ	ETF	29.92	30.279	29.56	29.65	486311.0
2010-05-18	AOA	ETF	30.73	30.73	29.85	29.85	24200.0
2010-05-18	AOK	ETF	27.8013	27.8013	27.64	27.647	9326.0
2010-05-18	AOM	ETF	28.4	28.4	28.174	28.174	8114.0
2010-05-18	AOR	ETF	29.34	29.34	28.9	28.94	4725.0
2010-05-18	ARB	ETF	33.0	33.04	32.59	32.83	207907.0
2010-05-18	BAB	ETF	25.97	26.16	25.9	26.12	238625.0
2010-05-18	BAL	ETF	38.68	38.95	38.68	38.85	1260.0
2010-05-18	BALT	ETF	12.85	13.0	12.81	12.9	171876.0
2010-05-18	BBH	ETF	30.9733	31.26	30.8367	30.86	180600.0
2010-05-18	BIB	ETF	6.5156	6.5156	6.26	6.26	13600.0
2010-05-18	BICK	ETF	28.02	28.1068	27.24	27.24	6682.0
2010-05-18	BIL	ETF	91.72	91.72	91.7	91.7	187700.0
2010-05-18	BIS	ETF	10784.0	11150.4	10716.8	11126.4	34.9
2010-05-18	BITS	ETF	30.04	30.72	30.0	30.72	238.0
2010-05-18	BIV	ETF	81.6	81.96	81.5	81.92	141000.0
2010-05-18	BJK	ETF	25.04	25.1	24.29	24.37	10700.0
2010-05-18	BKF	ETF	42.55	42.73	40.99	41.15	156467.0
2010-05-18	BLV	ETF	79.21	80.17	79.21	80.05	38100.0
2010-05-18	BMVP	ETF	13.0967	13.1533	12.7967	12.7974	24957.0
2010-05-18	BND	ETF	80.23	80.48	80.05	80.43	753200.0
2010-05-18	BNE	ETF	11.15	11.15	11.05	11.05	433310.0
2010-05-18	BOSS	ETF	25.525	25.55	25.525	25.55	500.0
2010-05-18	BRF	ETF	42.92	42.9299	40.63	40.79	259116.0
2010-05-18	BSV	ETF	80.42	80.55	80.37	80.55	689900.0
2010-05-18	BTF	ETF	68.89999999999999	69.4	67.39999999999999	67.39999999999999	11684.2
2010-05-18	BWX	ETF	26.695	27.0	26.16	26.19	414688.0
2010-05-18	BWZ	ETF	33.03	33.73	33.03	33.351	15031.0
2010-05-18	BZQ	ETF	4123.2	4584.0	4112.0	4561.6	1689.0
2010-05-18	CEF	ETF	14.88	15.15	14.85	15.14	3890400.0
2010-05-18	CEW	ETF	21.78	21.79	21.44	21.44	77720.0
2010-05-18	CGO	ETF	13.67	13.94	13.46	13.46	30090.0

> showing 50 of 757 rows — these rows as CSV

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