PREVIEW / etf_daily / 2011-01-19

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-19.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
2011-01-19	SPY	ETF	129.41	129.54	127.91	128.25	151958400.0
2011-01-19	QQQ	ETF	57.24	57.26	56.32	56.51	67767181.0
2011-01-19	IWM	ETF	80.57	80.7	78.36	78.53	70707400.0
2011-01-19	DIA	ETF	118.35	118.49	117.86	118.16	9080300.0
2011-01-19	GLD	ETF	134.34	134.4	133.4	133.72	11788100.0
2011-01-19	TLT	ETF	91.41	92.07	91.36	92.07	8886900.0
2011-01-19	AADR	ETF	30.0	30.0	29.95	29.95	900.0
2011-01-19	AAXJ	ETF	64.24	64.3	63.64	63.81	509300.0
2011-01-19	ACWI	ETF	48.0	48.02	47.39	47.55	850500.0
2011-01-19	ACWX	ETF	45.05	45.1125	44.53	44.67	74954.0
2011-01-19	ADRE	ETF	48.45	48.56	47.81	47.95	34169.0
2011-01-19	AFK	ETF	35.58	35.6	35.09	35.2	72473.0
2011-01-19	AGG	ETF	105.56	105.76	105.53	105.68	912100.0
2011-01-19	AGQ	ETF	285.72	286.14	270.7	272.26	424050.0
2011-01-19	AGZ	ETF	109.77	109.87	109.66	109.81	16241.0
2011-01-19	AIA	ETF	48.83	48.9	48.41	48.51	44412.0
2011-01-19	AIQ	ETF	20.5	20.7	19.975	20.1	43341.0
2011-01-19	AIS	ETF	1.69	1.69	1.6	1.61	638385.0
2011-01-19	AIVI	ETF	45.43	45.43	44.77	44.92	38700.0
2011-01-19	AMJ	ETF	37.22	37.3	36.57	36.6	828862.0
2011-01-19	AMLP	ETF	81.2	81.25	80.4	80.5	99060.0
2011-01-19	AOA	ETF	35.25	35.25	34.77	34.8	19400.0
2011-01-19	AOK	ETF	28.98	29.02	28.89	28.94	16211.0
2011-01-19	AOM	ETF	30.28	30.28	30.09	30.1	25668.0
2011-01-19	AOR	ETF	32.07	32.07	31.79	31.83	23173.0
2011-01-19	ARB	ETF	42.24	42.38	40.7319	40.94	187601.0
2011-01-19	BAB	ETF	24.92	25.12	24.92	25.12	122968.0
2011-01-19	BAL	ETF	76.52	76.895	75.7	76.19	31820.0
2011-01-19	BALT	ETF	10.27	10.28	10.15	10.18	184702.0
2011-01-19	BBH	ETF	34.4233	34.5033	34.0933	34.2	58800.0
2011-01-19	BIB	ETF	7.995	7.995	7.7225	7.7225	3384.0
2011-01-19	BICK	ETF	32.74	32.9535	32.735	32.83	23237.0
2011-01-19	BIL	ETF	91.72	91.72	91.7	91.72	150850.0
2011-01-19	BIS	ETF	7668.8	7670.4	7668.8	7670.4	1.25
2011-01-19	BITS	ETF	29.0	29.28	28.76	28.8	12240.0
2011-01-19	BIV	ETF	82.64	82.97	82.64	82.86	205300.0
2011-01-19	BJK	ETF	33.33	33.53	32.88	32.94	39800.0
2011-01-19	BKF	ETF	50.16	50.16	49.26	49.39	149879.0
2011-01-19	BLV	ETF	77.98	78.4	77.98	78.3	25600.0
2011-01-19	BMVP	ETF	14.87	14.87	14.77	14.79	27072.0
2011-01-19	BND	ETF	80.26	80.37	80.2	80.34	722200.0
2011-01-19	BNO	ETF	32.78	32.785	32.545	32.735	14400.0
2011-01-19	BRF	ETF	58.27	58.31	57.414	57.65	235403.0
2011-01-19	BSCE	ETF	20.84	20.85	20.78	20.84	11586.0
2011-01-19	BSV	ETF	80.52	80.66	80.52	80.63	578400.0
2011-01-19	BTF	ETF	78.94999999999999	79.0	78.25	78.39999999999999	6632.200000000001
2011-01-19	BWX	ETF	29.165	29.25	29.08	29.15	359488.0
2011-01-19	BWZ	ETF	37.15	37.2599	37.07	37.16	18276.0
2011-01-19	BZQ	ETF	2388.8	2444.8	2388.8	2428.8	289.0
2011-01-19	CEF	ETF	19.36	19.41	19.01	19.05	1165400.0

> showing 50 of 819 rows — these rows as CSV

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