PREVIEW / etf_daily / 2013-01-10

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-10.parquet
  size:    39 KB
  rows:    960

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-10	SPY	ETF	146.73	147.09	145.97	147.08	130735400.0
2013-01-10	QQQ	ETF	67.21	67.27	66.55	67.17	37534251.0
2013-01-10	IWM	ETF	87.61	87.69	86.95	87.47	39753000.0
2013-01-10	DIA	ETF	134.2	134.58	133.63	134.54	6004300.0
2013-01-10	GLD	ETF	161.61	162.56	161.61	161.98	11432600.0
2013-01-10	TLT	ETF	118.63	119.3	118.36	118.79	5602800.0
2013-01-10	AADR	ETF	32.13	32.13	31.85	31.9	1400.0
2013-01-10	AAXJ	ETF	61.18	61.31	60.91	61.23	288400.0
2013-01-10	ACTV	ETF	5.45	5.92	5.45	5.67	789331.0
2013-01-10	ACWI	ETF	49.17	49.32	48.92	49.29	522100.0
2013-01-10	ACWV	ETF	56.84	56.96	56.61	56.85	41400.0
2013-01-10	ACWX	ETF	42.62	42.73	42.43	42.67	187275.0
2013-01-10	ADRE	ETF	40.88	41.247	40.88	41.23	23001.0
2013-01-10	AFK	ETF	31.43	31.441	31.13	31.418	34640.0
2013-01-10	AGEM	ETF	23.6399	23.6399	23.6399	23.6399	1079.0
2013-01-10	AGG	ETF	110.7	110.81	110.65	110.74	1128700.0
2013-01-10	AGQ	ETF	179.16	182.36	179.0	180.44	277600.0
2013-01-10	AGZ	ETF	113.33	113.33	113.13	113.29	19443.0
2013-01-10	AIA	ETF	48.54	48.75	48.3897	48.71	20292.0
2013-01-10	AIQ	ETF	6.66	6.75	6.65	6.65	7514.0
2013-01-10	AIVI	ETF	42.52	42.69	42.39	42.63	62500.0
2013-01-10	AMJ	ETF	41.0	41.3199	40.97	41.26	674502.0
2013-01-10	AMLP	ETF	83.25	83.6	83.25	83.5	650540.0
2013-01-10	ANGL	ETF	27.4	27.4	27.1	27.2	2700.0
2013-01-10	AOA	ETF	38.01	38.08	37.87	38.07	26900.0
2013-01-10	AOK	ETF	30.91	30.91	30.724	30.8	15068.0
2013-01-10	AOM	ETF	32.09	32.09	31.9801	32.09	28164.0
2013-01-10	AOR	ETF	34.52	34.53	34.4103	34.52	22253.0
2013-01-10	ARB	ETF	46.85	46.86	46.8	46.83	331610.0
2013-01-10	ARGT	ETF	18.18	18.38	18.18	18.3	3150.0
2013-01-10	ASEA	ETF	17.05	17.07	16.92	17.05	63700.0
2013-01-10	AWAY	ETF	22.91	22.96	22.25	22.29	478198.0
2013-01-10	BAB	ETF	30.08	30.13	30.01	30.06	287575.0
2013-01-10	BAL	ETF	49.07	49.11	48.797	48.97	12167.0
2013-01-10	BALT	ETF	3.38	3.47	3.3	3.42	136979.0
2013-01-10	BBH	ETF	57.42	57.42	56.36	56.99	97300.0
2013-01-10	BCM	ETF	44.15	44.15	44.1499	44.1499	957.0
2013-01-10	BIB	ETF	17.285	17.285	16.1625	16.475	136364.0
2013-01-10	BICK	ETF	25.84	26.04	25.74	25.9399	27479.0
2013-01-10	BIL	ETF	91.6	91.62	91.6	91.6	81100.0
2013-01-10	BIS	ETF	2301.2	2326.8	2301.2	2306.404	150.0
2013-01-10	BIV	ETF	87.89	87.96	87.82	87.85	268600.0
2013-01-10	BJK	ETF	37.92	38.14	37.76	38.1	7300.0
2013-01-10	BKF	ETF	41.66	41.9199	41.488	41.83	86947.0
2013-01-10	BKLN	ETF	25.18	25.2	25.18	25.2	888600.0
2013-01-10	BLNG	ETF	49.87	49.87	49.87	49.87	1200.0
2013-01-10	BLV	ETF	92.63	93.09	92.36	92.81	100700.0
2013-01-10	BMVP	ETF	16.8367	16.9066	16.78	16.897	1963.0
2013-01-10	BND	ETF	83.75	83.8	83.67	83.77	1198700.0
2013-01-10	BNO	ETF	41.675	41.7	41.315	41.33	125600.0

> showing 50 of 960 rows — these rows as CSV

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