PREVIEW / etf_daily / 2010-05-13

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-13.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-05-13	SPY	ETF	117.13	117.68	115.89	115.99	234452500.0
2010-05-13	QQQ	ETF	48.43	48.79	47.7301	47.85	102844243.0
2010-05-13	IWM	ETF	71.46	72.1	70.59	70.93	78553600.0
2010-05-13	DIA	ETF	108.95	109.46	107.97	108.1	11160700.0
2010-05-13	GLD	ETF	121.29	121.71	120.1	120.56	22340400.0
2010-05-13	TLT	ETF	93.26	93.55	92.2	93.26	6849700.0
2010-05-13	AAXJ	ETF	55.69	55.69	54.89	55.02	77100.0
2010-05-13	ACWI	ETF	42.3	42.31	41.8	41.9	771700.0
2010-05-13	ACWX	ETF	39.21	39.355	38.85	38.85	71696.0
2010-05-13	ADRE	ETF	42.3	42.58	42.0	42.04	103680.0
2010-05-13	AFK	ETF	31.17	31.41	30.9201	30.93	7274.0
2010-05-13	AGG	ETF	104.88	104.92	104.66	104.83	352700.0
2010-05-13	AGQ	ETF	142.4	145.42	138.32	139.08	286500.0
2010-05-13	AGZ	ETF	108.73	108.74	108.5101	108.6	13025.0
2010-05-13	AIA	ETF	39.37	39.559	39.03	39.05	42654.0
2010-05-13	AIQ	ETF	28.05	28.3	26.95	27.25	16840.0
2010-05-13	AIS	ETF	1.7	1.7	1.66	1.67	602906.0
2010-05-13	AIVI	ETF	39.86	40.14	39.6	39.68	8000.0
2010-05-13	AMJ	ETF	30.92	31.0	30.48	30.48	688125.0
2010-05-13	AOA	ETF	31.32	31.94	31.04	31.04	23100.0
2010-05-13	AOK	ETF	28.01	28.0299	27.937	27.98	16417.0
2010-05-13	AOM	ETF	28.71	28.74	28.6	28.64	100769.0
2010-05-13	AOR	ETF	29.67	29.79	29.55	29.59	115647.0
2010-05-13	ARB	ETF	32.71	33.52	32.55	32.82	127360.0
2010-05-13	BAB	ETF	26.0	26.02	25.77	25.97	164044.0
2010-05-13	BAL	ETF	38.5599	38.5599	38.15	38.15	1837.0
2010-05-13	BALT	ETF	13.34	13.57	13.1601	13.45	175200.0
2010-05-13	BBH	ETF	31.9733	31.9733	31.6033	31.6133	144300.0
2010-05-13	BICK	ETF	29.02	29.16	28.61	28.61	41186.0
2010-05-13	BIL	ETF	91.72	91.72	91.7	91.7	1255850.0
2010-05-13	BITS	ETF	31.1596	31.16	30.52	30.88	1875.0
2010-05-13	BIV	ETF	81.12	81.42	80.97	81.25	94400.0
2010-05-13	BJK	ETF	25.69	25.91	25.51	25.58	17200.0
2010-05-13	BKF	ETF	43.91	44.02	43.3	43.42	146116.0
2010-05-13	BLV	ETF	78.44	78.8	78.11	78.56	26900.0
2010-05-13	BMVP	ETF	13.32	13.38	13.2	13.22	124669.0
2010-05-13	BND	ETF	79.95	79.95	79.71	79.85	413300.0
2010-05-13	BNE	ETF	11.07	11.15	11.06	11.11	1374993.0
2010-05-13	BOSS	ETF	26.985	26.985	26.485	26.485	300.0
2010-05-13	BRF	ETF	44.35	44.654	44.06	44.06	128326.0
2010-05-13	BSV	ETF	80.27	80.3	80.15	80.3	499500.0
2010-05-13	BTF	ETF	70.44999999999999	70.704	68.875	69.74999999999999	4877.2
2010-05-13	BWX	ETF	26.78	26.885	26.61	26.645	534498.0
2010-05-13	BWZ	ETF	34.1	34.28	34.05	34.07	15608.0
2010-05-13	BZQ	ETF	3915.2	3988.8	3865.6	3985.6	655.0
2010-05-13	CEF	ETF	15.16	15.22	14.95	15.11	3363100.0
2010-05-13	CEW	ETF	22.01	22.04	21.94	21.99	65634.0
2010-05-13	CGO	ETF	13.94	14.09	13.8104	13.94	28298.0
2010-05-13	CGW	ETF	17.88	17.88	17.65	17.65	50839.0
2010-05-13	CHI	ETF	12.55	12.62	12.4	12.49	203413.0

> showing 50 of 756 rows — these rows as CSV

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