PREVIEW / etf_daily / 2021-08-18

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-18.parquet
  size:    92 KB
  rows:    2,434

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-08-18	SPY	ETF	442.96	444.63	438.92	439.18	89351900.0
2021-08-18	QQQ	ETF	365.18	366.62	361.865	362.21	38541940.0
2021-08-18	IWM	ETF	216.1	218.04	214.37	214.51	29102300.0
2021-08-18	DIA	ETF	352.62	354.04	349.89	350.12	4038000.0
2021-08-18	GLD	ETF	167.24	167.51	166.26	167.1	7697900.0
2021-08-18	TLT	ETF	148.71	149.47	148.45	149.35	13144000.0
2021-08-18	AAA	ETF	25.02	25.02	25.016	25.016	302.0
2021-08-18	AAAU	ETF	17.77	17.8	17.69	17.77	189400.0
2021-08-18	AADR	ETF	66.92	67.17	66.89	67.14	1500.0
2021-08-18	AAXJ	ETF	85.77	86.2	85.39	85.44	1894700.0
2021-08-18	ABEQ	ETF	27.645	27.645	27.645	27.645	100.0
2021-08-18	ACES	ETF	67.42	68.34	67.15	67.35	36700.0
2021-08-18	ACIO	ETF	30.745	30.85	30.54	30.54	50800.0
2021-08-18	ACSI	ETF	50.6791	50.6791	50.6791	50.6791	11.0
2021-08-18	ACTV	ETF	38.04	38.24	37.67	37.67	4689.0
2021-08-18	ACVF	ETF	32.91	32.995	32.65	32.653	5300.0
2021-08-18	ACWF	ETF	38.46	38.53	38.154	38.154	8286.0
2021-08-18	ACWI	ETF	102.67	102.94	101.89	101.96	3195200.0
2021-08-18	ACWV	ETF	106.23	106.42	105.51	105.63	237100.0
2021-08-18	ACWX	ETF	56.61	56.82	56.37	56.38	1089989.0
2021-08-18	ADFI	ETF	9.71	9.73	9.7	9.72	3500.0
2021-08-18	ADME	ETF	40.595	40.659	40.295	40.295	41900.0
2021-08-18	ADRE	ETF	50.12	50.4112	49.94	49.94	9056.0
2021-08-18	AESR	ETF	13.98	14.06	13.928	13.928	362000.0
2021-08-18	AFIF	ETF	9.6	9.7	9.6	9.67	46942.0
2021-08-18	AFK	ETF	21.7	21.7	21.33	21.39	4471.0
2021-08-18	AFLG	ETF	26.35	26.35	26.083	26.083	3800.0
2021-08-18	AFMC	ETF	25.51	25.51	25.269	25.269	2400.0
2021-08-18	AFSM	ETF	25.93	25.93	25.611	25.611	1800.0
2021-08-18	AFTY	ETF	20.62	20.62	20.575	20.575	500.0
2021-08-18	AGG	ETF	115.94	116.03	115.8	115.95	3981900.0
2021-08-18	AGGY	ETF	52.61	52.67	52.57	52.62	55800.0
2021-08-18	AGNG	ETF	30.81	30.81	30.645	30.645	5700.0
2021-08-18	AGOV	ETF	99.6836	99.6836	99.6836	99.6836	50.0
2021-08-18	AGOX	ETF	26.21	26.21	25.74	25.776	42700.0
2021-08-18	AGQ	ETF	36.9	36.91	35.89	36.47	946100.0
2021-08-18	AGZ	ETF	119.16	119.16	119.0001	119.13	20648.0
2021-08-18	AGZD	ETF	23.405	23.42	23.385	23.41	32200.0
2021-08-18	AIA	ETF	80.85	81.06	80.31	80.45	116838.0
2021-08-18	AIEQ	ETF	41.33	41.396	41.0	41.04	13100.0
2021-08-18	AIQ	ETF	30.21	30.41	30.05	30.05	9785.0
2021-08-18	AIRR	ETF	41.15	41.549	41.09	41.12	122300.0
2021-08-18	AIVI	ETF	43.51	43.56	43.39	43.39	1900.0
2021-08-18	ALTL	ETF	43.77	43.77	43.17	43.17	22675.0
2021-08-18	ALTY	ETF	13.68	13.68	13.58	13.64	10200.0
2021-08-18	AMJ	ETF	17.86	17.98	17.54	17.54	257341.0
2021-08-18	AMLP	ETF	32.45	32.56	31.78	31.82	1489000.0
2021-08-18	AMNA	ETF	31.1889	31.1889	31.1889	31.1889	0.0
2021-08-18	AMND	ETF	32.8083	32.8083	32.8083	32.8083	2.0
2021-08-18	AMOM	ETF	36.43	36.565	36.07	36.1	9200.0

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

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