PREVIEW / etf_daily / 2011-05-18

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-18.parquet
  size:    36 KB
  rows:    847

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-05-18	SPY	ETF	133.24	134.5	132.95	134.36	135217900.0
2011-05-18	QQQ	ETF	57.48	58.14	57.41	58.04	42351089.0
2011-05-18	IWM	ETF	82.13	83.32	82.0	83.29	54512200.0
2011-05-18	DIA	ETF	124.89	125.85	124.56	125.71	4534600.0
2011-05-18	GLD	ETF	145.55	146.22	145.14	145.6	10502900.0
2011-05-18	TLT	ETF	96.27	96.39	95.28	95.31	7707600.0
2011-05-18	AAXJ	ETF	62.65	63.43	62.59	63.35	620800.0
2011-05-18	ACWI	ETF	48.63	49.06	48.53	48.98	229000.0
2011-05-18	ACWX	ETF	45.11	45.62	45.05	45.51	46075.0
2011-05-18	ADRE	ETF	45.89	46.09	45.64	45.87	36199.0
2011-05-18	AFK	ETF	32.75	32.98	32.41	32.9299	14136.0
2011-05-18	AGG	ETF	107.1	107.15	106.9	106.97	618600.0
2011-05-18	AGQ	ETF	340.08	354.86	334.82	345.7	1684250.0
2011-05-18	AGZ	ETF	110.35	110.41	110.21	110.22	13550.0
2011-05-18	AIA	ETF	47.69	48.18	47.675	48.174	17403.0
2011-05-18	AIQ	ETF	20.05	20.45	19.9	20.35	22017.0
2011-05-18	AIS	ETF	1.66	1.7	1.65	1.68	418186.0
2011-05-18	AIVI	ETF	47.71	48.17	47.68	48.17	25500.0
2011-05-18	AMJ	ETF	35.5	36.47	35.5	36.41	1098665.0
2011-05-18	AMLP	ETF	77.25	78.5	77.25	78.45	234460.0
2011-05-18	AOA	ETF	36.01	36.36	36.01	36.36	9900.0
2011-05-18	AOK	ETF	29.38	29.472	29.38	29.469	3732.0
2011-05-18	AOM	ETF	30.78	30.9	30.78	30.89	6906.0
2011-05-18	AOR	ETF	32.8	32.9852	32.76	32.94	12151.0
2011-05-18	ARB	ETF	41.19	42.46	41.07	42.38	226832.0
2011-05-18	ARGT	ETF	29.78	29.78	29.78	29.78	150.0
2011-05-18	ASEA	ETF	16.4	16.45	16.38	16.45	4900.0
2011-05-18	BAB	ETF	26.48	26.49	26.32	26.35	106095.0
2011-05-18	BAL	ETF	87.0	89.063	86.7961	87.9	102982.0
2011-05-18	BALT	ETF	6.51	6.59	6.44	6.53	242867.0
2011-05-18	BBH	ETF	35.31	35.63	35.31	35.5967	46500.0
2011-05-18	BCM	ETF	46.52	47.8899	46.52	47.8899	3800.0
2011-05-18	BIB	ETF	9.8025	10.015	9.7875	10.0137	99280.0
2011-05-18	BICK	ETF	32.5	32.74	31.55	32.7	52568.0
2011-05-18	BIL	ETF	91.7	91.72	91.7	91.7	75550.0
2011-05-18	BIS	ETF	5884.8	5937.6	5857.6	5857.6	7.7
2011-05-18	BITS	ETF	20.92	21.96	20.92	21.2	9284.0
2011-05-18	BIV	ETF	84.19	84.19	83.88	83.91	99900.0
2011-05-18	BJK	ETF	33.89	34.41	33.89	34.34	17000.0
2011-05-18	BKF	ETF	47.41	47.83	47.27	47.7	136006.0
2011-05-18	BKLN	ETF	25.19	25.19	25.17	25.19	112500.0
2011-05-18	BLV	ETF	81.79	81.99	81.31	81.34	39800.0
2011-05-18	BMVP	ETF	15.7	15.908	15.68	15.893	7869.0
2011-05-18	BND	ETF	81.47	81.49	81.27	81.28	705300.0
2011-05-18	BNO	ETF	37.04	37.64	36.94	37.315	70600.0
2011-05-18	BOSS	ETF	58.68	61.2	58.68	61.2	100.0
2011-05-18	BRF	ETF	56.26	56.87	56.06	56.24	173239.0
2011-05-18	BSCE	ETF	21.12	21.14	21.09	21.1399	17704.0
2011-05-18	BSV	ETF	80.91	80.95	80.81	80.84	859400.0
2011-05-18	BTF	ETF	83.3	83.75	83.3	83.55	2826.4

> showing 50 of 847 rows — these rows as CSV

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