PREVIEW / etf_daily / 2017-03-03

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-03.parquet
  size:    54 KB
  rows:    1,376

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
2017-03-03	SPY	ETF	238.17	238.61	237.73	238.42	81974300.0
2017-03-03	QQQ	ETF	130.65	131.06	130.341	131.02	13722749.0
2017-03-03	IWM	ETF	138.8	139.42	137.88	138.65	30989800.0
2017-03-03	DIA	ETF	210.06	210.32	209.41	209.91	2589000.0
2017-03-03	GLD	ETF	116.95	117.73	116.44	117.51	10665800.0
2017-03-03	TLT	ETF	119.23	119.35	118.55	119.35	9515200.0
2017-03-03	AADR	ETF	45.6	45.95	45.51	45.91	4600.0
2017-03-03	AAXJ	ETF	60.44	60.5	60.17	60.35	1587300.0
2017-03-03	ACSI	ETF	28.07	28.15	28.04	28.12	3000.0
2017-03-03	ACTX	ETF	100.3009	103.8409	93.8108	97.3509	1814.0
2017-03-03	ACWF	ETF	25.48	25.48	25.48	25.48	1930.0
2017-03-03	ACWI	ETF	62.82	62.98	62.69	62.94	1665100.0
2017-03-03	ACWV	ETF	76.4	76.42	76.13	76.4	72400.0
2017-03-03	ACWX	ETF	42.51	42.72	42.46	42.7	325021.0
2017-03-03	ADRE	ETF	35.82	35.849	35.6767	35.804	5367.0
2017-03-03	AFK	ETF	20.35	20.769	20.35	20.74	12349.0
2017-03-03	AFTY	ETF	13.8	13.813	13.8	13.813	1000.0
2017-03-03	AGG	ETF	107.92	107.97	107.74	107.92	4293900.0
2017-03-03	AGGY	ETF	49.606	49.65	49.5	49.65	10100.0
2017-03-03	AGNG	ETF	16.89	16.95	16.84	16.89	1100.0
2017-03-03	AGQ	ETF	39.26	40.39	38.96	40.18	214000.0
2017-03-03	AGZ	ETF	112.3732	112.66	112.3732	112.54	14034.0
2017-03-03	AGZD	ETF	24.155	24.175	24.03	24.03	9400.0
2017-03-03	AIA	ETF	50.51	50.5207	50.294	50.5207	12837.0
2017-03-03	AIQ	ETF	9.75	9.7598	9.5143	9.65	10723.0
2017-03-03	AIRR	ETF	24.47	24.535	24.23	24.35	66800.0
2017-03-03	AIVI	ETF	38.87	39.14	38.84	39.14	165100.0
2017-03-03	ALTY	ETF	15.58	15.58	15.375	15.48	15000.0
2017-03-03	AMJ	ETF	33.01	33.16	32.985	33.0	1080100.0
2017-03-03	AMLP	ETF	64.95	65.0	64.7	64.85	1827900.0
2017-03-03	AMZA	ETF	113.3	113.58	112.9	113.1	23990.0
2017-03-03	ANGL	ETF	29.58	29.58	29.47	29.52	186000.0
2017-03-03	AOA	ETF	49.58	49.63	49.43	49.62	37400.0
2017-03-03	AOK	ETF	33.06	33.11	33.02	33.07	25994.0
2017-03-03	AOM	ETF	36.16	36.189	36.0666	36.12	55180.0
2017-03-03	AOR	ETF	42.13	42.15	41.98	42.15	66517.0
2017-03-03	ARGT	ETF	26.35	26.71	26.35	26.69	411000.0
2017-03-03	ARKG	ETF	20.15	20.15	20.03	20.03	1500.0
2017-03-03	ARKK	ETF	23.25	23.25	23.14	23.2	3000.0
2017-03-03	ARKQ	ETF	23.782	23.782	23.66	23.75	3300.0
2017-03-03	ARKW	ETF	28.21	28.275	28.19	28.275	3700.0
2017-03-03	ASEA	ETF	13.56	13.62	13.56	13.62	8000.0
2017-03-03	ASET	ETF	26.21	26.29	26.17	26.289	2174.0
2017-03-03	ASHR	ETF	24.8	24.9	24.8	24.89	261600.0
2017-03-03	ASHS	ETF	33.95	33.96	33.95	33.96	500.0
2017-03-03	ATMP	ETF	23.94	24.36	23.94	24.07	29200.0
2017-03-03	BAB	ETF	29.11	29.202	29.07	29.12	120175.0
2017-03-03	BAL	ETF	50.12	50.6394	49.89	50.59	2101.0
2017-03-03	BBC	ETF	22.51	22.9	21.5968	22.7	18646.0
2017-03-03	BBH	ETF	121.66	122.85	121.33	122.85	26600.0

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

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