PREVIEW / etf_daily / 2021-04-15

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-15.parquet
  size:    89 KB
  rows:    2,330

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
2021-04-15	SPY	ETF	413.74	416.16	413.69	415.87	60229800.0
2021-04-15	QQQ	ETF	339.47	342.01	336.2153	341.61	36342821.0
2021-04-15	IWM	ETF	225.09	225.12	222.26	224.29	20587300.0
2021-04-15	DIA	ETF	338.83	340.72	338.83	340.44	3881800.0
2021-04-15	GLD	ETF	164.07	165.79	164.03	165.35	8250600.0
2021-04-15	TLT	ETF	139.49	140.98	139.46	140.35	23896700.0
2021-04-15	AAA	ETF	25.04	25.05	25.04	25.05	955.0
2021-04-15	AAAU	ETF	17.42	17.61	17.42	17.57	495600.0
2021-04-15	AADR	ETF	63.81	63.99	63.75	63.78	2300.0
2021-04-15	AAXJ	ETF	93.95	93.98	93.54	93.9	610600.0
2021-04-15	ABEQ	ETF	27.18	27.209	27.13	27.2	6800.0
2021-04-15	ACES	ETF	75.02	75.2	71.99	73.05	101600.0
2021-04-15	ACIO	ETF	29.5	29.62	29.46	29.62	12800.0
2021-04-15	ACSI	ETF	48.17	48.4702	48.17	48.4702	794.0
2021-04-15	ACTV	ETF	36.34	36.66	36.34	36.5924	15426.0
2021-04-15	ACTX	ETF	4.8	4.9	4.8	4.8	798.0
2021-04-15	ACVF	ETF	31.3	31.3	30.922	31.004	10400.0
2021-04-15	ACWF	ETF	37.63	37.79	37.63	37.79	7752.0
2021-04-15	ACWI	ETF	98.95	99.31	98.89	99.29	1906100.0
2021-04-15	ACWV	ETF	100.62	101.13	100.48	101.06	620600.0
2021-04-15	ACWX	ETF	56.83	56.9366	56.77	56.92	594139.0
2021-04-15	ADFI	ETF	9.705	9.73	9.705	9.711	1500.0
2021-04-15	ADIV	ETF	19.19	19.19	18.878	18.878	1700.0
2021-04-15	ADME	ETF	38.4	38.64	38.4	38.64	10100.0
2021-04-15	ADRE	ETF	57.07	57.07	56.1701	56.25	16211.0
2021-04-15	AESR	ETF	13.12	13.22	13.12	13.18	21500.0
2021-04-15	AFIF	ETF	9.741	9.76	9.73	9.745	16370.0
2021-04-15	AFK	ETF	21.6	21.75	21.6	21.75	7838.0
2021-04-15	AFLG	ETF	24.87	24.925	24.87	24.925	15700.0
2021-04-15	AFMC	ETF	25.046	25.046	25.046	25.046	400.0
2021-04-15	AFSM	ETF	25.875	25.875	25.875	25.875	100.0
2021-04-15	AFTY	ETF	22.02	22.02	21.92	21.92	5500.0
2021-04-15	AGG	ETF	113.78	114.98	113.78	114.84	6753200.0
2021-04-15	AGGY	ETF	51.81	52.04	51.8	51.96	71200.0
2021-04-15	AGNG	ETF	28.511	28.95	28.511	28.746	7800.0
2021-04-15	AGQ	ETF	45.16	46.52	45.16	46.1	848400.0
2021-04-15	AGZ	ETF	118.13	118.4	118.13	118.34	22209.0
2021-04-15	AGZD	ETF	23.56	23.655	23.56	23.635	57200.0
2021-04-15	AIA	ETF	94.03	94.055	93.62	93.8	359946.0
2021-04-15	AIEQ	ETF	39.62	39.7	39.405	39.591	31000.0
2021-04-15	AIQ	ETF	29.83	30.075	29.8	30.0	22667.0
2021-04-15	AIRR	ETF	41.5	41.6	40.865	41.07	54500.0
2021-04-15	AIVI	ETF	43.34	43.41	43.34	43.39	3200.0
2021-04-15	ALTL	ETF	40.01	40.01	39.736	39.89	7033.0
2021-04-15	ALTY	ETF	13.13	13.13	13.06	13.105	15600.0
2021-04-15	AMJ	ETF	17.17	17.215	16.92	17.18	303835.0
2021-04-15	AMLP	ETF	31.55	31.77	31.21	31.73	1352900.0
2021-04-15	AMNA	ETF	30.18	30.1914	30.18	30.1914	301.0
2021-04-15	AMND	ETF	32.1036	32.1036	32.1036	32.1036	0.0
2021-04-15	AMOM	ETF	35.19	35.42	35.0	35.2	133900.0

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

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