PREVIEW / stock_daily / 2022-03-14

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-14.parquet
  size:    259 KB
  rows:    8,005
  symbols: 2,487

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-14	AAPL	Stock	151.45	154.12	150.1	150.62	108732100.0
2022-03-14	MSFT	Stock	280.34	285.4	275.82	276.44	30660700.0
2022-03-14	NVDA	Stock	21.869	22.262	21.159	21.33	385354000.0
2022-03-14	AMZN	Stock	145.981	147.45	140.884	141.853	74086000.0
2022-03-14	GOOGL	Stock	130.25	130.409	125.275	125.951	38811260.0
2022-03-14	META	Stock	187.03	192.29	185.82	186.63	31010500.0
2022-03-14	TSLA	Stock	260.2033	266.9	252.0133	255.4567	71152200.0
2022-03-14	TLT	Stock	132.7	132.89	131.72	131.76	24384956.0
2022-03-14	ES	Stock	84.42	85.04	82.78	83.22	2429200.0
2022-03-14	CL	Stock	74.31	75.27	73.79	73.96	4080800.0
2022-03-14	A	Stock	131.0	132.26	126.9	127.58	1737100.0
2022-03-14	AA	Stock	77.17	77.17	72.048	73.5	7915100.0
2022-03-14	AAC-DELISTED	Stock	9.76	9.775	9.75	9.75	1519009.0
2022-03-14	AACG	Stock	1.28	1.33	1.15	1.24	61100.0
2022-03-14	AACIW-DELISTED	Stock	0.33	0.33	0.32	0.32	900.0
2022-03-14	AAIC-DELISTED	Stock	3.62	3.63	3.56	3.56	83920.0
2022-03-14	AAIC.C-DELISTED	Stock	25.0	25.0	24.69	24.7	1400.0
2022-03-14	AAL	Stock	14.04	14.83	13.7	14.25	53284300.0
2022-03-14	AAM.A-DELISTED	Stock	25.0	25.0	24.66	24.76	16247.0
2022-03-14	AAM.B-DELISTED	Stock	25.06	25.1	24.95	25.02	63310.0
2022-03-14	AAME	Stock	2.35	2.35	2.27	2.27	1900.0
2022-03-14	AAMI	Stock	23.88	25.09	23.88	24.09	858400.0
2022-03-14	AAN-DELISTED	Stock	21.75	22.71	21.57	21.78	242400.0
2022-03-14	AAOI	Stock	3.46	3.46	3.0	3.02	732600.0
2022-03-14	AAON	Stock	35.8933	36.1667	34.84	35.22	252300.0
2022-03-14	AAP	Stock	202.71	204.0	197.28	199.17	1229000.0
2022-03-14	AAQC-DELISTED	Stock	9.73	9.74	9.73	9.73	168228.0
2022-03-14	AAT	Stock	36.57	36.57	35.83	36.13	214600.0
2022-03-14	AATC	Stock	6.56	6.7395	6.3	6.41	28677.0
2022-03-14	AAU-DELISTED	Stock	0.3898	0.3898	0.3252	0.3294	2788093.0
2022-03-14	AAUAF-DELISTED	Stock	0.3898	0.3898	0.3252	0.3293	2809944.0
2022-03-14	AAWW-DELISTED	Stock	81.26	81.99	79.43	80.9	280860.0
2022-03-14	AAXJ	Stock	70.3	70.95	69.22	69.43	1882716.0
2022-03-14	AB	Stock	43.85	44.23	42.32	42.44	507500.0
2022-03-14	ABB-DELISTED	Stock	33.56	33.76	33.125	33.3	2020263.0
2022-03-14	ABBNY-DELISTED	Stock	33.56	33.76	33.125	33.3	2259831.0
2022-03-14	ABBV	Stock	150.73	152.97	149.02	152.1	8647200.0
2022-03-14	ABC-DELISTED	Stock	145.99	146.35	143.19	146.15	689649.0
2022-03-14	ABCB	Stock	48.78	49.69	46.7	47.07	458000.0
2022-03-14	ABCL	Stock	7.99	8.12	7.35	7.46	2052200.0
2022-03-14	ABCM-DELISTED	Stock	16.2	16.97	16.12	16.13	309868.0
2022-03-14	ABEO	Stock	7.5	7.5	6.75	7.0	53884.0
2022-03-14	ABEV	Stock	2.61	2.65	2.58	2.62	27252600.0
2022-03-14	ABG	Stock	189.49	190.24	179.38	181.59	400900.0
2022-03-14	ABGI-DELISTED	Stock	9.75	9.77	9.75	9.76	1199.0
2022-03-14	ABM	Stock	46.26	46.43	45.41	46.02	375600.0
2022-03-14	ABMD-DELISTED	Stock	287.28	290.66	274.3	277.82	108511.0
2022-03-14	ABNB	Stock	143.41	144.67	136.04	138.5	6330200.0
2022-03-14	ABOS	Stock	5.51	5.59	5.232	5.29	209200.0
2022-03-14	ABR	Stock	17.66	17.75	17.25	17.27	2084100.0

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

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