PREVIEW / etf_daily / 2020-04-22

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-22.parquet
  size:    73 KB
  rows:    1,942

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-04-22	SPY	ETF	278.35	281.0	276.91	279.1	92951600.0
2020-04-22	QQQ	ETF	209.14	212.35	208.33	210.97	40188772.0
2020-04-22	IWM	ETF	120.32	120.99	118.77	119.17	24333800.0
2020-04-22	DIA	ETF	234.4	236.27	233.39	234.77	4318000.0
2020-04-22	GLD	ETF	160.5	161.74	160.42	161.73	12902100.0
2020-04-22	TLT	ETF	169.97	170.39	168.71	169.54	6230200.0
2020-04-22	AAAU	ETF	17.04	17.15	17.01	17.15	351800.0
2020-04-22	AADR	ETF	44.67	44.94	44.42	44.94	2200.0
2020-04-22	AAXJ	ETF	62.92	63.01	62.76	62.87	556200.0
2020-04-22	ABEQ	ETF	21.355	21.45	21.315	21.41	8700.0
2020-04-22	ACES	ETF	30.56	31.35	30.56	31.22	19200.0
2020-04-22	ACIO	ETF	23.65	23.825	23.6	23.721	12100.0
2020-04-22	ACSI	ETF	29.84	29.9157	29.84	29.9157	443.0
2020-04-22	ACTX	ETF	5.428	5.428	4.72	4.72	204.0
2020-04-22	ACWF	ETF	25.41	25.56	25.3622	25.5135	13182.0
2020-04-22	ACWI	ETF	66.08	66.55	65.85	66.29	4314200.0
2020-04-22	ACWV	ETF	85.66	86.11	85.39	85.78	525300.0
2020-04-22	ACWX	ETF	38.79	38.88	38.65	38.82	1588572.0
2020-04-22	ADME	ETF	29.67	29.93	29.648	29.76	9800.0
2020-04-22	ADRE	ETF	35.62	35.85	35.62	35.7327	5126.0
2020-04-22	AESR	ETF	8.93	8.984	8.92	8.984	1980000.0
2020-04-22	AFIF	ETF	9.78	9.8248	9.75	9.795	2435912.0
2020-04-22	AFK	ETF	13.65	13.87	13.63	13.85	24368.0
2020-04-22	AFTY	ETF	15.555	15.56	15.547	15.547	400.0
2020-04-22	AGG	ETF	117.16	117.24	116.94	117.14	4647200.0
2020-04-22	AGGY	ETF	53.09	53.15	52.92	52.96	144800.0
2020-04-22	AGNG	ETF	22.03	22.218	22.03	22.128	500.0
2020-04-22	AGQ	ETF	20.66	21.39	20.51	21.18	205000.0
2020-04-22	AGZ	ETF	120.68	120.68	120.4	120.6	59494.0
2020-04-22	AGZD	ETF	23.24	23.675	23.235	23.355	13000.0
2020-04-22	AIA	ETF	58.44	58.57	58.26	58.405	48699.0
2020-04-22	AIEQ	ETF	25.038	25.299	24.9	25.242	6000.0
2020-04-22	AIQ	ETF	17.07	17.34	17.02	17.29	35635.0
2020-04-22	AIRR	ETF	19.985	20.03	19.89	19.953	34500.0
2020-04-22	AIVI	ETF	32.1	32.1	31.93	32.04	21700.0
2020-04-22	ALTY	ETF	9.3	9.42	9.27	9.319	5600.0
2020-04-22	AMJ	ETF	11.79	11.79	11.225	11.58	2521669.0
2020-04-22	AMLP	ETF	22.05	22.2	21.25	21.8	4571280.0
2020-04-22	AMOM	ETF	25.08	25.08	25.024	25.024	100.0
2020-04-22	AMUB	ETF	7.19	7.33	7.185	7.29	17412.0
2020-04-22	AMZA	ETF	14.08	14.43	13.78	14.11	74200.0
2020-04-22	ANGL	ETF	26.84	27.0	26.57	26.7	1248900.0
2020-04-22	AOA	ETF	49.72	49.94	49.55	49.81	96100.0
2020-04-22	AOK	ETF	34.77	34.8825	34.6698	34.78	80770.0
2020-04-22	AOM	ETF	37.6	37.7599	37.53	37.72	201281.0
2020-04-22	AOR	ETF	42.9	43.04	42.77	42.97	164186.0
2020-04-22	ARCM	ETF	100.45	100.45	100.295	100.295	200.0
2020-04-22	ARGT	ETF	17.34	17.64	17.1	17.43	16700.0
2020-04-22	ARKF	ETF	22.85	23.24	22.82	23.2	48400.0
2020-04-22	ARKG	ETF	38.94	39.4	38.425	38.92	420500.0

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

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