PREVIEW / stock_daily / 2022-05-26

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-26.parquet
  size:    258 KB
  rows:    7,994
  symbols: 2,395

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-05-26	AAPL	Stock	137.39	144.34	137.14	143.78	90601500.0
2022-05-26	MSFT	Stock	262.27	267.11	261.43	265.9	25002100.0
2022-05-26	NVDA	Stock	16.036	18.092	16.022	17.851	996575000.0
2022-05-26	AMZN	Stock	107.97	112.6655	107.4535	111.0775	93002000.0
2022-05-26	GOOGL	Stock	105.677	108.6495	105.2249	107.7925	37947220.0
2022-05-26	META	Stock	182.88	192.83	182.26	191.63	23056500.0
2022-05-26	TSLA	Stock	220.4733	239.5567	217.8867	235.91	106003200.0
2022-05-26	TLT	Stock	119.02	119.09	117.8	118.79	14912949.0
2022-05-26	ES	Stock	92.71	92.77	92.04	92.19	1043700.0
2022-05-26	CL	Stock	78.39	78.71	77.58	78.16	4139100.0
2022-05-26	A	Stock	120.75	124.22	120.72	123.85	1768000.0
2022-05-26	AA	Stock	60.95	63.25	59.74	62.85	5268400.0
2022-05-26	AAC-DELISTED	Stock	9.8	9.81	9.795	9.81	681549.0
2022-05-26	AACG	Stock	0.98	1.0	0.98	1.0	4500.0
2022-05-26	AACIW-DELISTED	Stock	0.2241	0.2241	0.2241	0.2241	200.0
2022-05-26	AAIC-DELISTED	Stock	3.3955	3.56	3.3909	3.55	85472.0
2022-05-26	AAIC.C-DELISTED	Stock	23.0	23.35	23.0	23.35	1165.0
2022-05-26	AAL	Stock	16.37	17.42	16.31	17.24	33955200.0
2022-05-26	AAM.A-DELISTED	Stock	24.54	24.79	24.54	24.65	37916.0
2022-05-26	AAM.B-DELISTED	Stock	25.29	25.45	25.13	25.41	12305.0
2022-05-26	AAMC-DELISTED	Stock	3.0368	3.0457	3.0368	3.0457	2349.0
2022-05-26	AAME	Stock	2.77	2.86	2.76	2.86	1600.0
2022-05-26	AAMI	Stock	19.71	20.01	19.7	19.93	431900.0
2022-05-26	AAN-DELISTED	Stock	18.89	19.365	18.59	18.64	370800.0
2022-05-26	AAOI	Stock	2.2	2.35	2.18	2.3	197700.0
2022-05-26	AAON	Stock	34.7867	35.2933	34.2333	35.16	338250.0
2022-05-26	AAP	Stock	186.45	191.55	184.98	190.9	1286500.0
2022-05-26	AAQC-DELISTED	Stock	9.75	9.76	9.75	9.76	400.0
2022-05-26	AAT	Stock	33.43	33.63	33.23	33.25	152200.0
2022-05-26	AATC	Stock	5.58	5.72	5.5309	5.59	3125.0
2022-05-26	AAU-DELISTED	Stock	0.24	0.27	0.24	0.2484	417751.0
2022-05-26	AAUAF-DELISTED	Stock	0.24	0.27	0.24	0.24	420455.0
2022-05-26	AAWW-DELISTED	Stock	67.08	68.9	67.08	68.5	189389.0
2022-05-26	AAXJ	Stock	68.46	69.87	68.46	69.69	793748.0
2022-05-26	AB	Stock	41.76	42.58	41.5	42.27	493300.0
2022-05-26	ABB-DELISTED	Stock	29.99	30.445	29.94	30.37	1414940.0
2022-05-26	ABBNY-DELISTED	Stock	29.99	30.445	29.94	30.37	1552310.0
2022-05-26	ABBV	Stock	151.63	153.07	150.39	150.57	6659300.0
2022-05-26	ABC-DELISTED	Stock	157.17	158.12	155.47	155.76	1120652.0
2022-05-26	ABCB	Stock	44.35	45.18	44.35	45.01	181400.0
2022-05-26	ABCL	Stock	7.52	7.71	7.4	7.5	1335200.0
2022-05-26	ABCM-DELISTED	Stock	14.34	14.72	14.34	14.53	99292.0
2022-05-26	ABEO	Stock	4.0	4.0	3.75	3.75	39420.0
2022-05-26	ABEV	Stock	2.88	2.97	2.86	2.94	25090000.0
2022-05-26	ABG	Stock	179.38	185.36	176.46	178.83	239300.0
2022-05-26	ABGI-DELISTED	Stock	9.8	9.8	9.8	9.8	200.0
2022-05-26	ABM	Stock	47.65	48.43	47.65	47.8	252600.0
2022-05-26	ABMD-DELISTED	Stock	256.21	263.1	251.69	261.16	127335.0
2022-05-26	ABNB	Stock	109.74	115.55	108.11	114.3	6883200.0
2022-05-26	ABOS	Stock	3.47	3.55	3.44	3.48	63000.0

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

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