PREVIEW / etf_daily / 2020-04-30

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-30.parquet
  size:    75 KB
  rows:    1,964

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-30	SPY	ETF	291.71	293.32	288.59	290.48	122901700.0
2020-04-30	QQQ	ETF	220.01	220.04	217.35	218.91	43359476.0
2020-04-30	IWM	ETF	131.9	132.94	130.14	130.31	43727500.0
2020-04-30	DIA	ETF	244.2	245.17	241.91	243.22	4928900.0
2020-04-30	GLD	ETF	160.22	160.82	158.13	158.8	13633500.0
2020-04-30	TLT	ETF	168.74	169.23	166.71	166.74	11606100.0
2020-04-30	AAAU	ETF	17.0	17.43	16.75	16.84	617400.0
2020-04-30	AADR	ETF	46.62	46.62	45.98	45.99	2200.0
2020-04-30	AAXJ	ETF	65.07	65.35	63.71	63.99	975000.0
2020-04-30	ABEQ	ETF	22.07	22.07	21.93	21.964	900.0
2020-04-30	ACES	ETF	35.0	35.0	33.536	33.681	30000.0
2020-04-30	ACIO	ETF	24.04	24.078	24.0	24.078	4900.0
2020-04-30	ACSI	ETF	31.1311	31.1311	31.1311	31.1311	275.0
2020-04-30	ACTX	ETF	5.8676	5.8676	4.189	4.9088	453.0
2020-04-30	ACWF	ETF	26.71	26.89	26.25	26.3687	23295.0
2020-04-30	ACWI	ETF	69.26	69.33	68.37	68.72	20850300.0
2020-04-30	ACWV	ETF	87.21	87.21	86.13	86.25	664600.0
2020-04-30	ACWX	ETF	40.46	40.53	39.8634	40.05	4546183.0
2020-04-30	ADME	ETF	30.34	30.34	30.14	30.234	22200.0
2020-04-30	ADRE	ETF	36.89	36.89	36.09	36.09	2368.0
2020-04-30	AESR	ETF	9.33	9.33	9.242	9.281	3400.0
2020-04-30	AFIF	ETF	9.811	9.829	9.76	9.785	17715.0
2020-04-30	AFK	ETF	15.0	15.03	14.73	14.75	7659.0
2020-04-30	AFLG	ETF	17.76	17.784	17.76	17.784	300.0
2020-04-30	AFTY	ETF	15.94	15.95	15.58	15.653	18000.0
2020-04-30	AGG	ETF	117.38	117.49	117.07	117.1	10487500.0
2020-04-30	AGGY	ETF	53.19	53.32	53.01	53.12	441000.0
2020-04-30	AGNG	ETF	22.79	22.816	22.658	22.66	1300.0
2020-04-30	AGQ	ETF	20.56	20.9	19.53	20.19	404500.0
2020-04-30	AGZ	ETF	120.85	120.85	120.655	120.71	53272.0
2020-04-30	AGZD	ETF	23.4	23.62	23.175	23.415	10800.0
2020-04-30	AIA	ETF	60.6	60.7878	59.23	59.43	88275.0
2020-04-30	AIEQ	ETF	25.63	25.77	25.478	25.53	21500.0
2020-04-30	AIQ	ETF	17.935	18.06	17.75	17.8499	38313.0
2020-04-30	AIRR	ETF	22.8	22.8	21.98	22.066	33400.0
2020-04-30	AIVI	ETF	33.7	33.7	33.37	33.51	5500.0
2020-04-30	ALTY	ETF	10.34	10.34	10.072	10.155	14800.0
2020-04-30	AMJ	ETF	14.3	14.395	13.498	13.65	9302638.0
2020-04-30	AMLP	ETF	26.5	26.95	25.25	25.65	7114300.0
2020-04-30	AMUB	ETF	8.95	8.95	8.536	8.6	25370.0
2020-04-30	AMZA	ETF	18.94	19.316	17.77	18.15	167400.0
2020-04-30	ANGL	ETF	27.02	28.0	26.89	27.19	1294300.0
2020-04-30	AOA	ETF	51.75	51.75	51.22	51.41	123600.0
2020-04-30	AOK	ETF	35.15	35.3185	35.0901	35.24	178374.0
2020-04-30	AOM	ETF	38.43	38.43	38.12	38.23	286869.0
2020-04-30	AOR	ETF	44.17	44.17	43.81	43.89	159325.0
2020-04-30	ARGT	ETF	18.63	18.75	17.97	18.04	13800.0
2020-04-30	ARKF	ETF	24.48	24.58	24.144	24.22	41500.0
2020-04-30	ARKG	ETF	41.83	42.0	40.65	40.69	265700.0
2020-04-30	ARKK	ETF	56.72	57.0	55.1	55.33	781300.0

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

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