PREVIEW / stock_daily / 2022-03-28

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-28.parquet
  size:    261 KB
  rows:    8,032
  symbols: 2,504

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-28	AAPL	Stock	172.17	175.73	172.0	175.6	90371900.0
2022-03-28	MSFT	Stock	304.33	310.8	304.33	310.7	29578200.0
2022-03-28	NVDA	Stock	27.756	28.25	27.206	28.219	425494000.0
2022-03-28	AMZN	Stock	164.975	169.0375	164.9	168.9905	59854000.0
2022-03-28	GOOGL	Stock	140.9005	142.0025	139.8112	141.4555	35049260.0
2022-03-28	META	Stock	222.13	224.04	219.54	223.59	26224100.0
2022-03-28	TSLA	Stock	355.0333	365.96	351.2	363.9467	102506100.0
2022-03-28	TLT	Stock	129.39	130.56	129.04	129.76	17657777.0
2022-03-28	ES	Stock	86.96	87.04	86.18	87.03	1115800.0
2022-03-28	CL	Stock	74.84	75.42	74.84	75.39	3646200.0
2022-03-28	A	Stock	136.25	137.25	134.46	135.42	1568100.0
2022-03-28	AA	Stock	90.64	92.87	88.11	92.46	5111300.0
2022-03-28	AAC-DELISTED	Stock	9.78	9.785	9.77	9.785	10977.0
2022-03-28	AACG	Stock	1.45	1.46	1.31	1.35	31700.0
2022-03-28	AACIW-DELISTED	Stock	0.3098	0.3098	0.2553	0.2553	3301.0
2022-03-28	AAIC-DELISTED	Stock	3.5	3.56	3.5	3.56	91533.0
2022-03-28	AAIC.C-DELISTED	Stock	24.71	24.71	24.71	24.71	100.0
2022-03-28	AAL	Stock	17.27	17.38	16.82	17.3	29985300.0
2022-03-28	AAM.A-DELISTED	Stock	24.96	25.14	24.96	25.12	15491.0
2022-03-28	AAM.B-DELISTED	Stock	25.13	25.44	25.13	25.4	32905.0
2022-03-28	AAMC-DELISTED	Stock	4.4412	4.4441	4.3118	4.3765	15120.0
2022-03-28	AAME	Stock	2.82	2.9	2.8	2.85	6300.0
2022-03-28	AAMI	Stock	23.98	24.17	23.47	24.16	521200.0
2022-03-28	AAN-DELISTED	Stock	21.79	22.01	21.46	21.92	204200.0
2022-03-28	AAOI	Stock	3.27	3.27	3.11	3.24	303900.0
2022-03-28	AAON	Stock	35.1467	35.2067	34.12	34.7867	254850.0
2022-03-28	AAP	Stock	215.92	215.92	210.07	210.49	706100.0
2022-03-28	AAQC-DELISTED	Stock	9.73	9.735	9.72	9.73	86125.0
2022-03-28	AAT	Stock	36.79	37.1	36.37	37.1	310000.0
2022-03-28	AATC	Stock	6.27	6.3698	6.26	6.26	11395.0
2022-03-28	AAU-DELISTED	Stock	0.36	0.377	0.341	0.3649	765092.0
2022-03-28	AAUAF-DELISTED	Stock	0.36	0.377	0.341	0.365	771710.0
2022-03-28	AAWW-DELISTED	Stock	88.76	89.82	88.07	89.0	248371.0
2022-03-28	AAXJ	Stock	75.13	75.45	74.71	75.42	760982.0
2022-03-28	AB	Stock	46.14	46.19	45.37	46.08	212800.0
2022-03-28	ABB-DELISTED	Stock	33.3	33.56	33.12	33.53	2324818.0
2022-03-28	ABBNY-DELISTED	Stock	33.3	33.56	33.12	33.54	2652083.0
2022-03-28	ABBV	Stock	160.61	162.03	159.53	161.97	4516500.0
2022-03-28	ABC-DELISTED	Stock	154.05	154.8	152.51	154.78	442472.0
2022-03-28	ABCB	Stock	44.93	45.07	43.65	44.32	425200.0
2022-03-28	ABCL	Stock	9.47	9.7	9.2	9.49	1777800.0
2022-03-28	ABCM-DELISTED	Stock	17.87	18.61	17.74	18.54	159957.0
2022-03-28	ABEO	Stock	7.5	7.75	7.25	7.25	33484.0
2022-03-28	ABEV	Stock	3.0	3.08	2.98	3.06	27942100.0
2022-03-28	ABG	Stock	173.22	174.23	161.78	164.71	274200.0
2022-03-28	ABM	Stock	44.86	45.08	44.22	44.49	228300.0
2022-03-28	ABMD-DELISTED	Stock	320.77	322.92	314.5899	321.81	102165.0
2022-03-28	ABNB	Stock	167.22	168.719	162.43	167.65	3829800.0
2022-03-28	ABOS	Stock	5.06	5.125	4.63	4.66	188400.0
2022-03-28	ABR	Stock	17.18	17.3	17.09	17.19	1526700.0

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

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