PREVIEW / etf_daily / 2020-05-08

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-08.parquet
  size:    74 KB
  rows:    1,957

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-05-08	SPY	ETF	291.09	292.95	289.86	292.44	76452400.0
2020-05-08	QQQ	ETF	223.55	225.0	222.48	224.86	31964416.0
2020-05-08	IWM	ETF	130.16	132.75	129.19	132.36	32122900.0
2020-05-08	DIA	ETF	242.27	243.8	241.34	243.62	3894800.0
2020-05-08	GLD	ETF	161.08	162.0	160.0	160.42	12240900.0
2020-05-08	TLT	ETF	164.49	165.4	163.68	163.98	8129800.0
2020-05-08	AAAU	ETF	17.09	17.19	16.98	17.02	146400.0
2020-05-08	AADR	ETF	47.0	47.29	47.0	47.29	1000.0
2020-05-08	AAXJ	ETF	64.11	64.69	63.99	64.55	1133900.0
2020-05-08	ABEQ	ETF	21.985	22.034	21.985	22.034	300.0
2020-05-08	ACES	ETF	34.46	34.95	34.167	34.92	30200.0
2020-05-08	ACIO	ETF	24.065	24.065	23.98	24.03	14200.0
2020-05-08	ACSI	ETF	30.9001	31.1077	30.9001	31.1077	499.0
2020-05-08	ACTX	ETF	4.2775	5.9001	4.13	4.13	575.0
2020-05-08	ACWF	ETF	26.37	26.5328	26.37	26.5328	7012.0
2020-05-08	ACWI	ETF	68.94	69.34	68.73	69.26	3530900.0
2020-05-08	ACWV	ETF	86.36	86.77	86.28	86.61	608500.0
2020-05-08	ACWX	ETF	40.0	40.29	39.9801	40.22	2013219.0
2020-05-08	ADME	ETF	30.58	30.598	30.502	30.549	9700.0
2020-05-08	ADRE	ETF	35.6	36.11	35.6	36.0535	13342.0
2020-05-08	AESR	ETF	9.33	9.36	9.31	9.36	27000.0
2020-05-08	AFIF	ETF	9.81	9.81	9.76	9.785	209171.0
2020-05-08	AFK	ETF	14.6	15.19	14.6	15.0239	20872.0
2020-05-08	AFTY	ETF	16.19	16.19	16.1	16.104	3200.0
2020-05-08	AGG	ETF	116.68	116.76	116.35	116.46	3241500.0
2020-05-08	AGGY	ETF	52.94	52.94	52.53	52.87	164400.0
2020-05-08	AGNG	ETF	23.085	23.24	23.021	23.061	1100.0
2020-05-08	AGQ	ETF	21.67	22.53	21.65	21.98	465800.0
2020-05-08	AGZ	ETF	120.79	120.8699	120.42	120.61	64766.0
2020-05-08	AGZD	ETF	23.165	23.34	23.165	23.22	7600.0
2020-05-08	AIA	ETF	59.4	59.96	59.34	59.58	575495.0
2020-05-08	AIEQ	ETF	26.38	26.575	26.2	26.546	18500.0
2020-05-08	AIQ	ETF	18.38	18.5994	18.34	18.5113	10959.0
2020-05-08	AIRR	ETF	21.53	21.59	21.37	21.573	13500.0
2020-05-08	AIVI	ETF	33.17	33.33	33.17	33.3	8800.0
2020-05-08	ALTY	ETF	9.88	10.057	9.88	10.057	9200.0
2020-05-08	AMJ	ETF	13.08	13.4	12.98	13.37	2425208.0
2020-05-08	AMLP	ETF	23.65	24.4	23.55	24.25	4510160.0
2020-05-08	AMUB	ETF	7.89	8.4083	7.89	8.4083	17899.0
2020-05-08	AMZA	ETF	16.9	17.44	16.69	17.42	48900.0
2020-05-08	ANGL	ETF	26.9	27.08	26.85	27.0	974600.0
2020-05-08	AOA	ETF	51.41	51.64	51.18	51.64	51200.0
2020-05-08	AOK	ETF	35.03	35.17	35.03	35.09	274354.0
2020-05-08	AOM	ETF	38.16	38.35	38.13	38.32	382699.0
2020-05-08	AOR	ETF	44.01	44.135	43.93	44.12	116346.0
2020-05-08	ARB	ETF	25.1	25.18	25.1	25.1321	3445.0
2020-05-08	ARCM	ETF	100.88	100.915	100.525	100.525	1500.0
2020-05-08	ARGT	ETF	19.98	20.37	19.83	20.14	196500.0
2020-05-08	ARKF	ETF	25.9	26.46	25.708	26.34	101400.0
2020-05-08	ARKG	ETF	42.89	43.5	42.29	43.23	390500.0

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

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