PREVIEW / etf_daily / 2021-02-19

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-19.parquet
  size:    86 KB
  rows:    2,267

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-02-19	SPY	ETF	392.07	392.38	389.55	390.03	83241000.0
2021-02-19	QQQ	ETF	333.86	333.99	329.97	331.02	39157677.0
2021-02-19	IWM	ETF	222.46	226.3	222.17	225.19	31238200.0
2021-02-19	DIA	ETF	315.61	316.34	314.58	314.92	2314900.0
2021-02-19	GLD	ETF	166.76	167.94	166.6	167.01	8273500.0
2021-02-19	TLT	ETF	144.06	144.32	142.85	143.27	12741700.0
2021-02-19	AAA	ETF	25.13	25.13	25.13	25.13	11.0
2021-02-19	AAAU	ETF	17.7	17.83	17.7	17.75	780600.0
2021-02-19	AADR	ETF	66.38	66.5	66.03	66.21	7000.0
2021-02-19	AAXJ	ETF	101.2	101.66	100.94	101.2	868100.0
2021-02-19	ABEQ	ETF	25.49	25.49	25.413	25.413	3800.0
2021-02-19	ACES	ETF	90.82	92.92	90.27	91.19	123600.0
2021-02-19	ACIO	ETF	28.023	28.051	27.89	27.92	23200.0
2021-02-19	ACSI	ETF	45.52	45.52	45.2195	45.2195	6298.0
2021-02-19	ACTV	ETF	34.34	35.028	34.34	34.9528	6478.0
2021-02-19	ACTX	ETF	4.99	4.99	3.26	3.26	1765.0
2021-02-19	ACVF	ETF	29.05	29.2	28.997	28.997	1500.0
2021-02-19	ACWF	ETF	36.06	36.245	36.06	36.111	2692.0
2021-02-19	ACWI	ETF	96.13	96.3	95.7	95.83	2532400.0
2021-02-19	ACWV	ETF	97.6	97.6	96.4	96.41	3710400.0
2021-02-19	ACWX	ETF	56.63	56.85	56.51	56.64	1663133.0
2021-02-19	ADFI	ETF	9.82	9.82	9.805	9.805	2200.0
2021-02-19	ADME	ETF	36.5	36.77	36.5	36.53	19500.0
2021-02-19	ADRE	ETF	65.25	65.5898	64.97	65.2545	13280.0
2021-02-19	AESR	ETF	12.42	12.47	12.379	12.379	181900.0
2021-02-19	AFIF	ETF	9.72	9.73	9.69	9.7001	269183.0
2021-02-19	AFK	ETF	21.82	22.13	21.82	22.05	15327.0
2021-02-19	AFLG	ETF	23.601	23.601	23.497	23.497	2100.0
2021-02-19	AFSM	ETF	25.57	25.57	25.53	25.551	400.0
2021-02-19	AFTY	ETF	26.56	26.56	26.437	26.437	2900.0
2021-02-19	AGG	ETF	116.02	116.06	115.75	115.84	4673100.0
2021-02-19	AGGY	ETF	52.5	52.57	52.42	52.435	212100.0
2021-02-19	AGNG	ETF	28.9	28.94	28.778	28.88	5300.0
2021-02-19	AGQ	ETF	52.47	53.3	51.62	51.85	2067100.0
2021-02-19	AGZ	ETF	118.82	118.93	118.76	118.85	34362.0
2021-02-19	AGZD	ETF	23.69	23.69	23.66	23.68	2200.0
2021-02-19	AIA	ETF	101.24	101.5877	100.8	101.1	152885.0
2021-02-19	AIEQ	ETF	40.86	41.41	40.83	41.08	61000.0
2021-02-19	AIQ	ETF	30.27	30.498	30.255	30.37	34950.0
2021-02-19	AIRR	ETF	37.61	38.26	37.593	38.23	40500.0
2021-02-19	AIVI	ETF	42.32	42.36	42.22	42.24	69100.0
2021-02-19	ALTL	ETF	36.37	36.7801	36.37	36.7801	2645.0
2021-02-19	ALTY	ETF	12.32	12.42	12.32	12.39	33800.0
2021-02-19	AMJ	ETF	15.45	15.635	15.43	15.52	345686.0
2021-02-19	AMLP	ETF	27.87	28.18	27.78	28.05	1527400.0
2021-02-19	AMNA	ETF	28.0522	28.0522	28.0522	28.0522	1.0
2021-02-19	AMND	ETF	29.6951	29.6951	29.6951	29.6951	1.0
2021-02-19	AMOM	ETF	34.53	34.65	34.375	34.375	2700.0
2021-02-19	AMPS	ETF	10.75	10.8	10.63	10.64	59238.0
2021-02-19	AMTR	ETF	32.28	32.28	32.25	32.25	448.0

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

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