PREVIEW / etf_daily / 2021-04-19

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-19.parquet
  size:    88 KB
  rows:    2,328

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-04-19	SPY	ETF	416.26	416.74	413.79	415.21	78498500.0
2021-04-19	QQQ	ETF	340.39	341.58	336.9016	338.88	34533129.0
2021-04-19	IWM	ETF	223.71	224.66	219.94	221.73	25285900.0
2021-04-19	DIA	ETF	341.07	341.31	339.65	340.75	3222800.0
2021-04-19	GLD	ETF	165.91	166.44	165.72	165.89	5721700.0
2021-04-19	TLT	ETF	138.74	139.31	138.55	138.86	13886800.0
2021-04-19	AAA	ETF	25.05	25.05	25.05	25.05	79.0
2021-04-19	AAAU	ETF	17.63	17.68	17.61	17.62	470300.0
2021-04-19	AADR	ETF	64.67	64.67	63.75	63.99	4400.0
2021-04-19	AAXJ	ETF	93.91	94.11	93.44	93.79	419100.0
2021-04-19	ABEQ	ETF	27.295	27.31	27.22	27.303	11500.0
2021-04-19	ACES	ETF	74.15	74.37	71.4	72.08	83300.0
2021-04-19	ACIO	ETF	29.7	29.7	29.49	29.57	34100.0
2021-04-19	ACSI	ETF	48.43	48.43	48.2257	48.2257	306.0
2021-04-19	ACTV	ETF	36.3	36.4	36.235	36.2651	5511.0
2021-04-19	ACVF	ETF	31.14	31.14	30.86	30.902	11300.0
2021-04-19	ACWF	ETF	37.99	38.04	37.69	37.8	23903.0
2021-04-19	ACWI	ETF	99.41	99.55	98.87	99.27	2254100.0
2021-04-19	ACWV	ETF	101.8	101.83	101.41	101.57	134000.0
2021-04-19	ACWX	ETF	57.23	57.25	56.9	57.02	2157455.0
2021-04-19	ADFI	ETF	9.69	9.7	9.68	9.68	1100.0
2021-04-19	ADIV	ETF	18.93	18.93	18.92	18.92	200.0
2021-04-19	ADME	ETF	38.5	38.59	38.47	38.55	36300.0
2021-04-19	ADRE	ETF	56.64	56.65	55.9401	56.15	10077.0
2021-04-19	AESR	ETF	13.21	13.22	13.12	13.17	34100.0
2021-04-19	AFIF	ETF	9.66	9.72	9.66	9.7099	29695.0
2021-04-19	AFK	ETF	21.75	21.8	21.6901	21.71	6759.0
2021-04-19	AFLG	ETF	24.854	24.854	24.854	24.854	300.0
2021-04-19	AFMC	ETF	25.046	25.046	25.046	25.046	100.0
2021-04-19	AFTY	ETF	22.27	22.37	22.27	22.37	3100.0
2021-04-19	AGG	ETF	114.0	114.5	114.0	114.45	5072800.0
2021-04-19	AGGY	ETF	51.69	51.78	51.69	51.71	1140600.0
2021-04-19	AGNG	ETF	28.72	28.75	28.6	28.75	4500.0
2021-04-19	AGQ	ETF	45.76	46.08	45.16	45.91	788200.0
2021-04-19	AGZ	ETF	118.17	118.2233	118.071	118.17	33924.0
2021-04-19	AGZD	ETF	23.575	23.58	23.53	23.54	2085200.0
2021-04-19	AIA	ETF	93.5	93.554	92.79	93.17	137099.0
2021-04-19	AIEQ	ETF	39.4	39.541	38.86	38.95	27600.0
2021-04-19	AIQ	ETF	29.93	29.99	29.4901	29.6059	30931.0
2021-04-19	AIRR	ETF	41.59	41.59	40.76	41.106	40200.0
2021-04-19	AIVI	ETF	43.82	43.82	43.7	43.74	5300.0
2021-04-19	ALTL	ETF	39.55	39.64	39.545	39.6018	4416.0
2021-04-19	ALTY	ETF	13.09	13.14	13.09	13.114	12400.0
2021-04-19	AMJ	ETF	16.95	17.16	16.92	17.0	276028.0
2021-04-19	AMLP	ETF	31.33	31.72	31.27	31.44	1870700.0
2021-04-19	AMNA	ETF	30.0475	30.0475	30.0475	30.0475	0.0
2021-04-19	AMND	ETF	31.9535	31.9535	31.9535	31.9535	3.0
2021-04-19	AMOM	ETF	35.54	35.54	35.011	35.2	59800.0
2021-04-19	AMPS	ETF	9.97	10.0	9.93	9.93	109187.0
2021-04-19	AMTR	ETF	35.1307	35.1307	35.1307	35.1307	0.0

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

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