PREVIEW / etf_daily / 2021-03-12

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-12.parquet
  size:    87 KB
  rows:    2,281

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-12	SPY	ETF	392.07	394.21	391.2	394.06	64653600.0
2021-03-12	QQQ	ETF	313.86	318.2302	311.391	315.46	69315601.0
2021-03-12	IWM	ETF	231.99	234.15	231.37	233.59	23732200.0
2021-03-12	DIA	ETF	325.67	328.49	325.5	328.31	4257200.0
2021-03-12	GLD	ETF	159.54	161.69	159.35	161.49	8608500.0
2021-03-12	TLT	ETF	136.4	136.46	135.65	136.06	20402700.0
2021-03-12	AAA	ETF	25.076	25.08	25.076	25.08	692.0
2021-03-12	AAAU	ETF	16.94	17.18	16.93	17.16	735100.0
2021-03-12	AADR	ETF	63.23	64.07	63.22	64.04	2600.0
2021-03-12	AAXJ	ETF	93.9	94.17	93.45	94.07	1289500.0
2021-03-12	ABEQ	ETF	26.32	26.357	26.271	26.357	16400.0
2021-03-12	ACES	ETF	79.58	81.12	78.15	80.99	81500.0
2021-03-12	ACIO	ETF	27.81	27.833	27.68	27.833	10700.0
2021-03-12	ACSI	ETF	45.86	46.2752	45.86	46.2752	983.0
2021-03-12	ACTV	ETF	36.8542	36.9688	36.8542	36.9688	1809.0
2021-03-12	ACTX	ETF	3.01	3.01	2.75	2.75	3056.0
2021-03-12	ACVF	ETF	29.37	29.467	29.33	29.467	1500.0
2021-03-12	ACWF	ETF	35.57	35.86	35.56	35.86	5791.0
2021-03-12	ACWI	ETF	94.66	95.22	94.45	95.17	2681700.0
2021-03-12	ACWV	ETF	96.48	97.06	96.4	97.02	209100.0
2021-03-12	ACWX	ETF	55.37	55.73	55.26	55.73	991637.0
2021-03-12	ADFI	ETF	9.6	9.63	9.59	9.61	3400.0
2021-03-12	ADME	ETF	36.21	36.21	35.92	36.085	10900.0
2021-03-12	ADRE	ETF	58.5	58.85	58.3065	58.74	19436.0
2021-03-12	AESR	ETF	12.43	12.51	12.42	12.51	60500.0
2021-03-12	AFIF	ETF	9.69	9.69	9.63	9.655	51895.0
2021-03-12	AFK	ETF	21.75	21.75	21.485	21.58	12890.0
2021-03-12	AFLG	ETF	23.67	23.703	23.65	23.703	600.0
2021-03-12	AFMC	ETF	24.612	24.612	24.612	24.612	100.0
2021-03-12	AFTY	ETF	22.99	23.047	22.88	23.045	5900.0
2021-03-12	AGG	ETF	113.88	113.91	113.71	113.79	5066800.0
2021-03-12	AGGY	ETF	51.38	51.416	51.28	51.29	278500.0
2021-03-12	AGNG	ETF	27.53	27.64	27.519	27.64	2100.0
2021-03-12	AGQ	ETF	44.76	46.56	44.57	46.53	591500.0
2021-03-12	AGZ	ETF	117.93	117.93	117.83	117.87	43470.0
2021-03-12	AGZD	ETF	23.72	23.72	23.615	23.655	31800.0
2021-03-12	AIA	ETF	93.79	93.9199	93.34	93.85	193013.0
2021-03-12	AIEQ	ETF	39.18	39.69	38.91	39.69	44300.0
2021-03-12	AIQ	ETF	28.64	28.74	28.45	28.7214	31031.0
2021-03-12	AIRR	ETF	41.82	42.51	41.82	42.459	261600.0
2021-03-12	AIVI	ETF	42.39	42.8	42.39	42.8	1900.0
2021-03-12	ALTL	ETF	40.49	40.49	40.265	40.4629	4936.0
2021-03-12	ALTY	ETF	12.69	12.71	12.607	12.676	22700.0
2021-03-12	AMJ	ETF	17.38	17.57	17.33	17.53	382761.0
2021-03-12	AMLP	ETF	32.2	32.48	31.99	32.42	2130400.0
2021-03-12	AMNA	ETF	30.7569	30.7569	30.7569	30.7569	0.0
2021-03-12	AMND	ETF	32.7498	32.7498	32.7498	32.7498	0.0
2021-03-12	AMOM	ETF	32.17	32.5	32.17	32.5	1300.0
2021-03-12	AMPS	ETF	10.2107	10.225	9.95	9.99	24093.0
2021-03-12	AMTR	ETF	35.17	35.4643	35.17	35.4643	1001.0

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

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