PREVIEW / stock_daily / 2021-03-04

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-04.parquet
  size:    251 KB
  rows:    7,596
  symbols: 2,842

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-04	AAPL	Stock	121.75	123.6	118.62	120.13	178155000.0
2021-03-04	MSFT	Stock	226.74	232.49	224.26	226.73	44727800.0
2021-03-04	NVDA	Stock	12.8008	12.975	12.0838	12.3702	573344000.0
2021-03-04	AMZN	Stock	150.6	152.9065	147.2715	148.8785	109632000.0
2021-03-04	GOOGL	Stock	100.7434	103.7295	100.2715	101.6965	49215720.0
2021-03-04	META	Stock	256.47	266.49	253.5	257.64	31626500.0
2021-03-04	TSLA	Stock	218.6	222.8167	200.0	207.1467	197758500.0
2021-03-04	TLT	Stock	139.632	139.94	137.96	138.64	22366564.0
2021-03-04	ES	Stock	77.92	79.37	77.03	77.27	1765100.0
2021-03-04	CL	Stock	74.92	75.94	74.27	74.44	6337500.0
2021-03-04	A	Stock	118.69	118.83	113.34	114.99	2725000.0
2021-03-04	AA	Stock	29.715	30.39	27.36	28.59	10364300.0
2021-03-04	AACG	Stock	4.51	4.63	4.05	4.26	249200.0
2021-03-04	AACQ-DELISTED	Stock	10.38	10.54	10.13	10.25	5555241.0
2021-03-04	AACQU-DELISTED	Stock	11.09	11.09	10.64	10.79	32690.0
2021-03-04	AACQW-DELISTED	Stock	2.1	2.15	1.62	1.79	891912.0
2021-03-04	AAIC-DELISTED	Stock	3.98	4.05	3.91	4.01	282432.0
2021-03-04	AAIC.C-DELISTED	Stock	22.06	22.2999	22.06	22.09	6060.0
2021-03-04	AAL	Stock	22.28	22.42	20.41	21.24	61124200.0
2021-03-04	AAM.A-DELISTED	Stock	25.76	25.87	25.63	25.78	55257.0
2021-03-04	AAM.B-DELISTED	Stock	26.37	26.4	26.15	26.25	20507.0
2021-03-04	AAMC-DELISTED	Stock	7.6088	7.8834	6.7029	6.7029	188183.0
2021-03-04	AAME	Stock	4.43	4.43	3.6	3.65	118800.0
2021-03-04	AAMI	Stock	18.79	19.33	18.395	18.65	503900.0
2021-03-04	AAN-DELISTED	Stock	22.16	23.21	22.16	23.1	687100.0
2021-03-04	AAOI	Stock	8.35	8.63	7.7	7.99	1238400.0
2021-03-04	AAON	Stock	49.2867	50.0733	47.92	48.0467	357000.0
2021-03-04	AAP	Stock	165.89	167.83	162.44	165.54	862700.0
2021-03-04	AAT	Stock	33.95	34.49	33.03	33.82	484000.0
2021-03-04	AAU-DELISTED	Stock	0.68	0.7088	0.57	0.6355	3440715.0
2021-03-04	AAUAF-DELISTED	Stock	0.68	0.7088	0.57	0.6313	3493959.0
2021-03-04	AAWW-DELISTED	Stock	56.81	57.9544	54.66	55.14	513361.0
2021-03-04	AAXJ	Stock	95.22	95.58	92.85	93.39	931327.0
2021-03-04	AB	Stock	38.02	38.16	36.06	36.46	956700.0
2021-03-04	ABB-DELISTED	Stock	29.71	29.785	28.66	29.17	3857355.0
2021-03-04	ABBNY-DELISTED	Stock	29.71	29.785	28.66	29.17	4105029.0
2021-03-04	ABBV	Stock	106.5	107.75	104.95	105.65	7503700.0
2021-03-04	ABC-DELISTED	Stock	102.7	104.85	101.85	103.05	645288.0
2021-03-04	ABCB	Stock	50.44	52.18	48.97	49.86	459400.0
2021-03-04	ABCL	Stock	35.5	35.5	29.569	30.05	2272500.0
2021-03-04	ABCM-DELISTED	Stock	21.5	21.68	20.9591	21.115	83250.0
2021-03-04	ABEO	Stock	54.75	56.75	48.25	52.0	185192.0
2021-03-04	ABEV	Stock	2.61	2.68	2.59	2.66	56229900.0
2021-03-04	ABG	Stock	166.28	169.87	161.13	167.92	159900.0
2021-03-04	ABGI-DELISTED	Stock	10.04	10.04	9.9	9.99	580082.0
2021-03-04	ABM	Stock	44.53	45.09	43.96	44.44	348400.0
2021-03-04	ABMD-DELISTED	Stock	306.29	311.65	289.52	295.76	222907.0
2021-03-04	ABNB	Stock	178.64	183.9	170.87	180.23	9993700.0
2021-03-04	ABR	Stock	16.3	16.5	15.54	15.92	1554800.0
2021-03-04	ABR.B-DELISTED	Stock	25.42	25.42	25.42	25.42	100.0

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

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