PREVIEW / stock_daily / 2021-02-02

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-02.parquet
  size:    244 KB
  rows:    7,404
  symbols: 2,714

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-02	AAPL	Stock	135.73	136.31	134.61	134.99	83305400.0
2021-02-02	MSFT	Stock	241.3	242.31	238.69	239.51	25916300.0
2021-02-02	NVDA	Stock	13.3988	13.572	13.2855	13.5568	220440000.0
2021-02-02	AMZN	Stock	169.0	171.387	168.0565	169.0	141972000.0
2021-02-02	GOOGL	Stock	95.6565	97.4685	95.3185	95.956	66332400.0
2021-02-02	META	Stock	264.0	268.85	263.27	267.08	17320800.0
2021-02-02	TSLA	Stock	281.56	293.5	280.7333	290.93	73038600.0
2021-02-02	TLT	Stock	150.74	151.085	150.52	151.02	9177457.0
2021-02-02	ES	Stock	88.05	89.18	87.22	88.23	1035100.0
2021-02-02	CL	Stock	78.85	79.75	78.56	78.85	5018800.0
2021-02-02	A	Stock	122.5	125.85	122.42	123.19	1489200.0
2021-02-02	AA	Stock	19.16	19.375	18.805	19.11	7218500.0
2021-02-02	AACG	Stock	1.34	1.41	1.34	1.4	25300.0
2021-02-02	AACQ-DELISTED	Stock	10.79	10.9594	10.78	10.84	958477.0
2021-02-02	AACQU-DELISTED	Stock	11.6396	11.65	11.58	11.64	36936.0
2021-02-02	AACQW-DELISTED	Stock	2.26	2.31	2.2	2.25	223818.0
2021-02-02	AAIC-DELISTED	Stock	3.64	3.69	3.585	3.63	157384.0
2021-02-02	AAIC.C-DELISTED	Stock	21.73	21.86	21.7278	21.85	1054.0
2021-02-02	AAL	Stock	17.03	17.26	16.55	16.59	39287800.0
2021-02-02	AAM.A-DELISTED	Stock	26.46	26.84	26.46	26.7	21006.0
2021-02-02	AAM.B-DELISTED	Stock	26.91	27.45	26.91	27.36	44274.0
2021-02-02	AAMC-DELISTED	Stock	6.4647	6.4647	6.3559	6.4559	2162.0
2021-02-02	AAME	Stock	2.32	2.32	2.23	2.24	23500.0
2021-02-02	AAMI	Stock	19.38	19.95	19.24	19.88	399200.0
2021-02-02	AAN-DELISTED	Stock	18.19	18.72	18.01	18.36	305900.0
2021-02-02	AAOI	Stock	11.05	11.08	10.26	10.63	654000.0
2021-02-02	AAON	Stock	50.4733	50.9	49.6533	50.5667	196650.0
2021-02-02	AAP	Stock	151.87	156.58	151.08	154.08	1569200.0
2021-02-02	AAT	Stock	28.3	28.3	27.61	27.89	183000.0
2021-02-02	AAU-DELISTED	Stock	0.778	0.8164	0.71	0.7884	10612829.0
2021-02-02	AAUAF-DELISTED	Stock	0.778	0.8164	0.71	0.7843	11029252.0
2021-02-02	AAWW-DELISTED	Stock	54.88	54.88	51.79	52.33	452610.0
2021-02-02	AAXJ	Stock	97.67	97.73	97.14	97.5	1417465.0
2021-02-02	AB	Stock	37.45	37.73	36.33	36.89	696000.0
2021-02-02	ABB-DELISTED	Stock	30.16	30.515	30.12	30.46	1474827.0
2021-02-02	ABBNY-DELISTED	Stock	30.16	30.515	30.12	30.47	1678924.0
2021-02-02	ABBV	Stock	102.88	104.31	102.5	103.47	10481300.0
2021-02-02	ABC-DELISTED	Stock	108.1	110.0	105.54	105.61	924408.0
2021-02-02	ABCB	Stock	42.05	42.05	40.59	41.44	311100.0
2021-02-02	ABCL	Stock	53.19	54.0	47.521	47.95	743900.0
2021-02-02	ABCM-DELISTED	Stock	22.54	22.85	22.4706	22.72	93427.0
2021-02-02	ABEO	Stock	50.0	51.25	49.0	50.75	74208.0
2021-02-02	ABEV	Stock	2.99	3.01	2.89	2.92	30748300.0
2021-02-02	ABG	Stock	151.9	155.55	137.96	144.44	390800.0
2021-02-02	ABM	Stock	38.9	38.9	38.0	38.59	224500.0
2021-02-02	ABMD-DELISTED	Stock	346.13	351.45	339.66	346.96	182024.0
2021-02-02	ABNB	Stock	183.22	186.479	177.11	179.17	4413600.0
2021-02-02	ABR	Stock	14.54	14.91	14.53	14.85	1255000.0
2021-02-02	ABR.A-DELISTED	Stock	25.77	25.95	25.77	25.95	2970.0
2021-02-02	ABR.B-DELISTED	Stock	25.67	25.67	25.66	25.66	1254.0

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

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