PREVIEW / etf_daily / 2020-07-14

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-14.parquet
  size:    76 KB
  rows:    2,028

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-14	SPY	ETF	313.3	319.76	312.0	318.92	93657000.0
2020-07-14	QQQ	ETF	256.07	260.79	252.76	260.37	72230512.0
2020-07-14	IWM	ETF	139.43	141.98	138.64	141.83	28114000.0
2020-07-14	DIA	ETF	260.54	267.05	260.1	266.59	7614300.0
2020-07-14	GLD	ETF	168.97	170.2	168.81	170.19	9812700.0
2020-07-14	TLT	ETF	167.93	168.14	166.98	167.12	11344600.0
2020-07-14	AAAU	ETF	17.93	18.07	17.91	18.05	320700.0
2020-07-14	AADR	ETF	54.65	55.29	54.54	55.29	10800.0
2020-07-14	AAXJ	ETF	73.9	74.9	73.73	74.72	989300.0
2020-07-14	ABEQ	ETF	22.3	22.49	22.25	22.49	3500.0
2020-07-14	ACES	ETF	42.39	44.54	41.88	44.01	58100.0
2020-07-14	ACIO	ETF	25.52	25.54	25.45	25.54	2500.0
2020-07-14	ACSI	ETF	34.06	34.4658	34.06	34.4658	1095.0
2020-07-14	ACTX	ETF	2.655	3.5135	2.655	3.481	91.0
2020-07-14	ACWF	ETF	28.16	28.72	28.16	28.72	10332.0
2020-07-14	ACWI	ETF	75.53	76.81	75.31	76.7	2962200.0
2020-07-14	ACWV	ETF	88.21	89.58	88.17	89.46	294200.0
2020-07-14	ACWX	ETF	44.57	45.185	44.49	45.1	1781500.0
2020-07-14	ADME	ETF	32.69	32.93	32.34	32.93	6000.0
2020-07-14	ADRE	ETF	42.64	43.3732	42.4586	43.3422	3753.0
2020-07-14	AESR	ETF	10.09	10.298	10.08	10.298	3200.0
2020-07-14	AFIF	ETF	9.85	9.86	9.8207	9.835	5068.0
2020-07-14	AFK	ETF	17.0	17.0819	16.79	17.0713	6392.0
2020-07-14	AFMC	ETF	16.999	16.999	16.999	16.999	100.0
2020-07-14	AFSM	ETF	16.76	16.76	16.76	16.76	200.0
2020-07-14	AFTY	ETF	19.16	19.47	19.16	19.43	3300.0
2020-07-14	AGG	ETF	118.58	118.74	118.58	118.67	3986700.0
2020-07-14	AGGY	ETF	54.15	54.19	54.12	54.14	196000.0
2020-07-14	AGNG	ETF	24.41	25.011	24.41	25.011	1500.0
2020-07-14	AGQ	ETF	31.84	32.87	31.7	32.87	1015300.0
2020-07-14	AGZ	ETF	120.8	121.01	120.8	120.97	35970.0
2020-07-14	AGZD	ETF	23.685	23.685	23.58	23.62	7000.0
2020-07-14	AIA	ETF	68.37	69.19	68.29	69.08	54334.0
2020-07-14	AIEQ	ETF	28.64	29.18	28.503	29.16	13600.0
2020-07-14	AIQ	ETF	21.34	21.575	21.01	21.575	16451.0
2020-07-14	AIRR	ETF	22.94	23.54	22.87	23.482	25500.0
2020-07-14	AIVI	ETF	35.81	36.37	35.81	36.37	7200.0
2020-07-14	ALTL	ETF	23.85	24.1	23.83	24.1	24840.0
2020-07-14	ALTY	ETF	10.33	10.435	10.33	10.41	6300.0
2020-07-14	AMJ	ETF	12.22	12.32	12.0	12.0	811823.0
2020-07-14	AMLP	ETF	22.64	22.86	22.39	22.6	2182300.0
2020-07-14	AMNA	ETF	22.88	23.0592	22.87	23.0592	504.0
2020-07-14	AMOM	ETF	31.317	31.481	30.34	31.481	1000.0
2020-07-14	AMUB	ETF	7.64	7.735	7.62	7.6802	6701.0
2020-07-14	AMZA	ETF	15.47	15.74	15.34	15.56	66100.0
2020-07-14	ANGL	ETF	28.79	29.12	28.79	29.03	848900.0
2020-07-14	AOA	ETF	55.23	56.18	55.23	56.15	74000.0
2020-07-14	AOK	ETF	36.5	36.81	36.5	36.81	114317.0
2020-07-14	AOM	ETF	40.04	40.4	40.01	40.4	110825.0
2020-07-14	AOR	ETF	46.63	47.19	46.53	47.19	129688.0

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

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