PREVIEW / stock_daily / 2020-09-25

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-25.parquet
  size:    226 KB
  rows:    6,882
  symbols: 2,457

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-09-25	AAPL	Stock	108.43	112.44	107.67	112.28	149981400.0
2020-09-25	MSFT	Stock	203.55	209.04	202.54	207.82	29437300.0
2020-09-25	NVDA	Stock	12.4475	12.8835	12.2458	12.8738	588016000.0
2020-09-25	AMZN	Stock	152.743	155.077	149.95	154.7565	92304000.0
2020-09-25	GOOGL	Stock	71.2525	72.297	70.384	71.953	30333540.0
2020-09-25	META	Stock	249.4	255.75	246.61	254.82	18351300.0
2020-09-25	TSLA	Stock	131.1567	136.2433	130.4333	135.78	201625500.0
2020-09-25	TLT	Stock	165.11	165.42	164.71	165.12	5140298.0
2020-09-25	ES	Stock	79.88	82.57	79.62	82.48	1991100.0
2020-09-25	CL	Stock	75.39	76.11	75.33	75.95	2803300.0
2020-09-25	A	Stock	95.96	98.14	95.77	97.69	1028600.0
2020-09-25	AA	Stock	11.5	11.757	11.3	11.55	6190400.0
2020-09-25	AACG	Stock	1.06	1.11	1.06	1.1	34000.0
2020-09-25	AACQ-DELISTED	Stock	9.97	9.97	9.87	9.88	365092.0
2020-09-25	AACQU-DELISTED	Stock	10.29	10.4	10.29	10.35	2800.0
2020-09-25	AACQW-DELISTED	Stock	1.44	1.5099	1.4	1.4599	31457.0
2020-09-25	AAIC-DELISTED	Stock	2.6	2.73	2.6	2.71	201433.0
2020-09-25	AAIC.C-DELISTED	Stock	18.76	18.935	18.75	18.935	800.0
2020-09-25	AAL	Stock	11.76	12.31	11.71	12.29	43764000.0
2020-09-25	AAM.A-DELISTED	Stock	25.91	26.27	25.87	26.22	13144.0
2020-09-25	AAM.B-DELISTED	Stock	26.86	27.105	26.61	27.105	4510.0
2020-09-25	AAMC-DELISTED	Stock	6.0294	6.1765	6.0294	6.1765	3373.0
2020-09-25	AAME	Stock	2.06	2.06	2.06	2.06	600.0
2020-09-25	AAMI	Stock	12.39	12.81	12.37	12.76	297400.0
2020-09-25	AAOI	Stock	10.38	10.77	10.3	10.73	275100.0
2020-09-25	AAON	Stock	38.0133	38.5267	37.8333	38.2867	181950.0
2020-09-25	AAP	Stock	146.33	150.4	146.26	149.41	778600.0
2020-09-25	AAT	Stock	23.01	23.4	22.94	23.39	310800.0
2020-09-25	AAU-DELISTED	Stock	0.8215	0.87	0.82	0.862	323953.0
2020-09-25	AAUAF-DELISTED	Stock	0.8215	0.87	0.82	0.8663	338183.0
2020-09-25	AAWW-DELISTED	Stock	60.51	61.79	60.15	60.31	264513.0
2020-09-25	AAXJ	Stock	74.42	75.04	73.96	74.95	625074.0
2020-09-25	AAXN-DELISTED	Stock	85.25	87.38	84.58	87.21	339927.0
2020-09-25	AB	Stock	26.6	27.55	26.52	27.38	314200.0
2020-09-25	ABB-DELISTED	Stock	24.83	25.17	24.76	25.09	1014297.0
2020-09-25	ABBNY-DELISTED	Stock	24.83	25.17	24.76	25.09	1076890.0
2020-09-25	ABBV	Stock	86.0	86.86	85.46	86.23	9935600.0
2020-09-25	ABC-DELISTED	Stock	94.66	97.07	94.2	96.8	602681.0
2020-09-25	ABCB	Stock	21.22	22.02	21.22	21.91	402400.0
2020-09-25	ABEO	Stock	49.0	49.75	46.25	46.5	25024.0
2020-09-25	ABEV	Stock	2.29	2.34	2.25	2.33	17736100.0
2020-09-25	ABG	Stock	92.96	93.86	91.65	93.14	273400.0
2020-09-25	ABM	Stock	36.42	37.26	36.42	36.85	507300.0
2020-09-25	ABMD-DELISTED	Stock	261.37	268.51	259.474	266.3	122543.0
2020-09-25	ABR	Stock	11.11	11.64	11.11	11.62	652300.0
2020-09-25	ABR.B-DELISTED	Stock	25.09	25.12	25.09	25.12	200.0
2020-09-25	ABR.C-DELISTED	Stock	25.4	25.507	25.4	25.4999	2300.0
2020-09-25	ABT	Stock	100.56	103.61	100.34	103.45	5060300.0
2020-09-25	ABTC	Stock	109200.0	116700.0	107100.0	108000.0	2.9733333333333336
2020-09-25	ABTS	Stock	19.5	22.485	19.275	21.0	7347.0

> showing 50 of 6,882 rows — these rows as CSV

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