PREVIEW / etf_daily / 2010-04-29

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-29.parquet
  size:    33 KB
  rows:    756

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-04-29	SPY	ETF	120.1	121.11	120.07	120.86	193775000.0
2010-04-29	QQQ	ETF	49.61	50.33	49.61	50.23	84180139.0
2010-04-29	IWM	ETF	72.82	73.84	72.38	73.81	68869600.0
2010-04-29	DIA	ETF	110.94	112.0	110.92	111.69	7472600.0
2010-04-29	GLD	ETF	113.85	114.52	113.84	114.28	10374300.0
2010-04-29	TLT	ETF	90.86	91.22	90.52	91.08	4067200.0
2010-04-29	AAXJ	ETF	57.39	57.69	57.11	57.67	124000.0
2010-04-29	ACWI	ETF	43.8	44.25	43.8	44.14	213100.0
2010-04-29	ACWX	ETF	41.17	41.4799	41.14	41.38	54113.0
2010-04-29	ADRE	ETF	44.03	44.51	44.0001	44.41	100185.0
2010-04-29	AFK	ETF	31.88	31.88	31.69	31.77	7463.0
2010-04-29	AGG	ETF	104.42	104.53	104.33	104.44	662300.0
2010-04-29	AGQ	ETF	122.98	129.26	122.94	128.24	173750.0
2010-04-29	AGZ	ETF	108.29	108.31	108.06	108.22	10818.0
2010-04-29	AIA	ETF	40.86	41.33	40.86	41.33	17149.0
2010-04-29	AIQ	ETF	27.35	27.9	27.2	27.65	29290.0
2010-04-29	AIS	ETF	1.59	1.59	1.54	1.56	341529.0
2010-04-29	AIVI	ETF	41.99	42.33	41.99	42.27	10800.0
2010-04-29	AMJ	ETF	31.32	31.5881	31.14	31.45	260071.0
2010-04-29	AOA	ETF	32.21	32.39	32.18	32.39	8700.0
2010-04-29	AOK	ETF	28.16	28.22	28.12	28.22	6109.0
2010-04-29	AOM	ETF	29.03	29.12	28.9966	29.12	10224.0
2010-04-29	AOR	ETF	30.24	30.36	30.1954	30.3146	5090.0
2010-04-29	ARB	ETF	31.34	32.04	31.03	31.98	209848.0
2010-04-29	BAB	ETF	25.46	25.5	25.37	25.49	98018.0
2010-04-29	BAL	ETF	40.25	40.25	39.2	39.51	9231.0
2010-04-29	BALT	ETF	14.13	14.25	13.84	14.06	475701.0
2010-04-29	BBH	ETF	32.7	33.1433	32.6367	32.8667	140400.0
2010-04-29	BIB	ETF	7.365	7.585	7.365	7.4938	49128.0
2010-04-29	BICK	ETF	29.65	29.94	29.4	29.94	24921.0
2010-04-29	BIL	ETF	91.68	91.7	91.68	91.7	76550.0
2010-04-29	BIS	ETF	10019.2	10019.2	9400.0	9505.6	39.75
2010-04-29	BITS	ETF	30.24	31.8	30.24	31.8	524.0
2010-04-29	BIV	ETF	80.75	80.86	80.63	80.84	117400.0
2010-04-29	BJK	ETF	27.0	27.55	27.0	27.42	24900.0
2010-04-29	BKF	ETF	45.84	46.33	45.73	46.29	483280.0
2010-04-29	BLV	ETF	77.74	78.16	77.7	78.1	16600.0
2010-04-29	BMVP	ETF	13.6567	13.7681	13.6567	13.7533	16052.0
2010-04-29	BND	ETF	79.58	79.66	79.49	79.57	689300.0
2010-04-29	BNE	ETF	11.26	11.26	11.2	11.25	272251.0
2010-04-29	BRF	ETF	46.0	46.67	45.87	46.57	219990.0
2010-04-29	BSV	ETF	80.1	80.14	79.97	80.14	587000.0
2010-04-29	BTF	ETF	74.3	74.85	73.94999999999999	74.53649999999999	4166.2
2010-04-29	BWX	ETF	27.405	27.45	27.3	27.33	245232.0
2010-04-29	BWZ	ETF	34.97	35.49	34.97	35.19	68093.0
2010-04-29	BZQ	ETF	3692.8	3699.2	3564.8	3584.0	1071.0
2010-04-29	CEF	ETF	14.69	14.93	14.64	14.83	2062900.0
2010-04-29	CEW	ETF	22.35	22.4	22.32	22.37	109113.0
2010-04-29	CGO	ETF	14.8	14.99	14.73	14.8801	62225.0
2010-04-29	CGW	ETF	18.52	18.77	18.46	18.73	48299.0

> showing 50 of 756 rows — these rows as CSV

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