PREVIEW / stock_daily / 2020-03-31

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-31.parquet
  size:    215 KB
  rows:    6,647
  symbols: 2,399

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
2020-03-31	AAPL	Stock	63.9	65.6225	63.0	63.5725	197002000.0
2020-03-31	MSFT	Stock	159.4	164.78	156.56	157.71	77927200.0
2020-03-31	NVDA	Stock	6.68	6.885	6.4438	6.59	949960000.0
2020-03-31	AMZN	Stock	98.2175	99.651	97.2005	97.486	102472000.0
2020-03-31	GOOGL	Stock	57.4365	58.67	56.836	58.0975	65279420.0
2020-03-31	META	Stock	165.48	170.93	164.2	166.8	23676300.0
2020-03-31	TSLA	Stock	33.4167	36.1973	33.1333	34.9333	266572500.0
2020-03-31	TLT	Stock	165.7	166.92	164.56	164.97	11464935.0
2020-03-31	ES	Stock	82.55	82.74	78.04	78.21	2981600.0
2020-03-31	CL	Stock	66.01	66.49	64.96	66.36	5784400.0
2020-03-31	A	Stock	72.34	72.8	70.5	71.62	1822100.0
2020-03-31	AA	Stock	6.16	6.62	6.06	6.16	12502000.0
2020-03-31	AACG	Stock	0.9	0.95	0.9	0.95	8300.0
2020-03-31	AAIC-DELISTED	Stock	2.21	2.39	2.15	2.19	536604.0
2020-03-31	AAIC.C-DELISTED	Stock	14.025	14.75	13.8242	14.71	4654.0
2020-03-31	AAL	Stock	12.9	12.96	12.1	12.19	44851400.0
2020-03-31	AAM.A-DELISTED	Stock	22.93	23.95	22.86	23.59	22811.0
2020-03-31	AAM.B-DELISTED	Stock	22.83	23.75	22.51	23.51	32674.0
2020-03-31	AAMC-DELISTED	Stock	3.5588	4.3471	3.5485	4.0588	21236.0
2020-03-31	AAME	Stock	2.11	2.11	2.11	2.11	300.0
2020-03-31	AAMI	Stock	6.31	6.53	6.08	6.39	709500.0
2020-03-31	AAOI	Stock	7.63	7.89	7.31	7.59	466100.0
2020-03-31	AAON	Stock	32.0933	33.9867	31.4267	32.2133	583350.0
2020-03-31	AAP	Stock	95.56	97.38	92.9	93.32	1268600.0
2020-03-31	AAT	Stock	24.55	25.57	24.18	25.0	607800.0
2020-03-31	AAU-DELISTED	Stock	0.275	0.289	0.275	0.2836	214400.0
2020-03-31	AAUAF-DELISTED	Stock	0.28	0.289	0.275	0.2836	227238.0
2020-03-31	AAWW-DELISTED	Stock	22.39	26.21	22.35	25.585	638957.0
2020-03-31	AAXJ	Stock	59.51	60.31	59.35	59.72	1123530.0
2020-03-31	AAXN-DELISTED	Stock	69.03	72.72	67.96	70.65	1006671.0
2020-03-31	AB	Stock	18.72	19.17	18.36	18.59	282400.0
2020-03-31	ABB-DELISTED	Stock	17.25	17.62	17.07	17.26	3870711.0
2020-03-31	ABBNY-DELISTED	Stock	17.25	17.62	17.07	17.26	4238552.0
2020-03-31	ABBV	Stock	75.4	77.92	74.44	76.19	20474400.0
2020-03-31	ABC-DELISTED	Stock	88.06	90.73	87.11	88.5	1565284.0
2020-03-31	ABCB	Stock	23.19	24.36	23.13	23.76	551400.0
2020-03-31	ABEO	Stock	50.75	54.25	48.75	52.5	34244.0
2020-03-31	ABEV	Stock	2.35	2.4	2.3	2.3	28246900.0
2020-03-31	ABG	Stock	54.6	56.44	53.42	55.23	167400.0
2020-03-31	ABM	Stock	24.36	25.17	23.85	24.36	853900.0
2020-03-31	ABMD-DELISTED	Stock	148.51	151.235	142.68	144.71	407909.0
2020-03-31	ABR	Stock	5.6	5.68	4.8	4.9	3931000.0
2020-03-31	ABR.A-DELISTED	Stock	17.0	17.02	15.9059	16.6111	11441.0
2020-03-31	ABR.B-DELISTED	Stock	15.5	15.55	14.005	14.9262	10570.0
2020-03-31	ABR.C-DELISTED	Stock	13.95	16.13	13.95	16.1	2700.0
2020-03-31	ABT	Stock	81.43	81.49	78.56	78.91	23792300.0
2020-03-31	ABTC	Stock	150000.0	165480.0	144000.0	153600.0	1.1466666666666665
2020-03-31	ABTS	Stock	11.85	13.545	11.25	11.25	473.0
2020-03-31	ABTX-DELISTED	Stock	24.01	25.03	23.42	24.11	79801.0
2020-03-31	ABUS	Stock	1.13	1.13	1.01	1.01	1492100.0

> showing 50 of 6,647 rows — these rows as CSV

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