PREVIEW / etf_daily / 2011-03-14

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-14.parquet
  size:    36 KB
  rows:    835

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-03-14	SPY	ETF	129.99	130.48	129.06	130.05	234974100.0
2011-03-14	QQQ	ETF	56.18	56.59	55.86	56.29	73621760.0
2011-03-14	IWM	ETF	79.34	80.33	78.91	79.75	60138300.0
2011-03-14	DIA	ETF	119.77	120.11	118.92	119.85	8026700.0
2011-03-14	GLD	ETF	139.33	139.55	138.61	138.86	10239300.0
2011-03-14	TLT	ETF	91.48	91.92	91.32	91.51	6765200.0
2011-03-14	AADR	ETF	29.96	29.96	29.74	29.74	2000.0
2011-03-14	AAXJ	ETF	60.59	61.1	60.56	61.06	265200.0
2011-03-14	ACWI	ETF	46.89	47.25	46.76	47.23	316800.0
2011-03-14	ACWX	ETF	43.67	43.94	43.444	43.91	81704.0
2011-03-14	ADRE	ETF	46.16	46.71	46.12	46.67	49254.0
2011-03-14	AFK	ETF	32.03	32.2999	31.79	31.9996	23852.0
2011-03-14	AGG	ETF	105.82	105.98	105.69	105.69	415900.0
2011-03-14	AGQ	ETF	415.14	422.04	407.82	412.4	456000.0
2011-03-14	AGZ	ETF	109.8	109.92	109.561	109.7125	22348.0
2011-03-14	AIA	ETF	45.71	45.9699	45.6552	45.9699	18058.0
2011-03-14	AIQ	ETF	20.35	20.65	20.25	20.5	19918.0
2011-03-14	AIS	ETF	1.65	1.66	1.61	1.64	436824.0
2011-03-14	AIVI	ETF	45.13	45.44	44.91	45.32	10800.0
2011-03-14	AMJ	ETF	36.68	36.78	36.34	36.64	832353.0
2011-03-14	AMLP	ETF	80.25	80.3	79.65	80.05	71180.0
2011-03-14	AOA	ETF	34.93	35.11	34.82	35.04	10100.0
2011-03-14	AOK	ETF	29.08	29.08	29.01	29.054	13818.0
2011-03-14	AOM	ETF	30.3	30.33	30.23	30.31	15842.0
2011-03-14	AOR	ETF	32.04	32.0956	31.91	32.0701	3455.0
2011-03-14	ARB	ETF	37.29	37.75	36.76	37.22	152166.0
2011-03-14	ARGT	ETF	29.62	29.8	29.12	29.34	7250.0
2011-03-14	ASEA	ETF	15.43	15.43	15.22	15.31	2700.0
2011-03-14	BAB	ETF	25.38	25.41	25.33	25.35	136787.0
2011-03-14	BAL	ETF	101.86	103.57	100.61	102.27	103379.0
2011-03-14	BALT	ETF	8.9	9.1404	8.75	8.97	114756.0
2011-03-14	BBH	ETF	34.5067	34.7867	34.5067	34.7567	12900.0
2011-03-14	BIB	ETF	7.665	7.665	7.665	7.665	800.0
2011-03-14	BICK	ETF	31.57	31.69	31.33	31.59	38257.0
2011-03-14	BIL	ETF	91.7	91.74	91.7	91.72	929650.0
2011-03-14	BIS	ETF	7747.2	7747.2	7708.8	7708.8	32.5
2011-03-14	BITS	ETF	25.92	25.92	25.52	25.56	500.0
2011-03-14	BIV	ETF	82.9	83.1	82.9	83.0	71300.0
2011-03-14	BJK	ETF	30.89	30.89	30.4	30.68	22500.0
2011-03-14	BKF	ETF	47.66	48.18	47.63	48.16	398381.0
2011-03-14	BKLN	ETF	24.99	25.0	24.92	24.92	65000.0
2011-03-14	BLV	ETF	78.21	78.5	78.13	78.37	41000.0
2011-03-14	BMVP	ETF	15.13	15.18	15.0	15.12	5809.0
2011-03-14	BND	ETF	80.43	80.54	80.4	80.41	568800.0
2011-03-14	BNO	ETF	37.755	37.885	37.455	37.735	128400.0
2011-03-14	BOSS	ETF	45.14	45.14	45.14	45.14	100.0
2011-03-14	BRF	ETF	52.33	52.79	52.0	52.53	188115.0
2011-03-14	BSCE	ETF	20.95	21.02	20.95	21.02	33819.0
2011-03-14	BSV	ETF	80.59	80.68	80.56	80.56	321100.0
2011-03-14	BTF	ETF	82.7995	82.7995	81.89999999999999	82.35	4131.6

> showing 50 of 835 rows — these rows as CSV

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