PREVIEW / etf_daily / 2015-02-02

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-02.parquet
  size:    47 KB
  rows:    1,170

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
2015-02-02	SPY	ETF	200.05	202.03	197.86	201.92	163107000.0
2015-02-02	QQQ	ETF	101.33	102.07	99.75	101.98	43624654.0
2015-02-02	IWM	ETF	116.12	116.84	114.38	116.76	44819100.0
2015-02-02	DIA	ETF	171.95	173.43	170.1	173.27	9437900.0
2015-02-02	GLD	ETF	121.84	123.16	121.82	122.42	8885200.0
2015-02-02	TLT	ETF	136.7	137.92	136.66	137.48	13689900.0
2015-02-02	AADR	ETF	36.91	36.91	36.4	36.74	2600.0
2015-02-02	AAXJ	ETF	62.68	63.05	62.46	62.92	1152700.0
2015-02-02	ACWI	ETF	57.94	58.54	57.63	58.48	2613100.0
2015-02-02	ACWV	ETF	70.04	70.45	69.61	70.45	147900.0
2015-02-02	ACWX	ETF	43.19	43.548	43.0899	43.48	1117449.0
2015-02-02	ADRE	ETF	35.46	35.8469	35.4201	35.8	8127.0
2015-02-02	AFK	ETF	25.34	25.9	25.29	25.83	166693.0
2015-02-02	AGG	ETF	112.06	112.23	112.0	112.2	2792100.0
2015-02-02	AGQ	ETF	44.75	45.88	44.45	45.1	357500.0
2015-02-02	AGZ	ETF	114.99	115.31	114.8	114.95	15330.0
2015-02-02	AGZD	ETF	24.42	24.475	24.35	24.415	18000.0
2015-02-02	AIA	ETF	48.46	48.76	48.34	48.76	19447.0
2015-02-02	AIQ	ETF	22.55	22.76	22.25	22.75	8498.0
2015-02-02	AIRR	ETF	16.72	17.23	16.72	17.23	72500.0
2015-02-02	AIVI	ETF	43.55	43.94	43.52	43.87	14900.0
2015-02-02	ALTL	ETF	37.125	37.56	37.125	37.35	841.0
2015-02-02	AMJ	ETF	44.64	45.15	44.18	45.15	2736353.0
2015-02-02	AMLP	ETF	86.0	86.5	85.1	86.3	1269980.0
2015-02-02	AMZA	ETF	215.7	217.0	214.2	216.0	400.0
2015-02-02	ANGL	ETF	26.56	27.08	26.56	27.08	1300.0
2015-02-02	AOA	ETF	46.31	46.33	45.77	46.33	40800.0
2015-02-02	AOK	ETF	32.82	32.82	32.6	32.77	293200.0
2015-02-02	AOM	ETF	35.36	35.36	35.04	35.25	128609.0
2015-02-02	AOR	ETF	39.99	40.17	39.8401	40.17	182427.0
2015-02-02	ARGT	ETF	18.47	18.61	18.34	18.56	44400.0
2015-02-02	ARKG	ETF	22.0	22.12	21.96	22.12	1900.0
2015-02-02	ARKK	ETF	20.2	20.367	20.12	20.367	2400.0
2015-02-02	ARKQ	ETF	18.89	19.1	18.89	19.04	1800.0
2015-02-02	ARKW	ETF	20.12	20.34	20.12	20.34	3500.0
2015-02-02	ASEA	ETF	15.46	15.58	15.46	15.55	207800.0
2015-02-02	ASHR	ETF	34.41	34.62	34.31	34.57	1095700.0
2015-02-02	ASHS	ETF	36.85	37.08	36.85	37.05	155100.0
2015-02-02	ATMP	ETF	29.54	29.91	29.47	29.91	44600.0
2015-02-02	AVIV	ETF	39.39	39.39	37.81	38.58	255359.0
2015-02-02	AWAY	ETF	25.6	26.11	25.13	25.92	1672693.0
2015-02-02	BAB	ETF	31.34	31.39	31.1828	31.32	178523.0
2015-02-02	BAL	ETF	40.37	40.94	40.23	40.72	5716.0
2015-02-02	BALT	ETF	1.61	1.67	1.56	1.59	555966.0
2015-02-02	BAR	ETF	3.325	3.404	3.3001	3.3001	42850.0
2015-02-02	BBC	ETF	28.73	28.73	27.73	28.05	4634.0
2015-02-02	BBH	ETF	124.07	124.34	120.99	122.56	217800.0
2015-02-02	BBP	ETF	27.65	28.0	27.471	27.67	4400.0
2015-02-02	BCHP	ETF	18.351	18.351	18.351	18.351	450.0
2015-02-02	BCM	ETF	31.69	31.69	31.03	31.27	13749.0

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

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