PREVIEW / etf_daily / 2020-07-09

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-09.parquet
  size:    77 KB
  rows:    2,035

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-07-09	SPY	ETF	316.84	317.1	310.68	314.38	83354200.0
2020-07-09	QQQ	ETF	261.89	262.87	257.63	262.18	40312906.0
2020-07-09	IWM	ETF	142.02	142.35	137.24	139.07	34647800.0
2020-07-09	DIA	ETF	260.87	261.19	255.35	257.24	3995600.0
2020-07-09	GLD	ETF	170.48	170.64	168.78	169.63	13327400.0
2020-07-09	TLT	ETF	164.66	167.45	164.6	167.17	13373100.0
2020-07-09	AAAU	ETF	18.09	18.1	17.91	17.99	635600.0
2020-07-09	AADR	ETF	55.98	56.23	55.45	56.01	3700.0
2020-07-09	AAXJ	ETF	76.24	76.38	74.99	75.65	2798900.0
2020-07-09	ABEQ	ETF	22.086	22.086	22.086	22.086	200.0
2020-07-09	ACES	ETF	43.5	43.5	41.72	42.46	64600.0
2020-07-09	ACIO	ETF	25.41	25.43	25.182	25.289	20600.0
2020-07-09	ACSI	ETF	33.64	33.8614	33.6276	33.8614	1250.0
2020-07-09	ACTX	ETF	2.8674	3.422	2.8615	2.8645	319.0
2020-07-09	ACWF	ETF	28.09	28.41	28.09	28.2917	10804.0
2020-07-09	ACWI	ETF	76.49	76.51	75.07	75.82	7607400.0
2020-07-09	ACWV	ETF	89.11	89.11	87.63	88.4	237100.0
2020-07-09	ACWX	ETF	45.09	45.13	44.36	44.68	1259759.0
2020-07-09	ADME	ETF	32.907	32.94	32.6	32.91	6800.0
2020-07-09	ADRE	ETF	44.08	44.08	43.63	43.8909	13980.0
2020-07-09	AESR	ETF	10.24	10.24	10.14	10.191	2300.0
2020-07-09	AFIF	ETF	9.84	9.89	9.84	9.845	19970.0
2020-07-09	AFK	ETF	16.9	17.218	16.725	16.77	6712.0
2020-07-09	AFLG	ETF	19.04	19.04	19.04	19.04	200.0
2020-07-09	AFTY	ETF	19.92	19.92	19.642	19.687	20600.0
2020-07-09	AGG	ETF	118.4	118.7	118.36	118.63	3804000.0
2020-07-09	AGGY	ETF	54.06	54.19	53.98	54.19	143500.0
2020-07-09	AGNG	ETF	25.0	25.0	24.78	24.875	2200.0
2020-07-09	AGQ	ETF	31.92	32.07	30.11	30.74	1854100.0
2020-07-09	AGZ	ETF	120.91	121.04	120.8136	121.04	27892.0
2020-07-09	AGZD	ETF	23.52	23.66	23.52	23.6	5000.0
2020-07-09	AIA	ETF	70.51	70.69	69.52	69.98	150979.0
2020-07-09	AIEQ	ETF	29.22	29.34	28.821	29.24	23100.0
2020-07-09	AIQ	ETF	22.08	22.13	21.75	22.11	16357.0
2020-07-09	AIRR	ETF	22.27	22.451	22.15	22.295	13400.0
2020-07-09	AIVI	ETF	35.89	35.89	35.39	35.58	8800.0
2020-07-09	ALTL	ETF	23.5	23.5	22.935	23.0981	7626.0
2020-07-09	ALTY	ETF	10.54	10.54	10.299	10.335	8500.0
2020-07-09	AMJ	ETF	12.75	12.76	12.25	12.25	1087128.0
2020-07-09	AMLP	ETF	23.68	23.69	22.69	22.8	3795100.0
2020-07-09	AMNA	ETF	22.5475	22.5475	22.5475	22.5475	0.0
2020-07-09	AMOM	ETF	32.004	32.272	31.68	32.272	1200.0
2020-07-09	AMUB	ETF	7.85	7.99	7.71	7.72	105936.0
2020-07-09	AMZA	ETF	16.46	16.46	15.59	15.66	74600.0
2020-07-09	ANGL	ETF	28.87	28.93	28.75	28.89	664400.0
2020-07-09	AOA	ETF	55.92	55.98	55.05	55.53	55000.0
2020-07-09	AOK	ETF	36.72	36.74	36.48	36.67	126068.0
2020-07-09	AOM	ETF	40.2	40.2503	39.88	40.14	213018.0
2020-07-09	AOR	ETF	47.03	47.031	46.5	46.8	95739.0
2020-07-09	APRT	ETF	25.4296	25.4296	25.4296	25.4296	22.0

> showing 50 of 2,035 rows — these rows as CSV

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