PREVIEW / etf_daily / 2020-01-21

all etf daily files

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

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-21	SPY	ETF	330.9	332.18	330.82	331.3	77742400.0
2020-01-21	QQQ	ETF	222.73	223.84	222.66	223.28	21146264.0
2020-01-21	IWM	ETF	168.36	168.99	167.27	167.67	17935100.0
2020-01-21	DIA	ETF	292.44	293.28	291.37	291.83	4476900.0
2020-01-21	GLD	ETF	145.77	146.86	145.55	146.74	6086100.0
2020-01-21	TLT	ETF	138.81	139.65	138.77	139.47	6794900.0
2020-01-21	AAAU	ETF	15.45	15.67	15.44	15.55	164200.0
2020-01-21	AADR	ETF	55.91	56.25	55.62	55.94	31800.0
2020-01-21	AAXJ	ETF	74.28	74.45	74.03	74.18	1418800.0
2020-01-21	ACES	ETF	38.02	38.02	36.41	36.82	133800.0
2020-01-21	ACIO	ETF	25.74	25.75	25.688	25.712	9300.0
2020-01-21	ACSI	ETF	36.228	36.2975	36.2	36.2975	1373.0
2020-01-21	ACTX	ETF	11.8001	12.6851	11.8001	12.0951	59.0
2020-01-21	ACWF	ETF	31.76	31.76	31.6201	31.6539	11086.0
2020-01-21	ACWI	ETF	80.89	81.11	80.8	80.87	2564500.0
2020-01-21	ACWV	ETF	97.99	98.32	97.99	98.21	496100.0
2020-01-21	ACWX	ETF	49.58	49.6154	49.39	49.39	1528614.0
2020-01-21	ADME	ETF	31.2	31.26	31.2	31.22	5600.0
2020-01-21	ADRE	ETF	44.85	44.85	44.46	44.595	11943.0
2020-01-21	AESR	ETF	10.39	10.39	10.355	10.355	2600.0
2020-01-21	AFIF	ETF	9.73	9.77	9.73	9.755	4320.0
2020-01-21	AFK	ETF	20.28	20.4216	20.15	20.21	28657.0
2020-01-21	AFLG	ETF	20.94	20.94	20.909	20.909	200.0
2020-01-21	AFTY	ETF	17.08	17.199	17.08	17.16	7200.0
2020-01-21	AGG	ETF	113.25	113.41	113.22	113.37	4672100.0
2020-01-21	AGGY	ETF	52.61	52.64	52.54	52.6	227000.0
2020-01-21	AGNG	ETF	24.13	24.321	24.09	24.26	1900.0
2020-01-21	AGQ	ETF	30.7	31.51	30.63	31.24	508400.0
2020-01-21	AGZ	ETF	116.39	116.39	116.01	116.37	23888.0
2020-01-21	AGZD	ETF	24.07	24.11	24.02	24.07	24400.0
2020-01-21	AIA	ETF	67.32	67.32	66.93	67.09	522717.0
2020-01-21	AIEQ	ETF	29.54	29.65	29.5	29.58	22500.0
2020-01-21	AIQ	ETF	19.01	19.01	18.88	18.915	43458.0
2020-01-21	AIRR	ETF	29.24	29.24	29.05	29.09	3900.0
2020-01-21	AIVI	ETF	42.83	42.83	42.68	42.68	5700.0
2020-01-21	ALTY	ETF	15.08	15.08	15.01	15.03	42100.0
2020-01-21	AMJ	ETF	22.55	22.55	22.09	22.14	2825954.0
2020-01-21	AMLP	ETF	44.05	44.1	43.05	43.2	5617940.0
2020-01-21	AMOM	ETF	27.02	27.02	26.98	27.012	500.0
2020-01-21	AMUB	ETF	14.065	14.065	13.9296	13.9296	7951.0
2020-01-21	AMZA	ETF	45.9	46.0	44.4	44.5	197330.0
2020-01-21	ANGL	ETF	30.24	30.25	30.03	30.03	860700.0
2020-01-21	AOA	ETF	59.03	59.05	58.84	58.92	101900.0
2020-01-21	AOK	ETF	36.69	36.69	36.61	36.61	132163.0
2020-01-21	AOM	ETF	40.53	40.65	40.53	40.6	204444.0
2020-01-21	AOR	ETF	48.56	48.6	48.41	48.47	172121.0
2020-01-21	ARCM	ETF	100.09	100.09	100.09	100.09	100.0
2020-01-21	ARGT	ETF	26.7	26.7	26.04	26.04	49500.0
2020-01-21	ARKF	ETF	25.54	25.651	25.43	25.51	60000.0
2020-01-21	ARKG	ETF	35.17	35.25	34.534	34.59	193700.0

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

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