PREVIEW / etf_daily / 2014-01-02

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-02.parquet
  size:    43 KB
  rows:    1,068

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
2014-01-02	SPY	ETF	183.98	184.07	182.48	182.92	119636900.0
2014-01-02	QQQ	ETF	87.55	87.58	87.02	87.27	29190009.0
2014-01-02	IWM	ETF	115.09	115.12	113.64	114.11	44247700.0
2014-01-02	DIA	ETF	164.79	165.01	163.84	164.11	9291100.0
2014-01-02	GLD	ETF	117.93	118.73	117.75	118.0	7551000.0
2014-01-02	TLT	ETF	101.72	102.39	101.69	102.17	8580800.0
2014-01-02	AADR	ETF	37.87	37.87	37.13	37.29	1900.0
2014-01-02	AAXJ	ETF	59.16	59.25	58.25	58.36	1357300.0
2014-01-02	ACWI	ETF	57.19	57.19	56.66	56.8	1530400.0
2014-01-02	ACWV	ETF	63.57	63.57	62.72	62.86	56100.0
2014-01-02	ACWX	ETF	46.15	46.15	45.65	45.77	159667.0
2014-01-02	ADRE	ETF	36.48	36.66	36.208	36.2501	47829.0
2014-01-02	AFK	ETF	30.89	30.89	30.321	30.4	28093.0
2014-01-02	AGG	ETF	106.45	106.57	106.43	106.5	1346600.0
2014-01-02	AGQ	ETF	67.32	68.0	66.32	66.32	495025.0
2014-01-02	AGZ	ETF	110.5	110.81	110.49	110.81	63932.0
2014-01-02	AGZD	ETF	24.965	24.965	24.965	24.965	400.0
2014-01-02	AIA	ETF	47.02	47.03	46.53	46.54	43234.0
2014-01-02	AIQ	ETF	24.85	26.77	24.85	26.24	57898.0
2014-01-02	AIVI	ETF	46.9	46.9	46.39	46.47	32800.0
2014-01-02	AMJ	ETF	46.07	46.44	45.63	45.77	413204.0
2014-01-02	AMLP	ETF	88.8	88.9	87.85	88.1	637260.0
2014-01-02	ANGL	ETF	27.01	27.01	26.91	26.97	4900.0
2014-01-02	AOA	ETF	44.42	44.42	44.07	44.15	29200.0
2014-01-02	AOK	ETF	31.91	31.9236	31.85	31.86	25542.0
2014-01-02	AOM	ETF	34.25	34.25	34.08	34.16	75121.0
2014-01-02	AOR	ETF	38.37	38.37	38.18	38.21	36169.0
2014-01-02	ARGT	ETF	19.66	19.7	19.24	19.29	5900.0
2014-01-02	ASEA	ETF	15.19	15.27	15.03	15.08	29300.0
2014-01-02	ASHR	ETF	24.36	24.4	24.19	24.2	147400.0
2014-01-02	ATMP	ETF	27.26	27.26	27.01	27.01	3700.0
2014-01-02	AVIV	ETF	23.57	23.75	22.77	23.0	138916.0
2014-01-02	AWAY	ETF	40.92	41.04	39.4	40.14	728015.0
2014-01-02	BAB	ETF	27.27	27.3799	27.27	27.3501	126647.0
2014-01-02	BAL	ETF	52.9981	53.3999	52.8	53.1	24864.0
2014-01-02	BALT	ETF	6.28	6.44	6.04	6.44	1553871.0
2014-01-02	BBH	ETF	87.97	88.87	87.65	88.74	86900.0
2014-01-02	BCM	ETF	39.42	39.43	39.41	39.43	105594.0
2014-01-02	BFOR	ETF	7.47	7.47	7.37	7.3875	308800.0
2014-01-02	BIB	ETF	37.8375	37.8375	36.805	37.59	171012.0
2014-01-02	BICK	ETF	24.3	24.3	23.991	24.014	3408.0
2014-01-02	BIL	ETF	91.54	91.56	91.54	91.54	265900.0
2014-01-02	BIS	ETF	835.54	849.6	823.24	823.24	1173.0
2014-01-02	BIV	ETF	81.76	81.96	81.75	81.89	259300.0
2014-01-02	BIZD	ETF	21.11	21.11	20.72	20.75	20700.0
2014-01-02	BJK	ETF	53.25	53.31	53.01	53.12	25600.0
2014-01-02	BKF	ETF	37.16	37.26	36.51	36.65	65724.0
2014-01-02	BKLN	ETF	24.87	24.88	24.86	24.88	4278200.0
2014-01-02	BLV	ETF	81.65	82.14	81.65	81.93	46000.0
2014-01-02	BMVP	ETF	22.67	22.67	22.5	22.5519	27540.0

> showing 50 of 1,068 rows — these rows as CSV

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