PREVIEW / etf_daily / 2018-02-14

all etf daily files

  file:    by_date/etf_daily/2018/2018-02-14.parquet
  size:    61 KB
  rows:    1,566

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
2018-02-14	SPY	ETF	264.31	270.0	264.3	269.59	120735700.0
2018-02-14	QQQ	ETF	158.79	162.93	158.0	162.68	52107431.0
2018-02-14	IWM	ETF	147.63	151.52	147.18	151.15	36286900.0
2018-02-14	DIA	ETF	245.17	249.49	245.04	249.3	5764000.0
2018-02-14	GLD	ETF	126.47	128.59	126.29	128.23	16416400.0
2018-02-14	TLT	ETF	118.46	118.54	117.47	117.67	12043300.0
2018-02-14	AADR	ETF	58.0	59.92	57.95	59.81	40700.0
2018-02-14	AAXJ	ETF	75.6	77.74	75.6	77.63	954200.0
2018-02-14	ACSI	ETF	30.6999	30.6999	30.67	30.67	465.0
2018-02-14	ACTX	ETF	72.5707	77.8807	70.8006	76.1107	622.0
2018-02-14	ACWF	ETF	30.52	31.334	30.52	31.23	26600.0
2018-02-14	ACWI	ETF	71.3	73.0	71.3	72.97	2926300.0
2018-02-14	ACWV	ETF	82.26	83.56	82.26	83.51	114200.0
2018-02-14	ACWX	ETF	49.22	50.46	49.215	50.43	559597.0
2018-02-14	ADRE	ETF	44.2	45.3419	44.19	45.34	11830.0
2018-02-14	AFK	ETF	24.93	25.98	24.93	25.6771	10577.0
2018-02-14	AFTY	ETF	18.342	18.63	18.342	18.63	9400.0
2018-02-14	AGG	ETF	106.57	106.66	106.4	106.46	4317000.0
2018-02-14	AGGY	ETF	49.21	49.24	49.12	49.15	548700.0
2018-02-14	AGNG	ETF	19.461	19.9	19.461	19.864	1800.0
2018-02-14	AGQ	ETF	32.3	33.5	32.23	33.3	193000.0
2018-02-14	AGZ	ETF	111.46	111.4748	111.32	111.3899	7657.0
2018-02-14	AGZD	ETF	24.07	24.245	24.07	24.15	22800.0
2018-02-14	AIA	ETF	66.63	68.515	66.58	68.37	92402.0
2018-02-14	AIEQ	ETF	25.9	26.48	25.82	26.48	112700.0
2018-02-14	AIRR	ETF	25.7	26.158	25.632	26.158	26200.0
2018-02-14	AIVI	ETF	42.94	43.5	42.94	43.5	3700.0
2018-02-14	ALTY	ETF	14.76	14.76	14.7	14.735	19400.0
2018-02-14	AMJ	ETF	27.84	28.28	27.72	28.02	1177028.0
2018-02-14	AMLP	ETF	53.85	54.7	53.5	54.2	1830040.0
2018-02-14	AMUB	ETF	16.6	17.43	16.55	17.185	2500.0
2018-02-14	AMZA	ETF	82.5	83.8	81.4	83.5	92030.0
2018-02-14	ANGL	ETF	29.15	29.3	29.15	29.29	238600.0
2018-02-14	AOA	ETF	53.17	54.07	53.01	53.97	92600.0
2018-02-14	AOK	ETF	33.97	34.2	33.8499	34.2	50462.0
2018-02-14	AOM	ETF	37.48	37.78	37.37	37.78	263268.0
2018-02-14	AOR	ETF	44.24	44.78	44.16	44.77	127063.0
2018-02-14	ARCM	ETF	100.33	100.33	100.132	100.132	300.0
2018-02-14	ARGT	ETF	34.99	36.25	34.85	36.25	48700.0
2018-02-14	ARKG	ETF	25.42	26.57	25.31	26.41	109400.0
2018-02-14	ARKK	ETF	39.06	40.389	39.04	40.28	455000.0
2018-02-14	ARKQ	ETF	33.67	34.45	33.55	34.4	36200.0
2018-02-14	ARKW	ETF	48.57	50.29	48.57	50.21	279300.0
2018-02-14	ASEA	ETF	17.3	17.77	17.3	17.62	3200.0
2018-02-14	ASET	ETF	27.32	27.58	27.3183	27.55	6580.0
2018-02-14	ASHR	ETF	30.96	31.67	30.96	31.62	1072800.0
2018-02-14	ASHS	ETF	32.81	33.47	32.8	33.47	5800.0
2018-02-14	ATMP	ETF	21.12	21.28	20.9	21.2	96200.0
2018-02-14	BAB	ETF	29.6	29.67	29.46	29.5	278326.0
2018-02-14	BAL	ETF	50.33	50.38	50.3	50.38	1495.0

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

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