PREVIEW / etf_daily / 2021-03-16

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-16.parquet
  size:    86 KB
  rows:    2,262

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-03-16	SPY	ETF	397.07	397.83	395.08	395.91	73722500.0
2021-03-16	QQQ	ETF	321.09	324.2	319.1	320.58	54925896.0
2021-03-16	IWM	ETF	234.02	234.09	229.12	230.5	24675000.0
2021-03-16	DIA	ETF	329.85	330.0	328.32	328.86	3270600.0
2021-03-16	GLD	ETF	162.36	163.2	161.81	162.35	7547400.0
2021-03-16	TLT	ETF	137.02	137.12	135.75	136.31	15567900.0
2021-03-16	AAA	ETF	25.08	25.08	25.08	25.08	90.0
2021-03-16	AAAU	ETF	17.26	17.33	17.2	17.25	324100.0
2021-03-16	AADR	ETF	64.55	64.73	64.17	64.49	4000.0
2021-03-16	AAXJ	ETF	94.75	95.1	94.4	94.87	335500.0
2021-03-16	ABEQ	ETF	26.35	26.43	26.35	26.423	12700.0
2021-03-16	ACES	ETF	81.19	81.285	78.11	79.07	204400.0
2021-03-16	ACIO	ETF	28.3	28.3	27.94	27.993	18000.0
2021-03-16	ACSI	ETF	46.449	46.449	46.3534	46.3534	717.0
2021-03-16	ACTV	ETF	36.76	36.76	36.505	36.6	2831.0
2021-03-16	ACTX	ETF	3.01	4.0	3.01	4.0	259.0
2021-03-16	ACVF	ETF	29.67	29.68	29.558	29.558	2500.0
2021-03-16	ACWF	ETF	36.2128	36.28	36.0799	36.1137	4334.0
2021-03-16	ACWI	ETF	95.82	96.03	95.42	95.67	2422400.0
2021-03-16	ACWV	ETF	98.07	98.16	97.84	98.04	333400.0
2021-03-16	ACWX	ETF	55.97	56.045	55.805	56.0	5794082.0
2021-03-16	ADFI	ETF	9.54	9.65	9.54	9.632	15900.0
2021-03-16	ADME	ETF	36.36	36.36	36.13	36.23	21000.0
2021-03-16	ADRE	ETF	58.91	59.34	58.4825	58.895	12691.0
2021-03-16	AESR	ETF	12.63	12.63	12.52	12.558	26200.0
2021-03-16	AFIF	ETF	9.6944	9.72	9.67	9.7	49435.0
2021-03-16	AFK	ETF	21.7	21.7	21.57	21.6	5497.0
2021-03-16	AFLG	ETF	23.98	23.98	23.816	23.816	2000.0
2021-03-16	AFMC	ETF	24.65	24.65	24.58	24.58	700.0
2021-03-16	AFSM	ETF	26.18	26.19	25.937	25.937	1100.0
2021-03-16	AFTY	ETF	23.02	23.096	22.97	23.096	3100.0
2021-03-16	AGG	ETF	113.97	114.03	113.78	113.87	3990900.0
2021-03-16	AGGY	ETF	51.47	51.47	51.29	51.38	126300.0
2021-03-16	AGNG	ETF	27.83	27.834	27.74	27.8	2500.0
2021-03-16	AGQ	ETF	46.53	47.32	46.2	46.65	619800.0
2021-03-16	AGZ	ETF	117.93	118.0	117.911	117.96	52891.0
2021-03-16	AGZD	ETF	23.645	23.675	23.645	23.655	13400.0
2021-03-16	AIA	ETF	94.24	94.72	94.12	94.59	164767.0
2021-03-16	AIEQ	ETF	40.46	40.46	39.18	39.52	29200.0
2021-03-16	AIQ	ETF	29.04	29.215	28.8666	28.9154	17190.0
2021-03-16	AIRR	ETF	42.09	42.31	41.55	41.64	71900.0
2021-03-16	AIVI	ETF	42.9	42.9	42.8	42.83	3900.0
2021-03-16	ALTL	ETF	40.74	40.74	39.685	39.7838	16808.0
2021-03-16	ALTY	ETF	12.83	12.83	12.71	12.731	11900.0
2021-03-16	AMJ	ETF	17.47	17.47	17.09	17.19	492021.0
2021-03-16	AMLP	ETF	32.22	32.22	31.55	31.71	1817000.0
2021-03-16	AMNA	ETF	30.2587	30.2587	30.2587	30.2587	17.0
2021-03-16	AMND	ETF	32.2311	32.2311	32.2311	32.2311	0.0
2021-03-16	AMPS	ETF	10.0199	10.0199	9.96	10.0	10640.0
2021-03-16	AMTR	ETF	34.8225	34.8225	34.8225	34.8225	0.0

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

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