PREVIEW / stock_daily / 2021-02-25

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-25.parquet
  size:    249 KB
  rows:    7,560
  symbols: 2,813

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-02-25	AAPL	Stock	124.68	126.46	120.54	120.99	148199500.0
2021-02-25	MSFT	Stock	232.08	234.59	227.88	228.99	39542200.0
2021-02-25	NVDA	Stock	14.0455	14.3748	13.2162	13.3075	824436000.0
2021-02-25	AMZN	Stock	156.837	158.913	152.388	152.858	90676000.0
2021-02-25	GOOGL	Stock	102.7965	104.15	100.3245	100.7975	41548180.0
2021-02-25	META	Stock	262.3	266.94	254.04	254.69	19053100.0
2021-02-25	TSLA	Stock	242.05	245.7367	223.5267	227.4067	117071700.0
2021-02-25	TLT	Stock	139.52	139.92	136.61	138.54	52621705.0
2021-02-25	ES	Stock	79.97	80.85	79.89	80.56	1462300.0
2021-02-25	CL	Stock	76.6	77.17	76.28	76.69	4178100.0
2021-02-25	A	Stock	124.81	125.25	121.93	122.1	1430900.0
2021-02-25	AA	Stock	27.48	27.8	25.105	25.56	8444400.0
2021-02-25	AACG	Stock	5.43	5.44	4.94	5.06	288100.0
2021-02-25	AACQ-DELISTED	Stock	11.95	12.19	11.02	11.22	4279477.0
2021-02-25	AACQU-DELISTED	Stock	12.86	13.31	11.92	12.19	52810.0
2021-02-25	AACQW-DELISTED	Stock	3.24	3.26	2.71	3.0	1039548.0
2021-02-25	AAIC-DELISTED	Stock	4.11	4.19	3.95	3.98	268592.0
2021-02-25	AAIC.C-DELISTED	Stock	22.29	22.29	21.9435	21.9435	1135.0
2021-02-25	AAL	Stock	22.13	22.44	20.38	20.86	65571000.0
2021-02-25	AAM.A-DELISTED	Stock	25.975	26.06	25.85	26.05	21239.0
2021-02-25	AAM.B-DELISTED	Stock	26.55	26.57	26.26	26.375	21476.0
2021-02-25	AAMC-DELISTED	Stock	7.2554	7.7735	6.8529	7.0382	106342.0
2021-02-25	AAME	Stock	4.69	4.73	4.54	4.63	71900.0
2021-02-25	AAMI	Stock	19.25	19.46	18.48	18.48	352500.0
2021-02-25	AAN-DELISTED	Stock	22.06	23.24	21.86	22.17	235800.0
2021-02-25	AAOI	Stock	11.61	11.8	10.97	11.17	652200.0
2021-02-25	AAON	Stock	51.48	52.8533	50.08	51.0867	280650.0
2021-02-25	AAP	Stock	166.53	166.68	160.05	160.67	872200.0
2021-02-25	AAT	Stock	32.7	33.73	32.56	32.69	550000.0
2021-02-25	AAU-DELISTED	Stock	0.788	0.8391	0.7103	0.7899	2893333.0
2021-02-25	AAUAF-DELISTED	Stock	0.788	0.8391	0.7103	0.7899	2961994.0
2021-02-25	AAWW-DELISTED	Stock	58.73	59.31	55.74	56.13	298621.0
2021-02-25	AAXJ	Stock	98.1	98.16	95.79	95.98	908396.0
2021-02-25	AB	Stock	36.57	37.08	36.37	36.47	495600.0
2021-02-25	ABB-DELISTED	Stock	29.73	29.85	29.18	29.27	1428713.0
2021-02-25	ABBNY-DELISTED	Stock	29.73	29.85	29.18	29.28	1568109.0
2021-02-25	ABBV	Stock	108.48	109.3	107.07	107.33	6237600.0
2021-02-25	ABC-DELISTED	Stock	105.86	106.82	102.54	102.86	679081.0
2021-02-25	ABCB	Stock	50.79	50.91	47.81	48.12	363000.0
2021-02-25	ABCL	Stock	40.38	41.65	38.7	39.06	481000.0
2021-02-25	ABCM-DELISTED	Stock	23.24	23.33	22.67	22.87	22146.0
2021-02-25	ABEO	Stock	53.75	71.0	53.25	62.25	700252.0
2021-02-25	ABEV	Stock	2.67	2.71	2.6	2.62	34126600.0
2021-02-25	ABG	Stock	171.56	172.9	163.48	167.6	225300.0
2021-02-25	ABGI-DELISTED	Stock	10.22	10.4	10.22	10.25	39880.0
2021-02-25	ABM	Stock	44.9	45.24	43.49	43.56	201000.0
2021-02-25	ABMD-DELISTED	Stock	324.02	326.93	317.59	321.03	184014.0
2021-02-25	ABNB	Stock	197.41	199.8	180.0	182.06	11568500.0
2021-02-25	ABR	Stock	17.0	17.19	15.91	16.01	3040800.0
2021-02-25	ABR.A-DELISTED	Stock	25.9	25.9	25.61	25.61	1559.0

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

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