PREVIEW / etf_daily / 2013-01-03

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-03.parquet
  size:    40 KB
  rows:    970

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
2013-01-03	SPY	ETF	145.99	146.37	145.34	145.73	144761800.0
2013-01-03	QQQ	ETF	67.2	67.34	66.65	66.8521	47366435.0
2013-01-03	IWM	ETF	86.85	87.28	86.37	86.6	45872900.0
2013-01-03	DIA	ETF	133.64	134.05	133.31	133.63	8665200.0
2013-01-03	GLD	ETF	162.48	162.88	160.83	161.2	16117500.0
2013-01-03	TLT	ETF	119.38	119.49	117.9	117.94	10004300.0
2013-01-03	AADR	ETF	31.53	31.73	31.43	31.64	3400.0
2013-01-03	AAXJ	ETF	61.32	61.66	61.23	61.29	416900.0
2013-01-03	ACTV	ETF	5.31	5.4	5.22	5.24	371854.0
2013-01-03	ACWI	ETF	48.81	49.08	48.72	48.83	1567500.0
2013-01-03	ACWV	ETF	56.56	56.64	56.47	56.5	30000.0
2013-01-03	ACWX	ETF	42.38	42.56	42.2	42.26	273197.0
2013-01-03	ADRE	ETF	40.96	41.48	40.96	41.185	37159.0
2013-01-03	AFK	ETF	31.56	31.79	31.46	31.49	68577.0
2013-01-03	AGEM	ETF	23.92	24.02	23.7703	23.86	3229.0
2013-01-03	AGG	ETF	111.01	111.08	110.64	110.67	1762900.0
2013-01-03	AGQ	ETF	181.76	184.36	172.12	173.92	417950.0
2013-01-03	AGZ	ETF	113.4	113.46	113.134	113.14	23017.0
2013-01-03	AIA	ETF	49.0	49.0	48.6	48.6	107814.0
2013-01-03	AIQ	ETF	6.5	6.66	6.49	6.65	11800.0
2013-01-03	AIVI	ETF	42.1	42.31	41.93	42.03	26900.0
2013-01-03	AMJ	ETF	39.87	40.46	39.27	40.23	750936.0
2013-01-03	AMLP	ETF	81.85	82.5	81.5	82.15	558720.0
2013-01-03	ANGL	ETF	26.89	27.09	26.84	27.0	30200.0
2013-01-03	AOA	ETF	37.84	37.94	37.71	37.79	30700.0
2013-01-03	AOK	ETF	30.71	30.77	30.6699	30.69	52505.0
2013-01-03	AOM	ETF	32.0	32.05	31.88	31.96	57879.0
2013-01-03	AOR	ETF	34.39	34.439	34.258	34.33	27956.0
2013-01-03	ARB	ETF	46.7	46.7	46.56	46.69	510676.0
2013-01-03	ARGT	ETF	17.9	17.9	17.9	17.9	100.0
2013-01-03	ASEA	ETF	17.25	17.41	17.19	17.22	36000.0
2013-01-03	AWAY	ETF	22.03	22.38	21.8239	22.11	273729.0
2013-01-03	BAB	ETF	30.16	30.23	29.99	30.03	258527.0
2013-01-03	BAL	ETF	49.52	49.53	49.0	49.469	23285.0
2013-01-03	BALT	ETF	3.1	3.2	3.05	3.2	39840.0
2013-01-03	BBH	ETF	55.31	55.61	54.95	55.18	75800.0
2013-01-03	BCM	ETF	44.0899	44.09	43.8299	43.8299	20191.0
2013-01-03	BIB	ETF	15.47	15.6125	15.1325	15.415	95284.0
2013-01-03	BICK	ETF	25.88	26.08	25.88	25.884	4643.0
2013-01-03	BIL	ETF	91.64	91.64	91.62	91.62	294500.0
2013-01-03	BIS	ETF	2484.0	2505.996	2454.4	2475.6	132.5
2013-01-03	BIV	ETF	88.15	88.19	87.81	87.85	430900.0
2013-01-03	BJK	ETF	36.95	37.14	36.9	36.97	2400.0
2013-01-03	BKF	ETF	41.71	42.19	41.69	41.89	59857.0
2013-01-03	BKLN	ETF	25.04	25.04	24.98	25.0	700800.0
2013-01-03	BLV	ETF	92.86	92.88	92.0	92.04	315700.0
2013-01-03	BMVP	ETF	16.7267	16.7833	16.7133	16.7216	7888.0
2013-01-03	BND	ETF	83.91	83.93	83.65	83.65	1908500.0
2013-01-03	BNO	ETF	41.32	41.425	41.22	41.22	39800.0
2013-01-03	BOIL	ETF	705000.0	727400.0	700200.0	708600.0	14.2

> showing 50 of 970 rows — these rows as CSV

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