PREVIEW / stock_daily / 2021-02-23

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-23.parquet
  size:    249 KB
  rows:    7,555
  symbols: 2,809

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-02-23	AAPL	Stock	123.76	126.71	118.39	125.86	158273000.0
2021-02-23	MSFT	Stock	230.33	234.83	228.73	233.27	30228700.0
2021-02-23	NVDA	Stock	14.0752	14.2388	13.3895	14.142	391780000.0
2021-02-23	AMZN	Stock	156.3515	160.2365	154.68	159.725	93544000.0
2021-02-23	GOOGL	Stock	100.6995	103.625	99.5115	103.006	34657980.0
2021-02-23	META	Stock	259.5	267.46	254.96	265.86	21924600.0
2021-02-23	TSLA	Stock	220.71	237.87	206.3333	232.9467	199820700.0
2021-02-23	TLT	Stock	141.52	142.5	141.14	141.77	12658455.0
2021-02-23	ES	Stock	79.17	80.75	78.76	80.19	1752100.0
2021-02-23	CL	Stock	77.8	78.44	77.0	77.49	4131400.0
2021-02-23	A	Stock	123.51	123.51	120.41	122.42	2125400.0
2021-02-23	AA	Stock	23.86	25.09	22.95	24.9	6009800.0
2021-02-23	AACG	Stock	5.21	5.65	4.45	4.46	863200.0
2021-02-23	AACQ-DELISTED	Stock	12.6	12.9	11.805	12.39	3944818.0
2021-02-23	AACQU-DELISTED	Stock	14.45	14.45	12.69	13.36	219336.0
2021-02-23	AACQW-DELISTED	Stock	3.49	3.6	3.0	3.39	1158455.0
2021-02-23	AAIC-DELISTED	Stock	4.06	4.06	3.8784	3.95	197017.0
2021-02-23	AAIC.C-DELISTED	Stock	22.7	22.77	22.5	22.6	13219.0
2021-02-23	AAL	Stock	20.68	21.05	18.74	20.66	78817600.0
2021-02-23	AAM.A-DELISTED	Stock	26.06	26.06	26.0	26.03	34811.0
2021-02-23	AAM.B-DELISTED	Stock	26.69	26.69	26.58	26.59	10484.0
2021-02-23	AAMC-DELISTED	Stock	6.7711	6.9529	6.5824	6.9059	27384.0
2021-02-23	AAME	Stock	4.75	4.75	4.2	4.41	130400.0
2021-02-23	AAMI	Stock	18.95	19.08	18.39	18.87	447300.0
2021-02-23	AAN-DELISTED	Stock	22.28	22.95	20.77	20.93	616900.0
2021-02-23	AAOI	Stock	11.41	11.54	10.41	11.4	784300.0
2021-02-23	AAON	Stock	50.4867	51.54	50.0733	51.22	199050.0
2021-02-23	AAP	Stock	169.41	169.41	163.85	166.19	906200.0
2021-02-23	AAT	Stock	31.52	31.79	31.23	31.62	472900.0
2021-02-23	AAU-DELISTED	Stock	0.7899	0.7899	0.65	0.7385	4143066.0
2021-02-23	AAUAF-DELISTED	Stock	0.7899	0.7899	0.65	0.7385	4425993.0
2021-02-23	AAWW-DELISTED	Stock	58.61	58.61	54.2257	57.83	585909.0
2021-02-23	AAXJ	Stock	97.61	99.1	96.77	98.76	1742416.0
2021-02-23	AB	Stock	36.57	36.7	35.45	36.19	613900.0
2021-02-23	ABB-DELISTED	Stock	29.01	29.3	28.615	29.29	2075342.0
2021-02-23	ABBNY-DELISTED	Stock	29.01	29.3	28.615	29.29	2220368.0
2021-02-23	ABBV	Stock	106.97	107.6	105.96	106.27	7058600.0
2021-02-23	ABC-DELISTED	Stock	106.76	108.0	104.5	106.46	528775.0
2021-02-23	ABCB	Stock	48.35	49.35	47.85	49.08	341800.0
2021-02-23	ABCL	Stock	39.61	40.0	35.73	38.83	911300.0
2021-02-23	ABCM-DELISTED	Stock	23.42	23.44	22.75	23.25	26467.0
2021-02-23	ABEO	Stock	53.5	54.25	47.0	52.5	198820.0
2021-02-23	ABEV	Stock	2.7	2.77	2.66	2.76	26068200.0
2021-02-23	ABG	Stock	163.23	165.79	157.46	165.0	140100.0
2021-02-23	ABGI-DELISTED	Stock	10.38	10.405	10.25	10.3	283532.0
2021-02-23	ABM	Stock	43.32	44.68	43.01	43.73	279100.0
2021-02-23	ABMD-DELISTED	Stock	319.54	323.01	310.5	321.68	214720.0
2021-02-23	ABNB	Stock	189.0	191.67	175.0	187.59	5902400.0
2021-02-23	ABR	Stock	16.37	16.57	16.07	16.41	2108400.0
2021-02-23	ABR.A-DELISTED	Stock	26.0475	26.0475	26.0475	26.0475	100.0

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

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