PREVIEW / etf_daily / 2020-10-14

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-14.parquet
  size:    80 KB
  rows:    2,115

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-10-14	SPY	ETF	350.75	351.93	347.14	347.93	57727900.0
2020-10-14	QQQ	ETF	295.32	296.35	290.26	292.06	37181227.0
2020-10-14	IWM	ETF	163.01	163.91	160.94	161.09	19024900.0
2020-10-14	DIA	ETF	287.22	287.95	284.58	285.13	2264000.0
2020-10-14	GLD	ETF	179.09	179.59	178.27	178.27	9076600.0
2020-10-14	TLT	ETF	162.33	162.75	161.97	162.12	6954800.0
2020-10-14	AAA	ETF	24.92	24.92	24.91	24.91	311.0
2020-10-14	AAAU	ETF	19.01	19.05	18.9	18.9	233500.0
2020-10-14	AADR	ETF	58.78	58.78	58.0	58.15	3800.0
2020-10-14	AAXJ	ETF	80.57	80.74	80.03	80.08	693600.0
2020-10-14	ABEQ	ETF	23.882	23.9	23.81	23.83	10000.0
2020-10-14	ACES	ETF	61.03	61.11	60.25	60.59	157200.0
2020-10-14	ACIO	ETF	27.3	27.3	27.1	27.16	29500.0
2020-10-14	ACSI	ETF	39.3302	39.3302	39.3302	39.3302	105.0
2020-10-14	ACWF	ETF	31.08	31.08	30.885	30.92	5334.0
2020-10-14	ACWI	ETF	83.4	83.6	82.68	82.83	2160300.0
2020-10-14	ACWV	ETF	94.3	94.52	93.8	93.93	333600.0
2020-10-14	ACWX	ETF	47.5583	47.665	47.32	47.35	5096703.0
2020-10-14	ADFI	ETF	10.0	10.0	10.0	10.0	100.0
2020-10-14	ADME	ETF	35.19	35.19	34.66	34.73	26000.0
2020-10-14	ADRE	ETF	50.18	50.18	49.815	49.905	4667.0
2020-10-14	AESR	ETF	11.4	11.4	11.31	11.358	3600.0
2020-10-14	AFIF	ETF	9.8203	9.825	9.81	9.825	1921.0
2020-10-14	AFK	ETF	18.0	18.1375	17.8654	17.8654	5441.0
2020-10-14	AFLG	ETF	20.97	21.023	20.97	21.023	800.0
2020-10-14	AFMC	ETF	18.97	18.97	18.95	18.95	300.0
2020-10-14	AFTY	ETF	20.3	20.378	20.27	20.27	2600.0
2020-10-14	AGG	ETF	118.1	118.11	117.99	118.05	4919700.0
2020-10-14	AGGY	ETF	53.89	53.89	53.82	53.86	100200.0
2020-10-14	AGNG	ETF	26.564	26.564	26.436	26.436	1800.0
2020-10-14	AGQ	ETF	45.89	46.43	44.7	44.91	1936000.0
2020-10-14	AGZ	ETF	121.05	121.07	120.975	121.06	142681.0
2020-10-14	AGZD	ETF	23.5	23.5	23.455	23.46	8200.0
2020-10-14	AIA	ETF	75.62	75.76	75.15	75.15	105418.0
2020-10-14	AIEQ	ETF	33.05	33.075	32.53	32.6	40200.0
2020-10-14	AIQ	ETF	25.16	25.16	24.755	24.8415	22840.0
2020-10-14	AIRR	ETF	28.01	28.18	27.63	27.63	400.0
2020-10-14	AIVI	ETF	36.88	36.96	36.78	36.82	3300.0
2020-10-14	ALTL	ETF	25.97	25.97	25.7	25.7702	13722.0
2020-10-14	ALTY	ETF	10.82	10.83	10.78	10.8	50500.0
2020-10-14	AMJ	ETF	11.85	12.21	11.85	11.94	1040893.0
2020-10-14	AMLP	ETF	21.85	22.65	21.85	22.22	3355900.0
2020-10-14	AMNA	ETF	22.74	22.74	22.5297	22.5297	700.0
2020-10-14	AMND	ETF	23.7516	23.7516	23.7516	23.7516	0.0
2020-10-14	AMOM	ETF	37.79	37.79	37.14	37.273	1200.0
2020-10-14	AMUB	ETF	7.59	7.59	7.5274	7.5274	791.0
2020-10-14	AMZA	ETF	14.98	15.72	14.98	15.32	68300.0
2020-10-14	ANGL	ETF	30.24	30.26	30.06	30.16	2353400.0
2020-10-14	AOA	ETF	59.92	60.0	59.47	59.54	32100.0
2020-10-14	AOK	ETF	37.74	37.74	37.6	37.6	104095.0

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

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