PREVIEW / stock_daily / 2020-05-22

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-22.parquet
  size:    216 KB
  rows:    6,584
  symbols: 2,331

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-05-22	AAPL	Stock	78.9425	79.8075	78.8375	79.7225	81803200.0
2020-05-22	MSFT	Stock	183.19	184.46	182.54	183.51	20826900.0
2020-05-22	NVDA	Stock	8.8252	9.093	8.7132	9.0263	1038764000.0
2020-05-22	AMZN	Stock	122.7505	123.4925	121.5065	121.844	57342000.0
2020-05-22	GOOGL	Stock	70.195	70.85	69.7975	70.662	28544120.0
2020-05-22	META	Stock	231.51	235.99	228.74	234.91	33925600.0
2020-05-22	TSLA	Stock	54.8113	55.452	54.1333	54.4587	149812500.0
2020-05-22	TLT	Stock	164.72	165.68	164.61	165.55	4956814.0
2020-05-22	ES	Stock	78.8	79.75	77.95	78.46	1053500.0
2020-05-22	CL	Stock	70.09	70.93	70.02	70.75	3427400.0
2020-05-22	A	Stock	85.0	87.67	84.2	84.98	5063100.0
2020-05-22	AA	Stock	8.3	8.368	8.02	8.21	4414800.0
2020-05-22	AACG	Stock	0.9	0.9	0.83	0.83	8600.0
2020-05-22	AAIC-DELISTED	Stock	2.36	2.3915	2.235	2.33	396106.0
2020-05-22	AAIC.C-DELISTED	Stock	16.5	16.5	16.4237	16.5	2450.0
2020-05-22	AAL	Stock	10.02	10.12	9.63	9.7	37596800.0
2020-05-22	AAM.A-DELISTED	Stock	26.24	26.24	26.1289	26.17	8547.0
2020-05-22	AAM.B-DELISTED	Stock	26.24	26.24	25.91	26.06	26807.0
2020-05-22	AAMC-DELISTED	Stock	4.8529	4.9676	4.7456	4.9676	7402.0
2020-05-22	AAME	Stock	1.97	1.97	1.81	1.95	1200.0
2020-05-22	AAMI	Stock	8.43	8.43	8.175	8.34	171200.0
2020-05-22	AAOI	Stock	8.68	8.735	8.52	8.61	452700.0
2020-05-22	AAON	Stock	34.62	35.0933	34.0467	34.4667	274650.0
2020-05-22	AAP	Stock	133.29	134.21	131.39	133.48	682600.0
2020-05-22	AAT	Stock	26.17	26.27	25.1	25.17	334700.0
2020-05-22	AAU-DELISTED	Stock	0.45	0.46	0.4352	0.4581	316452.0
2020-05-22	AAUAF-DELISTED	Stock	0.45	0.46	0.4352	0.46	325888.0
2020-05-22	AAWW-DELISTED	Stock	39.55	39.84	37.84	39.28	290525.0
2020-05-22	AAXJ	Stock	63.19	63.19	62.58	62.72	693879.0
2020-05-22	AAXN-DELISTED	Stock	77.11	77.19	73.6	74.07	464730.0
2020-05-22	AB	Stock	23.68	24.33	23.59	24.27	350300.0
2020-05-22	ABB-DELISTED	Stock	18.68	18.8	18.58	18.78	1993214.0
2020-05-22	ABBNY-DELISTED	Stock	18.68	18.8	18.58	18.77	2412707.0
2020-05-22	ABBV	Stock	92.87	93.01	91.73	92.1	5507000.0
2020-05-22	ABC-DELISTED	Stock	92.16	93.69	92.16	93.17	752011.0
2020-05-22	ABCB	Stock	22.0	22.19	21.3	21.65	228000.0
2020-05-22	ABEO	Stock	80.75	84.0	78.25	80.75	22552.0
2020-05-22	ABEV	Stock	2.15	2.18	2.1	2.14	15958500.0
2020-05-22	ABG	Stock	73.73	74.29	70.26	72.07	113500.0
2020-05-22	ABM	Stock	32.67	32.74	32.04	32.58	201100.0
2020-05-22	ABMD-DELISTED	Stock	198.03	207.215	196.03	206.16	422197.0
2020-05-22	ABR	Stock	7.6	7.94	7.45	7.89	1637000.0
2020-05-22	ABR.A-DELISTED	Stock	24.0	24.32	23.35	23.6	5555.0
2020-05-22	ABR.B-DELISTED	Stock	23.47	23.48	23.185	23.1955	1102.0
2020-05-22	ABR.C-DELISTED	Stock	26.605	26.605	23.78	24.5	23204.0
2020-05-22	ABT	Stock	90.42	91.54	89.71	91.47	5184500.0
2020-05-22	ABTC	Stock	236400.0	283200.0	233190.0	269100.0	14.666666666666666
2020-05-22	ABTS	Stock	9.0	9.975	8.85	9.645	953.0
2020-05-22	ABTX-DELISTED	Stock	25.08	25.1	24.525	24.84	34277.0
2020-05-22	ABUS	Stock	2.31	2.36	2.24	2.29	813100.0

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

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