PREVIEW / etf_daily / 2020-10-13

all etf daily files

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

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-13	SPY	ETF	352.28	352.47	349.09	350.13	73255500.0
2020-10-13	QQQ	ETF	296.34	297.0496	293.11	294.52	64240031.0
2020-10-13	IWM	ETF	162.52	163.22	161.48	162.7	20106500.0
2020-10-13	DIA	ETF	287.66	288.11	286.02	286.74	2430600.0
2020-10-13	GLD	ETF	178.56	178.6	177.1	177.72	8384300.0
2020-10-13	TLT	ETF	161.21	161.83	161.18	161.75	7914300.0
2020-10-13	AAA	ETF	24.92	24.92	24.91	24.91	364.0
2020-10-13	AAAU	ETF	18.96	18.96	18.8	18.86	583500.0
2020-10-13	AADR	ETF	58.33	58.79	58.05	58.77	7800.0
2020-10-13	AAXJ	ETF	80.64	80.78	80.32	80.67	789800.0
2020-10-13	ABEQ	ETF	23.87	23.89	23.83	23.859	5700.0
2020-10-13	ACES	ETF	60.4	60.719	60.0	60.42	178700.0
2020-10-13	ACIO	ETF	27.55	27.55	27.23	27.25	32000.0
2020-10-13	ACSI	ETF	39.6521	39.6521	39.6521	39.6521	117.0
2020-10-13	ACWF	ETF	31.15	31.15	31.005	31.0767	7033.0
2020-10-13	ACWI	ETF	83.51	83.53	83.0	83.23	4126700.0
2020-10-13	ACWV	ETF	94.34	94.51	93.96	94.3	277600.0
2020-10-13	ACWX	ETF	47.55	47.57	47.37	47.46	643982.0
2020-10-13	ADFI	ETF	10.01	10.02	9.995	9.995	136300.0
2020-10-13	ADME	ETF	35.15	35.15	34.82	34.91	30700.0
2020-10-13	ADRE	ETF	50.06	50.11	49.66	49.9297	8401.0
2020-10-13	AESR	ETF	11.46	11.47	11.436	11.436	211500.0
2020-10-13	AFIF	ETF	9.83	9.83	9.8	9.8143	311030.0
2020-10-13	AFK	ETF	17.92	17.92	17.79	17.86	2330.0
2020-10-13	AFLG	ETF	21.134	21.134	21.134	21.134	100.0
2020-10-13	AFMC	ETF	19.024	19.024	19.024	19.024	200.0
2020-10-13	AFTY	ETF	20.29	20.415	20.29	20.415	1200.0
2020-10-13	AGG	ETF	118.01	118.07	117.93	117.98	3421700.0
2020-10-13	AGGY	ETF	53.81	53.85	53.775	53.84	86700.0
2020-10-13	AGNG	ETF	26.51	26.66	26.51	26.605	6500.0
2020-10-13	AGQ	ETF	45.61	45.62	43.79	44.66	2535900.0
2020-10-13	AGZ	ETF	120.98	121.0184	120.91	121.0	59043.0
2020-10-13	AGZD	ETF	23.515	23.56	23.465	23.52	9200.0
2020-10-13	AIA	ETF	75.6	75.92	75.396	75.87	182712.0
2020-10-13	AIEQ	ETF	32.66	33.09	32.66	33.014	15200.0
2020-10-13	AIQ	ETF	24.99	25.15	24.93	25.06	44412.0
2020-10-13	AIRR	ETF	28.25	28.25	27.895	27.97	13300.0
2020-10-13	AIVI	ETF	36.84	36.85	36.74	36.81	5200.0
2020-10-13	ALTL	ETF	25.9034	25.933	25.83	25.933	4095.0
2020-10-13	ALTY	ETF	10.83	10.83	10.76	10.76	3400.0
2020-10-13	AMJ	ETF	11.76	11.85	11.645	11.8	1304720.0
2020-10-13	AMLP	ETF	21.85	21.97	21.57	21.83	3467700.0
2020-10-13	AMNA	ETF	22.38	22.38	22.32	22.3549	700.0
2020-10-13	AMND	ETF	23.51	23.5113	23.51	23.5113	200.0
2020-10-13	AMOM	ETF	37.75	37.76	37.54	37.657	2700.0
2020-10-13	AMUB	ETF	7.4	7.43	7.38	7.4087	1909.0
2020-10-13	AMZA	ETF	15.02	15.196	14.818	14.97	83700.0
2020-10-13	ANGL	ETF	30.28	30.31	30.18	30.22	515400.0
2020-10-13	AOA	ETF	59.98	59.98	59.65	59.76	36200.0
2020-10-13	AOK	ETF	37.62	37.7451	37.62	37.63	235026.0

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

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