PREVIEW / etf_daily / 2020-01-24

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-24.parquet
  size:    74 KB
  rows:    1,942

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-01-24	SPY	ETF	332.44	332.53	327.36	328.77	87578400.0
2020-01-24	QQQ	ETF	225.62	225.88	221.6701	222.7	37436483.0
2020-01-24	IWM	ETF	168.01	168.01	164.23	165.39	20491400.0
2020-01-24	DIA	ETF	292.54	292.77	288.34	289.8	3612500.0
2020-01-24	GLD	ETF	146.9	148.38	146.89	147.98	9919900.0
2020-01-24	TLT	ETF	141.42	142.55	141.3	142.08	8585000.0
2020-01-24	AAAU	ETF	15.56	15.72	15.56	15.68	68600.0
2020-01-24	AADR	ETF	55.9	56.09	55.33	55.43	9900.0
2020-01-24	AAXJ	ETF	73.8	73.88	72.79	73.17	985100.0
2020-01-24	ABEQ	ETF	24.94	24.94	24.81	24.864	27000.0
2020-01-24	ACES	ETF	36.84	37.05	36.471	36.525	19900.0
2020-01-24	ACIO	ETF	25.69	25.69	25.521	25.603	9200.0
2020-01-24	ACSI	ETF	36.54	36.54	36.2912	36.2912	1820.0
2020-01-24	ACTX	ETF	11.3576	12.0951	10.6201	10.6201	496.0
2020-01-24	ACWF	ETF	31.82	31.82	31.4124	31.5148	8834.0
2020-01-24	ACWI	ETF	81.13	81.14	80.03	80.27	2580200.0
2020-01-24	ACWV	ETF	98.84	98.84	98.2	98.43	284100.0
2020-01-24	ACWX	ETF	49.52	49.52	48.98	49.1	1132860.0
2020-01-24	ADME	ETF	31.24	31.24	30.94	31.029	20000.0
2020-01-24	ADRE	ETF	44.4	44.4	43.62	43.68	108792.0
2020-01-24	AFIF	ETF	9.745	9.745	9.745	9.745	104.0
2020-01-24	AFK	ETF	20.1981	20.21	20.11	20.11	4920.0
2020-01-24	AFLG	ETF	20.768	20.798	20.768	20.798	1000.0
2020-01-24	AFMC	ETF	20.491	20.491	20.491	20.491	100.0
2020-01-24	AFSM	ETF	20.5	20.5	20.46	20.479	1400.0
2020-01-24	AFTY	ETF	16.72	16.771	16.5	16.54	56000.0
2020-01-24	AGG	ETF	113.68	113.89	113.67	113.79	4199800.0
2020-01-24	AGGY	ETF	52.83	52.9	52.819	52.89	112800.0
2020-01-24	AGNG	ETF	24.11	24.4	23.8	23.8	5900.0
2020-01-24	AGQ	ETF	31.44	32.43	31.43	32.35	292400.0
2020-01-24	AGZ	ETF	116.51	116.77	116.51	116.71	39938.0
2020-01-24	AGZD	ETF	24.03	24.075	24.0	24.025	11600.0
2020-01-24	AIA	ETF	67.16	67.16	66.14	66.56	100351.0
2020-01-24	AIEQ	ETF	29.71	29.71	29.155	29.307	31700.0
2020-01-24	AIQ	ETF	19.22	19.3399	18.95	19.03	18678.0
2020-01-24	AIRR	ETF	29.16	29.16	28.555	28.73	2200.0
2020-01-24	AIVI	ETF	42.68	42.68	42.3	42.38	3600.0
2020-01-24	ALTY	ETF	15.07	15.09	14.916	14.95	7500.0
2020-01-24	AMJ	ETF	21.68	21.7114	21.23	21.34	2709303.0
2020-01-24	AMLP	ETF	42.25	42.35	41.35	41.5	5370360.0
2020-01-24	AMOM	ETF	26.831	26.831	26.831	26.831	100.0
2020-01-24	AMUB	ETF	13.4642	13.4642	13.4234	13.4234	428.0
2020-01-24	AMZA	ETF	43.0	43.3	41.9	42.0	60020.0
2020-01-24	ANGL	ETF	30.1	30.14	29.93	29.99	2273300.0
2020-01-24	AOA	ETF	59.0	59.02	58.42	58.58	56400.0
2020-01-24	AOK	ETF	36.69	36.75	36.6301	36.68	104715.0
2020-01-24	AOM	ETF	40.68	40.72	40.5	40.53	116201.0
2020-01-24	AOR	ETF	48.63	48.63	48.22	48.26	282500.0
2020-01-24	ARGT	ETF	25.96	26.07	25.5	25.6	59300.0
2020-01-24	ARKF	ETF	25.78	25.9	25.38	25.569	36900.0

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

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