PREVIEW / stock_daily / 2022-03-29

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-29.parquet
  size:    264 KB
  rows:    8,110
  symbols: 2,540

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
2022-03-29	AAPL	Stock	176.69	179.01	176.34	178.96	100589400.0
2022-03-29	MSFT	Stock	313.91	315.82	309.05	315.41	30393400.0
2022-03-29	NVDA	Stock	28.695	28.946	27.98	28.656	488984000.0
2022-03-29	AMZN	Stock	170.384	170.8315	167.8685	169.315	66154000.0
2022-03-29	GOOGL	Stock	142.6475	143.7935	142.0382	142.5055	34317020.0
2022-03-29	META	Stock	226.07	230.89	225.29	229.86	31417900.0
2022-03-29	TSLA	Stock	369.33	371.59	357.7033	366.5233	73614900.0
2022-03-29	TLT	Stock	130.56	131.55	129.74	130.74	19319654.0
2022-03-29	ES	Stock	87.54	87.84	86.72	87.78	993600.0
2022-03-29	CL	Stock	76.14	76.79	75.75	76.2	4651500.0
2022-03-29	A	Stock	138.22	139.32	137.21	138.42	1608600.0
2022-03-29	AA	Stock	86.5	90.1	84.13	90.07	7530700.0
2022-03-29	AAC-DELISTED	Stock	9.79	9.79	9.77	9.79	189034.0
2022-03-29	AACG	Stock	1.34	1.4	1.34	1.37	15200.0
2022-03-29	AACIW-DELISTED	Stock	0.3099	0.3099	0.2999	0.3099	1900.0
2022-03-29	AAIC-DELISTED	Stock	3.555	3.5801	3.55	3.55	41808.0
2022-03-29	AAIC.C-DELISTED	Stock	24.9	24.9	24.9	24.9	255.0
2022-03-29	AAL	Stock	17.89	18.43	17.86	18.16	58105500.0
2022-03-29	AAM.A-DELISTED	Stock	25.17	25.17	25.1	25.16	9116.0
2022-03-29	AAM.B-DELISTED	Stock	25.35	25.62	25.35	25.62	44718.0
2022-03-29	AAMC-DELISTED	Stock	4.3897	4.4971	4.3824	4.4294	17772.0
2022-03-29	AAME	Stock	2.9	3.04	2.85	2.97	11200.0
2022-03-29	AAMI	Stock	24.57	24.95	24.55	24.95	457500.0
2022-03-29	AAN-DELISTED	Stock	22.1	22.49	21.669	22.05	228300.0
2022-03-29	AAOI	Stock	3.29	3.39	3.29	3.34	117900.0
2022-03-29	AAON	Stock	36.0267	37.8	35.42	37.4067	463950.0
2022-03-29	AAP	Stock	212.58	216.39	212.13	215.45	587300.0
2022-03-29	AAQC-DELISTED	Stock	9.72	9.74	9.72	9.73	68807.0
2022-03-29	AAT	Stock	37.52	38.96	37.52	38.84	426800.0
2022-03-29	AATC	Stock	6.45	6.485	6.25	6.25	10645.0
2022-03-29	AAU-DELISTED	Stock	0.355	0.3654	0.3462	0.357	820148.0
2022-03-29	AAUAF-DELISTED	Stock	0.355	0.3654	0.3462	0.36	826432.0
2022-03-29	AAWW-DELISTED	Stock	88.86	89.9	87.62	88.93	330941.0
2022-03-29	AAXJ	Stock	76.65	76.93	76.32	76.77	1577602.0
2022-03-29	AB	Stock	46.66	47.37	46.52	46.91	267400.0
2022-03-29	ABB-DELISTED	Stock	33.49	33.985	33.49	33.98	2764762.0
2022-03-29	ABBNY-DELISTED	Stock	33.49	33.985	33.49	33.97	3008656.0
2022-03-29	ABBV	Stock	162.99	163.28	161.29	162.18	6154100.0
2022-03-29	ABC-DELISTED	Stock	155.1	155.3499	153.38	155.04	625525.0
2022-03-29	ABCB	Stock	45.34	46.41	45.14	46.32	745500.0
2022-03-29	ABCL	Stock	9.6	9.9	9.33	9.78	2623800.0
2022-03-29	ABCM-DELISTED	Stock	18.72	18.87	18.4	18.73	65777.0
2022-03-29	ABEO	Stock	7.25	8.0	7.25	7.75	67644.0
2022-03-29	ABEV	Stock	3.16	3.19	3.13	3.18	20505100.0
2022-03-29	ABG	Stock	166.54	174.0	166.54	173.28	244100.0
2022-03-29	ABGI-DELISTED	Stock	9.76	9.78	9.76	9.78	325350.0
2022-03-29	ABM	Stock	44.83	45.72	44.55	45.52	488600.0
2022-03-29	ABMD-DELISTED	Stock	328.06	331.725	324.88	331.61	145748.0
2022-03-29	ABNB	Stock	172.11	178.88	171.81	175.52	5452800.0
2022-03-29	ABOS	Stock	4.75	4.85	4.3	4.38	360900.0

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

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