PREVIEW / etf_daily / 2020-01-27

all etf daily files

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

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-27	SPY	ETF	323.03	325.12	322.66	323.5	84062500.0
2020-01-27	QQQ	ETF	217.72	219.2845	217.18	218.1	42264418.0
2020-01-27	IWM	ETF	162.85	164.49	162.42	163.51	18539000.0
2020-01-27	DIA	ETF	284.85	286.65	283.86	285.36	4129100.0
2020-01-27	GLD	ETF	149.24	149.32	148.46	148.99	9988100.0
2020-01-27	TLT	ETF	143.95	144.29	143.5	144.29	10935200.0
2020-01-27	AAAU	ETF	15.8	15.8	15.74	15.79	56800.0
2020-01-27	AADR	ETF	54.32	54.47	53.95	54.37	9300.0
2020-01-27	AAXJ	ETF	69.84	71.01	69.57	70.68	1037100.0
2020-01-27	ABEQ	ETF	24.62	24.65	24.598	24.598	24300.0
2020-01-27	ACES	ETF	36.0	36.05	35.69	35.853	45300.0
2020-01-27	ACIO	ETF	25.435	25.469	25.421	25.421	5600.0
2020-01-27	ACSI	ETF	35.57	35.83	35.57	35.7939	3676.0
2020-01-27	ACTX	ETF	10.0301	11.1511	10.0301	10.6201	266.0
2020-01-27	ACWF	ETF	30.89	31.07	30.8899	30.9228	20083.0
2020-01-27	ACWI	ETF	78.73	79.13	78.55	78.78	1887200.0
2020-01-27	ACWV	ETF	96.96	97.72	96.66	97.51	252400.0
2020-01-27	ACWX	ETF	47.96	48.18	47.82	47.97	2456936.0
2020-01-27	ADME	ETF	30.68	30.86	30.68	30.72	19400.0
2020-01-27	ADRE	ETF	42.03	42.57	42.0	42.41	19504.0
2020-01-27	AESR	ETF	10.18	10.19	10.15	10.18	34200.0
2020-01-27	AFIF	ETF	9.74	9.7596	9.74	9.7452	1013.0
2020-01-27	AFK	ETF	20.0	20.0019	19.6	19.65	15167.0
2020-01-27	AFLG	ETF	20.554	20.554	20.554	20.554	100.0
2020-01-27	AFMC	ETF	20.249	20.249	20.249	20.249	100.0
2020-01-27	AFSM	ETF	20.238	20.238	20.238	20.238	100.0
2020-01-27	AFTY	ETF	15.59	15.77	15.59	15.74	16700.0
2020-01-27	AGG	ETF	114.14	114.16	114.05	114.14	4790000.0
2020-01-27	AGGY	ETF	52.99	53.02	52.949	53.0	171500.0
2020-01-27	AGNG	ETF	23.84	23.9	23.46	23.698	15000.0
2020-01-27	AGQ	ETF	32.86	32.89	32.08	32.27	211600.0
2020-01-27	AGZ	ETF	117.02	117.04	116.95	117.02	68154.0
2020-01-27	AGZD	ETF	24.055	24.07	24.0	24.02	14600.0
2020-01-27	AIA	ETF	63.27	64.56	63.27	64.1924	223454.0
2020-01-27	AIEQ	ETF	28.73	28.944	28.55	28.82	88700.0
2020-01-27	AIQ	ETF	18.6	18.7147	18.44	18.5935	18628.0
2020-01-27	AIRR	ETF	28.33	28.55	28.07	28.441	43700.0
2020-01-27	AIVI	ETF	41.62	41.65	41.52	41.56	13000.0
2020-01-27	ALTY	ETF	14.9	14.9	14.825	14.853	27200.0
2020-01-27	AMJ	ETF	21.0	21.085	20.89	20.98	2940551.0
2020-01-27	AMLP	ETF	41.0	41.1	40.8	41.0	4772540.0
2020-01-27	AMOM	ETF	26.525	26.525	26.525	26.525	100.0
2020-01-27	AMUB	ETF	13.2101	13.2391	13.2101	13.2391	146.0
2020-01-27	AMZA	ETF	40.7	41.4	40.6	41.0	121400.0
2020-01-27	ANGL	ETF	29.81	29.82	29.61	29.76	1687200.0
2020-01-27	AOA	ETF	57.76	57.95	57.5	57.7	97400.0
2020-01-27	AOK	ETF	36.66	36.66	36.475	36.53	125528.0
2020-01-27	AOM	ETF	40.39	40.49	40.2546	40.34	169112.0
2020-01-27	AOR	ETF	47.81	47.91	47.71	47.77	138213.0
2020-01-27	ARCM	ETF	100.22	100.22	100.165	100.165	600.0

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

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