PREVIEW / stock_daily / 2021-02-11

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-11.parquet
  size:    248 KB
  rows:    7,501
  symbols: 2,778

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-11	AAPL	Stock	135.9	136.39	133.77	135.13	64280000.0
2021-02-11	MSFT	Stock	244.78	245.15	242.15	244.49	15751100.0
2021-02-11	NVDA	Stock	14.9803	15.2722	14.925	15.2508	450828000.0
2021-02-11	AMZN	Stock	164.6	164.6	162.403	163.1065	46028000.0
2021-02-11	GOOGL	Stock	104.55	104.7	103.443	104.4375	20480580.0
2021-02-11	META	Stock	271.89	273.58	268.49	270.39	12828600.0
2021-02-11	TSLA	Stock	270.8133	276.6267	267.2433	270.5533	64868400.0
2021-02-11	TLT	Stock	149.6791	149.79	148.75	148.96	11962758.0
2021-02-11	ES	Stock	87.03	87.47	86.03	86.23	942600.0
2021-02-11	CL	Stock	79.25	79.3	78.35	78.41	3106000.0
2021-02-11	A	Stock	125.7	127.26	125.11	126.96	1122200.0
2021-02-11	AA	Stock	21.51	21.67	20.97	21.39	3865100.0
2021-02-11	AACG	Stock	6.02	6.25	5.37	5.62	1095000.0
2021-02-11	AACQ-DELISTED	Stock	11.35	11.88	11.18	11.27	1426671.0
2021-02-11	AACQU-DELISTED	Stock	12.3	12.54	11.94	11.94	139230.0
2021-02-11	AACQW-DELISTED	Stock	2.6	2.66	2.35	2.5416	256302.0
2021-02-11	AAIC-DELISTED	Stock	3.69	3.7618	3.645	3.72	173446.0
2021-02-11	AAIC.C-DELISTED	Stock	22.6	22.6	22.25	22.47	3400.0
2021-02-11	AAL	Stock	17.3	17.4	16.79	16.99	38746400.0
2021-02-11	AAM.A-DELISTED	Stock	26.29	26.29	26.07	26.2	18949.0
2021-02-11	AAM.B-DELISTED	Stock	26.89	26.89	26.74	26.74	13965.0
2021-02-11	AAMC-DELISTED	Stock	7.7059	8.2853	7.4118	8.1559	58126.0
2021-02-11	AAME	Stock	5.61	5.63	5.2	5.26	427600.0
2021-02-11	AAMI	Stock	19.59	20.13	19.34	19.8	473600.0
2021-02-11	AAN-DELISTED	Stock	19.95	20.05	19.31	19.94	547300.0
2021-02-11	AAOI	Stock	11.9	12.38	11.6	12.36	524200.0
2021-02-11	AAON	Stock	53.4667	53.7667	51.7267	52.9067	232050.0
2021-02-11	AAP	Stock	161.0	161.78	154.07	154.46	1538400.0
2021-02-11	AAT	Stock	29.7	30.8	29.61	30.3	324300.0
2021-02-11	AAU-DELISTED	Stock	0.9639	1.01	0.863	0.917	11131370.0
2021-02-11	AAUAF-DELISTED	Stock	0.9639	1.01	0.863	0.915	11474092.0
2021-02-11	AAWW-DELISTED	Stock	55.48	56.0	53.37	54.32	191656.0
2021-02-11	AAXJ	Stock	101.4	102.03	101.29	101.69	618669.0
2021-02-11	AB	Stock	38.5	38.71	37.02	38.7	623500.0
2021-02-11	ABB-DELISTED	Stock	29.31	29.405	29.02	29.25	1580917.0
2021-02-11	ABBNY-DELISTED	Stock	29.31	29.405	29.02	29.26	1674342.0
2021-02-11	ABBV	Stock	104.57	104.68	103.32	103.75	5090100.0
2021-02-11	ABC-DELISTED	Stock	106.63	106.72	104.22	104.52	757674.0
2021-02-11	ABCB	Stock	46.05	46.58	44.68	45.66	317500.0
2021-02-11	ABCL	Stock	48.0	48.41	44.589	46.0	807300.0
2021-02-11	ABCM-DELISTED	Stock	23.36	23.41	22.95	23.07	178351.0
2021-02-11	ABEO	Stock	86.5	88.75	77.0	84.0	286748.0
2021-02-11	ABEV	Stock	2.82	2.87	2.78	2.83	16992200.0
2021-02-11	ABG	Stock	160.84	163.14	156.7	159.13	147200.0
2021-02-11	ABM	Stock	41.75	42.46	40.32	40.73	294400.0
2021-02-11	ABMD-DELISTED	Stock	324.84	327.43	319.49	322.48	170559.0
2021-02-11	ABNB	Stock	213.5	219.94	207.0	216.84	3595200.0
2021-02-11	ABR	Stock	15.24	15.46	14.88	15.27	969700.0
2021-02-11	ABR.A-DELISTED	Stock	25.81	25.96	25.5	25.5878	9688.0
2021-02-11	ABR.B-DELISTED	Stock	25.3	25.378	25.3	25.34	1571.0

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

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