PREVIEW / etf_daily / 2019-12-13

all etf daily files

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

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-13	SPY	ETF	316.87	318.67	316.02	317.32	81503900.0
2019-12-13	QQQ	ETF	206.36	207.91	205.96	207.19	32534393.0
2019-12-13	IWM	ETF	163.73	164.81	162.55	163.33	23279600.0
2019-12-13	DIA	ETF	281.93	283.61	281.0	282.11	3065500.0
2019-12-13	GLD	ETF	138.52	139.21	137.98	139.05	6964300.0
2019-12-13	TLT	ETF	138.12	139.61	137.23	139.04	11335100.0
2019-12-13	AAAU	ETF	14.68	14.74	14.63	14.74	41500.0
2019-12-13	AADR	ETF	52.48	52.8	52.44	52.54	6500.0
2019-12-13	AAXJ	ETF	72.61	73.11	72.25	72.42	1470000.0
2019-12-13	ACES	ETF	32.78	32.91	32.56	32.56	15100.0
2019-12-13	ACIO	ETF	25.521	25.522	25.513	25.522	600.0
2019-12-13	ACSI	ETF	35.3447	35.37	35.3447	35.3645	905.0
2019-12-13	ACTX	ETF	6.7851	7.0801	6.4901	6.4901	362.0
2019-12-13	ACWF	ETF	31.12	31.12	31.0567	31.0916	51801.0
2019-12-13	ACWI	ETF	78.8	79.23	78.56	78.88	3235600.0
2019-12-13	ACWV	ETF	95.84	96.03	95.64	95.95	192700.0
2019-12-13	ACWX	ETF	49.18	49.48	49.035	49.24	1627254.0
2019-12-13	ADME	ETF	30.58	30.58	30.448	30.469	2600.0
2019-12-13	ADRE	ETF	43.78	43.78	43.5347	43.585	6607.0
2019-12-13	AFIF	ETF	9.77	9.79	9.77	9.79	49864.0
2019-12-13	AFK	ETF	20.61	20.71	20.59	20.595	136198.0
2019-12-13	AFLG	ETF	20.22	20.22	20.19	20.201	2300.0
2019-12-13	AFMC	ETF	20.14	20.14	20.122	20.122	1000.0
2019-12-13	AFSM	ETF	20.275	20.291	20.275	20.291	900.0
2019-12-13	AFTY	ETF	17.2	17.2	16.89	16.94	10300.0
2019-12-13	AGG	ETF	112.58	112.86	112.4	112.81	5911000.0
2019-12-13	AGGY	ETF	52.26	52.38	52.17	52.38	193500.0
2019-12-13	AGNG	ETF	23.57	23.76	23.52	23.76	6500.0
2019-12-13	AGQ	ETF	28.36	28.66	28.23	28.56	173600.0
2019-12-13	AGZ	ETF	115.9	116.06	115.815	116.0	17980.0
2019-12-13	AGZD	ETF	24.005	24.075	24.005	24.065	4200.0
2019-12-13	AIA	ETF	65.38	65.94	65.01	65.11	68967.0
2019-12-13	AIEQ	ETF	27.77	27.935	27.68	27.86	17200.0
2019-12-13	AIQ	ETF	17.34	17.559	17.34	17.522	8825.0
2019-12-13	AIRR	ETF	29.15	29.19	28.751	28.79	20100.0
2019-12-13	AIVI	ETF	42.75	42.94	42.73	42.84	5100.0
2019-12-13	ALTY	ETF	14.69	14.74	14.69	14.735	8300.0
2019-12-13	AMJ	ETF	21.09	21.19	20.74	20.91	2644140.0
2019-12-13	AMLP	ETF	41.4	41.4	40.4	40.65	6937580.0
2019-12-13	AMOM	ETF	27.073	27.073	27.073	27.073	100.0
2019-12-13	AMUB	ETF	13.146	13.146	13.146	13.146	0.0
2019-12-13	AMZA	ETF	43.5	43.6	42.5	42.8	56230.0
2019-12-13	ANGL	ETF	29.54	29.61	29.52	29.6	420600.0
2019-12-13	AOA	ETF	57.67	57.92	57.64	57.79	39000.0
2019-12-13	AOK	ETF	36.2	36.29	36.1504	36.21	42808.0
2019-12-13	AOM	ETF	40.09	40.2199	40.06	40.14	146506.0
2019-12-13	AOR	ETF	47.67	47.82	47.6602	47.72	65182.0
2019-12-13	ARCM	ETF	100.18	100.255	100.18	100.255	1400.0
2019-12-13	ARGT	ETF	24.62	25.26	24.62	24.98	148400.0
2019-12-13	ARKF	ETF	23.81	23.81	23.67	23.687	11500.0

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

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