PREVIEW / etf_daily / 2019-03-25

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-25.parquet
  size:    68 KB
  rows:    1,762

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-03-25	SPY	ETF	278.87	280.19	277.64	279.04	85575200.0
2019-03-25	QQQ	ETF	177.92	178.84	176.93	178.22	46336524.0
2019-03-25	IWM	ETF	149.48	151.32	148.41	150.28	26454700.0
2019-03-25	DIA	ETF	254.69	255.89	253.57	255.07	4982500.0
2019-03-25	GLD	ETF	124.56	125.11	124.48	124.92	7288300.0
2019-03-25	TLT	ETF	124.81	125.94	124.51	125.06	9736300.0
2019-03-25	AAAU	ETF	13.18	13.23	13.17	13.21	15800.0
2019-03-25	AADR	ETF	44.96	45.25	44.88	45.09	101400.0
2019-03-25	AAXJ	ETF	69.38	69.82	69.33	69.61	954700.0
2019-03-25	ACES	ETF	26.8	26.81	26.54	26.78	20500.0
2019-03-25	ACSI	ETF	32.1799	32.1799	32.07	32.1386	830.0
2019-03-25	ACTX	ETF	61.9506	61.9506	40.7104	49.5604	2735.0
2019-03-25	ACWF	ETF	28.6	28.688	28.5001	28.62	8650.0
2019-03-25	ACWI	ETF	71.28	71.56	71.02	71.33	4008400.0
2019-03-25	ACWV	ETF	88.36	88.71	88.21	88.57	259200.0
2019-03-25	ACWX	ETF	45.78	45.98	45.71	45.9	1186104.0
2019-03-25	ADRE	ETF	40.22	40.4037	40.22	40.37	2328.0
2019-03-25	AFIF	ETF	9.991	10.03	9.99	10.0062	28825.0
2019-03-25	AFK	ETF	21.5	21.52	21.47	21.47	18942.0
2019-03-25	AFTY	ETF	16.0	16.15	16.0	16.1	4400.0
2019-03-25	AGG	ETF	108.63	108.99	108.6	108.82	4971300.0
2019-03-25	AGGY	ETF	49.8	49.905	49.76	49.87	95200.0
2019-03-25	AGNG	ETF	21.168	21.377	21.168	21.377	2000.0
2019-03-25	AGQ	ETF	25.84	26.1	25.84	25.98	121000.0
2019-03-25	AGZ	ETF	113.41	113.6	113.3513	113.51	10844.0
2019-03-25	AGZD	ETF	23.94	23.94	23.835	23.88	14200.0
2019-03-25	AIA	ETF	60.38	60.6432	60.32	60.56	30694.0
2019-03-25	AIEQ	ETF	25.51	25.69	25.38	25.54	76900.0
2019-03-25	AIQ	ETF	15.51	15.6	15.4885	15.592	18670.0
2019-03-25	AIRR	ETF	23.72	23.92	23.639	23.89	15700.0
2019-03-25	AIVI	ETF	41.28	41.38	41.24	41.35	10900.0
2019-03-25	ALTY	ETF	14.69	14.75	14.68	14.75	3100.0
2019-03-25	AMJ	ETF	25.5	25.5	25.08	25.27	1902206.0
2019-03-25	AMLP	ETF	50.25	50.25	49.4	49.8	4617280.0
2019-03-25	AMUB	ETF	15.9571	15.9571	15.9571	15.9571	0.0
2019-03-25	AMZA	ETF	59.4	59.7	58.4	59.2	66120.0
2019-03-25	ANGL	ETF	28.62	28.67	28.57	28.64	212500.0
2019-03-25	AOA	ETF	53.0	53.12	52.84	53.03	44100.0
2019-03-25	AOK	ETF	34.32	34.37	34.2706	34.3	35112.0
2019-03-25	AOM	ETF	37.81	37.8499	37.76	37.82	216179.0
2019-03-25	AOR	ETF	44.38	44.4473	44.271	44.42	88011.0
2019-03-25	ARCM	ETF	100.21	100.21	100.21	100.21	100.0
2019-03-25	ARGT	ETF	27.84	28.28	27.82	28.05	150300.0
2019-03-25	ARKF	ETF	21.1	21.21	20.97	21.142	24500.0
2019-03-25	ARKG	ETF	31.85	32.31	31.48	32.07	235500.0
2019-03-25	ARKK	ETF	45.82	46.234	45.21	45.95	611800.0
2019-03-25	ARKQ	ETF	33.4	33.5	33.072	33.47	12700.0
2019-03-25	ARKW	ETF	51.04	51.35	50.59	51.19	108400.0
2019-03-25	ASEA	ETF	15.83	15.86	15.79	15.86	4800.0
2019-03-25	ASET	ETF	28.72	28.72	28.72	28.72	633.0

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

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