PREVIEW / etf_daily / 2019-12-19

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-19.parquet
  size:    73 KB
  rows:    1,923

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-12-19	SPY	ETF	319.8	320.98	319.52	320.9	85310500.0
2019-12-19	QQQ	ETF	209.64	210.93	209.62	210.86	17892062.0
2019-12-19	IWM	ETF	165.28	165.73	164.88	165.73	11919800.0
2019-12-19	DIA	ETF	283.65	284.54	283.57	284.46	1815100.0
2019-12-19	GLD	ETF	139.04	139.55	138.87	139.38	4975000.0
2019-12-19	TLT	ETF	136.0	136.86	135.76	136.47	6591100.0
2019-12-19	AAAU	ETF	14.73	14.78	14.72	14.76	28800.0
2019-12-19	AADR	ETF	53.21	53.32	53.09	53.15	21400.0
2019-12-19	AAXJ	ETF	72.59	72.85	72.57	72.77	563500.0
2019-12-19	ACES	ETF	34.1	34.1	33.38	33.5	34400.0
2019-12-19	ACIO	ETF	25.647	25.71	25.647	25.681	13600.0
2019-12-19	ACSI	ETF	35.825	35.825	35.8	35.8232	1570.0
2019-12-19	ACTX	ETF	11.2042	11.8591	9.3693	11.806	3428.0
2019-12-19	ACWF	ETF	30.9361	31.01	30.8969	30.9697	56658.0
2019-12-19	ACWI	ETF	78.51	78.73	78.44	78.73	2847200.0
2019-12-19	ACWV	ETF	95.03	95.29	94.86	95.24	992200.0
2019-12-19	ACWX	ETF	48.75	48.87	48.7	48.84	1159973.0
2019-12-19	ADME	ETF	30.71	30.76	30.69	30.718	10900.0
2019-12-19	ADRE	ETF	44.41	44.4167	44.29	44.3	3008.0
2019-12-19	AESR	ETF	10.01	10.028	10.01	10.026	4600.0
2019-12-19	AFIF	ETF	9.74	9.745	9.74	9.745	1020.0
2019-12-19	AFK	ETF	21.29	21.2999	21.175	21.1975	5581.0
2019-12-19	AFLG	ETF	20.355	20.355	20.355	20.355	100.0
2019-12-19	AFMC	ETF	20.398	20.398	20.398	20.398	100.0
2019-12-19	AFSM	ETF	20.517	20.53	20.517	20.53	400.0
2019-12-19	AFTY	ETF	17.119	17.16	17.119	17.16	1400.0
2019-12-19	AGG	ETF	112.19	112.36	112.13	112.3	5613800.0
2019-12-19	AGGY	ETF	52.25	52.31	52.2	52.31	101300.0
2019-12-19	AGNG	ETF	23.71	23.846	23.588	23.742	2200.0
2019-12-19	AGQ	ETF	28.67	29.14	28.6	28.99	146000.0
2019-12-19	AGZ	ETF	115.52	115.618	115.45	115.53	14125.0
2019-12-19	AGZD	ETF	24.04	24.13	24.015	24.015	92200.0
2019-12-19	AIA	ETF	65.41	65.4636	65.23	65.4	92269.0
2019-12-19	AIEQ	ETF	28.21	28.373	28.2	28.32	15400.0
2019-12-19	AIQ	ETF	17.75	17.8388	17.75	17.8388	4972.0
2019-12-19	AIRR	ETF	29.105	29.159	29.09	29.11	5300.0
2019-12-19	AIVI	ETF	42.86	42.99	42.86	42.94	2300.0
2019-12-19	ALTY	ETF	14.93	14.99	14.93	14.96	3100.0
2019-12-19	AMJ	ETF	21.87	21.94	21.655	21.71	3988072.0
2019-12-19	AMLP	ETF	42.7	42.9	42.3	42.35	8405940.0
2019-12-19	AMOM	ETF	27.23	27.23	27.23	27.23	100.0
2019-12-19	AMUB	ETF	13.68	13.6948	13.674	13.6776	1779.0
2019-12-19	AMZA	ETF	45.4	45.8	45.1	45.2	73720.0
2019-12-19	ANGL	ETF	29.95	29.95	29.85	29.87	310900.0
2019-12-19	AOA	ETF	58.16	58.24	58.02	58.21	36900.0
2019-12-19	AOK	ETF	36.29	36.33	36.25	36.26	75393.0
2019-12-19	AOM	ETF	40.3	40.32	40.17	40.23	360178.0
2019-12-19	AOR	ETF	47.94	48.02	47.85	48.02	83530.0
2019-12-19	ARGT	ETF	25.26	25.89	25.26	25.59	131400.0
2019-12-19	ARKF	ETF	24.11	24.201	24.11	24.186	16700.0

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

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