PREVIEW / etf_daily / 2020-01-15

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-15.parquet
  size:    74 KB
  rows:    1,931

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
2020-01-15	SPY	ETF	327.35	329.02	327.26	328.19	72056600.0
2020-01-15	QQQ	ETF	220.18	221.2	219.45	220.17	25742084.0
2020-01-15	IWM	ETF	166.15	167.95	166.14	167.37	15437200.0
2020-01-15	DIA	ETF	289.01	291.24	288.95	290.35	2195100.0
2020-01-15	GLD	ETF	146.21	146.73	145.82	146.54	6510000.0
2020-01-15	TLT	ETF	139.52	139.76	139.02	139.65	6290500.0
2020-01-15	AAAU	ETF	15.5	15.54	15.45	15.52	41800.0
2020-01-15	AADR	ETF	55.19	55.53	55.13	55.38	1700.0
2020-01-15	AAXJ	ETF	75.51	75.66	75.26	75.45	1509900.0
2020-01-15	ACES	ETF	36.15	36.151	35.8	36.06	28100.0
2020-01-15	ACIO	ETF	25.64	25.64	25.59	25.616	13800.0
2020-01-15	ACSI	ETF	35.74	36.05	35.74	35.9588	8198.0
2020-01-15	ACTX	ETF	11.9771	11.9771	11.806	11.806	567.0
2020-01-15	ACWF	ETF	31.5216	31.5285	31.4301	31.4869	3469.0
2020-01-15	ACWI	ETF	80.44	80.72	80.38	80.5	1618600.0
2020-01-15	ACWV	ETF	96.87	97.37	96.87	97.29	1566000.0
2020-01-15	ACWX	ETF	49.61	49.68	49.53	49.57	1160329.0
2020-01-15	ADME	ETF	30.77	31.02	30.77	30.96	193900.0
2020-01-15	ADRE	ETF	45.51	45.5453	45.04	45.18	13490.0
2020-01-15	AESR	ETF	10.26	10.26	10.25	10.25	2000.0
2020-01-15	AFIF	ETF	9.73	9.7502	9.73	9.7502	642.0
2020-01-15	AFK	ETF	20.52	20.52	20.36	20.36	45712.0
2020-01-15	AFTY	ETF	17.62	17.75	17.62	17.73	2500.0
2020-01-15	AGG	ETF	113.18	113.19	113.07	113.18	3896300.0
2020-01-15	AGGY	ETF	52.63	52.63	52.56	52.62	171600.0
2020-01-15	AGNG	ETF	24.01	24.106	23.974	23.993	3400.0
2020-01-15	AGQ	ETF	31.71	32.1	31.59	32.02	98600.0
2020-01-15	AGZ	ETF	116.16	116.2	116.11	116.1666	56999.0
2020-01-15	AGZD	ETF	24.105	24.12	24.045	24.095	9400.0
2020-01-15	AIA	ETF	68.31	68.385	68.04	68.2	69037.0
2020-01-15	AIEQ	ETF	29.15	29.349	29.15	29.24	18300.0
2020-01-15	AIQ	ETF	18.83	18.89	18.7566	18.775	13191.0
2020-01-15	AIRR	ETF	28.87	29.036	28.818	28.93	9200.0
2020-01-15	AIVI	ETF	42.6	42.75	42.6	42.69	6500.0
2020-01-15	ALTY	ETF	14.99	15.03	14.975	15.015	8100.0
2020-01-15	AMJ	ETF	22.68	22.74	22.565	22.68	2156725.0
2020-01-15	AMLP	ETF	44.3	44.45	44.05	44.35	4748140.0
2020-01-15	AMOM	ETF	26.661	26.661	26.661	26.661	100.0
2020-01-15	AMUB	ETF	14.3	14.3	14.2863	14.2863	1202.0
2020-01-15	AMZA	ETF	46.8	47.1	46.6	46.9	61010.0
2020-01-15	ANGL	ETF	30.05	30.15	30.05	30.14	828900.0
2020-01-15	AOA	ETF	58.55	58.81	58.55	58.65	72500.0
2020-01-15	AOK	ETF	36.45	36.5783	36.45	36.54	51233.0
2020-01-15	AOM	ETF	40.5	40.54	40.44	40.45	157660.0
2020-01-15	AOR	ETF	48.32	48.4	48.27	48.27	88063.0
2020-01-15	ARGT	ETF	26.38	26.46	26.11	26.17	27300.0
2020-01-15	ARKF	ETF	25.45	25.709	25.45	25.525	51900.0
2020-01-15	ARKG	ETF	34.77	35.52	34.77	35.16	321500.0
2020-01-15	ARKK	ETF	53.2	54.035	53.15	53.43	335300.0
2020-01-15	ARKQ	ETF	39.61	39.68	39.098	39.151	51800.0

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

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