PREVIEW / etf_daily / 2011-01-11

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-11.parquet
  size:    35 KB
  rows:    815

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-11	SPY	ETF	127.44	127.74	126.95	127.43	110287000.0
2011-01-11	QQQ	ETF	56.29	56.36	55.95	56.16	56663769.0
2011-01-11	IWM	ETF	79.36	79.68	78.87	79.29	42124300.0
2011-01-11	DIA	ETF	116.63	116.86	116.17	116.55	5122600.0
2011-01-11	GLD	ETF	134.79	135.16	133.96	134.91	10268400.0
2011-01-11	TLT	ETF	92.49	92.6	91.69	92.33	9495400.0
2011-01-11	AADR	ETF	29.76	29.87	29.72	29.83	5900.0
2011-01-11	AAXJ	ETF	63.46	63.64	63.27	63.4	1825800.0
2011-01-11	ACWI	ETF	46.78	46.79	46.5	46.68	378900.0
2011-01-11	ACWX	ETF	43.61	43.73	43.44	43.61	96631.0
2011-01-11	ADRE	ETF	47.76	48.0	47.71	47.9	66195.0
2011-01-11	AFK	ETF	35.54	35.59	35.27	35.45	23635.0
2011-01-11	AGG	ETF	105.81	105.81	105.44	105.58	620800.0
2011-01-11	AGQ	ETF	288.82	290.56	284.4	289.38	410200.0
2011-01-11	AGZ	ETF	109.46	109.705	109.46	109.67	12273.0
2011-01-11	AIA	ETF	47.56	47.62	47.424	47.54	31324.0
2011-01-11	AIQ	ETF	21.35	21.65	20.95	21.1	17075.0
2011-01-11	AIS	ETF	1.75	1.77	1.7399	1.75	327921.0
2011-01-11	AIVI	ETF	42.97	42.99	42.69	42.92	69900.0
2011-01-11	AMJ	ETF	36.75	36.88	36.69	36.84	422655.0
2011-01-11	AMLP	ETF	80.7	80.95	80.65	80.9	192260.0
2011-01-11	AOA	ETF	34.6	34.6	34.43	34.53	28800.0
2011-01-11	AOK	ETF	28.83	28.84	28.78	28.83	5596.0
2011-01-11	AOM	ETF	30.0	30.0	29.92	29.9699	6515.0
2011-01-11	AOR	ETF	31.6	31.62	31.53	31.5899	24454.0
2011-01-11	ARB	ETF	42.28	42.48	41.855	42.06	158925.0
2011-01-11	BAB	ETF	25.02	25.11	24.95	25.11	146123.0
2011-01-11	BAL	ETF	75.1	76.35	74.33	76.35	44939.0
2011-01-11	BALT	ETF	10.89	10.89	10.58	10.71	107847.0
2011-01-11	BBH	ETF	33.8967	34.1133	33.8967	34.0333	18300.0
2011-01-11	BIB	ETF	7.8025	7.8025	7.8	7.8	1600.0
2011-01-11	BICK	ETF	32.52	32.76	32.52	32.76	20991.0
2011-01-11	BIL	ETF	91.72	91.72	91.7	91.72	127300.0
2011-01-11	BIS	ETF	7828.48	7828.48	7828.48	7828.48	0.625
2011-01-11	BITS	ETF	28.68	28.68	28.44	28.44	6325.0
2011-01-11	BIV	ETF	82.93	82.95	82.58	82.76	106900.0
2011-01-11	BJK	ETF	33.18	33.29	32.88	33.0	307800.0
2011-01-11	BKF	ETF	49.31	49.37	48.87	49.28	260335.0
2011-01-11	BLV	ETF	78.68	78.68	78.1	78.41	14500.0
2011-01-11	BMVP	ETF	14.73	14.78	14.7	14.74	40899.0
2011-01-11	BND	ETF	80.38	80.39	80.14	80.23	980700.0
2011-01-11	BNO	ETF	32.02	32.38	32.02	32.33	5200.0
2011-01-11	BRF	ETF	57.51	57.85	57.35	57.85	578999.0
2011-01-11	BSCE	ETF	20.82	20.83	20.798	20.8	19837.0
2011-01-11	BSV	ETF	80.56	80.61	80.5	80.54	606400.0
2011-01-11	BTF	ETF	77.55	78.7	77.35	78.3	5244.8
2011-01-11	BWX	ETF	28.435	28.49	28.3582	28.485	190168.0
2011-01-11	BWZ	ETF	36.39	36.39	36.188	36.35	12931.0
2011-01-11	BZQ	ETF	2473.6	2492.8	2424.0	2436.8	295.0
2011-01-11	CEF	ETF	19.48	19.8	19.45	19.68	1235800.0

> showing 50 of 815 rows — these rows as CSV

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