PREVIEW / stock_daily / 2022-03-23

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-23.parquet
  size:    260 KB
  rows:    7,989
  symbols: 2,464

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-23	AAPL	Stock	167.99	172.64	167.65	170.21	98062700.0
2022-03-23	MSFT	Stock	300.51	303.23	297.72	299.49	25715400.0
2022-03-23	NVDA	Stock	26.126	26.612	25.575	25.634	502120000.0
2022-03-23	AMZN	Stock	163.705	166.37	162.687	163.408	55812000.0
2022-03-23	GOOGL	Stock	138.7025	139.5885	137.835	138.2755	25153400.0
2022-03-23	META	Stock	213.33	216.8	212.16	213.46	23717300.0
2022-03-23	TSLA	Stock	326.6467	346.9	325.4667	333.0367	120676200.0
2022-03-23	TLT	Stock	129.37	131.6	128.86	131.5	21266117.0
2022-03-23	ES	Stock	84.33	85.35	83.92	84.68	1685300.0
2022-03-23	CL	Stock	74.7	74.91	73.54	73.63	3875900.0
2022-03-23	A	Stock	137.85	137.96	133.45	134.18	1337400.0
2022-03-23	AA	Stock	91.49	95.79	91.02	94.22	6848000.0
2022-03-23	AAC-DELISTED	Stock	9.76	9.78	9.76	9.78	2016208.0
2022-03-23	AACG	Stock	1.36	1.65	1.36	1.46	165900.0
2022-03-23	AACIU	Stock	9.87	9.87	9.87	9.87	301.0
2022-03-23	AACIW-DELISTED	Stock	0.235	0.251	0.2201	0.25	21963.0
2022-03-23	AAIC-DELISTED	Stock	3.42	3.5136	3.42	3.45	59011.0
2022-03-23	AAIC.C-DELISTED	Stock	24.59	24.6	24.59	24.59	561.0
2022-03-23	AAL	Stock	16.31	16.46	16.17	16.21	31336000.0
2022-03-23	AAM.A-DELISTED	Stock	25.03	25.03	24.96	24.99	15670.0
2022-03-23	AAM.B-DELISTED	Stock	25.15	25.2769	25.12	25.25	9367.0
2022-03-23	AAMC-DELISTED	Stock	4.3824	4.6765	4.0735	4.1324	204224.0
2022-03-23	AAME	Stock	2.67	2.75	2.62	2.63	13300.0
2022-03-23	AAMI	Stock	25.235	25.32	24.59	24.63	689600.0
2022-03-23	AAN-DELISTED	Stock	22.2	22.26	21.07	21.16	232000.0
2022-03-23	AAOI	Stock	3.35	3.45	3.25	3.34	248300.0
2022-03-23	AAON	Stock	36.8733	36.9	35.6933	35.7867	258150.0
2022-03-23	AAP	Stock	208.85	214.29	207.17	213.34	962100.0
2022-03-23	AAQC-DELISTED	Stock	9.73	9.73	9.72	9.729	480.0
2022-03-23	AAT	Stock	36.36	36.57	35.92	36.02	291900.0
2022-03-23	AATC	Stock	6.65	6.65	6.4	6.44	18831.0
2022-03-23	AAU-DELISTED	Stock	0.385	0.388	0.367	0.38	640871.0
2022-03-23	AAUAF-DELISTED	Stock	0.385	0.388	0.367	0.38	649674.0
2022-03-23	AAWW-DELISTED	Stock	85.92	87.26	85.82	86.67	165141.0
2022-03-23	AAXJ	Stock	75.57	76.48	75.22	75.52	1127845.0
2022-03-23	AB	Stock	46.09	46.4	45.29	45.7	382000.0
2022-03-23	ABB-DELISTED	Stock	34.83	35.1	34.71	34.82	2506316.0
2022-03-23	ABBNY-DELISTED	Stock	34.83	35.1	34.71	34.83	2742283.0
2022-03-23	ABBV	Stock	160.01	161.18	158.36	158.42	6300600.0
2022-03-23	ABC-DELISTED	Stock	152.01	152.56	150.54	151.52	740261.0
2022-03-23	ABCB	Stock	46.33	46.57	43.84	43.94	502000.0
2022-03-23	ABCL	Stock	9.27	9.73	9.11	9.42	2129500.0
2022-03-23	ABCM-DELISTED	Stock	17.81	18.04	17.71	17.9	174168.0
2022-03-23	ABEO	Stock	7.5	8.0	7.5	7.75	37348.0
2022-03-23	ABEV	Stock	2.89	2.94	2.86	2.92	22149800.0
2022-03-23	ABG	Stock	185.3	185.34	179.04	179.69	179300.0
2022-03-23	ABM	Stock	45.16	45.16	44.65	44.66	243900.0
2022-03-23	ABMD-DELISTED	Stock	310.2	312.345	302.6	311.53	133959.0
2022-03-23	ABNB	Stock	163.64	166.89	162.88	164.16	2814300.0
2022-03-23	ABOS	Stock	5.85	5.85	5.63	5.67	133300.0

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

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