PREVIEW / etf_daily / 2010-12-16

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-16.parquet
  size:    35 KB
  rows:    819

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-12-16	SPY	ETF	124.18	124.91	123.75	124.82	185035200.0
2010-12-16	QQQ	ETF	54.21	54.66	54.06	54.58	65519385.0
2010-12-16	IWM	ETF	77.18	77.97	76.86	77.78	57936100.0
2010-12-16	DIA	ETF	114.99	115.39	114.42	115.24	8109500.0
2010-12-16	GLD	ETF	134.21	134.23	132.86	133.81	23463000.0
2010-12-16	TLT	ETF	91.03	91.58	90.57	91.57	17939000.0
2010-12-16	AADR	ETF	29.45	29.55	29.32	29.55	1600.0
2010-12-16	AAXJ	ETF	62.32	62.66	62.15	62.6	1611200.0
2010-12-16	ACWI	ETF	45.97	46.36	45.97	46.32	350200.0
2010-12-16	ACWX	ETF	43.51	43.68	43.33	43.67	85787.0
2010-12-16	ADRE	ETF	46.29	46.51	46.19	46.45	36936.0
2010-12-16	AFK	ETF	34.41	34.43	34.2	34.37	18884.0
2010-12-16	AGG	ETF	104.5	104.84	104.3	104.8	1647800.0
2010-12-16	AGQ	ETF	279.26	280.0	268.02	279.44	592500.0
2010-12-16	AGZ	ETF	109.25	109.29	108.97	109.29	22344.0
2010-12-16	AIA	ETF	45.58	45.8	45.44	45.8	53128.0
2010-12-16	AIQ	ETF	18.05	18.85	17.4	18.8	72023.0
2010-12-16	AIS	ETF	1.49	1.49	1.4	1.46	982312.0
2010-12-16	AIVI	ETF	43.66	43.76	43.42	43.71	22000.0
2010-12-16	AMJ	ETF	35.37	35.38	34.93	35.12	1225954.0
2010-12-16	AMLP	ETF	79.2	79.2	78.4	78.65	153760.0
2010-12-16	AOA	ETF	33.84	34.07	33.8	34.03	21200.0
2010-12-16	AOK	ETF	28.54	28.58	28.47	28.5434	10158.0
2010-12-16	AOM	ETF	29.7	29.78	29.64	29.78	18690.0
2010-12-16	AOR	ETF	31.19	31.31	31.19	31.31	6289.0
2010-12-16	ARB	ETF	40.52	40.675	39.78	40.1	320917.0
2010-12-16	BAB	ETF	24.7	25.0	24.62	24.98	581645.0
2010-12-16	BAL	ETF	74.24	74.74	73.281	74.74	53657.0
2010-12-16	BALT	ETF	11.0	11.07	10.93	10.96	98371.0
2010-12-16	BBH	ETF	33.45	33.9633	33.45	33.9433	88200.0
2010-12-16	BIB	ETF	7.5375	7.5375	7.0963	7.3937	4080.0
2010-12-16	BICK	ETF	31.86	31.864	31.705	31.8599	8008.0
2010-12-16	BIL	ETF	91.7	91.72	91.7	91.7	564600.0
2010-12-16	BIS	ETF	8243.2	8243.2	8243.2	8243.2	0.625
2010-12-16	BITS	ETF	29.0	29.12	28.12	29.08	3603.0
2010-12-16	BIV	ETF	82.0	82.31	81.7	82.23	241300.0
2010-12-16	BJK	ETF	30.96	31.43	30.78	31.4	16400.0
2010-12-16	BKF	ETF	48.04	48.42	48.04	48.41	459341.0
2010-12-16	BLV	ETF	77.26	77.96	77.19	77.96	42900.0
2010-12-16	BMVP	ETF	14.66	14.76	14.65	14.75	12697.0
2010-12-16	BND	ETF	79.72	79.99	79.59	79.95	1117000.0
2010-12-16	BNO	ETF	30.555	30.6	30.55	30.6	4000.0
2010-12-16	BRF	ETF	57.9	58.14	57.491	57.95	349120.0
2010-12-16	BSCE	ETF	20.47	20.54	20.47	20.5088	4742.0
2010-12-16	BSV	ETF	80.55	80.58	80.46	80.57	624600.0
2010-12-16	BTF	ETF	77.5	77.94999999999999	77.5	77.55	2101.0
2010-12-16	BWX	ETF	28.74	28.74	28.4928	28.625	243866.0
2010-12-16	BWZ	ETF	36.12	36.32	36.12	36.15	47042.0
2010-12-16	BZQ	ETF	2723.2	2761.6	2705.6	2744.0	312.5
2010-12-16	CEF	ETF	19.92	19.92	19.61	19.82	913700.0

> showing 50 of 819 rows — these rows as CSV

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