PREVIEW / stock_daily / 2022-09-13

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-13.parquet
  size:    251 KB
  rows:    7,818
  symbols: 2,184

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-09-13	AAPL	Stock	159.9	160.54	153.37	153.84	122656600.0
2022-09-13	MSFT	Stock	258.84	260.4	251.59	251.99	33353300.0
2022-09-13	NVDA	Stock	13.802	13.922	13.099	13.131	714956000.0
2022-09-13	AMZN	Stock	131.01	131.4	126.27	126.82	72694000.0
2022-09-13	GOOGL	Stock	107.8	108.3	104.09	104.32	38172871.0
2022-09-13	META	Stock	161.54	161.63	152.67	153.13	44444100.0
2022-09-13	TSLA	Stock	292.9	297.4	290.4	292.13	68229600.0
2022-09-13	TLT	Stock	106.56	107.735	106.24	107.67	22158884.0
2022-09-13	ES	Stock	91.75	92.0	89.25	89.64	1839800.0
2022-09-13	CL	Stock	77.56	77.83	75.33	75.43	3988500.0
2022-09-13	A	Stock	136.32	137.41	133.44	133.54	1587000.0
2022-09-13	AA	Stock	50.34	52.44	49.83	50.29	4331600.0
2022-09-13	AAC-DELISTED	Stock	9.91	9.93	9.91	9.93	1333463.0
2022-09-13	AACG	Stock	1.97	2.06	1.92	2.01	36800.0
2022-09-13	AAIC-DELISTED	Stock	3.19	3.2	3.12	3.12	27309.0
2022-09-13	AAIC.C-DELISTED	Stock	21.6001	21.9999	21.59	21.9999	2733.0
2022-09-13	AAL	Stock	13.93	14.11	13.63	13.68	31432900.0
2022-09-13	AAM.A-DELISTED	Stock	24.14	24.2	23.9	24.19	7732.0
2022-09-13	AAM.B-DELISTED	Stock	23.96	24.358	23.96	24.31	8059.0
2022-09-13	AAMC-DELISTED	Stock	5.8794	5.8794	5.8794	5.8794	4060.0
2022-09-13	AAME	Stock	3.07	3.09	2.99	3.07	3700.0
2022-09-13	AAMI	Stock	17.86	17.97	17.19	17.29	211000.0
2022-09-13	AAN-DELISTED	Stock	12.25	12.38	11.98	12.2	361500.0
2022-09-13	AAOI	Stock	2.38	2.5	2.33	2.42	192400.0
2022-09-13	AAON	Stock	38.7867	38.9933	37.88	38.1667	167850.0
2022-09-13	AAP	Stock	177.59	179.2	172.62	172.83	1005500.0
2022-09-13	AAQC-DELISTED	Stock	9.81	9.815	9.81	9.81	7200.0
2022-09-13	AAT	Stock	27.94	28.04	27.21	27.37	186400.0
2022-09-13	AATC	Stock	5.1779	5.21	5.09	5.1337	15441.0
2022-09-13	AAU-DELISTED	Stock	0.2226	0.2315	0.22	0.2251	158541.0
2022-09-13	AAUAF-DELISTED	Stock	0.2226	0.2315	0.22	0.2251	165060.0
2022-09-13	AAWW-DELISTED	Stock	99.81	100.1	99.735	99.79	738781.0
2022-09-13	AAXJ	Stock	65.54	65.9	64.8	64.88	771994.0
2022-09-13	AB	Stock	42.98	43.02	42.26	42.49	207000.0
2022-09-13	ABB-DELISTED	Stock	28.63	28.8	28.11	28.155	1960076.0
2022-09-13	ABBNY-DELISTED	Stock	28.63	28.8	28.11	28.15	2116872.0
2022-09-13	ABBV	Stock	140.55	141.93	137.49	138.53	6195900.0
2022-09-13	ABC-DELISTED	Stock	146.34	146.62	140.39	140.95	765934.0
2022-09-13	ABCB	Stock	47.18	47.43	46.35	46.86	364900.0
2022-09-13	ABCL	Stock	10.71	10.86	10.6	10.74	1227400.0
2022-09-13	ABCM-DELISTED	Stock	15.71	15.84	15.55	15.72	220170.0
2022-09-13	ABEO	Stock	3.86	3.87	3.72	3.85	61100.0
2022-09-13	ABEV	Stock	2.99	3.03	2.93	2.94	38486400.0
2022-09-13	ABG	Stock	167.39	168.47	159.03	161.12	225400.0
2022-09-13	ABGI-DELISTED	Stock	9.88	9.89	9.88	9.89	347600.0
2022-09-13	ABLV	Stock	9.94	9.94	9.94	9.94	30077.0
2022-09-13	ABM	Stock	43.07	43.4	41.48	41.74	592100.0
2022-09-13	ABMD-DELISTED	Stock	272.9	272.9	265.8	266.3	95295.0
2022-09-13	ABNB	Stock	119.7	123.86	119.05	121.54	7126500.0
2022-09-13	ABOS	Stock	6.17	6.33	5.81	6.05	20300.0

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

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