PREVIEW / stock_daily / 2020-03-17

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-17.parquet
  size:    216 KB
  rows:    6,670
  symbols: 2,408

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-17	AAPL	Stock	61.8775	64.4025	59.6	63.215	324056000.0
2020-03-17	MSFT	Stock	140.0	147.5	135.0	146.57	81059800.0
2020-03-17	NVDA	Stock	5.0228	5.5215	4.775	5.4318	833632000.0
2020-03-17	AMZN	Stock	88.7735	92.889	84.462	90.392	218342000.0
2020-03-17	GOOGL	Stock	54.532	56.3	52.455	55.903	83193720.0
2020-03-17	META	Stock	150.74	153.94	140.0	149.42	34255600.0
2020-03-17	TSLA	Stock	29.334	31.4567	26.4	28.68	359919000.0
2020-03-17	TLT	Stock	163.5	165.63	152.71	152.98	18570872.0
2020-03-17	ES	Stock	78.63	90.16	78.63	87.21	5763000.0
2020-03-17	CL	Stock	64.19	70.43	63.31	70.2	9389100.0
2020-03-17	A	Stock	66.02	70.53	63.94	70.44	3341800.0
2020-03-17	AA	Stock	7.12	7.25	6.61	7.0	8065700.0
2020-03-17	AACG	Stock	0.89	0.93	0.85	0.91	20300.0
2020-03-17	AAIC-DELISTED	Stock	3.17	3.47	2.87	3.38	869982.0
2020-03-17	AAIC.C-DELISTED	Stock	14.066	14.066	12.26	13.07	8920.0
2020-03-17	AAL	Stock	15.79	18.49	14.79	15.58	58055800.0
2020-03-17	AAM.A-DELISTED	Stock	21.51	22.07	20.51	21.4	61866.0
2020-03-17	AAM.B-DELISTED	Stock	21.75	21.865	20.62	21.64	60380.0
2020-03-17	AAMC-DELISTED	Stock	3.9029	4.6353	3.9029	4.5588	29913.0
2020-03-17	AAME	Stock	2.38	2.38	2.2	2.2	6100.0
2020-03-17	AAMI	Stock	5.19	5.27	4.725	4.9	1478000.0
2020-03-17	AAOI	Stock	5.8	6.14	5.51	5.96	1246500.0
2020-03-17	AAON	Stock	34.58	34.98	30.8733	31.9267	1475700.0
2020-03-17	AAP	Stock	97.15	101.92	92.64	100.25	1475700.0
2020-03-17	AAT	Stock	25.04	25.42	23.31	24.37	531300.0
2020-03-17	AAU-DELISTED	Stock	0.254	0.2747	0.239	0.2737	617869.0
2020-03-17	AAUAF-DELISTED	Stock	0.254	0.2747	0.239	0.2747	640612.0
2020-03-17	AAWW-DELISTED	Stock	19.23	23.95	19.01	23.69	2261927.0
2020-03-17	AAXJ	Stock	56.68	58.84	55.93	58.56	1878518.0
2020-03-17	AAXN-DELISTED	Stock	54.42	57.3754	51.3	57.15	781717.0
2020-03-17	AB	Stock	20.14	20.69	18.14	18.81	2355200.0
2020-03-17	ABB-DELISTED	Stock	15.58	16.28	15.23	16.23	2332390.0
2020-03-17	ABBNY-DELISTED	Stock	15.58	16.28	15.23	16.23	2642966.0
2020-03-17	ABBV	Stock	75.71	77.71	69.99	73.02	23205000.0
2020-03-17	ABC-DELISTED	Stock	82.79	89.73	82.2	89.5	2412784.0
2020-03-17	ABCB	Stock	22.34	24.61	21.26	24.33	840900.0
2020-03-17	ABEO	Stock	40.0	55.0	33.75	51.0	132276.0
2020-03-17	ABEV	Stock	2.31	2.4	2.17	2.3	76122100.0
2020-03-17	ABG	Stock	46.77	50.86	43.19	48.11	484500.0
2020-03-17	ABM	Stock	27.0	29.21	26.68	28.22	785400.0
2020-03-17	ABMD-DELISTED	Stock	145.2	148.42	134.49	145.13	808634.0
2020-03-17	ABR	Stock	7.7	7.84	5.45	5.81	8167400.0
2020-03-17	ABR.A-DELISTED	Stock	21.825	21.825	16.05	17.26	35033.0
2020-03-17	ABR.B-DELISTED	Stock	18.19	18.342	13.88	14.3	10680.0
2020-03-17	ABR.C-DELISTED	Stock	20.78	20.78	15.74	16.47	11177.0
2020-03-17	ABT	Stock	75.52	79.79	73.34	79.49	13315300.0
2020-03-17	ABTC	Stock	131400.0	141690.0	130800.0	141000.0	2.2800000000000002
2020-03-17	ABTS	Stock	18.3	18.3	15.75	16.5	2593.0
2020-03-17	ABTX-DELISTED	Stock	23.09	27.195	22.81	27.14	118969.0
2020-03-17	ABUS	Stock	1.52	1.59	1.2	1.27	872800.0

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

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