PREVIEW / stock_daily / 2022-05-27

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-27.parquet
  size:    257 KB
  rows:    7,951
  symbols: 2,369

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-27	AAPL	Stock	145.39	149.68	145.26	149.64	90978500.0
2022-05-27	MSFT	Stock	268.48	273.34	267.56	273.24	26910800.0
2022-05-27	NVDA	Stock	18.186	18.881	18.1	18.811	738379000.0
2022-05-27	AMZN	Stock	113.55	115.187	112.628	115.1465	93660000.0
2022-05-27	GOOGL	Stock	109.483	112.318	109.1382	112.3165	37914120.0
2022-05-27	META	Stock	191.36	195.33	189.8	195.13	22562700.0
2022-05-27	TSLA	Stock	241.0833	253.2667	240.1767	253.21	89295000.0
2022-05-27	TLT	Stock	119.36	119.737	118.74	119.08	11190426.0
2022-05-27	ES	Stock	91.9	93.33	91.44	93.3	1232400.0
2022-05-27	CL	Stock	78.39	79.07	78.14	78.86	2742300.0
2022-05-27	A	Stock	124.92	130.77	124.49	130.55	2698800.0
2022-05-27	AA	Stock	63.59	65.98	63.248	64.5	6887400.0
2022-05-27	AAC-DELISTED	Stock	9.805	9.81	9.8	9.81	804752.0
2022-05-27	AACG	Stock	0.96	1.17	0.96	1.06	14900.0
2022-05-27	AACIW-DELISTED	Stock	0.23	0.23	0.23	0.23	400.0
2022-05-27	AAIC-DELISTED	Stock	3.55	3.55	3.5	3.51	22204.0
2022-05-27	AAIC.C-DELISTED	Stock	23.4	23.4	23.4	23.4	1100.0
2022-05-27	AAL	Stock	17.45	18.21	17.34	18.13	27615600.0
2022-05-27	AAM.A-DELISTED	Stock	24.75	25.24	24.75	25.08	23313.0
2022-05-27	AAM.B-DELISTED	Stock	25.47	26.0	25.4214	26.0	29491.0
2022-05-27	AAME	Stock	2.9	2.95	2.52	2.76	21700.0
2022-05-27	AAMI	Stock	20.11	20.46	19.99	20.28	359800.0
2022-05-27	AAN-DELISTED	Stock	18.65	18.88	18.37	18.83	212500.0
2022-05-27	AAOI	Stock	2.32	2.33	2.22	2.25	160300.0
2022-05-27	AAON	Stock	35.42	35.96	35.14	35.4067	174900.0
2022-05-27	AAP	Stock	190.74	194.83	190.66	193.05	685700.0
2022-05-27	AAQC-DELISTED	Stock	9.76	9.76	9.75	9.75	380879.0
2022-05-27	AAT	Stock	33.37	34.28	33.37	34.16	270300.0
2022-05-27	AATC	Stock	5.91	6.0	5.7791	5.82	9620.0
2022-05-27	AAU-DELISTED	Stock	0.24	0.255	0.24	0.2498	328640.0
2022-05-27	AAUAF-DELISTED	Stock	0.24	0.255	0.24	0.25	332095.0
2022-05-27	AAWW-DELISTED	Stock	69.05	70.04	68.85	69.69	217328.0
2022-05-27	AAXJ	Stock	70.25	70.57	69.97	70.57	2183453.0
2022-05-27	AB	Stock	42.7	43.94	42.65	42.9	366700.0
2022-05-27	ABB-DELISTED	Stock	30.57	30.87	30.545	30.87	1423489.0
2022-05-27	ABBNY-DELISTED	Stock	30.57	30.87	30.545	30.86	1589438.0
2022-05-27	ABBV	Stock	149.52	150.05	147.75	150.0	8405000.0
2022-05-27	ABC-DELISTED	Stock	155.53	157.04	154.55	156.86	1093809.0
2022-05-27	ABCB	Stock	44.99	46.08	44.82	46.06	279900.0
2022-05-27	ABCL	Stock	7.58	7.985	7.45	7.9	2135700.0
2022-05-27	ABCM-DELISTED	Stock	14.88	14.98	14.78	14.98	56026.0
2022-05-27	ABEO	Stock	3.75	4.25	3.75	4.25	45280.0
2022-05-27	ABEV	Stock	2.94	3.0	2.93	2.96	21964500.0
2022-05-27	ABG	Stock	179.04	185.73	179.04	185.0	144700.0
2022-05-27	ABGI-DELISTED	Stock	9.785	9.785	9.785	9.785	77169.0
2022-05-27	ABM	Stock	48.19	49.02	48.19	48.77	206800.0
2022-05-27	ABMD-DELISTED	Stock	263.4	268.84	261.045	266.03	169935.0
2022-05-27	ABNB	Stock	116.0	120.7	115.77	120.5	7391500.0
2022-05-27	ABOS	Stock	3.51	3.608	3.38	3.56	77600.0
2022-05-27	ABR	Stock	16.39	16.64	16.36	16.62	2703100.0

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

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