PREVIEW / stock_daily / 2021-01-25

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-25.parquet
  size:    243 KB
  rows:    7,369
  symbols: 2,693

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
2021-01-25	AAPL	Stock	143.07	145.09	136.54	142.92	157611700.0
2021-01-25	MSFT	Stock	229.12	229.78	224.22	229.53	33152100.0
2021-01-25	NVDA	Stock	13.7818	13.8285	13.2365	13.6532	251112000.0
2021-01-25	AMZN	Stock	166.425	168.1945	162.1575	164.7	74996000.0
2021-01-25	GOOGL	Stock	95.637	96.091	92.958	94.714	50586920.0
2021-01-25	META	Stock	278.14	280.1	271.51	278.01	19087000.0
2021-01-25	TSLA	Stock	285.0	300.1333	279.6067	293.6	123520200.0
2021-01-25	TLT	Stock	152.76	153.69	152.635	153.67	8712616.0
2021-01-25	ES	Stock	87.1	90.3	87.0	90.29	1546300.0
2021-01-25	CL	Stock	78.21	79.1	78.15	78.61	7750400.0
2021-01-25	A	Stock	126.69	127.48	124.43	125.48	1365400.0
2021-01-25	AA	Stock	19.26	19.44	18.58	19.34	7926900.0
2021-01-25	AACG	Stock	1.44	1.46	1.33	1.39	32200.0
2021-01-25	AACQ-DELISTED	Stock	11.13	11.27	10.97	11.01	2030921.0
2021-01-25	AACQU-DELISTED	Stock	11.9	12.1033	11.81	11.81	100767.0
2021-01-25	AACQW-DELISTED	Stock	2.7	2.71	2.42	2.43	593558.0
2021-01-25	AAIC-DELISTED	Stock	3.7	3.86	3.7	3.81	210997.0
2021-01-25	AAIC.C-DELISTED	Stock	21.5	21.525	21.49	21.51	3718.0
2021-01-25	AAL	Stock	15.52	15.56	15.02	15.43	61954500.0
2021-01-25	AAM.A-DELISTED	Stock	26.45	26.5	26.43	26.46	8417.0
2021-01-25	AAM.B-DELISTED	Stock	26.99	26.99	26.8101	26.86	5995.0
2021-01-25	AAMC-DELISTED	Stock	6.3206	6.4025	6.1579	6.3029	11098.0
2021-01-25	AAME	Stock	2.49	2.63	2.49	2.56	28400.0
2021-01-25	AAMI	Stock	20.69	20.93	20.3	20.66	199500.0
2021-01-25	AAN-DELISTED	Stock	20.56	21.49	20.51	20.89	315600.0
2021-01-25	AAOI	Stock	10.43	11.15	10.43	10.95	818400.0
2021-01-25	AAON	Stock	48.26	49.2667	47.6667	48.8667	350100.0
2021-01-25	AAP	Stock	163.68	164.67	156.39	159.66	1847100.0
2021-01-25	AAT	Stock	28.62	29.18	28.26	28.61	193300.0
2021-01-25	AAU-DELISTED	Stock	0.59	0.5955	0.5355	0.5731	4123016.0
2021-01-25	AAUAF-DELISTED	Stock	0.59	0.5955	0.5355	0.57	4212400.0
2021-01-25	AAWW-DELISTED	Stock	53.47	54.45	52.69	53.18	204515.0
2021-01-25	AAXJ	Stock	99.29	99.59	98.22	99.19	673956.0
2021-01-25	AAXN-DELISTED	Stock	173.46	177.705	168.03	174.65	424558.0
2021-01-25	AB	Stock	36.57	37.0	36.0	36.6	588700.0
2021-01-25	ABB-DELISTED	Stock	30.11	30.25	29.82	30.09	1789673.0
2021-01-25	ABBNY-DELISTED	Stock	30.11	30.25	29.82	30.09	2030550.0
2021-01-25	ABBV	Stock	109.73	111.23	109.21	110.5	6928200.0
2021-01-25	ABC-DELISTED	Stock	107.09	107.52	106.0	106.9	524275.0
2021-01-25	ABCB	Stock	43.54	43.92	42.64	43.66	467100.0
2021-01-25	ABCL	Stock	51.2	51.24	46.43	48.79	478800.0
2021-01-25	ABCM-DELISTED	Stock	23.56	23.9	23.19	23.89	93594.0
2021-01-25	ABEO	Stock	55.5	58.5	51.0	58.25	247080.0
2021-01-25	ABEV	Stock	2.83	2.85	2.77	2.85	22275500.0
2021-01-25	ABG	Stock	160.51	163.62	155.32	156.83	506000.0
2021-01-25	ABM	Stock	39.36	40.24	39.08	39.56	339500.0
2021-01-25	ABMD-DELISTED	Stock	348.98	352.7	345.34	348.065	286638.0
2021-01-25	ABNB	Stock	186.05	192.47	170.03	177.53	7472900.0
2021-01-25	ABR	Stock	14.55	14.6	14.22	14.37	1363800.0
2021-01-25	ABR.A-DELISTED	Stock	25.94	25.94	25.8547	25.89	900.0

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

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