PREVIEW / etf_daily / 2017-12-14

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-14.parquet
  size:    59 KB
  rows:    1,521

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-12-14	SPY	ETF	267.09	267.22	265.6	265.66	100666700.0
2017-12-14	QQQ	ETF	156.28	156.66	155.71	155.88	24594682.0
2017-12-14	IWM	ETF	151.85	152.2	149.64	150.1	32882600.0
2017-12-14	DIA	ETF	246.89	247.07	245.47	245.57	4713300.0
2017-12-14	GLD	ETF	119.1	119.29	118.71	118.93	6993600.0
2017-12-14	TLT	ETF	127.05	127.98	126.79	127.87	6885000.0
2017-12-14	AADR	ETF	56.91	57.02	56.7	56.78	42000.0
2017-12-14	AAXJ	ETF	75.91	76.04	75.49	75.49	1409700.0
2017-12-14	ACSI	ETF	31.02	31.02	30.95	30.95	3741.0
2017-12-14	ACTX	ETF	69.4436	79.6507	68.1456	75.5797	673.0
2017-12-14	ACWF	ETF	30.5419	30.5419	30.36	30.36	2760.0
2017-12-14	ACWI	ETF	72.07	72.1	71.67	71.68	2458400.0
2017-12-14	ACWV	ETF	84.77	84.77	84.49	84.59	421800.0
2017-12-14	ACWX	ETF	49.66	49.7057	49.45	49.47	534473.0
2017-12-14	ADRE	ETF	42.2	42.2	41.987	42.0503	13524.0
2017-12-14	AFK	ETF	24.23	24.7	24.23	24.64	7456.0
2017-12-14	AFTY	ETF	18.47	18.47	18.361	18.38	6200.0
2017-12-14	AGG	ETF	109.31	109.51	109.23	109.44	4126100.0
2017-12-14	AGGY	ETF	50.79	50.86	50.72	50.85	426700.0
2017-12-14	AGNG	ETF	19.62	19.67	19.3	19.35	16900.0
2017-12-14	AGQ	ETF	30.15	30.15	29.66	29.98	134900.0
2017-12-14	AGZ	ETF	113.35	113.4	113.27	113.38	30124.0
2017-12-14	AGZD	ETF	24.215	24.215	24.125	24.195	17000.0
2017-12-14	AIA	ETF	65.3	65.36	65.05	65.09	42718.0
2017-12-14	AIEQ	ETF	25.66	25.679	25.342	25.37	135000.0
2017-12-14	AIRR	ETF	26.68	26.74	26.3	26.36	22700.0
2017-12-14	AIVI	ETF	43.04	43.06	42.85	42.86	4200.0
2017-12-14	ALTY	ETF	15.31	15.38	15.29	15.335	14700.0
2017-12-14	AMJ	ETF	27.26	27.7	27.14	27.44	5846344.0
2017-12-14	AMLP	ETF	53.65	54.75	53.65	54.35	4974420.0
2017-12-14	AMZA	ETF	85.2	86.7	85.0	86.0	89720.0
2017-12-14	ANGL	ETF	30.01	30.01	29.92	29.93	263000.0
2017-12-14	AOA	ETF	55.42	55.42	55.17	55.24	50100.0
2017-12-14	AOK	ETF	34.67	34.67	34.51	34.58	96751.0
2017-12-14	AOM	ETF	38.56	38.62	38.55	38.56	352027.0
2017-12-14	AOR	ETF	45.94	45.979	45.82	45.82	250316.0
2017-12-14	ARGT	ETF	34.99	35.13	34.72	34.79	85000.0
2017-12-14	ARKG	ETF	24.42	24.458	23.92	23.96	29100.0
2017-12-14	ARKK	ETF	37.82	37.989	37.465	37.57	233800.0
2017-12-14	ARKQ	ETF	34.3	34.35	33.901	33.926	50900.0
2017-12-14	ARKW	ETF	47.3	47.57	47.1	47.3	122300.0
2017-12-14	ASEA	ETF	16.92	17.0	16.92	16.95	1200.0
2017-12-14	ASET	ETF	28.8083	28.809	28.7821	28.7821	1635.0
2017-12-14	ASHR	ETF	30.82	30.87	30.77	30.77	630100.0
2017-12-14	ASHS	ETF	34.53	34.58	34.44	34.55	11900.0
2017-12-14	ASHX	ETF	22.75	22.75	22.7	22.7	501.0
2017-12-14	ATMP	ETF	20.42	20.8	20.42	20.64	597900.0
2017-12-14	BAB	ETF	30.65	30.73	30.65	30.7	57219.0
2017-12-14	BAL	ETF	49.65	49.98	49.5	49.79	13729.0
2017-12-14	BAR	ETF	12.54	12.54	12.54	12.54	6330.0

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

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