PREVIEW / stock_daily / 2021-01-05

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-05.parquet
  size:    240 KB
  rows:    7,279
  symbols: 2,636

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
2021-01-05	AAPL	Stock	128.89	131.74	128.43	131.01	97664900.0
2021-01-05	MSFT	Stock	217.26	218.52	215.7	217.9	23823000.0
2021-01-05	NVDA	Stock	13.0998	13.4435	13.087	13.4048	322760000.0
2021-01-05	AMZN	Stock	158.3005	161.169	158.253	160.9255	53110000.0
2021-01-05	GOOGL	Stock	86.2545	87.3415	85.845	87.0025	20359240.0
2021-01-05	META	Stock	268.29	272.4	268.21	270.97	9871600.0
2021-01-05	TSLA	Stock	241.22	246.9467	239.7333	245.0367	96735600.0
2021-01-05	TLT	Stock	156.95	156.95	155.66	156.37	10458065.0
2021-01-05	ES	Stock	84.31	85.28	84.23	85.12	2209200.0
2021-01-05	CL	Stock	84.33	84.82	83.37	84.52	2559300.0
2021-01-05	A	Stock	118.48	120.32	118.07	119.61	2344000.0
2021-01-05	AA	Stock	23.3	24.12	23.22	23.67	4297900.0
2021-01-05	AACG	Stock	1.2	1.27	1.19	1.23	21300.0
2021-01-05	AACQ-DELISTED	Stock	10.66	10.66	10.48	10.6	612797.0
2021-01-05	AACQU-DELISTED	Stock	11.21	11.29	11.18	11.29	18567.0
2021-01-05	AACQW-DELISTED	Stock	2.14	2.25	2.075	2.19	299063.0
2021-01-05	AAIC-DELISTED	Stock	3.67	3.9	3.67	3.77	215007.0
2021-01-05	AAL	Stock	14.92	15.63	14.87	15.43	53368200.0
2021-01-05	AAM.A-DELISTED	Stock	26.46	26.69	26.46	26.6635	8744.0
2021-01-05	AAM.B-DELISTED	Stock	27.22	27.22	27.1	27.14	10937.0
2021-01-05	AAMC-DELISTED	Stock	7.0118	7.0118	7.0118	7.0118	1156.0
2021-01-05	AAME	Stock	2.5	2.79	2.25	2.6	825500.0
2021-01-05	AAMI	Stock	18.72	18.895	18.61	18.64	516900.0
2021-01-05	AAN-DELISTED	Stock	18.65	19.99	18.53	19.57	528400.0
2021-01-05	AAOI	Stock	8.47	8.99	8.42	8.91	863900.0
2021-01-05	AAON	Stock	42.9933	44.14	42.9933	43.6267	232800.0
2021-01-05	AAP	Stock	156.23	158.14	155.34	157.17	619500.0
2021-01-05	AAT	Stock	27.44	27.83	27.24	27.64	203800.0
2021-01-05	AAU-DELISTED	Stock	0.49	0.5169	0.4859	0.5063	2569036.0
2021-01-05	AAUAF-DELISTED	Stock	0.49	0.5169	0.4859	0.5063	2650342.0
2021-01-05	AAWW-DELISTED	Stock	54.96	56.28	53.58	53.8	300551.0
2021-01-05	AAXJ	Stock	91.47	92.72	91.47	92.65	1247699.0
2021-01-05	AAXN-DELISTED	Stock	116.41	122.54	116.01	122.36	480638.0
2021-01-05	AB	Stock	33.37	33.67	33.1	33.19	164900.0
2021-01-05	ABB-DELISTED	Stock	28.51	29.04	28.49	28.92	2595245.0
2021-01-05	ABBNY-DELISTED	Stock	28.51	29.04	28.49	28.92	2719534.0
2021-01-05	ABBV	Stock	105.41	107.02	104.63	106.5	6823800.0
2021-01-05	ABC-DELISTED	Stock	96.73	98.88	94.89	97.77	1382460.0
2021-01-05	ABCB	Stock	38.18	39.55	37.88	39.11	506900.0
2021-01-05	ABCL	Stock	38.81	39.5	37.7	38.51	1727200.0
2021-01-05	ABCM-DELISTED	Stock	20.33	20.34	19.9	20.3	72164.0
2021-01-05	ABEO	Stock	42.75	44.75	42.5	43.5	91936.0
2021-01-05	ABEV	Stock	2.91	3.06	2.9	3.06	79550700.0
2021-01-05	ABG	Stock	142.03	148.86	141.69	147.27	143000.0
2021-01-05	ABM	Stock	36.94	38.53	36.94	38.19	328300.0
2021-01-05	ABMD-DELISTED	Stock	316.79	326.29	316.73	322.87	149904.0
2021-01-05	ABNB	Stock	138.28	149.0	137.25	148.3	5974200.0
2021-01-05	ABR	Stock	13.85	14.06	13.77	13.96	756200.0
2021-01-05	ABR.A-DELISTED	Stock	25.4701	25.555	25.46	25.47	3395.0
2021-01-05	ABR.B-DELISTED	Stock	25.3	25.46	25.3	25.46	1600.0

> showing 50 of 7,279 rows — these rows as CSV

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