PREVIEW / stock_daily / 2021-03-24

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-24.parquet
  size:    253 KB
  rows:    7,689
  symbols: 2,904

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-03-24	AAPL	Stock	122.82	122.9	120.07	120.09	88530500.0
2021-03-24	MSFT	Stock	237.85	238.0	235.32	235.46	25620100.0
2021-03-24	NVDA	Stock	13.1512	13.1592	12.6368	12.643	245840000.0
2021-03-24	AMZN	Stock	157.552	158.0155	154.2575	154.3535	59180000.0
2021-03-24	GOOGL	Stock	102.588	103.38	101.45	101.6265	25217060.0
2021-03-24	META	Stock	291.0	291.72	281.16	282.14	18675000.0
2021-03-24	TSLA	Stock	222.6367	222.6733	210.0367	210.09	101385600.0
2021-03-24	TLT	Stock	137.06	138.28	136.945	138.23	13862975.0
2021-03-24	ES	Stock	83.89	86.13	83.71	85.63	2341400.0
2021-03-24	CL	Stock	76.9	78.26	76.9	77.77	4255400.0
2021-03-24	A	Stock	122.12	122.96	120.74	120.84	1477500.0
2021-03-24	AA	Stock	29.72	30.48	28.59	28.76	9127500.0
2021-03-24	AACG	Stock	4.3	4.44	4.0	4.09	274000.0
2021-03-24	AACQ-DELISTED	Stock	10.13	10.24	10.0	10.055	1977126.0
2021-03-24	AACQU-DELISTED	Stock	10.925	11.14	10.55	10.55	10902.0
2021-03-24	AACQW-DELISTED	Stock	2.01	2.02	1.83	1.83	230240.0
2021-03-24	AAIC-DELISTED	Stock	3.94	4.1202	3.89	3.89	235298.0
2021-03-24	AAIC.C-DELISTED	Stock	22.54	23.2	22.5071	22.85	4564.0
2021-03-24	AAL	Stock	22.79	23.18	21.76	21.81	44703900.0
2021-03-24	AAM.A-DELISTED	Stock	26.02	26.02	25.8814	25.95	20052.0
2021-03-24	AAM.B-DELISTED	Stock	26.73	26.84	26.73	26.82	13698.0
2021-03-24	AAMC-DELISTED	Stock	5.2676	5.2699	5.0426	5.2699	73488.0
2021-03-24	AAME	Stock	5.0	5.0	4.08	4.09	407200.0
2021-03-24	AAMI	Stock	19.01	19.38	18.68	18.77	460000.0
2021-03-24	AAN-DELISTED	Stock	24.29	24.74	24.17	24.39	348600.0
2021-03-24	AAOI	Stock	8.23	8.26	7.69	7.7	924300.0
2021-03-24	AAON	Stock	47.0067	48.0333	46.2267	46.3133	190200.0
2021-03-24	AAP	Stock	179.53	183.72	179.53	181.73	812900.0
2021-03-24	AAT	Stock	32.84	33.48	32.34	32.34	299300.0
2021-03-24	AAU-DELISTED	Stock	0.5628	0.5684	0.5411	0.555	2693741.0
2021-03-24	AAUAF-DELISTED	Stock	0.5628	0.5684	0.5411	0.555	2755337.0
2021-03-24	AAWW-DELISTED	Stock	57.93	58.5773	55.09	55.09	320869.0
2021-03-24	AAXJ	Stock	91.78	91.78	90.0	90.01	1461398.0
2021-03-24	AB	Stock	41.2	41.8	39.9	40.0	471800.0
2021-03-24	ABB-DELISTED	Stock	30.99	31.11	30.825	30.85	1258813.0
2021-03-24	ABBNY-DELISTED	Stock	30.99	31.11	30.825	30.85	1408286.0
2021-03-24	ABBV	Stock	104.82	105.33	103.05	103.06	9420100.0
2021-03-24	ABC-DELISTED	Stock	113.66	116.85	113.43	115.36	1017823.0
2021-03-24	ABCB	Stock	52.85	54.41	51.59	51.65	439900.0
2021-03-24	ABCL	Stock	29.47	29.97	27.61	27.79	634700.0
2021-03-24	ABCM-DELISTED	Stock	20.26	20.26	19.64	19.71	55755.0
2021-03-24	ABEO	Stock	48.75	50.0	44.25	44.5	103004.0
2021-03-24	ABEV	Stock	2.75	2.78	2.65	2.67	17261900.0
2021-03-24	ABG	Stock	183.95	185.05	180.3	181.38	217100.0
2021-03-24	ABGI-DELISTED	Stock	9.85	9.85	9.72	9.76	14046.0
2021-03-24	ABM	Stock	49.87	50.33	49.49	49.96	566600.0
2021-03-24	ABMD-DELISTED	Stock	298.74	301.4949	291.8482	294.11	194424.0
2021-03-24	ABNB	Stock	189.0	189.78	178.51	178.85	3756100.0
2021-03-24	ABR	Stock	16.16	16.57	16.01	16.01	958600.0
2021-03-24	ABR.A-DELISTED	Stock	25.96	25.96	25.6512	25.6512	468.0

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

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