PREVIEW / stock_daily / 2021-12-21

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-21.parquet
  size:    261 KB
  rows:    7,971
  symbols: 2,588

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-21	AAPL	Stock	171.56	173.2	169.12	172.99	91185900.0
2021-12-21	MSFT	Stock	323.29	327.73	319.8	327.29	24740600.0
2021-12-21	NVDA	Stock	28.374	29.12	27.401	29.075	524385000.0
2021-12-21	AMZN	Stock	167.8505	170.7165	165.6475	170.417	55956000.0
2021-12-21	GOOGL	Stock	142.0535	143.869	140.5025	143.4725	28755360.0
2021-12-21	META	Stock	326.41	336.0	323.75	334.2	16116800.0
2021-12-21	TSLA	Stock	305.6233	313.1667	295.3733	312.8433	71517900.0
2021-12-21	TLT	Stock	148.14	149.2	147.62	149.13	16598163.0
2021-12-21	ES	Stock	90.18	90.65	88.57	88.96	874000.0
2021-12-21	CL	Stock	82.31	82.74	81.77	82.09	4630800.0
2021-12-21	A	Stock	151.0	154.06	150.61	153.96	1496600.0
2021-12-21	AA	Stock	53.8	57.24	53.75	56.79	10784100.0
2021-12-21	AAC-DELISTED	Stock	9.75	9.78	9.75	9.76	39166.0
2021-12-21	AACG	Stock	1.24	1.28	1.15	1.19	22100.0
2021-12-21	AACIU	Stock	10.0	10.05	10.0	10.03	44805.0
2021-12-21	AACIW-DELISTED	Stock	0.48	0.5	0.452	0.4999	363642.0
2021-12-21	AAIC-DELISTED	Stock	3.35	3.54	3.35	3.51	165562.0
2021-12-21	AAIC.C-DELISTED	Stock	25.7	25.7	25.35	25.35	1100.0
2021-12-21	AAL	Stock	17.45	18.46	17.4	18.12	47592000.0
2021-12-21	AAM.A-DELISTED	Stock	25.4094	25.4094	25.35	25.3786	11525.0
2021-12-21	AAM.B-DELISTED	Stock	26.2826	26.3799	26.2826	26.344	7943.0
2021-12-21	AAME	Stock	3.12	3.36	3.09	3.12	8600.0
2021-12-21	AAMI	Stock	25.16	25.43	24.88	25.28	2057600.0
2021-12-21	AAN-DELISTED	Stock	23.84	24.5	23.84	24.22	166000.0
2021-12-21	AAOI	Stock	5.4	5.545	5.4	5.47	393400.0
2021-12-21	AAON	Stock	51.6933	52.32	51.34	51.94	195900.0
2021-12-21	AAP	Stock	229.89	231.2	227.78	229.57	498300.0
2021-12-21	AAQC-DELISTED	Stock	9.7001	9.72	9.7001	9.72	600.0
2021-12-21	AAT	Stock	35.29	36.12	35.1	36.11	268100.0
2021-12-21	AATC	Stock	6.48	6.5	6.25	6.4	40319.0
2021-12-21	AAU-DELISTED	Stock	0.2909	0.3078	0.29	0.3018	778900.0
2021-12-21	AAUAF-DELISTED	Stock	0.2909	0.3078	0.29	0.296	783033.0
2021-12-21	AAWW-DELISTED	Stock	89.11	90.1048	88.55	89.08	312763.0
2021-12-21	AAXJ	Stock	80.96	81.74	80.94	81.72	1245807.0
2021-12-21	AB	Stock	46.07	46.82	45.95	46.67	269400.0
2021-12-21	ABB-DELISTED	Stock	36.71	37.01	36.5689	37.0	866214.0
2021-12-21	ABBNY-DELISTED	Stock	36.71	37.01	36.5689	37.0	982336.0
2021-12-21	ABBV	Stock	131.23	131.35	129.15	129.95	6085900.0
2021-12-21	ABC-DELISTED	Stock	126.84	129.5	126.745	127.65	960071.0
2021-12-21	ABCB	Stock	47.29	48.58	47.2	48.2	550600.0
2021-12-21	ABCL	Stock	14.92	15.8	14.6	15.74	1510600.0
2021-12-21	ABCM-DELISTED	Stock	21.88	21.91	21.485	21.51	87680.0
2021-12-21	ABEO	Stock	7.75	8.5	7.5	8.25	359040.0
2021-12-21	ABEV	Stock	2.66	2.69	2.64	2.66	15879100.0
2021-12-21	ABG	Stock	161.33	164.06	159.16	163.0	234800.0
2021-12-21	ABGI-DELISTED	Stock	9.76	9.8	9.75	9.8	4020.0
2021-12-21	ABM	Stock	39.2	40.46	39.2	40.41	408300.0
2021-12-21	ABMD-DELISTED	Stock	318.24	333.07	318.24	332.58	169927.0
2021-12-21	ABNB	Stock	159.5	167.275	158.37	165.66	6293500.0
2021-12-21	ABOS	Stock	6.96	7.08	6.81	7.07	249300.0

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

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