PREVIEW / etf_daily / 2019-08-21

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-21.parquet
  size:    70 KB
  rows:    1,828

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
2019-08-21	SPY	ETF	292.48	292.86	291.72	292.45	49524700.0
2019-08-21	QQQ	ETF	188.66	189.23	187.96	188.63	20745478.0
2019-08-21	IWM	ETF	150.62	150.65	149.79	150.38	13446100.0
2019-08-21	DIA	ETF	261.83	262.66	261.49	262.03	2156300.0
2019-08-21	GLD	ETF	141.62	142.17	141.46	141.76	8114700.0
2019-08-21	TLT	ETF	144.72	145.79	144.29	144.56	9372000.0
2019-08-21	AAAU	ETF	15.0	15.04	14.99	15.01	57200.0
2019-08-21	AADR	ETF	49.43	49.81	49.41	49.62	7100.0
2019-08-21	AAXJ	ETF	65.7	65.74	65.32	65.55	480700.0
2019-08-21	ACES	ETF	31.21	31.21	30.947	30.955	23400.0
2019-08-21	ACIO	ETF	23.65	24.404	23.65	24.404	2600.0
2019-08-21	ACSI	ETF	33.2915	33.3123	33.28	33.3123	1183.0
2019-08-21	ACTX	ETF	20.6502	24.1902	20.6502	20.6502	637.0
2019-08-21	ACWF	ETF	28.24	28.28	28.19	28.2416	11227.0
2019-08-21	ACWI	ETF	72.12	72.22	71.93	72.05	1109900.0
2019-08-21	ACWV	ETF	93.27	93.28	93.05	93.13	83200.0
2019-08-21	ACWX	ETF	44.77	44.79	44.64	44.7	682215.0
2019-08-21	ADRE	ETF	38.3001	38.4299	38.3001	38.4299	1551.0
2019-08-21	AFIF	ETF	9.66	9.66	9.63	9.65	155042.0
2019-08-21	AFK	ETF	20.14	20.14	19.9027	19.93	6178.0
2019-08-21	AFTY	ETF	16.887	16.92	16.88	16.909	3900.0
2019-08-21	AGG	ETF	113.51	113.83	113.51	113.62	3815400.0
2019-08-21	AGGY	ETF	52.53	52.693	52.52	52.63	218800.0
2019-08-21	AGNG	ETF	21.74	21.74	21.618	21.618	800.0
2019-08-21	AGQ	ETF	30.31	30.69	30.19	30.53	157300.0
2019-08-21	AGZ	ETF	116.91	116.9895	116.83	116.84	41666.0
2019-08-21	AGZD	ETF	23.855	23.88	23.825	23.875	9600.0
2019-08-21	AIA	ETF	57.34	57.3465	57.17	57.22	25926.0
2019-08-21	AIEQ	ETF	25.92	26.08	25.92	25.99	23400.0
2019-08-21	AIQ	ETF	16.18	16.21	16.14	16.17	2501.0
2019-08-21	AIRR	ETF	25.17	25.25	25.115	25.14	23100.0
2019-08-21	AIVI	ETF	39.29	39.29	39.21	39.22	7100.0
2019-08-21	ALTY	ETF	14.75	14.78	14.72	14.755	19000.0
2019-08-21	AMJ	ETF	23.95	23.95	23.72	23.83	1179661.0
2019-08-21	AMLP	ETF	45.85	46.15	45.7	45.9	2795340.0
2019-08-21	AMOM	ETF	26.648	26.648	26.648	26.648	100.0
2019-08-21	AMUB	ETF	14.9584	14.9584	14.9584	14.9584	0.0
2019-08-21	AMZA	ETF	48.7	49.2	48.4	48.6	249920.0
2019-08-21	ANGL	ETF	29.11	29.2	29.09	29.18	904400.0
2019-08-21	AOA	ETF	53.85	53.91	53.78	53.86	31500.0
2019-08-21	AOK	ETF	35.48	35.51	35.44	35.4648	78844.0
2019-08-21	AOM	ETF	38.87	38.94	38.84	38.94	112835.0
2019-08-21	AOR	ETF	45.36	45.45	45.31	45.4	36756.0
2019-08-21	ARCM	ETF	100.225	100.225	100.225	100.225	5300.0
2019-08-21	ARGT	ETF	24.32	24.54	24.31	24.51	43900.0
2019-08-21	ARKF	ETF	21.87	21.97	21.828	21.92	14100.0
2019-08-21	ARKG	ETF	32.94	33.11	32.702	32.95	68300.0
2019-08-21	ARKK	ETF	45.67	45.876	45.332	45.66	249200.0
2019-08-21	ARKQ	ETF	31.24	31.454	31.24	31.33	15800.0
2019-08-21	ARKW	ETF	50.35	50.814	50.31	50.58	76000.0

> showing 50 of 1,828 rows — these rows as CSV

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