PREVIEW / etf_daily / 2011-01-06

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-06.parquet
  size:    35 KB
  rows:    822

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-06	SPY	ETF	127.69	127.83	127.01	127.39	122519000.0
2011-01-06	QQQ	ETF	55.79	55.96	55.68	55.92	46139540.0
2011-01-06	IWM	ETF	79.4	79.53	78.65	78.97	39392300.0
2011-01-06	DIA	ETF	117.14	117.19	116.5	116.78	7161600.0
2011-01-06	GLD	ETF	134.05	134.38	133.14	133.83	15965300.0
2011-01-06	TLT	ETF	91.54	92.12	91.16	91.86	9317500.0
2011-01-06	AADR	ETF	29.82	29.85	29.74	29.83	13300.0
2011-01-06	AAXJ	ETF	64.4	64.6	64.09	64.28	1076600.0
2011-01-06	ACWI	ETF	47.16	47.16	46.66	46.81	1656300.0
2011-01-06	ACWX	ETF	44.15	44.16	43.6	43.74	324244.0
2011-01-06	ADRE	ETF	48.1	48.2801	47.82	47.82	60047.0
2011-01-06	AFK	ETF	35.69	35.69	35.28	35.334	27038.0
2011-01-06	AGG	ETF	105.31	105.31	105.11	105.17	2032600.0
2011-01-06	AGQ	ETF	285.38	285.54	275.2	280.68	493350.0
2011-01-06	AGZ	ETF	109.41	109.41	109.09	109.2	21024.0
2011-01-06	AIA	ETF	47.86	47.86	47.4501	47.6	80303.0
2011-01-06	AIQ	ETF	21.25	22.1	21.25	22.0	25791.0
2011-01-06	AIS	ETF	1.8	1.8	1.72	1.73	358620.0
2011-01-06	AIVI	ETF	43.75	43.75	43.05	43.15	19200.0
2011-01-06	AMJ	ETF	36.49	36.53	36.32	36.42	1111178.0
2011-01-06	AMLP	ETF	80.4	80.5	80.15	80.25	106640.0
2011-01-06	AOA	ETF	34.67	34.67	34.39	34.47	24200.0
2011-01-06	AOK	ETF	28.81	28.81	28.73	28.7799	7347.0
2011-01-06	AOM	ETF	29.99	29.99	29.888	29.91	17452.0
2011-01-06	AOR	ETF	31.61	31.66	31.508	31.53	61204.0
2011-01-06	ARB	ETF	42.23	42.74	41.96	42.37	215158.0
2011-01-06	BAB	ETF	24.89	25.0299	24.86	24.986	283441.0
2011-01-06	BAL	ETF	74.54	75.55	71.53	71.53	77199.0
2011-01-06	BALT	ETF	10.7	10.95	10.685	10.93	252747.0
2011-01-06	BBH	ETF	33.9533	34.0333	33.8267	33.95	87600.0
2011-01-06	BIB	ETF	7.7625	7.785	7.7625	7.785	12000.0
2011-01-06	BICK	ETF	33.44	33.44	32.8656	33.0452	54770.0
2011-01-06	BIL	ETF	91.72	91.72	91.7	91.72	64950.0
2011-01-06	BIS	ETF	8128.0	8128.0	7868.8	7868.8	1.25
2011-01-06	BITS	ETF	28.76	29.0	28.72	28.84	514.0
2011-01-06	BIV	ETF	82.16	82.35	82.03	82.24	182000.0
2011-01-06	BJK	ETF	32.47	32.47	32.09	32.17	27800.0
2011-01-06	BKF	ETF	50.19	50.21	49.58	49.7768	169777.0
2011-01-06	BLV	ETF	77.86	78.22	77.75	78.07	21800.0
2011-01-06	BMVP	ETF	14.78	14.8	14.74	14.76	20825.0
2011-01-06	BND	ETF	79.9	79.96	79.77	79.9	591000.0
2011-01-06	BNO	ETF	31.85	31.855	31.34	31.34	4600.0
2011-01-06	BOSS	ETF	48.965	48.965	48.56	48.56	200.0
2011-01-06	BRF	ETF	57.72	57.84	57.05	57.47	762096.0
2011-01-06	BSCE	ETF	20.67	20.68	20.67	20.68	6620.0
2011-01-06	BSV	ETF	80.22	80.31	80.21	80.31	693600.0
2011-01-06	BTF	ETF	78.25	78.75	77.8	78.3	4376.0
2011-01-06	BWX	ETF	28.585	28.628	28.36	28.485	340090.0
2011-01-06	BWZ	ETF	36.62	36.62	36.27	36.439	6182.0
2011-01-06	BZQ	ETF	2401.6	2459.2	2398.4	2443.2	362.0

> showing 50 of 822 rows — these rows as CSV

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