PREVIEW / etf_daily / 2020-03-11

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-11.parquet
  size:    75 KB
  rows:    1,977

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-03-11	SPY	ETF	280.7	281.94	270.88	274.36	255316300.0
2020-03-11	QQQ	ETF	199.35	200.75	192.73	195.22	89168783.0
2020-03-11	IWM	ETF	130.92	132.27	124.17	125.88	51354800.0
2020-03-11	DIA	ETF	243.54	244.91	233.6	235.84	7687200.0
2020-03-11	GLD	ETF	156.25	156.5	153.61	153.93	18159900.0
2020-03-11	TLT	ETF	165.43	167.03	155.63	156.53	29519300.0
2020-03-11	AAAU	ETF	16.57	16.59	16.29	16.33	200100.0
2020-03-11	AADR	ETF	46.17	46.17	44.36	45.09	81400.0
2020-03-11	AAXJ	ETF	65.55	65.84	64.53	64.62	2961200.0
2020-03-11	ABEQ	ETF	21.57	21.83	21.43	21.83	23000.0
2020-03-11	ACES	ETF	34.39	34.87	32.42	32.93	77300.0
2020-03-11	ACIO	ETF	23.965	23.98	23.83	23.926	11400.0
2020-03-11	ACSI	ETF	30.7938	30.8054	30.22	30.2808	2349.0
2020-03-11	ACTX	ETF	6.2541	6.9621	6.2541	6.26	190.0
2020-03-11	ACWF	ETF	26.47	26.4899	25.61	25.89	37341.0
2020-03-11	ACWI	ETF	67.92	68.12	65.63	66.25	7040200.0
2020-03-11	ACWV	ETF	88.78	88.8	86.03	86.69	1036300.0
2020-03-11	ACWX	ETF	41.06	41.12	39.8	40.0	2467478.0
2020-03-11	ADME	ETF	29.706	29.8	29.26	29.47	14000.0
2020-03-11	ADRE	ETF	37.08	37.415	36.15	36.5331	8257.0
2020-03-11	AESR	ETF	8.79	8.79	8.707	8.707	1400.0
2020-03-11	AFIF	ETF	10.1204	10.1204	9.95	9.95	1407.0
2020-03-11	AFK	ETF	15.83	15.84	15.33	15.42	7406.0
2020-03-11	AFLG	ETF	17.31	17.32	17.075	17.228	10000.0
2020-03-11	AFMC	ETF	16.19	16.19	15.925	15.925	4000.0
2020-03-11	AFSM	ETF	15.643	15.74	15.407	15.407	2800.0
2020-03-11	AFTY	ETF	16.577	16.577	16.37	16.409	8800.0
2020-03-11	AGG	ETF	116.7	116.79	114.55	114.72	13053300.0
2020-03-11	AGGY	ETF	53.2	53.3	52.09	52.09	626500.0
2020-03-11	AGNG	ETF	21.148	21.248	20.739	20.865	5600.0
2020-03-11	AGQ	ETF	27.62	27.82	26.77	27.02	370600.0
2020-03-11	AGZ	ETF	121.24	121.24	120.57	120.57	70417.0
2020-03-11	AGZD	ETF	23.175	23.45	23.065	23.295	24200.0
2020-03-11	AIA	ETF	59.49	59.72	58.655	58.79	101247.0
2020-03-11	AIEQ	ETF	24.73	24.75	23.696	23.87	38500.0
2020-03-11	AIQ	ETF	16.38	16.4572	15.8	15.86	16554.0
2020-03-11	AIRR	ETF	22.25	22.35	21.665	21.961	13400.0
2020-03-11	AIVI	ETF	34.0	34.07	33.19	33.44	34700.0
2020-03-11	ALTY	ETF	12.29	12.29	11.65	11.65	28000.0
2020-03-11	AMJ	ETF	11.91	12.55	11.6583	11.98	9202460.0
2020-03-11	AMLP	ETF	23.0	24.45	22.6	23.25	10332780.0
2020-03-11	AMOM	ETF	23.701	23.701	23.701	23.701	300.0
2020-03-11	AMUB	ETF	7.77	7.85	6.56	7.5373	10926.0
2020-03-11	AMZA	ETF	17.5	18.7	16.7	17.7	208360.0
2020-03-11	ANGL	ETF	27.87	27.89	27.12	27.32	1894400.0
2020-03-11	AOA	ETF	51.28	51.29	49.8	50.19	213000.0
2020-03-11	AOK	ETF	35.27	35.298	34.62	34.64	209642.0
2020-03-11	AOM	ETF	38.32	38.4725	37.65	37.67	231323.0
2020-03-11	AOR	ETF	43.96	44.09	42.98	43.15	347976.0
2020-03-11	ARCM	ETF	100.05	100.262	100.05	100.055	300.0

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

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