PREVIEW / etf_daily / 2019-10-03

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-03.parquet
  size:    70 KB
  rows:    1,832

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
2019-10-03	SPY	ETF	287.81	290.45	284.82	290.42	85278800.0
2019-10-03	QQQ	ETF	184.07	186.2065	181.82	186.07	39612315.0
2019-10-03	IWM	ETF	146.69	147.94	144.93	147.74	25362800.0
2019-10-03	DIA	ETF	260.31	262.03	257.38	262.01	5610300.0
2019-10-03	GLD	ETF	141.36	143.25	141.29	141.9	12396100.0
2019-10-03	TLT	ETF	143.98	145.67	143.92	144.92	13470500.0
2019-10-03	AAAU	ETF	14.96	15.16	14.96	15.03	41300.0
2019-10-03	AADR	ETF	46.77	47.42	46.77	47.36	26700.0
2019-10-03	AAXJ	ETF	65.92	66.44	65.73	66.4	1667600.0
2019-10-03	ACES	ETF	30.04	30.265	29.84	30.26	17800.0
2019-10-03	ACIO	ETF	24.222	24.31	24.222	24.31	17300.0
2019-10-03	ACSI	ETF	33.0378	33.1414	32.86	33.1414	940.0
2019-10-03	ACTX	ETF	12.9801	15.2221	10.6201	15.2221	503.0
2019-10-03	ACWF	ETF	28.075	28.325	28.075	28.3188	9679.0
2019-10-03	ACWI	ETF	71.69	72.28	71.12	72.28	7861100.0
2019-10-03	ACWV	ETF	93.32	93.88	93.04	93.88	667900.0
2019-10-03	ACWX	ETF	44.91	45.21	44.72	45.19	1710593.0
2019-10-03	ADRE	ETF	38.08	38.56	38.08	38.525	1986.0
2019-10-03	AFIF	ETF	9.805	9.8116	9.805	9.8116	600.0
2019-10-03	AFK	ETF	20.005	20.12	19.8779	19.95	4674.0
2019-10-03	AFTY	ETF	16.75	16.75	16.667	16.73	2800.0
2019-10-03	AGG	ETF	113.34	113.74	113.32	113.64	4219100.0
2019-10-03	AGGY	ETF	52.47	52.64	52.43	52.608	233200.0
2019-10-03	AGNG	ETF	20.86	21.136	20.86	21.136	1100.0
2019-10-03	AGQ	ETF	31.16	32.15	31.12	31.4	347000.0
2019-10-03	AGZ	ETF	116.76	117.07	116.76	117.03	35636.0
2019-10-03	AGZD	ETF	23.895	23.895	23.825	23.83	14400.0
2019-10-03	AIA	ETF	58.51	58.75	58.38	58.71	53677.0
2019-10-03	AIEQ	ETF	25.51	25.75	25.2	25.71	13000.0
2019-10-03	AIQ	ETF	15.49	15.7318	15.3902	15.7318	2005.0
2019-10-03	AIRR	ETF	25.76	25.76	25.53	25.71	7900.0
2019-10-03	AIVI	ETF	39.26	39.5	39.26	39.48	3200.0
2019-10-03	ALTY	ETF	14.62	14.62	14.515	14.55	15800.0
2019-10-03	AMJ	ETF	22.8	22.98	22.59	22.97	1280590.0
2019-10-03	AMLP	ETF	44.8	45.25	44.35	45.05	3501220.0
2019-10-03	AMUB	ETF	14.39	14.4622	14.39	14.4622	5000.0
2019-10-03	AMZA	ETF	48.0	48.2	47.0	48.2	86890.0
2019-10-03	ANGL	ETF	28.96	29.03	28.91	28.96	1099700.0
2019-10-03	AOA	ETF	53.51	53.89	53.26	53.89	84600.0
2019-10-03	AOK	ETF	35.36	35.52	35.34	35.5	78594.0
2019-10-03	AOM	ETF	38.64	38.9	38.64	38.86	121637.0
2019-10-03	AOR	ETF	45.08	45.3801	44.98	45.37	104830.0
2019-10-03	ARGT	ETF	22.72	22.87	22.43	22.87	12300.0
2019-10-03	ARKF	ETF	21.06	21.315	20.907	21.312	7900.0
2019-10-03	ARKG	ETF	28.16	28.77	27.62	28.72	91600.0
2019-10-03	ARKK	ETF	41.06	41.614	40.12	41.53	337700.0
2019-10-03	ARKQ	ETF	30.67	31.13	30.371	31.04	11300.0
2019-10-03	ARKW	ETF	47.21	48.05	46.37	48.05	51000.0
2019-10-03	ASEA	ETF	15.42	15.45	15.41	15.45	1100.0
2019-10-03	ASET	ETF	29.3131	29.38	29.3131	29.38	226.0

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

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