PREVIEW / etf_daily / 2011-01-18

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-18.parquet
  size:    35 KB
  rows:    817

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-18	SPY	ETF	129.18	129.64	129.03	129.52	114401300.0
2011-01-18	QQQ	ETF	56.52	57.23	56.49	57.16	65802974.0
2011-01-18	IWM	ETF	80.29	80.63	79.87	80.6	37824100.0
2011-01-18	DIA	ETF	117.76	118.43	117.74	118.23	4665700.0
2011-01-18	GLD	ETF	133.63	134.0	133.17	133.43	11592900.0
2011-01-18	TLT	ETF	91.29	91.71	90.73	91.41	10663600.0
2011-01-18	AADR	ETF	30.21	30.29	30.19	30.2	1800.0
2011-01-18	AAXJ	ETF	64.08	64.18	63.82	63.93	1182700.0
2011-01-18	ACWI	ETF	47.81	47.93	47.7	47.92	637500.0
2011-01-18	ACWX	ETF	44.9	45.039	44.84	44.99	54103.0
2011-01-18	ADRE	ETF	48.27	48.44	48.2	48.26	41300.0
2011-01-18	AFK	ETF	35.39	35.71	35.12	35.57	110732.0
2011-01-18	AGG	ETF	105.69	105.74	105.46	105.66	445200.0
2011-01-18	AGQ	ETF	273.66	279.22	273.2	274.68	315700.0
2011-01-18	AGZ	ETF	109.8	109.8	109.67	109.77	36671.0
2011-01-18	AIA	ETF	48.49	48.49	48.34	48.48	32076.0
2011-01-18	AIQ	ETF	21.55	21.6	20.55	20.55	27759.0
2011-01-18	AIS	ETF	1.68	1.72	1.66	1.69	434616.0
2011-01-18	AIVI	ETF	44.93	45.11	44.93	45.09	25800.0
2011-01-18	AMJ	ETF	37.33	37.36	37.1274	37.25	647842.0
2011-01-18	AMLP	ETF	81.5	81.55	81.1	81.15	114400.0
2011-01-18	AOA	ETF	35.15	35.23	35.04	35.23	21600.0
2011-01-18	AOK	ETF	28.98	29.01	28.94	28.98	13495.0
2011-01-18	AOM	ETF	30.22	30.27	30.15	30.27	21526.0
2011-01-18	AOR	ETF	32.03	32.03	31.935	32.01	29791.0
2011-01-18	ARB	ETF	42.08	42.73	42.07	42.34	133818.0
2011-01-18	BAB	ETF	25.0	25.04	24.85	24.97	252881.0
2011-01-18	BAL	ETF	73.59	74.25	73.57	74.14	32615.0
2011-01-18	BALT	ETF	10.32	10.35	10.17	10.3	147510.0
2011-01-18	BBH	ETF	34.36	34.5933	34.3333	34.5933	42900.0
2011-01-18	BIB	ETF	7.9688	8.075	7.45	8.0675	13848.0
2011-01-18	BICK	ETF	32.59	33.01	32.59	32.9942	29526.0
2011-01-18	BIL	ETF	91.7	91.72	91.7	91.7	426600.0
2011-01-18	BITS	ETF	29.0	29.36	28.92	29.0	6475.0
2011-01-18	BIV	ETF	82.83	82.88	82.51	82.81	126100.0
2011-01-18	BJK	ETF	33.27	33.32	33.08	33.12	22900.0
2011-01-18	BKF	ETF	49.85	50.0	49.7	49.985	337914.0
2011-01-18	BLV	ETF	77.89	78.16	77.51	77.99	29700.0
2011-01-18	BMVP	ETF	14.863	14.918	14.863	14.913	33560.0
2011-01-18	BND	ETF	80.25	80.3	80.1	80.24	766200.0
2011-01-18	BNO	ETF	32.195	32.71	32.195	32.475	31800.0
2011-01-18	BRF	ETF	57.61	58.24	57.61	58.24	282293.0
2011-01-18	BSCE	ETF	20.8	20.82	20.7501	20.82	25886.0
2011-01-18	BSV	ETF	80.57	80.59	80.47	80.53	330400.0
2011-01-18	BTF	ETF	78.15	79.0	78.15	78.8	3115.4
2011-01-18	BWX	ETF	28.95	29.045	28.93	29.02	260422.0
2011-01-18	BWZ	ETF	36.94	37.13	36.846	37.03	88042.0
2011-01-18	BZQ	ETF	2366.4	2388.8	2361.6	2366.4	168.0
2011-01-18	CEF	ETF	19.39	19.54	19.08	19.1	1571900.0
2011-01-18	CEW	ETF	22.51	22.54	22.4601	22.49	87349.0

> showing 50 of 817 rows — these rows as CSV

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