PREVIEW / etf_daily / 2019-12-27

all etf daily files

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

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-27	SPY	ETF	323.74	323.8	322.28	322.86	42528800.0
2019-12-27	QQQ	ETF	214.55	214.56	213.04	213.61	18142239.0
2019-12-27	IWM	ETF	167.12	167.12	165.43	165.86	12261800.0
2019-12-27	DIA	ETF	286.83	286.85	285.9	286.33	1930200.0
2019-12-27	GLD	ETF	142.26	142.73	142.17	142.33	5119900.0
2019-12-27	TLT	ETF	137.44	137.63	137.29	137.32	7300500.0
2019-12-27	AAAU	ETF	15.08	15.11	15.07	15.08	64600.0
2019-12-27	AADR	ETF	54.57	54.8	54.06	54.51	9700.0
2019-12-27	AAXJ	ETF	73.82	73.93	73.54	73.7	2165600.0
2019-12-27	ACES	ETF	34.35	34.35	33.95	34.037	10700.0
2019-12-27	ACIO	ETF	25.925	25.925	25.82	25.91	6400.0
2019-12-27	ACSI	ETF	36.1783	36.1783	36.0908	36.0908	785.0
2019-12-27	ACTX	ETF	11.806	12.6851	11.806	11.806	216.0
2019-12-27	ACWF	ETF	31.22	31.3062	31.22	31.27	3071.0
2019-12-27	ACWI	ETF	79.92	79.92	79.41	79.55	1247200.0
2019-12-27	ACWV	ETF	96.02	96.02	95.76	95.98	171700.0
2019-12-27	ACWX	ETF	49.38	49.38	49.2	49.22	1425851.0
2019-12-27	ADME	ETF	30.79	30.79	30.679	30.693	6800.0
2019-12-27	ADRE	ETF	45.12	45.12	44.716	44.7465	15362.0
2019-12-27	AESR	ETF	10.125	10.125	10.125	10.125	400.0
2019-12-27	AFIF	ETF	9.755	9.78	9.755	9.755	4669.0
2019-12-27	AFK	ETF	20.34	20.38	20.15	20.19	8072.0
2019-12-27	AFSM	ETF	20.501	20.501	20.501	20.501	100.0
2019-12-27	AFTY	ETF	17.141	17.16	17.13	17.132	9300.0
2019-12-27	AGG	ETF	112.6	112.64	112.58	112.63	4733800.0
2019-12-27	AGGY	ETF	52.3	52.32	52.25	52.31	140600.0
2019-12-27	AGNG	ETF	24.02	24.02	23.71	23.95	2400.0
2019-12-27	AGQ	ETF	31.85	32.14	31.31	31.33	418600.0
2019-12-27	AGZ	ETF	115.7	115.74	115.6511	115.66	98676.0
2019-12-27	AGZD	ETF	24.04	24.06	24.04	24.045	7800.0
2019-12-27	AIA	ETF	66.3	66.45	66.2417	66.35	13676.0
2019-12-27	AIEQ	ETF	28.7	28.7	28.55	28.602	13700.0
2019-12-27	AIQ	ETF	18.2	18.2	18.0657	18.08	5335.0
2019-12-27	AIRR	ETF	29.16	29.16	28.92	28.93	27700.0
2019-12-27	AIVI	ETF	42.98	42.98	42.82	42.82	3900.0
2019-12-27	ALTY	ETF	15.15	15.15	15.04	15.04	4700.0
2019-12-27	AMJ	ETF	22.34	22.34	21.82	21.94	2696384.0
2019-12-27	AMLP	ETF	43.45	43.55	42.65	42.85	4795220.0
2019-12-27	AMOM	ETF	26.09	26.09	26.09	26.09	100.0
2019-12-27	AMUB	ETF	13.8347	13.8347	13.8347	13.8347	347.0
2019-12-27	AMZA	ETF	46.8	46.8	45.5	45.7	63380.0
2019-12-27	ANGL	ETF	30.0	30.0	29.88	29.97	218700.0
2019-12-27	AOA	ETF	58.1	58.27	58.07	58.15	46600.0
2019-12-27	AOK	ETF	36.33	36.35	36.28	36.31	116021.0
2019-12-27	AOM	ETF	40.09	40.2	40.09	40.14	154474.0
2019-12-27	AOR	ETF	47.87	48.0	47.87	47.93	195651.0
2019-12-27	ARCM	ETF	99.975	99.975	99.975	99.975	100.0
2019-12-27	ARGT	ETF	27.88	27.88	27.14	27.24	57800.0
2019-12-27	ARKF	ETF	24.34	24.34	24.13	24.212	41300.0
2019-12-27	ARKG	ETF	35.2	35.22	34.35	34.43	237100.0

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

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