PREVIEW / etf_daily / 2021-06-17

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-17.parquet
  size:    89 KB
  rows:    2,367

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-06-17	SPY	ETF	421.67	423.02	419.32	421.97	90949700.0
2021-06-17	QQQ	ETF	339.97	346.38	339.92	345.34	59722700.0
2021-06-17	IWM	ETF	229.24	230.2	224.52	227.29	48292500.0
2021-06-17	DIA	ETF	340.56	341.28	336.62	338.65	5169100.0
2021-06-17	GLD	ETF	167.02	167.62	165.44	165.85	27232200.0
2021-06-17	TLT	ETF	141.86	144.93	141.64	143.04	35225800.0
2021-06-17	AAA	ETF	25.02	25.02	25.015	25.015	405.0
2021-06-17	AAAU	ETF	17.74	17.81	17.59	17.63	646100.0
2021-06-17	AADR	ETF	65.8	65.8	65.0	65.42	1800.0
2021-06-17	AAXJ	ETF	93.13	93.74	93.13	93.49	578300.0
2021-06-17	ABEQ	ETF	27.63	27.63	27.49	27.49	7900.0
2021-06-17	ACES	ETF	71.55	72.839	71.38	72.59	64200.0
2021-06-17	ACIO	ETF	29.86	29.91	29.74	29.86	59600.0
2021-06-17	ACSI	ETF	48.8919	48.8958	48.8919	48.8958	436.0
2021-06-17	ACTV	ETF	38.975	38.975	38.37	38.6638	5070.0
2021-06-17	ACVF	ETF	31.45	31.65	31.255	31.46	19900.0
2021-06-17	ACWF	ETF	37.79	37.83	37.4	37.66	5991.0
2021-06-17	ACWI	ETF	100.37	100.66	99.88	100.4	3225800.0
2021-06-17	ACWV	ETF	102.27	102.79	102.23	102.61	91400.0
2021-06-17	ACWX	ETF	57.93	58.1	57.69	57.93	1844536.0
2021-06-17	ADFI	ETF	9.7	9.73	9.7	9.715	4400.0
2021-06-17	ADIV	ETF	18.845	18.845	18.845	18.845	100.0
2021-06-17	ADME	ETF	38.91	39.14	38.87	39.095	60000.0
2021-06-17	ADRE	ETF	56.54	56.755	56.3026	56.57	13338.0
2021-06-17	AESR	ETF	13.35	13.36	13.25	13.337	44700.0
2021-06-17	AFIF	ETF	9.735	9.77	9.73	9.755	84974.0
2021-06-17	AFK	ETF	22.18	22.18	22.06	22.06	40334.0
2021-06-17	AFLG	ETF	25.01	25.01	24.85	24.983	400.0
2021-06-17	AFMC	ETF	24.75	24.904	24.75	24.904	1600.0
2021-06-17	AFSM	ETF	25.9	25.9	25.878	25.889	800.0
2021-06-17	AFTY	ETF	23.06	23.14	22.97	23.048	3900.0
2021-06-17	AGG	ETF	114.79	115.25	114.79	114.98	7641700.0
2021-06-17	AGGY	ETF	52.01	52.26	51.99	52.12	274600.0
2021-06-17	AGNG	ETF	30.32	30.48	30.32	30.44	800.0
2021-06-17	AGOX	ETF	26.1	26.1	25.575	25.715	10200.0
2021-06-17	AGQ	ETF	46.72	47.19	44.86	45.46	3514000.0
2021-06-17	AGZ	ETF	118.11	118.405	118.11	118.2	9192.0
2021-06-17	AGZD	ETF	23.51	23.565	23.485	23.53	69000.0
2021-06-17	AIA	ETF	90.08	90.76	90.0457	90.58	127029.0
2021-06-17	AIEQ	ETF	39.78	40.42	39.75	40.4	94200.0
2021-06-17	AIQ	ETF	29.52	29.93	29.35	29.78	10919.0
2021-06-17	AIRR	ETF	41.55	41.55	40.23	40.44	93300.0
2021-06-17	AIVI	ETF	44.47	44.48	44.18	44.32	7200.0
2021-06-17	ALTL	ETF	41.37	42.0	41.02	41.19	15122.0
2021-06-17	ALTY	ETF	13.81	13.84	13.58	13.61	51300.0
2021-06-17	AMJ	ETF	20.89	20.93	19.66	19.93	1765092.0
2021-06-17	AMLP	ETF	38.62	38.71	36.27	36.83	4702900.0
2021-06-17	AMNA	ETF	34.5805	34.5805	34.5805	34.5805	0.0
2021-06-17	AMND	ETF	36.7026	36.7026	36.7026	36.7026	6.0
2021-06-17	AMOM	ETF	35.23	35.46	35.101	35.37	13000.0

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

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