PREVIEW / stock_daily / 2022-12-09

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-09.parquet
  size:    249 KB
  rows:    7,747
  symbols: 2,021

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-12-09	AAPL	Stock	142.34	145.57	140.9	142.16	76097000.0
2022-12-09	MSFT	Stock	244.7	248.31	244.16	245.42	20609700.0
2022-12-09	NVDA	Stock	17.16	17.583	16.975	17.001	465338000.0
2022-12-09	AMZN	Stock	88.9	90.3	88.63	89.09	67398500.0
2022-12-09	GOOGL	Stock	93.77	94.26	92.75	92.83	28225448.0
2022-12-09	META	Stock	115.3	117.54	113.87	115.9	26033400.0
2022-12-09	TSLA	Stock	173.84	182.5	173.36	179.05	104872300.0
2022-12-09	TLT	Stock	107.94	108.17	106.27	106.33	25872173.0
2022-12-09	ES	Stock	84.36	84.84	83.79	84.05	1160300.0
2022-12-09	CL	Stock	77.97	78.36	77.7	77.78	2516700.0
2022-12-09	A	Stock	155.67	156.7	152.68	152.95	1020200.0
2022-12-09	AA	Stock	45.81	46.15	44.78	45.08	4587200.0
2022-12-09	AAC-DELISTED	Stock	10.08	10.08	10.06	10.06	346770.0
2022-12-09	AACG	Stock	1.51	1.51	1.46	1.47	3300.0
2022-12-09	AAIC-DELISTED	Stock	3.0016	3.0016	2.95	2.97	34413.0
2022-12-09	AAIC.C-DELISTED	Stock	21.68	21.68	21.68	21.68	119.0
2022-12-09	AAL	Stock	13.52	13.66	13.42	13.53	18535400.0
2022-12-09	AAM.A-DELISTED	Stock	23.63	23.6338	22.9503	22.9503	18126.0
2022-12-09	AAM.B-DELISTED	Stock	24.6	24.655	22.9	23.01	19207.0
2022-12-09	AAMC-DELISTED	Stock	6.7618	6.9632	6.6176	6.6176	21923.0
2022-12-09	AAME	Stock	2.57	2.58	2.53	2.57	3600.0
2022-12-09	AAMI	Stock	19.43	19.56	19.38	19.46	71300.0
2022-12-09	AAN-DELISTED	Stock	11.66	11.94	11.49	11.73	192100.0
2022-12-09	AAOI	Stock	2.15	2.185	2.11	2.12	46500.0
2022-12-09	AAON	Stock	52.9667	53.7933	51.9	53.6667	242550.0
2022-12-09	AAP	Stock	145.23	147.56	144.92	145.9	831400.0
2022-12-09	AAQC-DELISTED	Stock	10.09	10.09	10.07	10.08	23520.0
2022-12-09	AAT	Stock	26.95	27.37	26.95	27.16	158600.0
2022-12-09	AATC	Stock	5.15	5.2	5.15	5.1853	5999.0
2022-12-09	AAU-DELISTED	Stock	0.24	0.2483	0.2351	0.2406	100906.0
2022-12-09	AAUAF-DELISTED	Stock	0.24	0.2483	0.2351	0.24	102921.0
2022-12-09	AAWW-DELISTED	Stock	100.69	100.78	100.5	100.57	150520.0
2022-12-09	AAXJ	Stock	67.13	67.27	66.64	66.64	864538.0
2022-12-09	AB	Stock	38.0	38.88	37.25	38.54	1351500.0
2022-12-09	ABB-DELISTED	Stock	31.13	31.34	31.015	31.035	881150.0
2022-12-09	ABBNY-DELISTED	Stock	31.13	31.34	31.015	31.03	1024436.0
2022-12-09	ABBV	Stock	166.76	167.75	162.81	163.06	4644800.0
2022-12-09	ABC-DELISTED	Stock	165.51	166.93	164.52	165.29	2044956.0
2022-12-09	ABCB	Stock	50.0	50.67	49.83	50.26	264500.0
2022-12-09	ABCL	Stock	11.03	11.14	10.44	10.47	1737000.0
2022-12-09	ABCM-DELISTED	Stock	15.38	15.56	14.89	15.52	727490.0
2022-12-09	ABEO	Stock	3.11	3.26	3.06	3.12	153300.0
2022-12-09	ABEV	Stock	2.95	2.97	2.92	2.92	16430600.0
2022-12-09	ABG	Stock	178.75	182.8	178.75	181.18	143800.0
2022-12-09	ABGI-DELISTED	Stock	10.05	10.05	10.05	10.05	3400.0
2022-12-09	ABM	Stock	44.91	45.79	44.91	45.62	298800.0
2022-12-09	ABMD-DELISTED	Stock	380.33	381.025	380.25	380.76	692477.0
2022-12-09	ABNB	Stock	93.84	96.668	93.24	94.7	4405800.0
2022-12-09	ABOS	Stock	5.72	6.17	5.67	6.12	108100.0
2022-12-09	ABR	Stock	13.95	14.17	13.81	14.01	1549700.0

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

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