PREVIEW / stock_daily / 2021-05-20

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-20.parquet
  size:    256 KB
  rows:    7,836
  symbols: 2,938

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-05-20	AAPL	Stock	125.23	127.72	125.1	127.31	76857100.0
2021-05-20	MSFT	Stock	243.96	247.95	243.86	246.48	21800700.0
2021-05-20	NVDA	Stock	14.3025	14.6838	14.2705	14.6125	321592000.0
2021-05-20	AMZN	Stock	162.22	162.984	161.809	162.384	52664000.0
2021-05-20	GOOGL	Stock	114.55	115.6	114.176	115.3475	32351000.0
2021-05-20	META	Stock	313.58	319.25	313.16	318.61	17320200.0
2021-05-20	TSLA	Stock	191.6667	196.2833	190.3567	195.5933	92463300.0
2021-05-20	TLT	Stock	136.76	137.49	136.67	137.23	13310501.0
2021-05-20	ES	Stock	83.42	84.53	83.42	83.76	1413900.0
2021-05-20	CL	Stock	83.26	84.68	83.17	84.09	3966900.0
2021-05-20	A	Stock	130.61	132.79	130.61	132.15	1035100.0
2021-05-20	AA	Stock	36.36	36.36	35.28	35.82	7124300.0
2021-05-20	AAC-DELISTED	Stock	9.78	9.8	9.77	9.77	49669.0
2021-05-20	AACG	Stock	2.83	2.99	2.8	2.89	38800.0
2021-05-20	AACQ-DELISTED	Stock	9.85	9.88	9.84	9.85	347955.0
2021-05-20	AACQW-DELISTED	Stock	1.51	1.59	1.48	1.53	44221.0
2021-05-20	AAIC-DELISTED	Stock	3.95	4.02	3.94	4.01	243260.0
2021-05-20	AAIC.C-DELISTED	Stock	24.75	24.75	24.75	24.75	700.0
2021-05-20	AAL	Stock	23.18	23.18	22.29	22.6	33606500.0
2021-05-20	AAM.A-DELISTED	Stock	26.28	26.315	26.1	26.1765	33955.0
2021-05-20	AAM.B-DELISTED	Stock	27.07	27.195	26.97	27.0787	48335.0
2021-05-20	AAMC-DELISTED	Stock	5.2941	5.3147	5.103	5.2018	26724.0
2021-05-20	AAME	Stock	4.07	4.18	4.07	4.11	33100.0
2021-05-20	AAMI	Stock	22.49	22.84	22.31	22.69	276500.0
2021-05-20	AAN-DELISTED	Stock	32.92	33.99	32.669	33.76	262600.0
2021-05-20	AAOI	Stock	7.78	8.15	7.78	7.89	658200.0
2021-05-20	AAON	Stock	44.4733	44.72	44.2067	44.5867	126900.0
2021-05-20	AAP	Stock	194.7	197.99	193.11	196.95	980500.0
2021-05-20	AAQC-DELISTED	Stock	9.67	9.69	9.65	9.66	2021.0
2021-05-20	AAT	Stock	35.07	35.07	34.5	34.85	319200.0
2021-05-20	AAU-DELISTED	Stock	0.5517	0.56	0.5451	0.5532	450285.0
2021-05-20	AAUAF-DELISTED	Stock	0.5517	0.56	0.5451	0.555	468742.0
2021-05-20	AAWW-DELISTED	Stock	75.03	75.23	74.04	74.3	172874.0
2021-05-20	AAXJ	Stock	91.99	92.48	91.94	92.39	415772.0
2021-05-20	AB	Stock	43.6	43.92	43.12	43.4	381100.0
2021-05-20	ABB-DELISTED	Stock	33.14	33.4	33.11	33.34	827954.0
2021-05-20	ABBNY-DELISTED	Stock	33.14	33.4	33.11	33.33	918249.0
2021-05-20	ABBV	Stock	115.34	117.34	115.12	117.11	5526100.0
2021-05-20	ABC-DELISTED	Stock	118.51	120.64	118.26	120.04	727004.0
2021-05-20	ABCB	Stock	56.02	57.35	55.15	57.02	467600.0
2021-05-20	ABCL	Stock	32.35	32.96	31.13	31.79	365200.0
2021-05-20	ABCM-DELISTED	Stock	20.09	20.185	20.03	20.13	49703.0
2021-05-20	ABEO	Stock	37.5	39.75	37.5	39.25	51052.0
2021-05-20	ABEV	Stock	3.34	3.37	3.31	3.35	17548800.0
2021-05-20	ABG	Stock	195.54	198.64	192.53	193.35	96600.0
2021-05-20	ABGI-DELISTED	Stock	9.885	9.97	9.8301	9.97	800.0
2021-05-20	ABM	Stock	50.82	51.08	49.49	49.81	304000.0
2021-05-20	ABMD-DELISTED	Stock	276.41	279.985	274.85	276.26	120556.0
2021-05-20	ABNB	Stock	138.839	138.89	135.65	136.2	8903600.0
2021-05-20	ABR	Stock	17.45	17.63	17.16	17.56	1948900.0

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

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