PREVIEW / stock_daily / 2021-12-03

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-03.parquet
  size:    260 KB
  rows:    8,001
  symbols: 2,652

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-12-03	AAPL	Stock	164.02	164.96	159.72	161.84	118023100.0
2021-12-03	MSFT	Stock	331.99	332.7	318.03	323.01	41779300.0
2021-12-03	NVDA	Stock	32.0	32.129	30.13	30.693	544325000.0
2021-12-03	AMZN	Stock	172.75	173.4935	166.93	169.4895	80712000.0
2021-12-03	GOOGL	Stock	143.681	144.4	140.301	142.0015	41230160.0
2021-12-03	META	Stock	313.73	313.75	299.5	306.84	27471000.0
2021-12-03	TSLA	Stock	361.5967	363.5267	333.4033	338.3233	92322000.0
2021-12-03	TLT	Stock	151.68	155.12	151.35	154.35	34427106.0
2021-12-03	ES	Stock	83.74	85.39	82.72	85.3	1554600.0
2021-12-03	CL	Stock	76.02	76.78	75.44	76.77	5206200.0
2021-12-03	A	Stock	151.82	153.0	147.72	149.33	1412600.0
2021-12-03	AA	Stock	44.76	44.92	43.26	44.07	5930800.0
2021-12-03	AAC-DELISTED	Stock	9.78	9.8	9.78	9.78	72258.0
2021-12-03	AACG	Stock	1.57	1.57	1.24	1.32	39100.0
2021-12-03	AACIW-DELISTED	Stock	0.5146	0.52	0.495	0.5	6092.0
2021-12-03	AAIC-DELISTED	Stock	3.66	3.69	3.64	3.65	107847.0
2021-12-03	AAIC.C-DELISTED	Stock	25.66	25.75	25.63	25.75	1059.0
2021-12-03	AAL	Stock	17.27	17.29	16.34	16.62	57884000.0
2021-12-03	AAM.A-DELISTED	Stock	25.38	25.38	25.2129	25.25	11323.0
2021-12-03	AAM.B-DELISTED	Stock	26.14	26.28	25.9	25.93	15996.0
2021-12-03	AAME	Stock	3.8	3.81	3.71	3.76	6400.0
2021-12-03	AAMI	Stock	29.8	29.98	26.92	27.33	1571400.0
2021-12-03	AAN-DELISTED	Stock	23.0	23.25	22.66	22.81	267100.0
2021-12-03	AAOI	Stock	5.52	5.6	5.29	5.4	536700.0
2021-12-03	AAON	Stock	52.8933	53.1467	52.3933	53.0133	559050.0
2021-12-03	AAP	Stock	229.17	231.69	225.32	226.86	543800.0
2021-12-03	AAQC-DELISTED	Stock	9.73	9.73	9.72	9.73	18388.0
2021-12-03	AAT	Stock	35.28	35.49	34.62	35.01	224600.0
2021-12-03	AATC	Stock	6.85	6.85	6.45	6.51	25077.0
2021-12-03	AAU-DELISTED	Stock	0.3152	0.3224	0.3101	0.316	724540.0
2021-12-03	AAUAF-DELISTED	Stock	0.3152	0.3224	0.3101	0.316	729919.0
2021-12-03	AAWW-DELISTED	Stock	86.84	87.74	85.87	86.94	278495.0
2021-12-03	AAXJ	Stock	84.08	84.13	82.67	83.01	1381393.0
2021-12-03	AB	Stock	51.41	51.41	50.06	50.79	289700.0
2021-12-03	ABB-DELISTED	Stock	35.9	35.93	35.07	35.425	1730198.0
2021-12-03	ABBNY-DELISTED	Stock	35.9	35.93	35.07	35.42	1936009.0
2021-12-03	ABBV	Stock	117.74	119.0	117.0	118.85	6428100.0
2021-12-03	ABC-DELISTED	Stock	116.88	118.805	115.79	116.76	897661.0
2021-12-03	ABCB	Stock	49.87	50.01	48.28	48.77	298000.0
2021-12-03	ABCL	Stock	14.87	14.94	13.69	14.02	2936700.0
2021-12-03	ABCM-DELISTED	Stock	22.5	22.51	21.99	22.1	226459.0
2021-12-03	ABEO	Stock	15.25	15.25	14.0	14.25	36964.0
2021-12-03	ABEV	Stock	2.83	2.85	2.78	2.82	25577700.0
2021-12-03	ABG	Stock	167.79	169.15	163.89	166.84	308600.0
2021-12-03	ABGI-DELISTED	Stock	9.78	9.79	9.75	9.78	4700.0
2021-12-03	ABM	Stock	45.53	45.61	43.99	44.73	461700.0
2021-12-03	ABMD-DELISTED	Stock	314.35	316.62	295.71	300.65	155091.0
2021-12-03	ABNB	Stock	168.98	170.73	162.14	166.75	6460900.0
2021-12-03	ABOS	Stock	8.25	8.4	7.733	7.81	80000.0
2021-12-03	ABR	Stock	17.76	17.82	17.4	17.42	1445800.0

> showing 50 of 8,001 rows — these rows as CSV

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