PREVIEW / stock_daily / 2021-03-11

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-11.parquet
  size:    252 KB
  rows:    7,635
  symbols: 2,871

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-03-11	AAPL	Stock	122.54	123.21	121.26	121.96	103026500.0
2021-03-11	MSFT	Stock	234.96	239.17	234.31	237.13	29907600.0
2021-03-11	NVDA	Stock	12.95	13.0462	12.7345	12.9935	299916000.0
2021-03-11	AMZN	Stock	155.2005	156.589	154.1465	155.6795	55528000.0
2021-03-11	GOOGL	Stock	102.911	105.5635	102.8225	105.027	27702600.0
2021-03-11	META	Stock	268.11	277.9	267.82	273.88	21834000.0
2021-03-11	TSLA	Stock	233.1333	234.1667	225.7267	233.2	108761700.0
2021-03-11	TLT	Stock	139.17	139.38	138.46	139.01	14150742.0
2021-03-11	ES	Stock	81.29	82.28	80.7	80.83	1457900.0
2021-03-11	CL	Stock	75.57	75.86	75.11	75.27	4842600.0
2021-03-11	A	Stock	121.42	122.92	120.9	121.83	1818700.0
2021-03-11	AA	Stock	32.3	32.872	31.69	32.16	6259200.0
2021-03-11	AACG	Stock	4.52	4.93	4.32	4.78	447500.0
2021-03-11	AACQ-DELISTED	Stock	10.6	10.815	10.47	10.77	2983943.0
2021-03-11	AACQU-DELISTED	Stock	11.2	11.59	11.2	11.59	36805.0
2021-03-11	AACQW-DELISTED	Stock	2.17	2.64	2.06	2.4001	488678.0
2021-03-11	AAIC-DELISTED	Stock	4.29	4.4	4.28	4.35	83855.0
2021-03-11	AAIC.C-DELISTED	Stock	22.26	22.26	21.93	21.93	3898.0
2021-03-11	AAL	Stock	22.0	22.5	21.77	22.15	39002400.0
2021-03-11	AAM.A-DELISTED	Stock	25.85	25.92	25.83	25.91	28135.0
2021-03-11	AAM.B-DELISTED	Stock	26.63	26.634	26.51	26.59	20372.0
2021-03-11	AAMC-DELISTED	Stock	5.8949	6.0183	5.1471	5.3412	228273.0
2021-03-11	AAME	Stock	3.94	4.53	3.93	4.37	134900.0
2021-03-11	AAMI	Stock	20.38	20.39	19.9	20.38	228000.0
2021-03-11	AAN-DELISTED	Stock	24.31	24.55	23.67	24.4	447000.0
2021-03-11	AAOI	Stock	8.6	8.99	8.57	8.85	646900.0
2021-03-11	AAON	Stock	48.32	49.3267	48.06	48.9067	393150.0
2021-03-11	AAP	Stock	176.34	177.44	173.37	173.64	850300.0
2021-03-11	AAT	Stock	34.84	35.14	34.18	34.71	512300.0
2021-03-11	AAU-DELISTED	Stock	0.656	0.7074	0.6351	0.702	2186049.0
2021-03-11	AAUAF-DELISTED	Stock	0.656	0.7074	0.6351	0.702	2229740.0
2021-03-11	AAWW-DELISTED	Stock	61.0	61.73	60.08	61.73	442982.0
2021-03-11	AAXJ	Stock	95.38	96.15	94.99	96.07	625157.0
2021-03-11	AB	Stock	38.95	39.25	38.78	38.97	352100.0
2021-03-11	ABB-DELISTED	Stock	30.83	31.14	30.735	30.89	1354374.0
2021-03-11	ABBNY-DELISTED	Stock	30.83	31.14	30.735	30.89	1478115.0
2021-03-11	ABBV	Stock	108.13	108.63	107.34	107.87	4671400.0
2021-03-11	ABC-DELISTED	Stock	110.68	111.43	108.52	109.86	1116538.0
2021-03-11	ABCB	Stock	52.21	54.27	51.84	54.15	327000.0
2021-03-11	ABCL	Stock	34.22	36.22	32.9	36.0	1066100.0
2021-03-11	ABCM-DELISTED	Stock	21.25	21.63	21.11	21.63	22408.0
2021-03-11	ABEO	Stock	55.5	57.75	55.25	56.5	74164.0
2021-03-11	ABEV	Stock	2.76	2.78	2.73	2.75	14292200.0
2021-03-11	ABG	Stock	187.87	188.84	183.44	187.94	174400.0
2021-03-11	ABGI-DELISTED	Stock	10.09	10.1	10.01	10.08	149866.0
2021-03-11	ABM	Stock	50.73	51.96	49.75	51.54	472400.0
2021-03-11	ABMD-DELISTED	Stock	300.91	306.14	298.0404	304.36	159436.0
2021-03-11	ABNB	Stock	189.9	201.0	188.5	197.87	6031200.0
2021-03-11	ABR	Stock	16.45	16.61	16.3	16.5	1382400.0
2021-03-11	ABR.A-DELISTED	Stock	25.592	25.71	25.52	25.71	435.0

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

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