PREVIEW / etf_daily / 2019-12-31

all etf daily files

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

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-31	SPY	ETF	320.53	322.13	320.15	321.86	57077300.0
2019-12-31	QQQ	ETF	211.62	212.76	211.2	212.61	18201585.0
2019-12-31	IWM	ETF	165.08	166.35	164.71	165.67	17362400.0
2019-12-31	DIA	ETF	283.91	285.31	283.56	285.1	1341300.0
2019-12-31	GLD	ETF	143.31	143.6	142.8	142.9	5313500.0
2019-12-31	TLT	ETF	136.21	136.46	135.38	135.48	10707400.0
2019-12-31	AAAU	ETF	15.19	15.21	15.15	15.15	169000.0
2019-12-31	AADR	ETF	54.35	54.35	53.88	53.89	10400.0
2019-12-31	AAXJ	ETF	73.26	73.53	73.16	73.5	213800.0
2019-12-31	ACES	ETF	33.7	33.87	33.7	33.76	13000.0
2019-12-31	ACIO	ETF	25.6	25.607	25.555	25.607	10600.0
2019-12-31	ACSI	ETF	35.38	35.457	35.36	35.457	3157.0
2019-12-31	ACTX	ETF	11.8031	13.5701	11.8031	12.6881	531.0
2019-12-31	ACWF	ETF	31.1694	31.2	31.12	31.2	8320.0
2019-12-31	ACWI	ETF	78.96	79.31	78.89	79.25	2046800.0
2019-12-31	ACWV	ETF	95.64	95.85	95.43	95.83	217500.0
2019-12-31	ACWX	ETF	48.98	49.125	48.8565	49.12	1460522.0
2019-12-31	ADME	ETF	30.31	30.67	30.31	30.66	19800.0
2019-12-31	ADRE	ETF	44.13	44.42	44.11	44.17	9249.0
2019-12-31	AESR	ETF	10.045	10.074	10.045	10.074	2000.0
2019-12-31	AFIF	ETF	9.7164	9.7164	9.68	9.695	5192.0
2019-12-31	AFK	ETF	20.24	20.4945	20.2101	20.285	15131.0
2019-12-31	AFLG	ETF	20.506	20.506	20.506	20.506	100.0
2019-12-31	AFTY	ETF	17.39	17.43	17.39	17.425	3200.0
2019-12-31	AGG	ETF	112.54	112.54	112.37	112.37	6807600.0
2019-12-31	AGGY	ETF	52.28	52.281	52.227	52.25	152600.0
2019-12-31	AGNG	ETF	23.76	23.799	23.56	23.56	1400.0
2019-12-31	AGQ	ETF	32.0	32.13	31.53	31.65	440500.0
2019-12-31	AGZ	ETF	115.58	115.7	115.51	115.58	34071.0
2019-12-31	AGZD	ETF	24.04	24.05	23.995	24.035	14200.0
2019-12-31	AIA	ETF	65.74	66.0	65.63	66.0	13674.0
2019-12-31	AIEQ	ETF	28.41	28.5	28.383	28.45	17200.0
2019-12-31	AIQ	ETF	17.84	17.9	17.785	17.9	5905.0
2019-12-31	AIRR	ETF	29.135	29.15	29.0	29.0	7200.0
2019-12-31	AIVI	ETF	42.52	42.62	42.42	42.62	5900.0
2019-12-31	ALTY	ETF	14.72	14.804	14.72	14.79	20700.0
2019-12-31	AMJ	ETF	21.58	21.81	21.49	21.81	4369106.0
2019-12-31	AMLP	ETF	42.0	42.6	42.0	42.5	4822220.0
2019-12-31	AMOM	ETF	25.93	25.93	25.93	25.93	100.0
2019-12-31	AMUB	ETF	13.7213	13.7213	13.7213	13.7213	0.0
2019-12-31	AMZA	ETF	44.7	45.4	44.3	45.2	86540.0
2019-12-31	ANGL	ETF	29.8	29.85	29.75	29.85	161600.0
2019-12-31	AOA	ETF	57.86	58.0	57.77	58.0	64200.0
2019-12-31	AOK	ETF	36.26	36.271	36.1802	36.24	85110.0
2019-12-31	AOM	ETF	40.03	40.13	40.0109	40.13	99156.0
2019-12-31	AOR	ETF	47.74	47.84	47.6869	47.84	103524.0
2019-12-31	ARCM	ETF	99.995	100.07	99.993	99.995	1000.0
2019-12-31	ARGT	ETF	26.79	26.83	26.45	26.59	48300.0
2019-12-31	ARKF	ETF	23.89	23.99	23.87	23.985	11600.0
2019-12-31	ARKG	ETF	33.29	33.65	33.25	33.52	408400.0

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

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