PREVIEW / etf_daily / 2020-10-12

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-12.parquet
  size:    79 KB
  rows:    2,098

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
2020-10-12	SPY	ETF	349.59	354.02	349.06	352.43	80388500.0
2020-10-12	QQQ	ETF	290.6	297.46	289.47	294.53	79370657.0
2020-10-12	IWM	ETF	163.4	164.24	162.6	163.79	20336200.0
2020-10-12	DIA	ETF	286.95	289.61	286.68	288.46	2534800.0
2020-10-12	GLD	ETF	180.57	180.83	180.19	180.56	4843000.0
2020-10-12	TLT	ETF	160.43	160.68	160.11	160.6	3962000.0
2020-10-12	AAA	ETF	24.895	24.895	24.895	24.895	638.0
2020-10-12	AAAU	ETF	19.15	19.19	19.12	19.17	195100.0
2020-10-12	AADR	ETF	58.37	58.75	58.34	58.39	110500.0
2020-10-12	AAXJ	ETF	80.57	81.06	80.43	80.93	521500.0
2020-10-12	ABEQ	ETF	24.025	24.025	24.025	24.025	100.0
2020-10-12	ACES	ETF	62.49	62.49	60.25	60.42	78000.0
2020-10-12	ACIO	ETF	27.36	27.41	27.35	27.35	38900.0
2020-10-12	ACSI	ETF	39.33	39.87	39.33	39.7748	407.0
2020-10-12	ACTX	ETF	1.0	1.0	1.0	1.0	122.0
2020-10-12	ACWF	ETF	31.09	31.2073	31.09	31.2073	2966.0
2020-10-12	ACWI	ETF	83.26	84.03	83.19	83.79	1542600.0
2020-10-12	ACWV	ETF	94.54	94.91	94.17	94.69	410300.0
2020-10-12	ACWX	ETF	47.76	47.95	47.68	47.87	483546.0
2020-10-12	ADFI	ETF	9.985	9.985	9.985	9.985	100.0
2020-10-12	ADME	ETF	34.642	35.07	34.642	34.95	18800.0
2020-10-12	ADRE	ETF	49.94	50.4	49.825	50.15	12406.0
2020-10-12	AESR	ETF	11.35	11.483	11.35	11.467	800.0
2020-10-12	AFIF	ETF	9.8175	9.8175	9.81	9.81	3237.0
2020-10-12	AFK	ETF	17.99	17.9999	17.95	17.97	3210.0
2020-10-12	AFLG	ETF	21.04	21.25	21.04	21.242	500.0
2020-10-12	AFSM	ETF	19.616	19.616	19.616	19.616	100.0
2020-10-12	AFTY	ETF	20.33	20.35	20.32	20.34	2800.0
2020-10-12	AGG	ETF	117.85	117.95	117.77	117.95	2999300.0
2020-10-12	AGGY	ETF	53.61	53.77	53.61	53.74	248100.0
2020-10-12	AGNG	ETF	26.71	26.795	26.705	26.795	2900.0
2020-10-12	AGQ	ETF	48.32	49.1	47.25	48.39	2065900.0
2020-10-12	AGZ	ETF	120.92	120.92	120.7801	120.88	23321.0
2020-10-12	AGZD	ETF	23.53	23.53	23.43	23.485	4400.0
2020-10-12	AIA	ETF	75.51	75.8799	75.35	75.8	65519.0
2020-10-12	AIEQ	ETF	32.38	32.79	32.35	32.6	27700.0
2020-10-12	AIQ	ETF	24.89	25.1413	24.79	24.9653	23686.0
2020-10-12	AIRR	ETF	28.04	28.474	28.04	28.415	9100.0
2020-10-12	AIVI	ETF	36.98	37.14	36.97	37.1	2300.0
2020-10-12	ALTL	ETF	26.0497	26.0497	26.0083	26.0083	320.0
2020-10-12	ALTY	ETF	10.84	10.84	10.815	10.84	1900.0
2020-10-12	AMJ	ETF	11.73	11.84	11.615	11.76	1166848.0
2020-10-12	AMLP	ETF	21.78	21.93	21.53	21.84	2587000.0
2020-10-12	AMNA	ETF	22.3	22.439	22.3	22.439	2000.0
2020-10-12	AMND	ETF	23.41	23.6102	23.41	23.6102	218.0
2020-10-12	AMOM	ETF	37.0	37.73	37.0	37.562	1700.0
2020-10-12	AMUB	ETF	7.34	7.43	7.33	7.4232	3865.0
2020-10-12	AMZA	ETF	15.02	15.115	14.78	15.06	61700.0
2020-10-12	ANGL	ETF	30.2	30.36	30.2	30.3	832800.0
2020-10-12	AOA	ETF	59.84	60.24	59.74	60.14	127200.0

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

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