PREVIEW / etf_daily / 2021-08-19

all etf daily files

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

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-19	SPY	ETF	436.27	441.14	436.12	439.86	92812200.0
2021-08-19	QQQ	ETF	360.22	365.68	359.96	363.96	48499368.0
2021-08-19	IWM	ETF	212.43	214.07	210.68	211.94	38119900.0
2021-08-19	DIA	ETF	347.33	350.48	347.31	349.48	5442200.0
2021-08-19	GLD	ETF	167.24	167.29	166.16	166.61	6934300.0
2021-08-19	TLT	ETF	150.31	150.46	149.81	150.45	15474300.0
2021-08-19	AAA	ETF	25.015	25.015	25.015	25.015	71.0
2021-08-19	AAAU	ETF	17.78	17.79	17.67	17.71	81000.0
2021-08-19	AADR	ETF	65.71	65.71	64.56	64.56	2200.0
2021-08-19	AAXJ	ETF	83.84	84.45	83.73	84.05	925000.0
2021-08-19	ABEQ	ETF	27.525	27.525	27.507	27.507	1000.0
2021-08-19	ACES	ETF	66.85	67.39	66.438	66.54	44600.0
2021-08-19	ACIO	ETF	30.55	30.64	30.53	30.575	27900.0
2021-08-19	ACSI	ETF	50.6577	50.6577	50.6577	50.6577	19.0
2021-08-19	ACTV	ETF	37.45	37.45	37.11	37.133	12227.0
2021-08-19	ACTX	ETF	1.27	1.27	1.01	1.04	2406.0
2021-08-19	ACVF	ETF	32.66	33.59	32.63	32.74	44600.0
2021-08-19	ACWF	ETF	37.72	38.02	37.69	37.8957	11033.0
2021-08-19	ACWI	ETF	100.89	101.76	100.84	101.42	3991600.0
2021-08-19	ACWV	ETF	104.99	105.92	104.99	105.76	222500.0
2021-08-19	ACWX	ETF	55.49	55.82	55.47	55.68	1462260.0
2021-08-19	ADFI	ETF	9.74	9.74	9.73	9.73	1400.0
2021-08-19	ADIV	ETF	17.87	17.923	17.87	17.923	1700.0
2021-08-19	ADME	ETF	40.4	40.47	40.31	40.352	23400.0
2021-08-19	ADRE	ETF	48.61	48.74	48.28	48.28	16928.0
2021-08-19	AESR	ETF	13.85	13.95	13.81	13.891	64200.0
2021-08-19	AFIF	ETF	9.61	9.7	9.61	9.69	42871.0
2021-08-19	AFK	ETF	21.3	21.36	21.0	21.0	7442.0
2021-08-19	AFLG	ETF	26.065	26.065	26.065	26.065	100.0
2021-08-19	AFMC	ETF	25.056	25.056	25.056	25.056	100.0
2021-08-19	AFSM	ETF	25.271	25.271	25.271	25.271	1700.0
2021-08-19	AFTY	ETF	20.43	20.43	20.39	20.43	1500.0
2021-08-19	AGG	ETF	116.12	116.16	116.02	116.15	4581300.0
2021-08-19	AGGY	ETF	52.67	52.73	52.67	52.71	106400.0
2021-08-19	AGNG	ETF	30.39	30.73	30.39	30.5	4400.0
2021-08-19	AGOV	ETF	99.53	99.53	99.53	99.53	97.0
2021-08-19	AGOX	ETF	25.5	25.66	25.44	25.584	17300.0
2021-08-19	AGQ	ETF	36.24	36.28	35.38	35.66	534700.0
2021-08-19	AGZ	ETF	119.19	119.27	119.1278	119.19	36010.0
2021-08-19	AGZD	ETF	23.435	23.445	23.4	23.42	16400.0
2021-08-19	AIA	ETF	78.46	78.855	78.14	78.34	121900.0
2021-08-19	AIEQ	ETF	40.5	40.99	40.5	40.737	10900.0
2021-08-19	AIQ	ETF	29.77	30.15	29.68	29.93	26247.0
2021-08-19	AIRR	ETF	40.65	40.85	40.447	40.67	13800.0
2021-08-19	AIVI	ETF	42.86	42.86	42.82	42.82	800.0
2021-08-19	ALTL	ETF	43.18	43.54	43.18	43.45	66702.0
2021-08-19	ALTY	ETF	13.6	13.61	13.47	13.47	12700.0
2021-08-19	AMJ	ETF	17.42	17.47	17.01	17.22	502666.0
2021-08-19	AMLP	ETF	31.39	31.5	30.7	31.16	3961600.0
2021-08-19	AMNA	ETF	30.4999	30.4999	30.4999	30.4999	3.0

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

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