PREVIEW / etf_daily / 2021-06-10

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-10.parquet
  size:    88 KB
  rows:    2,346

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-10	SPY	ETF	422.96	424.63	421.55	423.61	51020100.0
2021-06-10	QQQ	ETF	337.19	340.46	336.73	340.35	33702067.0
2021-06-10	IWM	ETF	231.68	232.18	228.71	229.28	29069000.0
2021-06-10	DIA	ETF	346.54	347.73	344.8	344.98	3089400.0
2021-06-10	GLD	ETF	176.7	177.85	176.48	177.74	9896600.0
2021-06-10	TLT	ETF	140.83	142.56	140.68	142.54	19698300.0
2021-06-10	AAA	ETF	25.02	25.02	25.005	25.005	612.0
2021-06-10	AAAU	ETF	18.77	18.9	18.75	18.88	352800.0
2021-06-10	AADR	ETF	68.22	68.22	67.64	67.9	900.0
2021-06-10	AAXJ	ETF	94.32	94.78	94.28	94.72	351600.0
2021-06-10	ABEQ	ETF	28.33	28.35	28.241	28.28	5900.0
2021-06-10	ACES	ETF	71.14	72.08	70.84	71.93	30200.0
2021-06-10	ACIO	ETF	29.89	29.94	29.88	29.93	22300.0
2021-06-10	ACSI	ETF	48.9893	48.9893	48.9893	48.9893	188.0
2021-06-10	ACTV	ETF	39.56	39.56	39.4074	39.4074	5239.0
2021-06-10	ACTX	ETF	3.4	3.4	3.4	3.4	255.0
2021-06-10	ACVF	ETF	31.59	31.68	31.582	31.658	1600.0
2021-06-10	ACWF	ETF	38.3	38.39	38.24	38.24	16740.0
2021-06-10	ACWI	ETF	100.83	101.15	100.57	100.99	2076400.0
2021-06-10	ACWV	ETF	103.1	103.82	103.1	103.82	112700.0
2021-06-10	ACWX	ETF	58.41	58.58	58.33	58.54	1010144.0
2021-06-10	ADFI	ETF	9.72	9.75	9.72	9.736	8700.0
2021-06-10	ADIV	ETF	19.2	19.2	19.15	19.15	1300.0
2021-06-10	ADME	ETF	38.87	39.03	38.864	38.996	17900.0
2021-06-10	ADRE	ETF	57.2258	57.3391	56.9541	57.07	5032.0
2021-06-10	AESR	ETF	13.38	13.4	13.33	13.371	15100.0
2021-06-10	AFIF	ETF	9.73	9.75	9.72	9.75	22523.0
2021-06-10	AFK	ETF	22.61	22.8	22.59	22.71	25120.0
2021-06-10	AFLG	ETF	25.25	25.27	25.25	25.27	600.0
2021-06-10	AFMC	ETF	25.59	25.59	25.559	25.559	1000.0
2021-06-10	AFSM	ETF	26.29	26.3	26.271	26.271	2500.0
2021-06-10	AFTY	ETF	24.21	24.21	24.21	24.21	1500.0
2021-06-10	AGG	ETF	115.3	115.31	114.86	115.28	4021900.0
2021-06-10	AGGY	ETF	51.98	52.2	51.98	52.2	103200.0
2021-06-10	AGNG	ETF	30.33	30.63	30.33	30.601	4400.0
2021-06-10	AGOX	ETF	26.44	26.44	25.98	26.047	61000.0
2021-06-10	AGQ	ETF	52.52	53.71	52.21	53.65	764700.0
2021-06-10	AGZ	ETF	118.4	118.68	118.4	118.68	42563.0
2021-06-10	AGZD	ETF	23.475	23.475	23.445	23.465	28400.0
2021-06-10	AIA	ETF	90.98	91.48	90.87	91.32	129983.0
2021-06-10	AIEQ	ETF	39.59	39.79	39.32	39.76	11200.0
2021-06-10	AIQ	ETF	29.34	29.54	29.15	29.54	19367.0
2021-06-10	AIRR	ETF	42.67	42.67	41.735	41.75	25100.0
2021-06-10	AIVI	ETF	45.0	45.17	45.0	45.11	3900.0
2021-06-10	ALTL	ETF	41.42	41.56	41.35	41.54	54490.0
2021-06-10	ALTY	ETF	13.75	13.82	13.71	13.8	13500.0
2021-06-10	AMJ	ETF	20.16	20.6	20.16	20.56	718204.0
2021-06-10	AMLP	ETF	37.56	38.23	37.26	38.23	3030200.0
2021-06-10	AMNA	ETF	35.25	35.2823	35.25	35.2823	500.0
2021-06-10	AMND	ETF	37.3032	37.3032	37.3032	37.3032	0.0

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

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