PREVIEW / etf_daily / 2021-05-03

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-03.parquet
  size:    88 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-05-03	SPY	ETF	419.43	419.84	417.67	418.2	68128300.0
2021-05-03	QQQ	ETF	339.23	340.0	335.73	336.19	29729730.0
2021-05-03	IWM	ETF	227.21	227.41	224.92	225.99	18693400.0
2021-05-03	DIA	ETF	340.79	342.18	340.55	341.11	2698400.0
2021-05-03	GLD	ETF	167.61	168.43	167.41	167.81	9014700.0
2021-05-03	TLT	ETF	138.7	139.65	138.28	138.52	16447700.0
2021-05-03	AAA	ETF	25.005	25.005	25.005	25.005	328.0
2021-05-03	AAAU	ETF	17.8	17.89	17.8	17.83	382900.0
2021-05-03	AADR	ETF	65.83	66.07	65.81	65.88	2200.0
2021-05-03	AAXJ	ETF	93.54	93.88	93.16	93.51	384600.0
2021-05-03	ABEQ	ETF	27.64	27.753	27.64	27.753	1500.0
2021-05-03	ACES	ETF	72.99	73.22	71.1	71.25	70800.0
2021-05-03	ACIO	ETF	29.82	29.84	29.75	29.75	23900.0
2021-05-03	ACSI	ETF	49.1497	49.1497	49.1497	49.1497	309.0
2021-05-03	ACTV	ETF	37.1716	37.5831	37.1716	37.4721	1829.0
2021-05-03	ACTX	ETF	4.24	4.24	4.0	4.0	825.0
2021-05-03	ACVF	ETF	31.57	31.57	31.022	31.028	8500.0
2021-05-03	ACWF	ETF	37.76	37.83	37.53	37.7651	29593.0
2021-05-03	ACWI	ETF	99.83	99.86	99.44	99.58	1676400.0
2021-05-03	ACWV	ETF	101.54	102.19	101.54	101.98	130000.0
2021-05-03	ACWX	ETF	56.82	57.05	56.7475	57.0	562120.0
2021-05-03	ADFI	ETF	9.7	9.7	9.69	9.69	300.0
2021-05-03	ADIV	ETF	18.78	18.78	18.752	18.752	100.0
2021-05-03	ADME	ETF	38.95	38.95	38.793	38.793	14900.0
2021-05-03	ADRE	ETF	56.83	57.135	56.52	56.65	16427.0
2021-05-03	AESR	ETF	13.313	13.313	13.251	13.251	6000.0
2021-05-03	AFIF	ETF	9.82	9.82	9.69	9.73	19577.0
2021-05-03	AFK	ETF	21.75	21.9	21.675	21.81	5848.0
2021-05-03	AFLG	ETF	24.961	24.961	24.961	24.961	1600.0
2021-05-03	AFSM	ETF	26.027	26.027	26.027	26.027	1600.0
2021-05-03	AFTY	ETF	22.63	22.63	22.616	22.616	1500.0
2021-05-03	AGG	ETF	114.4	114.59	114.33	114.39	5939500.0
2021-05-03	AGGY	ETF	51.68	51.775	51.66	51.69	115400.0
2021-05-03	AGNG	ETF	29.15	29.21	29.1	29.1	3100.0
2021-05-03	AGQ	ETF	48.22	50.0	47.91	49.64	1832100.0
2021-05-03	AGZ	ETF	118.05	118.18	117.91	118.02	263191.0
2021-05-03	AGZD	ETF	23.46	23.555	23.46	23.545	596800.0
2021-05-03	AIA	ETF	92.35	92.54	91.7801	92.04	505702.0
2021-05-03	AIEQ	ETF	39.16	39.26	38.69	38.69	55500.0
2021-05-03	AIQ	ETF	29.44	29.47	29.13	29.1648	17118.0
2021-05-03	AIRR	ETF	42.0	42.359	41.75	42.17	61900.0
2021-05-03	AIVI	ETF	43.4	43.53	43.28	43.5	3300.0
2021-05-03	ALTL	ETF	42.25	42.25	40.995	41.2565	54776.0
2021-05-03	ALTY	ETF	13.41	13.49	13.41	13.46	81200.0
2021-05-03	AMJ	ETF	17.86	17.88	17.65	17.87	184538.0
2021-05-03	AMLP	ETF	33.0	33.13	32.62	33.04	4363300.0
2021-05-03	AMNA	ETF	31.4041	31.4041	31.4041	31.4041	0.0
2021-05-03	AMND	ETF	33.2982	33.2982	33.2982	33.2982	0.0
2021-05-03	AMOM	ETF	35.12	35.36	35.08	35.1	18700.0
2021-05-03	AMPS	ETF	9.98	9.98	9.94	9.95	15795.0

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

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