PREVIEW / etf_daily / 2019-12-26

all etf daily files

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

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-26	SPY	ETF	321.65	322.95	321.64	322.94	30911200.0
2019-12-26	QQQ	ETF	212.26	213.81	212.23	213.79	17159310.0
2019-12-26	IWM	ETF	166.83	166.98	166.36	166.68	9371200.0
2019-12-26	DIA	ETF	285.23	286.1	285.2	286.06	931600.0
2019-12-26	GLD	ETF	142.06	142.47	141.91	142.38	8342500.0
2019-12-26	TLT	ETF	136.91	137.22	136.51	137.17	5290200.0
2019-12-26	AAAU	ETF	15.06	15.1	15.04	15.07	42600.0
2019-12-26	AADR	ETF	54.3	54.3	54.02	54.3	3800.0
2019-12-26	AAXJ	ETF	73.1	73.31	72.94	73.26	182200.0
2019-12-26	ACES	ETF	33.96	34.308	33.96	34.205	17000.0
2019-12-26	ACIO	ETF	26.23	26.23	25.822	25.85	5900.0
2019-12-26	ACSI	ETF	36.04	36.1043	36.04	36.1043	1146.0
2019-12-26	ACTX	ETF	11.806	12.9801	11.8001	12.1399	499.0
2019-12-26	ACWF	ETF	31.2236	31.2553	31.2	31.2143	1854.0
2019-12-26	ACWI	ETF	79.18	79.5	79.17	79.5	764600.0
2019-12-26	ACWV	ETF	95.73	95.8	95.55	95.8	107700.0
2019-12-26	ACWX	ETF	49.0	49.16	48.97	49.13	1687815.0
2019-12-26	ADME	ETF	30.85	30.85	30.634	30.676	3900.0
2019-12-26	ADRE	ETF	44.45	44.85	44.45	44.755	11401.0
2019-12-26	AESR	ETF	10.14	10.48	10.14	10.368	4000.0
2019-12-26	AFIF	ETF	9.73	9.755	9.73	9.755	290.0
2019-12-26	AFK	ETF	20.09	20.34	20.09	20.1	12061.0
2019-12-26	AFSM	ETF	20.565	20.571	20.565	20.571	200.0
2019-12-26	AFTY	ETF	16.99	17.14	16.99	17.14	2800.0
2019-12-26	AGG	ETF	112.42	112.49	112.32	112.48	6072100.0
2019-12-26	AGGY	ETF	52.2	52.21	52.15	52.21	89400.0
2019-12-26	AGNG	ETF	24.0	24.02	23.851	23.882	3300.0
2019-12-26	AGQ	ETF	32.16	32.47	31.44	31.97	480200.0
2019-12-26	AGZ	ETF	115.52	115.63	115.48	115.63	21589.0
2019-12-26	AGZD	ETF	24.03	24.055	24.025	24.025	19000.0
2019-12-26	AIA	ETF	65.57	65.7491	65.57	65.67	7692.0
2019-12-26	AIEQ	ETF	28.6	28.63	28.508	28.63	14100.0
2019-12-26	AIQ	ETF	18.07	18.1289	18.0537	18.075	4650.0
2019-12-26	AIRR	ETF	29.22	29.22	29.06	29.158	2300.0
2019-12-26	AIVI	ETF	42.63	42.73	42.6	42.69	23600.0
2019-12-26	ALTY	ETF	15.08	15.08	15.0	15.039	4200.0
2019-12-26	AMJ	ETF	21.86	22.28	21.86	22.26	2669241.0
2019-12-26	AMLP	ETF	43.15	43.55	43.05	43.55	5649740.0
2019-12-26	AMOM	ETF	26.09	26.09	26.02	26.052	800.0
2019-12-26	AMUB	ETF	14.0	14.001	13.98	14.001	850.0
2019-12-26	AMZA	ETF	46.0	46.7	45.9	46.7	75480.0
2019-12-26	ANGL	ETF	29.97	30.0	29.89	29.96	165400.0
2019-12-26	AOA	ETF	58.0	58.07	57.91	58.07	57300.0
2019-12-26	AOK	ETF	36.21	36.2899	36.19	36.26	60760.0
2019-12-26	AOM	ETF	40.1	40.15	40.07	40.15	179673.0
2019-12-26	AOR	ETF	47.79	47.87	47.71	47.87	160546.0
2019-12-26	ARCM	ETF	99.955	99.955	99.955	99.955	100.0
2019-12-26	ARGT	ETF	27.13	27.92	27.13	27.66	47600.0
2019-12-26	ARKF	ETF	24.37	24.53	24.37	24.488	14400.0
2019-12-26	ARKG	ETF	36.63	36.63	35.97	36.03	76200.0

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

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