PREVIEW / stock_daily / 2022-12-02

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-02.parquet
  size:    251 KB
  rows:    7,796
  symbols: 2,061

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-02	AAPL	Stock	145.96	148.0	145.65	147.81	65447400.0
2022-12-02	MSFT	Stock	249.82	256.06	249.69	255.02	21528500.0
2022-12-02	NVDA	Stock	16.659	16.933	16.445	16.876	371389000.0
2022-12-02	AMZN	Stock	94.48	95.36	93.78	94.13	72496400.0
2022-12-02	GOOGL	Stock	99.05	100.77	98.9	100.44	21480703.0
2022-12-02	META	Stock	117.83	124.04	117.61	123.49	39950500.0
2022-12-02	TSLA	Stock	191.78	196.25	191.11	194.86	73645900.0
2022-12-02	TLT	Stock	105.3	107.1	104.605	107.09	24479525.0
2022-12-02	ES	Stock	83.01	84.0	82.12	83.71	1549600.0
2022-12-02	CL	Stock	77.47	78.25	77.27	78.17	2797000.0
2022-12-02	A	Stock	153.97	156.73	153.59	155.67	1183200.0
2022-12-02	AA	Stock	48.06	50.58	47.65	50.39	4833500.0
2022-12-02	AAC-DELISTED	Stock	10.02	10.05	10.02	10.03	764446.0
2022-12-02	AACG	Stock	1.58	1.65	1.58	1.63	2300.0
2022-12-02	AACIW-DELISTED	Stock	0.02	0.03215	0.01997	0.02	220233.0
2022-12-02	AAIC-DELISTED	Stock	3.03	3.08	3.03	3.06	29802.0
2022-12-02	AAIC.C-DELISTED	Stock	21.7785	21.88	21.7785	21.88	648.0
2022-12-02	AAL	Stock	13.82	13.98	13.67	13.97	24124300.0
2022-12-02	AAM.A-DELISTED	Stock	24.3	24.4995	24.13	24.29	12914.0
2022-12-02	AAM.B-DELISTED	Stock	25.03	25.1	24.675	25.08	6675.0
2022-12-02	AAMC-DELISTED	Stock	5.5882	5.5883	5.5588	5.5882	8667.0
2022-12-02	AAME	Stock	2.89	2.89	2.89	2.89	500.0
2022-12-02	AAMI	Stock	20.48	20.9	20.28	20.82	109300.0
2022-12-02	AAN-DELISTED	Stock	12.0	12.6	11.77	12.57	419200.0
2022-12-02	AAOI	Stock	2.17	2.35	2.17	2.32	141400.0
2022-12-02	AAON	Stock	51.64	53.9067	50.0133	53.6267	324750.0
2022-12-02	AAP	Stock	150.08	153.14	147.76	153.03	1320700.0
2022-12-02	AAQC-DELISTED	Stock	10.065	10.065	10.06	10.06	2000.0
2022-12-02	AAT	Stock	28.04	28.5	27.83	27.95	394500.0
2022-12-02	AATC	Stock	4.91	5.04	4.91	5.0	11749.0
2022-12-02	AAU-DELISTED	Stock	0.2325	0.247	0.2311	0.245	257975.0
2022-12-02	AAUAF-DELISTED	Stock	0.2325	0.247	0.2311	0.245	260579.0
2022-12-02	AAWW-DELISTED	Stock	100.4	100.665	100.04	100.2	310156.0
2022-12-02	AAXJ	Stock	65.74	67.0791	65.74	66.88	629071.0
2022-12-02	AB	Stock	40.02	40.53	39.78	40.48	264100.0
2022-12-02	ABB-DELISTED	Stock	31.35	31.69	31.2812	31.64	670184.0
2022-12-02	ABBNY-DELISTED	Stock	31.35	31.69	31.2812	31.63	763777.0
2022-12-02	ABBV	Stock	160.72	163.76	160.51	163.66	4304900.0
2022-12-02	ABC-DELISTED	Stock	171.41	174.63	171.19	173.99	970614.0
2022-12-02	ABCB	Stock	52.24	52.78	51.94	52.65	242600.0
2022-12-02	ABCL	Stock	13.08	13.08	12.19	12.71	1640000.0
2022-12-02	ABCM-DELISTED	Stock	16.59	17.07	16.48	17.0	330077.0
2022-12-02	ABEO	Stock	3.81	4.08	3.75	3.99	227300.0
2022-12-02	ABEV	Stock	3.09	3.16	3.08	3.1	62146200.0
2022-12-02	ABG	Stock	181.26	184.83	180.69	183.32	119500.0
2022-12-02	ABGI-DELISTED	Stock	10.04	10.04	10.04	10.04	67100.0
2022-12-02	ABLV	Stock	10.125	10.13	10.11	10.11	36784.0
2022-12-02	ABM	Stock	46.3	46.72	46.03	46.29	385900.0
2022-12-02	ABMD-DELISTED	Stock	376.8	378.0	376.55	377.22	515510.0
2022-12-02	ABNB	Stock	99.25	101.74	98.97	101.0	4128600.0

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

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