PREVIEW / etf_daily / 2010-09-13

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-13.parquet
  size:    34 KB
  rows:    778

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-09-13	SPY	ETF	112.58	112.95	112.13	112.72	178503500.0
2010-09-13	QQQ	ETF	46.95	47.37	46.94	47.25	64523292.0
2010-09-13	IWM	ETF	64.45	65.48	64.32	65.27	60551500.0
2010-09-13	DIA	ETF	105.65	105.86	105.06	105.67	4944900.0
2010-09-13	GLD	ETF	121.63	122.11	121.39	121.62	9693300.0
2010-09-13	TLT	ETF	101.8	103.05	101.77	102.82	7054800.0
2010-09-13	AADR	ETF	26.86	27.07	26.86	27.07	300.0
2010-09-13	AAXJ	ETF	58.0	58.39	58.0	58.34	643200.0
2010-09-13	ACWI	ETF	42.09	42.27	42.02	42.26	256100.0
2010-09-13	ACWX	ETF	40.29	40.38	40.2	40.38	108462.0
2010-09-13	ADRE	ETF	43.17	43.68	43.17	43.68	119796.0
2010-09-13	AFK	ETF	30.89	31.1	30.77	30.95	96291.0
2010-09-13	AGG	ETF	107.52	107.83	107.47	107.74	1044100.0
2010-09-13	AGQ	ETF	141.2	144.6	139.84	140.96	246650.0
2010-09-13	AGZ	ETF	110.7	110.83	110.67	110.82	11001.0
2010-09-13	AIA	ETF	40.95	41.16	40.95	41.11	13876.0
2010-09-13	AIQ	ETF	22.2	22.45	21.75	22.3	26351.0
2010-09-13	AIS	ETF	1.54	1.575	1.53	1.55	305509.0
2010-09-13	AIVI	ETF	41.92	41.97	41.81	41.88	8900.0
2010-09-13	AMJ	ETF	33.0	33.09	32.9	32.93	534665.0
2010-09-13	AMLP	ETF	76.05	76.25	76.0	76.25	114340.0
2010-09-13	AOA	ETF	30.7	30.9	30.7	30.9	9900.0
2010-09-13	AOK	ETF	28.05	28.18	28.05	28.18	21459.0
2010-09-13	AOM	ETF	28.73	28.84	28.73	28.834	8478.0
2010-09-13	AOR	ETF	29.57	29.58	29.5556	29.5556	2420.0
2010-09-13	ARB	ETF	26.55	27.14	26.35	26.66	143031.0
2010-09-13	BAB	ETF	26.37	26.52	26.35	26.43	194064.0
2010-09-13	BAL	ETF	45.435	45.5	45.3413	45.5	4033.0
2010-09-13	BALT	ETF	11.21	11.32	10.97	11.24	167471.0
2010-09-13	BBH	ETF	31.7433	31.8067	31.5967	31.7	33000.0
2010-09-13	BIB	ETF	6.2462	6.2462	6.1162	6.1762	47208.0
2010-09-13	BICK	ETF	30.39	30.51	30.35	30.48	30304.0
2010-09-13	BIL	ETF	91.7	91.72	91.7	91.7	364500.0
2010-09-13	BIS	ETF	10168.0	10168.0	10168.0	10168.0	0.75
2010-09-13	BITS	ETF	25.0	25.88	24.24	25.88	9145.0
2010-09-13	BIV	ETF	84.87	85.31	84.87	85.26	260800.0
2010-09-13	BJK	ETF	27.17	27.4	27.17	27.32	4600.0
2010-09-13	BKF	ETF	45.91	46.37	45.73	46.32	107748.0
2010-09-13	BLV	ETF	83.74	84.4	83.66	84.26	59700.0
2010-09-13	BMVP	ETF	12.73	12.82	12.73	12.81	9567.0
2010-09-13	BND	ETF	81.78	82.07	81.76	82.01	732400.0
2010-09-13	BNE	ETF	11.09	11.1	11.0699	11.08	459729.0
2010-09-13	BNO	ETF	26.555	26.555	26.555	26.555	2000.0
2010-09-13	BRF	ETF	54.83	55.16	54.74	54.91	599081.0
2010-09-13	BSCE	ETF	20.76	20.77	20.759	20.77	11800.0
2010-09-13	BSV	ETF	81.25	81.4	81.24	81.37	544600.0
2010-09-13	BTF	ETF	73.89999999999999	74.86999999999999	73.8	74.05	11027.400000000001
2010-09-13	BWX	ETF	28.625	28.935	28.585	28.935	333004.0
2010-09-13	BWZ	ETF	35.63	35.841	35.58	35.63	38460.0
2010-09-13	BZQ	ETF	3142.4	3142.4	3048.0	3052.8	982.5

> showing 50 of 778 rows — these rows as CSV

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