PREVIEW / stock_daily / 2022-10-27

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-27.parquet
  size:    251 KB
  rows:    7,822
  symbols: 2,115

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-10-27	AAPL	Stock	148.07	149.05	144.13	144.8	109180200.0
2022-10-27	MSFT	Stock	231.04	233.69	225.78	226.75	40424600.0
2022-10-27	NVDA	Stock	13.63	13.838	13.122	13.176	583113000.0
2022-10-27	AMZN	Stock	113.92	114.12	109.77	110.96	129605400.0
2022-10-27	GOOGL	Stock	94.52	95.43	91.8	92.22	60710859.0
2022-10-27	META	Stock	97.98	102.5	96.38	97.94	232316600.0
2022-10-27	TSLA	Stock	229.77	233.81	222.85	225.09	61638800.0
2022-10-27	TLT	Stock	96.98	97.9	96.215	97.47	20270036.0
2022-10-27	ES	Stock	74.78	75.95	74.57	74.67	1622300.0
2022-10-27	CL	Stock	73.69	74.24	73.06	73.23	5128900.0
2022-10-27	A	Stock	137.26	137.99	135.33	136.49	930700.0
2022-10-27	AA	Stock	42.58	42.81	41.19	41.41	5169100.0
2022-10-27	AAC-DELISTED	Stock	9.97	9.98	9.97	9.97	15028.0
2022-10-27	AACG	Stock	1.83	1.83	1.76	1.81	2500.0
2022-10-27	AACIW-DELISTED	Stock	0.0299	0.0454	0.0299	0.04	10000.0
2022-10-27	AAIC-DELISTED	Stock	2.73	3.017	2.68	3.0	51267.0
2022-10-27	AAIC.C-DELISTED	Stock	19.7388	20.0	19.7388	19.74	3484.0
2022-10-27	AAL	Stock	14.18	14.48	13.96	13.97	25575200.0
2022-10-27	AAM.A-DELISTED	Stock	21.67	22.19	21.67	21.9	15024.0
2022-10-27	AAM.B-DELISTED	Stock	22.43	23.12	22.15	22.6688	5919.0
2022-10-27	AAMC-DELISTED	Stock	4.3529	4.7941	4.2059	4.2941	7150.0
2022-10-27	AAME	Stock	3.07	3.09	2.97	3.05	8500.0
2022-10-27	AAMI	Stock	18.52	18.75	18.29	18.3	270000.0
2022-10-27	AAN-DELISTED	Stock	10.08	11.24	10.03	10.5	1234100.0
2022-10-27	AAOI	Stock	2.97	3.0	2.8	2.81	280700.0
2022-10-27	AAON	Stock	41.3067	42.7733	41.2933	42.0867	158550.0
2022-10-27	AAP	Stock	184.39	189.84	183.94	188.08	1141400.0
2022-10-27	AAQC-DELISTED	Stock	9.93	9.94	9.92	9.93	912100.0
2022-10-27	AAT	Stock	27.92	28.12	27.11	27.19	423700.0
2022-10-27	AATC	Stock	4.37	4.435	4.28	4.28	8608.0
2022-10-27	AAU-DELISTED	Stock	0.23	0.238	0.221	0.233	850854.0
2022-10-27	AAUAF-DELISTED	Stock	0.23	0.238	0.221	0.233	892203.0
2022-10-27	AAWW-DELISTED	Stock	100.88	101.2	100.475	100.55	234195.0
2022-10-27	AAXJ	Stock	56.63	56.93	56.28	56.3	752653.0
2022-10-27	AB	Stock	36.24	36.59	35.36	35.51	227000.0
2022-10-27	ABB-DELISTED	Stock	27.88	28.26	27.86	27.91	1390025.0
2022-10-27	ABBNY-DELISTED	Stock	27.89	28.26	27.86	27.91	1563429.0
2022-10-27	ABBV	Stock	153.76	153.99	152.06	153.5	6850400.0
2022-10-27	ABC-DELISTED	Stock	155.35	158.11	155.35	156.0	666173.0
2022-10-27	ABCB	Stock	51.56	52.25	50.99	51.28	364500.0
2022-10-27	ABCL	Stock	10.95	10.95	10.56	10.74	1595200.0
2022-10-27	ABCM-DELISTED	Stock	15.79	15.86	15.48	15.72	321456.0
2022-10-27	ABEO	Stock	4.51	4.6	4.12	4.33	182700.0
2022-10-27	ABEV	Stock	2.9	2.96	2.84	2.89	39647900.0
2022-10-27	ABG	Stock	156.58	164.02	153.82	157.95	163800.0
2022-10-27	ABGI-DELISTED	Stock	9.96	9.96	9.96	9.96	6596.0
2022-10-27	ABM	Stock	44.2	45.22	43.97	44.41	263400.0
2022-10-27	ABMD-DELISTED	Stock	270.99	273.51	263.06	267.82	133913.0
2022-10-27	ABNB	Stock	116.05	116.37	111.925	112.06	4594000.0
2022-10-27	ABOS	Stock	7.57	7.57	7.01	7.07	155300.0

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

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