PREVIEW / stock_daily / 2021-04-28

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-28.parquet
  size:    254 KB
  rows:    7,780
  symbols: 2,942

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-28	AAPL	Stock	134.31	135.02	133.08	133.58	107760100.0
2021-04-28	MSFT	Stock	256.08	256.54	252.95	254.56	46903100.0
2021-04-28	NVDA	Stock	15.3645	15.5322	15.2155	15.2768	209416000.0
2021-04-28	AMZN	Stock	171.74	174.494	171.25	172.925	92638000.0
2021-04-28	GOOGL	Stock	119.6248	121.569	117.661	117.952	81106800.0
2021-04-28	META	Stock	307.36	310.92	305.37	307.1	33907200.0
2021-04-28	TSLA	Stock	232.1367	236.1667	231.2	231.4667	66813000.0
2021-04-28	TLT	Stock	138.65	138.89	137.96	138.73	15263720.0
2021-04-28	ES	Stock	87.17	87.37	85.21	85.45	1885900.0
2021-04-28	CL	Stock	79.06	79.27	78.58	78.77	3353300.0
2021-04-28	A	Stock	136.0	136.51	134.71	134.8	1603900.0
2021-04-28	AA	Stock	36.53	36.97	36.29	36.49	3468300.0
2021-04-28	AAC-DELISTED	Stock	9.84	9.84	9.79	9.81	137379.0
2021-04-28	AACG	Stock	3.32	3.4	3.21	3.33	145000.0
2021-04-28	AACQ-DELISTED	Stock	10.08	10.11	10.05	10.06	386475.0
2021-04-28	AACQU-DELISTED	Stock	10.81	10.81	10.81	10.81	100.0
2021-04-28	AACQW-DELISTED	Stock	1.85	1.9	1.8	1.85	124907.0
2021-04-28	AAIC-DELISTED	Stock	4.16	4.22	4.03	4.13	420211.0
2021-04-28	AAIC.C-DELISTED	Stock	24.15	24.25	24.15	24.2499	11833.0
2021-04-28	AAL	Stock	21.64	21.89	21.48	21.7	22572100.0
2021-04-28	AAM.A-DELISTED	Stock	26.1	26.13	26.0923	26.13	10021.0
2021-04-28	AAM.B-DELISTED	Stock	26.87	27.02	26.87	27.02	17389.0
2021-04-28	AAMC-DELISTED	Stock	5.1617	5.3088	5.1617	5.1618	71573.0
2021-04-28	AAME	Stock	4.02	4.39	4.0	4.29	143800.0
2021-04-28	AAMI	Stock	23.45	23.45	23.07	23.17	368500.0
2021-04-28	AAN-DELISTED	Stock	34.26	34.26	31.66	32.18	666900.0
2021-04-28	AAOI	Stock	8.09	8.24	7.98	8.2	261100.0
2021-04-28	AAON	Stock	45.5267	45.5267	44.72	45.4067	188250.0
2021-04-28	AAP	Stock	196.97	199.27	196.13	197.63	516700.0
2021-04-28	AAT	Stock	34.36	35.4	34.36	34.69	184800.0
2021-04-28	AAU-DELISTED	Stock	0.5564	0.5831	0.55	0.569	1327905.0
2021-04-28	AAUAF-DELISTED	Stock	0.5564	0.5831	0.55	0.569	1357270.0
2021-04-28	AAWW-DELISTED	Stock	68.73	69.69	67.82	69.43	244379.0
2021-04-28	AAXJ	Stock	95.1	95.68	94.81	95.28	860620.0
2021-04-28	AB	Stock	43.08	43.3	41.45	41.85	446100.0
2021-04-28	ABB-DELISTED	Stock	33.21	33.41	33.175	33.3	882494.0
2021-04-28	ABBNY-DELISTED	Stock	33.21	33.41	33.175	33.29	1274304.0
2021-04-28	ABBV	Stock	111.68	112.57	111.32	111.93	5116000.0
2021-04-28	ABC-DELISTED	Stock	119.12	119.6899	118.14	119.35	798185.0
2021-04-28	ABCB	Stock	52.35	52.9	51.96	52.67	351600.0
2021-04-28	ABCL	Stock	29.0	30.62	28.96	30.03	516100.0
2021-04-28	ABCM-DELISTED	Stock	21.0	21.3	20.91	21.13	79991.0
2021-04-28	ABEO	Stock	42.5	43.0	41.0	42.0	37144.0
2021-04-28	ABEV	Stock	2.87	2.88	2.83	2.85	11196600.0
2021-04-28	ABG	Stock	207.69	207.69	202.88	204.7	109200.0
2021-04-28	ABGI-DELISTED	Stock	9.9202	9.945	9.9202	9.945	850.0
2021-04-28	ABM	Stock	52.81	52.81	52.25	52.4	351400.0
2021-04-28	ABMD-DELISTED	Stock	340.64	352.57	338.25	351.0	214739.0
2021-04-28	ABNB	Stock	174.437	181.67	173.351	180.0	2409700.0
2021-04-28	ABR	Stock	17.5	17.78	17.47	17.78	799100.0

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

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