PREVIEW / etf_daily / 2021-07-14

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-14.parquet
  size:    92 KB
  rows:    2,431

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-07-14	SPY	ETF	437.4	437.92	434.91	436.24	64130400.0
2021-07-14	QQQ	ETF	364.83	365.49	362.22	363.07	35336350.0
2021-07-14	IWM	ETF	223.71	224.36	218.55	218.87	30594100.0
2021-07-14	DIA	ETF	350.19	350.69	348.36	349.41	3933300.0
2021-07-14	GLD	ETF	170.91	171.04	170.28	171.04	8830300.0
2021-07-14	TLT	ETF	146.01	146.92	145.81	146.87	16038600.0
2021-07-14	AAA	ETF	25.01	25.01	25.01	25.01	356.0
2021-07-14	AAAU	ETF	18.16	18.18	18.11	18.18	373900.0
2021-07-14	AADR	ETF	66.34	66.34	65.71	65.77	1100.0
2021-07-14	AAXJ	ETF	92.61	92.67	91.95	92.25	364700.0
2021-07-14	ABEQ	ETF	27.511	27.58	27.5	27.54	7400.0
2021-07-14	ACES	ETF	72.56	72.56	69.64	69.73	41100.0
2021-07-14	ACIO	ETF	30.88	30.89	30.73	30.76	42500.0
2021-07-14	ACSI	ETF	51.28	51.28	50.8997	50.8997	2802.0
2021-07-14	ACTV	ETF	38.38	38.3888	37.98	37.9947	5441.0
2021-07-14	ACTX	ETF	2.5	2.5	2.5	2.5	140.0
2021-07-14	ACVF	ETF	32.295	32.295	32.15	32.207	2200.0
2021-07-14	ACWF	ETF	38.21	38.26	38.07	38.0957	1679.0
2021-07-14	ACWI	ETF	102.57	102.6	101.99	102.17	2846100.0
2021-07-14	ACWV	ETF	104.49	104.62	104.15	104.39	215000.0
2021-07-14	ACWX	ETF	57.58	57.61	57.345	57.42	896028.0
2021-07-14	ADFI	ETF	9.76	9.761	9.76	9.761	400.0
2021-07-14	ADIV	ETF	18.32	18.365	18.32	18.365	1700.0
2021-07-14	ADME	ETF	40.74	40.74	40.54	40.54	40800.0
2021-07-14	ADRE	ETF	56.7281	56.7281	56.19	56.31	11708.0
2021-07-14	AEMB	ETF	50.085	50.085	50.085	50.085	100.0
2021-07-14	AESR	ETF	13.87	13.87	13.77	13.821	10400.0
2021-07-14	AFIF	ETF	9.76	9.76	9.73	9.755	6843.0
2021-07-14	AFK	ETF	21.8	21.8	21.595	21.71	11900.0
2021-07-14	AFLG	ETF	25.68	25.68	25.68	25.68	100.0
2021-07-14	AFMC	ETF	24.972	24.972	24.972	24.972	100.0
2021-07-14	AFSM	ETF	25.499	25.499	25.499	25.499	100.0
2021-07-14	AFTY	ETF	22.13	22.158	22.13	22.158	500.0
2021-07-14	AGG	ETF	115.59	115.76	115.57	115.75	4977400.0
2021-07-14	AGGY	ETF	52.43	52.57	52.43	52.57	87300.0
2021-07-14	AGNG	ETF	30.72	30.72	30.63	30.63	3400.0
2021-07-14	AGOX	ETF	26.5	26.5	25.91	25.915	8500.0
2021-07-14	AGQ	ETF	47.17	47.21	45.7	46.41	795000.0
2021-07-14	AGZ	ETF	118.72	118.8	118.6101	118.72	11915.0
2021-07-14	AGZD	ETF	23.555	23.58	23.5	23.54	22800.0
2021-07-14	AIA	ETF	90.08	90.26	89.3978	89.59	189425.0
2021-07-14	AIEQ	ETF	41.0	41.0	40.09	40.2	14300.0
2021-07-14	AIQ	ETF	30.88	31.03	30.69	30.69	17907.0
2021-07-14	AIRR	ETF	40.34	40.641	39.85	40.04	69900.0
2021-07-14	AIVI	ETF	43.77	43.88	43.72	43.79	7100.0
2021-07-14	ALTL	ETF	42.0	42.145	41.8593	42.08	26665.0
2021-07-14	ALTY	ETF	13.64	13.64	13.52	13.56	15200.0
2021-07-14	AMJ	ETF	19.19	19.34	18.74	18.74	436023.0
2021-07-14	AMLP	ETF	35.45	35.82	34.68	34.69	3127500.0
2021-07-14	AMNA	ETF	32.8004	32.8004	32.8004	32.8004	19.0

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

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