PREVIEW / stock_daily / 2021-04-30

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-30.parquet
  size:    255 KB
  rows:    7,814
  symbols: 2,953

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-04-30	AAPL	Stock	131.78	133.56	131.07	131.46	109839500.0
2021-04-30	MSFT	Stock	249.74	253.08	249.6	252.18	30945100.0
2021-04-30	NVDA	Stock	15.1745	15.365	14.997	15.0095	201912000.0
2021-04-30	AMZN	Stock	176.256	177.7	173.125	173.371	140186000.0
2021-04-30	GOOGL	Stock	118.401	119.0925	117.328	117.675	44856760.0
2021-04-30	META	Stock	326.14	329.82	324.5	325.08	26332400.0
2021-04-30	TSLA	Stock	222.53	238.49	222.0467	236.48	122276100.0
2021-04-30	TLT	Stock	138.507	138.73	137.98	138.64	15692322.0
2021-04-30	ES	Stock	85.8	86.23	85.26	86.22	2935100.0
2021-04-30	CL	Stock	79.61	81.16	79.61	80.7	7252300.0
2021-04-30	A	Stock	133.9	134.66	133.15	133.64	1514200.0
2021-04-30	AA	Stock	36.52	38.07	36.35	36.64	6284700.0
2021-04-30	AAC-DELISTED	Stock	9.81	9.87	9.75	9.82	854924.0
2021-04-30	AACG	Stock	3.29	3.34	3.09	3.09	121000.0
2021-04-30	AACQ-DELISTED	Stock	10.02	10.06	10.0	10.0399	430002.0
2021-04-30	AACQU-DELISTED	Stock	10.8	10.8	10.8	10.8	149.0
2021-04-30	AACQW-DELISTED	Stock	1.7499	1.89	1.67	1.73	138136.0
2021-04-30	AAIC-DELISTED	Stock	4.04	4.12	4.01	4.1	314201.0
2021-04-30	AAIC.C-DELISTED	Stock	24.395	24.395	24.395	24.395	100.0
2021-04-30	AAL	Stock	21.17	21.88	21.08	21.72	31608800.0
2021-04-30	AAM.A-DELISTED	Stock	26.076	26.15	26.03	26.04	37858.0
2021-04-30	AAM.B-DELISTED	Stock	27.15	27.15	26.84	26.84	45903.0
2021-04-30	AAMC-DELISTED	Stock	5.0647	5.2941	4.9089	5.0676	80672.0
2021-04-30	AAME	Stock	4.17	4.2	4.04	4.09	61200.0
2021-04-30	AAMI	Stock	22.77	23.14	22.43	22.51	730700.0
2021-04-30	AAN-DELISTED	Stock	31.1	32.147	30.84	30.89	332100.0
2021-04-30	AAOI	Stock	7.81	7.828	7.4	7.41	1011400.0
2021-04-30	AAON	Stock	44.6667	44.6667	43.48	43.6067	264900.0
2021-04-30	AAP	Stock	199.89	202.47	199.11	200.16	544700.0
2021-04-30	AAT	Stock	35.27	35.27	34.66	35.05	233400.0
2021-04-30	AAU-DELISTED	Stock	0.5799	0.6	0.566	0.5921	1650062.0
2021-04-30	AAUAF-DELISTED	Stock	0.5799	0.6	0.566	0.5787	1686411.0
2021-04-30	AAWW-DELISTED	Stock	68.62	69.0	67.43	67.99	358885.0
2021-04-30	AAXJ	Stock	93.92	94.188	93.4303	93.68	426684.0
2021-04-30	AB	Stock	42.01	43.37	42.01	43.11	613700.0
2021-04-30	ABB-DELISTED	Stock	32.71	32.85	32.405	32.43	991284.0
2021-04-30	ABBNY-DELISTED	Stock	32.71	32.85	32.405	32.43	1151552.0
2021-04-30	ABBV	Stock	111.47	112.31	110.11	111.5	10575400.0
2021-04-30	ABC-DELISTED	Stock	121.06	122.0943	120.48	120.91	755018.0
2021-04-30	ABCB	Stock	53.85	55.02	53.46	54.09	641100.0
2021-04-30	ABCL	Stock	28.63	29.07	26.5	26.65	1062200.0
2021-04-30	ABCM-DELISTED	Stock	21.13	21.51	21.06	21.44	71039.0
2021-04-30	ABEO	Stock	41.0	45.0	40.25	44.25	80820.0
2021-04-30	ABEV	Stock	2.89	2.89	2.77	2.78	12611500.0
2021-04-30	ABG	Stock	202.24	203.71	197.38	198.61	286200.0
2021-04-30	ABGI-DELISTED	Stock	9.9215	9.9215	9.9215	9.9215	100.0
2021-04-30	ABM	Stock	52.37	52.68	51.27	51.41	1988100.0
2021-04-30	ABMD-DELISTED	Stock	320.09	327.0	319.52	320.32	146468.0
2021-04-30	ABNB	Stock	173.004	176.45	172.01	172.71	3580000.0
2021-04-30	ABR	Stock	17.87	17.87	17.6	17.68	851000.0

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

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