PREVIEW / etf_daily / 2010-11-29

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-29.parquet
  size:    34 KB
  rows:    807

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-11-29	SPY	ETF	118.5	119.48	117.74	119.16	223642300.0
2010-11-29	QQQ	ETF	52.7	52.9	52.1	52.73	89265939.0
2010-11-29	IWM	ETF	72.95	73.51	72.03	73.33	47897000.0
2010-11-29	DIA	ETF	110.26	110.86	109.4	110.65	6040400.0
2010-11-29	GLD	ETF	133.19	133.75	132.33	133.51	13983800.0
2010-11-29	TLT	ETF	97.56	97.95	97.09	97.9	8950000.0
2010-11-29	AADR	ETF	28.59	28.59	28.38	28.38	1000.0
2010-11-29	AAXJ	ETF	61.15	61.36	60.7	61.31	554500.0
2010-11-29	ACWI	ETF	44.19	44.35	43.73	44.2	337300.0
2010-11-29	ACWX	ETF	41.59	41.75	41.16	41.64	76316.0
2010-11-29	ADRE	ETF	45.24	45.48	44.72	45.39	36294.0
2010-11-29	AFK	ETF	32.88	32.91	32.41	32.86	36483.0
2010-11-29	AGG	ETF	107.59	107.59	107.35	107.44	658900.0
2010-11-29	AGQ	ETF	244.94	251.98	238.32	250.0	529900.0
2010-11-29	AGZ	ETF	110.86	110.89	110.715	110.87	6359.0
2010-11-29	AIA	ETF	44.03	44.18	43.7201	44.07	15259.0
2010-11-29	AIQ	ETF	19.25	19.35	18.75	19.1	60911.0
2010-11-29	AIS	ETF	1.39	1.4	1.37	1.4	217265.0
2010-11-29	AIVI	ETF	42.02	42.17	41.45	42.03	19000.0
2010-11-29	AMJ	ETF	35.89	35.89	35.51	35.75	573568.0
2010-11-29	AMLP	ETF	79.65	79.65	79.0	79.3	120240.0
2010-11-29	AOA	ETF	32.55	32.7	32.39	32.7	8900.0
2010-11-29	AOK	ETF	28.54	28.57	28.4701	28.5636	15491.0
2010-11-29	AOM	ETF	29.39	29.45	29.328	29.447	7654.0
2010-11-29	AOR	ETF	30.6	30.63	30.44	30.63	5115.0
2010-11-29	ARB	ETF	29.41	29.71	28.67	29.41	268745.0
2010-11-29	BAB	ETF	25.55	25.55	25.4	25.47	184346.0
2010-11-29	BAL	ETF	57.72	59.0	57.62	58.8	59891.0
2010-11-29	BALT	ETF	12.13	12.27	11.73	12.22	171204.0
2010-11-29	BBH	ETF	32.6233	32.7333	32.2267	32.6133	39000.0
2010-11-29	BICK	ETF	31.34	31.66	31.33	31.66	6390.0
2010-11-29	BIL	ETF	91.7	91.72	91.7	91.72	250500.0
2010-11-29	BIS	ETF	9233.6	9233.6	9166.4	9166.4	4.375
2010-11-29	BITS	ETF	28.04	28.36	27.96	28.36	250.0
2010-11-29	BIV	ETF	85.71	85.71	85.42	85.58	164500.0
2010-11-29	BJK	ETF	30.64	30.88	30.49	30.88	9600.0
2010-11-29	BKF	ETF	47.68	47.99	47.13	47.97	162836.0
2010-11-29	BLV	ETF	81.65	81.79	81.25	81.59	33300.0
2010-11-29	BMVP	ETF	14.133	14.177	14.007	14.171	10777.0
2010-11-29	BND	ETF	81.96	81.96	81.77	81.88	373100.0
2010-11-29	BNO	ETF	28.75	28.75	28.75	28.75	400.0
2010-11-29	BRF	ETF	58.81	58.9199	57.64	58.87	626621.0
2010-11-29	BSCE	ETF	20.87	20.88	20.852	20.87	2227.0
2010-11-29	BSV	ETF	81.37	81.44	81.32	81.44	632400.0
2010-11-29	BTF	ETF	77.6	77.94999999999999	76.85	77.8005	4479.400000000001
2010-11-29	BWX	ETF	28.785	28.79	28.43	28.445	496550.0
2010-11-29	BWZ	ETF	36.12	36.24	35.86	36.16	70537.0
2010-11-29	BZQ	ETF	2828.8	2913.6	2761.6	2763.2	884.5
2010-11-29	CEF	ETF	18.87	18.95	18.61	18.89	776300.0
2010-11-29	CEW	ETF	22.58	22.6598	22.53	22.65	127236.0

> showing 50 of 807 rows — these rows as CSV

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