PREVIEW / etf_daily / 2019-02-14

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-14.parquet
  size:    67 KB
  rows:    1,735

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-02-14	SPY	ETF	273.78	275.64	272.87	274.38	83234400.0
2019-02-14	QQQ	ETF	170.38	171.83	169.83	171.22	30326830.0
2019-02-14	IWM	ETF	152.58	154.37	152.4	153.77	18251000.0
2019-02-14	DIA	ETF	254.54	256.17	253.62	255.16	3811000.0
2019-02-14	GLD	ETF	123.84	124.2	123.53	124.06	6276500.0
2019-02-14	TLT	ETF	122.14	122.2	121.58	121.79	5868900.0
2019-02-14	AAAU	ETF	13.1	13.12	13.07	13.12	15000.0
2019-02-14	AADR	ETF	44.49	45.01	44.49	45.01	11200.0
2019-02-14	AAXJ	ETF	68.37	68.8	68.16	68.59	754000.0
2019-02-14	ACES	ETF	25.71	26.407	25.71	26.222	6200.0
2019-02-14	ACSI	ETF	32.06	32.1689	31.9101	32.1689	3601.0
2019-02-14	ACTX	ETF	47.2004	47.2004	44.2504	46.0204	586.0
2019-02-14	ACWF	ETF	28.7	28.8705	28.665	28.76	88888.0
2019-02-14	ACWI	ETF	69.64	70.07	69.46	69.79	5637300.0
2019-02-14	ACWV	ETF	86.22	86.51	85.95	86.15	211900.0
2019-02-14	ACWX	ETF	44.81	45.08	44.74	44.94	4586684.0
2019-02-14	ADRE	ETF	39.57	39.9827	39.5007	39.9827	3034.0
2019-02-14	AFIF	ETF	9.95	10.015	9.95	9.99	12437.0
2019-02-14	AFK	ETF	21.53	21.655	21.53	21.6119	2476.0
2019-02-14	AFTY	ETF	15.01	15.19	15.01	15.168	8000.0
2019-02-14	AGG	ETF	107.33	107.35	107.17	107.22	2908500.0
2019-02-14	AGGY	ETF	48.94	48.96	48.92	48.95	36400.0
2019-02-14	AGNG	ETF	21.286	21.298	21.21	21.298	900.0
2019-02-14	AGQ	ETF	26.21	26.53	26.14	26.52	114900.0
2019-02-14	AGZ	ETF	112.22	112.26	112.1701	112.21	36455.0
2019-02-14	AGZD	ETF	23.795	23.85	23.75	23.805	35200.0
2019-02-14	AIA	ETF	60.03	60.37	59.94	60.25	50900.0
2019-02-14	AIEQ	ETF	25.27	25.46	25.12	25.33	52100.0
2019-02-14	AIQ	ETF	15.0013	15.0796	14.98	15.04	9770.0
2019-02-14	AIRR	ETF	24.54	24.84	24.54	24.72	43300.0
2019-02-14	AIVI	ETF	39.94	40.15	39.94	40.03	5000.0
2019-02-14	ALTY	ETF	14.614	14.69	14.614	14.669	13600.0
2019-02-14	AMJ	ETF	25.15	25.6	25.15	25.52	1527655.0
2019-02-14	AMLP	ETF	48.25	49.5	48.05	49.3	3160120.0
2019-02-14	AMUB	ETF	16.07	16.07	16.0698	16.0698	200.0
2019-02-14	AMZA	ETF	59.1	60.0	58.8	59.8	92090.0
2019-02-14	ANGL	ETF	28.22	28.32	28.18	28.25	163000.0
2019-02-14	AOA	ETF	51.99	52.18	51.88	52.07	61400.0
2019-02-14	AOK	ETF	33.78	33.8259	33.75	33.79	61798.0
2019-02-14	AOM	ETF	37.13	37.22	37.114	37.16	99731.0
2019-02-14	AOR	ETF	43.51	43.6639	43.5	43.6	177049.0
2019-02-14	ARGT	ETF	27.57	27.94	27.46	27.77	54000.0
2019-02-14	ARKF	ETF	20.48	20.62	20.4	20.58	13900.0
2019-02-14	ARKG	ETF	28.67	28.7	28.43	28.65	60300.0
2019-02-14	ARKK	ETF	44.41	44.73	44.18	44.66	331800.0
2019-02-14	ARKQ	ETF	34.12	34.64	33.97	34.551	36400.0
2019-02-14	ARKW	ETF	50.11	50.74	49.93	50.54	70300.0
2019-02-14	ASEA	ETF	15.95	16.08	15.94	16.08	9300.0
2019-02-14	ASET	ETF	27.81	27.81	27.7336	27.7336	5785.0
2019-02-14	ASHR	ETF	25.06	25.25	25.04	25.18	2020300.0

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

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