PREVIEW / etf_daily / 2020-01-14

all etf daily files

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

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-14	SPY	ETF	327.47	328.62	326.84	327.45	62832800.0
2020-01-14	QQQ	ETF	220.75	221.21	219.74	220.08	24573340.0
2020-01-14	IWM	ETF	165.14	167.59	164.98	166.57	18323000.0
2020-01-14	DIA	ETF	288.87	290.49	288.72	289.22	2198500.0
2020-01-14	GLD	ETF	145.42	145.81	145.08	145.69	6589700.0
2020-01-14	TLT	ETF	138.18	138.82	138.14	138.73	13920300.0
2020-01-14	AAAU	ETF	15.4	15.44	15.38	15.44	43500.0
2020-01-14	AADR	ETF	54.98	55.22	54.94	55.22	6400.0
2020-01-14	AAXJ	ETF	75.95	75.98	75.61	75.94	1100000.0
2020-01-14	ACES	ETF	35.99	36.08	35.7	35.995	20200.0
2020-01-14	ACIO	ETF	25.67	25.69	25.63	25.655	13700.0
2020-01-14	ACSI	ETF	35.66	35.92	35.66	35.8856	1136.0
2020-01-14	ACTX	ETF	11.9854	11.9854	11.806	11.806	774.0
2020-01-14	ACWF	ETF	31.54	31.607	31.52	31.5437	11314.0
2020-01-14	ACWI	ETF	80.44	80.71	80.36	80.55	1863000.0
2020-01-14	ACWV	ETF	96.73	96.92	96.68	96.91	1044300.0
2020-01-14	ACWX	ETF	49.56	49.73	49.55	49.68	1316921.0
2020-01-14	ADME	ETF	30.894	30.94	30.85	30.86	21700.0
2020-01-14	ADRE	ETF	45.9267	45.95	45.6201	45.95	11681.0
2020-01-14	AESR	ETF	10.265	10.265	10.265	10.265	200.0
2020-01-14	AFIF	ETF	9.747	9.747	9.7252	9.7252	723.0
2020-01-14	AFK	ETF	20.44	20.5262	20.3513	20.42	5143.0
2020-01-14	AFLG	ETF	20.685	20.685	20.685	20.685	100.0
2020-01-14	AFTY	ETF	17.77	17.9	17.77	17.9	8000.0
2020-01-14	AGG	ETF	112.97	113.02	112.93	113.01	3625400.0
2020-01-14	AGGY	ETF	52.49	52.58	52.48	52.54	413800.0
2020-01-14	AGNG	ETF	23.87	24.106	23.8	23.96	7100.0
2020-01-14	AGQ	ETF	31.22	31.47	31.0	31.33	168100.0
2020-01-14	AGZ	ETF	116.02	116.0899	116.01	116.04	20816.0
2020-01-14	AGZD	ETF	24.135	24.135	24.04	24.09	11000.0
2020-01-14	AIA	ETF	68.69	68.94	68.585	68.94	102137.0
2020-01-14	AIEQ	ETF	29.17	29.3	29.1	29.16	38400.0
2020-01-14	AIQ	ETF	18.84	18.84	18.68	18.81	26294.0
2020-01-14	AIRR	ETF	28.85	29.115	28.81	28.878	7100.0
2020-01-14	AIVI	ETF	42.6	42.78	42.6	42.66	5200.0
2020-01-14	ALTY	ETF	14.965	14.987	14.94	14.975	15200.0
2020-01-14	AMJ	ETF	22.39	22.72	22.39	22.65	2936620.0
2020-01-14	AMLP	ETF	44.15	44.4	43.8	44.35	4954460.0
2020-01-14	AMOM	ETF	26.52	26.63	26.52	26.589	2200.0
2020-01-14	AMUB	ETF	14.29	14.29	14.2636	14.2636	1200.0
2020-01-14	AMZA	ETF	46.5	47.1	46.4	46.8	56520.0
2020-01-14	ANGL	ETF	30.03	30.06	30.01	30.06	12661700.0
2020-01-14	AOA	ETF	58.68	58.75	58.57	58.6	92500.0
2020-01-14	AOK	ETF	36.51	36.53	36.4514	36.51	56721.0
2020-01-14	AOM	ETF	40.47	40.5	40.3991	40.44	149632.0
2020-01-14	AOR	ETF	48.25	48.3205	48.23	48.31	91331.0
2020-01-14	ARCM	ETF	100.62	100.62	100.075	100.075	100.0
2020-01-14	ARGT	ETF	26.86	26.86	26.37	26.4	34700.0
2020-01-14	ARKF	ETF	25.53	25.53	25.34	25.416	47900.0
2020-01-14	ARKG	ETF	34.41	35.076	34.05	34.78	157800.0

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

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