PREVIEW / stock_daily / 2022-02-18

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-18.parquet
  size:    260 KB
  rows:    8,007
  symbols: 2,510

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-02-18	AAPL	Stock	169.82	170.54	166.19	167.3	82772700.0
2022-02-18	MSFT	Stock	293.05	293.86	286.31	287.93	34264000.0
2022-02-18	NVDA	Stock	24.668	24.986	23.1	23.642	761255000.0
2022-02-18	AMZN	Stock	155.4995	155.4995	150.893	152.6015	63604000.0
2022-02-18	GOOGL	Stock	133.467	134.07	130.1965	130.403	45619440.0
2022-02-18	META	Stock	209.39	210.75	205.18	206.16	37128400.0
2022-02-18	TSLA	Stock	295.3333	295.6233	279.2033	285.66	68501700.0
2022-02-18	TLT	Stock	137.52	138.37	137.16	138.23	17522577.0
2022-02-18	ES	Stock	81.37	82.85	81.32	82.82	2208900.0
2022-02-18	CL	Stock	79.31	79.65	78.94	79.55	3351800.0
2022-02-18	A	Stock	130.5	133.43	130.0	132.05	3614100.0
2022-02-18	AA	Stock	76.03	78.37	75.55	78.2	5825300.0
2022-02-18	AAC-DELISTED	Stock	9.75	9.75	9.735	9.745	60123.0
2022-02-18	AACG	Stock	1.57	1.57	1.36	1.39	52500.0
2022-02-18	AACIW-DELISTED	Stock	0.2501	0.3248	0.25	0.32294	2877.0
2022-02-18	AAIC-DELISTED	Stock	3.55	3.55	3.36	3.38	141532.0
2022-02-18	AAIC.C-DELISTED	Stock	24.88	24.88	24.88	24.88	200.0
2022-02-18	AAL	Stock	18.22	18.41	17.75	17.87	30507500.0
2022-02-18	AAM.A-DELISTED	Stock	25.26	25.3	25.25	25.27	8390.0
2022-02-18	AAM.B-DELISTED	Stock	25.55	25.5573	25.51	25.54	7086.0
2022-02-18	AAME	Stock	2.8	2.9	2.62	2.75	5500.0
2022-02-18	AAMI	Stock	24.13	24.495	23.95	24.32	495300.0
2022-02-18	AAN-DELISTED	Stock	21.0	21.63	20.89	21.02	138800.0
2022-02-18	AAOI	Stock	4.19	4.56	4.19	4.37	711900.0
2022-02-18	AAON	Stock	38.5733	39.6133	38.5733	38.8133	302700.0
2022-02-18	AAP	Stock	219.84	221.5	217.08	218.8	933500.0
2022-02-18	AAQC-DELISTED	Stock	9.71	9.71	9.71	9.71	9799.0
2022-02-18	AAT	Stock	36.81	37.42	36.69	36.69	596000.0
2022-02-18	AATC	Stock	7.22	7.32	7.14	7.19	11791.0
2022-02-18	AAU-DELISTED	Stock	0.29	0.2993	0.27	0.279	1605436.0
2022-02-18	AAUAF-DELISTED	Stock	0.29	0.2993	0.27	0.275	1613564.0
2022-02-18	AAWW-DELISTED	Stock	77.24	78.71	76.72	78.44	613312.0
2022-02-18	AAXJ	Stock	81.73	81.815	81.11	81.33	781597.0
2022-02-18	AB	Stock	45.07	45.92	44.78	44.99	458700.0
2022-02-18	ABB-DELISTED	Stock	34.63	34.73	34.25	34.34	1451772.0
2022-02-18	ABBNY-DELISTED	Stock	34.63	34.73	34.25	34.34	1634942.0
2022-02-18	ABBV	Stock	144.69	145.73	143.37	144.03	7585900.0
2022-02-18	ABC-DELISTED	Stock	142.1	144.22	141.01	141.51	792391.0
2022-02-18	ABCB	Stock	49.15	50.56	48.95	50.09	279300.0
2022-02-18	ABCL	Stock	9.27	9.45	9.03	9.16	1148800.0
2022-02-18	ABCM-DELISTED	Stock	16.83	16.85	16.4	16.49	55557.0
2022-02-18	ABEO	Stock	6.25	6.25	5.75	6.0	47436.0
2022-02-18	ABEV	Stock	2.88	2.9	2.85	2.88	15327200.0
2022-02-18	ABG	Stock	184.0	189.42	183.86	186.33	281300.0
2022-02-18	ABGI-DELISTED	Stock	9.74	9.74	9.71	9.71	24377.0
2022-02-18	ABM	Stock	43.06	43.96	42.69	43.44	694700.0
2022-02-18	ABMD-DELISTED	Stock	306.81	307.5	294.16	298.38	209588.0
2022-02-18	ABNB	Stock	180.26	182.66	173.62	174.9	8848800.0
2022-02-18	ABOS	Stock	5.74	6.04	5.555	5.91	227700.0
2022-02-18	ABR	Stock	17.07	17.47	17.0	17.33	2287500.0

> showing 50 of 8,007 rows — these rows as CSV

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