PREVIEW / etf_daily / 2019-12-18

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-18.parquet
  size:    73 KB
  rows:    1,923

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-12-18	SPY	ETF	320.0	320.25	319.53	319.59	48133000.0
2019-12-18	QQQ	ETF	209.6	210.13	209.33	209.55	15490828.0
2019-12-18	IWM	ETF	165.06	165.28	164.32	165.02	15379300.0
2019-12-18	DIA	ETF	283.79	283.91	283.15	283.21	1592600.0
2019-12-18	GLD	ETF	138.86	139.25	138.81	139.02	3607600.0
2019-12-18	TLT	ETF	137.3	137.45	136.28	136.47	6244700.0
2019-12-18	AAAU	ETF	14.7	14.76	14.7	14.73	134200.0
2019-12-18	AADR	ETF	53.17	53.26	53.0	53.16	4200.0
2019-12-18	AAXJ	ETF	72.83	72.98	72.76	72.95	1797800.0
2019-12-18	ACES	ETF	35.0	35.0	33.259	33.5	46600.0
2019-12-18	ACIO	ETF	25.67	25.69	25.649	25.66	16600.0
2019-12-18	ACSI	ETF	35.7403	35.781	35.7403	35.7584	1179.0
2019-12-18	ACTX	ETF	6.5491	12.1482	6.5491	11.2101	908.0
2019-12-18	ACWF	ETF	30.98	31.025	30.9457	30.9659	9860.0
2019-12-18	ACWI	ETF	78.59	78.64	78.49	78.55	2486200.0
2019-12-18	ACWV	ETF	95.16	95.28	94.91	95.06	557500.0
2019-12-18	ACWX	ETF	48.85	48.87	48.76	48.82	789143.0
2019-12-18	ADME	ETF	30.69	30.71	30.68	30.685	6400.0
2019-12-18	ADRE	ETF	44.37	44.5112	44.27	44.5112	4591.0
2019-12-18	AESR	ETF	10.01	10.01	9.995	9.995	113500.0
2019-12-18	AFIF	ETF	9.7401	9.7479	9.735	9.735	1171.0
2019-12-18	AFK	ETF	20.73	21.26	20.73	21.21	8526.0
2019-12-18	AFLG	ETF	20.33	20.33	20.325	20.325	100.0
2019-12-18	AFMC	ETF	20.38	20.4	20.38	20.4	200.0
2019-12-18	AFTY	ETF	17.11	17.226	17.11	17.226	2400.0
2019-12-18	AGG	ETF	112.55	112.56	112.36	112.37	6516300.0
2019-12-18	AGGY	ETF	52.32	52.32	52.22	52.29	139200.0
2019-12-18	AGNG	ETF	23.51	23.615	23.51	23.615	1900.0
2019-12-18	AGQ	ETF	28.57	28.8	28.52	28.78	211000.0
2019-12-18	AGZ	ETF	115.75	115.75	115.5593	115.69	173279.0
2019-12-18	AGZD	ETF	24.05	24.125	24.04	24.075	31000.0
2019-12-18	AIA	ETF	65.72	65.86	65.67	65.7986	31804.0
2019-12-18	AIEQ	ETF	28.15	28.23	28.132	28.19	13900.0
2019-12-18	AIQ	ETF	17.73	17.7681	17.66	17.7011	18080.0
2019-12-18	AIRR	ETF	29.13	29.161	29.0	29.157	6500.0
2019-12-18	AIVI	ETF	43.03	43.03	42.93	42.99	4300.0
2019-12-18	ALTY	ETF	14.92	14.969	14.9	14.94	8800.0
2019-12-18	AMJ	ETF	21.5	21.93	21.5	21.86	5884390.0
2019-12-18	AMLP	ETF	42.15	42.9	42.1	42.65	6801120.0
2019-12-18	AMOM	ETF	27.121	27.121	27.121	27.121	100.0
2019-12-18	AMUB	ETF	13.773	13.773	13.773	13.773	0.0
2019-12-18	AMZA	ETF	44.7	45.7	44.6	45.4	80190.0
2019-12-18	ANGL	ETF	29.92	29.98	29.86	29.95	317500.0
2019-12-18	AOA	ETF	58.1	58.14	58.07	58.12	29900.0
2019-12-18	AOK	ETF	36.34	36.36	36.27	36.29	134817.0
2019-12-18	AOM	ETF	40.28	40.3	40.2	40.25	108919.0
2019-12-18	AOR	ETF	47.93	47.9776	47.87	47.87	113097.0
2019-12-18	ARCM	ETF	99.935	99.935	99.935	99.935	100.0
2019-12-18	ARGT	ETF	24.99	25.66	24.99	25.47	78200.0
2019-12-18	ARKF	ETF	24.14	24.24	24.136	24.15	23700.0

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

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