PREVIEW / etf_daily / 2021-06-15

all etf daily files

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

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-15	SPY	ETF	425.42	425.46	423.54	424.48	51508500.0
2021-06-15	QQQ	ETF	344.15	344.47	341.52	342.26	35963780.0
2021-06-15	IWM	ETF	231.12	231.47	228.48	230.36	17039900.0
2021-06-15	DIA	ETF	344.51	344.53	342.37	343.41	2138500.0
2021-06-15	GLD	ETF	174.78	174.92	173.34	174.05	7550200.0
2021-06-15	TLT	ETF	140.8	141.09	140.48	141.05	18207300.0
2021-06-15	AAA	ETF	25.01	25.01	25.01	25.01	8.0
2021-06-15	AAAU	ETF	18.58	18.58	18.43	18.5	199000.0
2021-06-15	AADR	ETF	67.65	67.65	67.54	67.54	1200.0
2021-06-15	AAXJ	ETF	94.51	94.51	93.88	93.99	441000.0
2021-06-15	ABEQ	ETF	28.139	28.15	28.095	28.128	8200.0
2021-06-15	ACES	ETF	72.34	72.34	70.72	70.91	52100.0
2021-06-15	ACIO	ETF	29.86	30.01	29.86	29.957	18600.0
2021-06-15	ACSI	ETF	49.1163	49.1163	49.1163	49.1163	184.0
2021-06-15	ACTV	ETF	39.29	39.41	39.125	39.3472	5490.0
2021-06-15	ACTX	ETF	3.4	3.575	2.57	2.57	1573.0
2021-06-15	ACVF	ETF	31.74	31.74	31.595	31.648	2300.0
2021-06-15	ACWF	ETF	38.3	38.3	38.16	38.24	16963.0
2021-06-15	ACWI	ETF	101.37	101.41	101.02	101.24	3848000.0
2021-06-15	ACWV	ETF	103.68	103.78	103.39	103.51	90500.0
2021-06-15	ACWX	ETF	58.7	58.7	58.49	58.63	1723417.0
2021-06-15	ADFI	ETF	9.72	9.74	9.72	9.725	7700.0
2021-06-15	ADIV	ETF	19.0	19.04	18.92	18.92	1400.0
2021-06-15	ADME	ETF	39.125	39.19	39.09	39.142	11700.0
2021-06-15	ADRE	ETF	57.39	57.39	56.81	56.86	3916.0
2021-06-15	AESR	ETF	13.41	13.42	13.36	13.36	30600.0
2021-06-15	AFIF	ETF	9.72	9.74	9.69	9.72	40553.0
2021-06-15	AFK	ETF	22.78	22.78	22.45	22.45	41637.0
2021-06-15	AFLG	ETF	25.275	25.275	25.275	25.275	500.0
2021-06-15	AFMC	ETF	25.42	25.499	25.42	25.499	1200.0
2021-06-15	AFSM	ETF	26.27	26.275	26.27	26.275	500.0
2021-06-15	AFTY	ETF	23.56	23.56	23.33	23.38	8900.0
2021-06-15	AGG	ETF	114.9	115.02	114.87	114.99	8230400.0
2021-06-15	AGGY	ETF	52.03	52.096	52.02	52.07	49500.0
2021-06-15	AGNG	ETF	30.72	30.72	30.55	30.64	11300.0
2021-06-15	AGOX	ETF	26.034	26.034	25.89	25.976	37000.0
2021-06-15	AGQ	ETF	52.31	52.35	51.1	52.24	1027900.0
2021-06-15	AGZ	ETF	118.41	118.43	118.26	118.26	1690942.0
2021-06-15	AGZD	ETF	23.49	23.505	23.475	23.495	25600.0
2021-06-15	AIA	ETF	91.22	91.2356	90.32	90.46	1564143.0
2021-06-15	AIEQ	ETF	40.05	40.24	39.58	39.71	38500.0
2021-06-15	AIQ	ETF	29.83	29.94	29.66	29.69	7860.0
2021-06-15	AIRR	ETF	41.61	41.77	41.343	41.677	80200.0
2021-06-15	AIVI	ETF	45.07	45.11	45.07	45.1	2900.0
2021-06-15	ALTL	ETF	41.73	41.73	41.53	41.56	11546.0
2021-06-15	ALTY	ETF	13.9	13.9	13.79	13.825	23600.0
2021-06-15	AMJ	ETF	20.85	20.94	20.405	20.75	254349.0
2021-06-15	AMLP	ETF	38.6	38.73	37.68	38.26	1948800.0
2021-06-15	AMNA	ETF	35.43	35.6131	35.43	35.6131	282.0
2021-06-15	AMND	ETF	37.76	37.76	37.76	37.76	3.0

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

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