PREVIEW / stock_daily / 2020-05-18

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-18.parquet
  size:    217 KB
  rows:    6,611
  symbols: 2,349

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-18	AAPL	Stock	78.2925	79.125	77.58	78.74	135178400.0
2020-05-18	MSFT	Stock	185.75	186.2	183.96	184.91	35264500.0
2020-05-18	NVDA	Stock	8.7605	8.9165	8.6805	8.7502	774460000.0
2020-05-18	AMZN	Stock	120.2175	121.65	119.2005	121.313	87144000.0
2020-05-18	GOOGL	Stock	68.079	69.638	67.71	69.259	47128980.0
2020-05-18	META	Stock	212.15	214.64	210.94	213.19	20151900.0
2020-05-18	TSLA	Stock	55.1853	55.648	53.592	54.242	174987000.0
2020-05-18	TLT	Stock	164.93	165.055	162.42	163.05	10073986.0
2020-05-18	ES	Stock	78.8	80.33	77.93	79.8	1579600.0
2020-05-18	CL	Stock	69.92	70.75	69.18	70.22	5017700.0
2020-05-18	A	Stock	83.24	84.39	82.29	83.66	2076000.0
2020-05-18	AA	Stock	7.07	7.875	7.01	7.8	12915400.0
2020-05-18	AACG	Stock	0.71	0.76	0.69	0.72	23200.0
2020-05-18	AAIC-DELISTED	Stock	2.28	2.45	2.28	2.41	513669.0
2020-05-18	AAIC.C-DELISTED	Stock	16.8	16.9	16.0	16.55	4973.0
2020-05-18	AAL	Stock	9.62	9.94	9.36	9.87	76109300.0
2020-05-18	AAM.A-DELISTED	Stock	25.89	25.89	25.67	25.69	16665.0
2020-05-18	AAM.B-DELISTED	Stock	25.92	25.97	25.6468	25.8	11430.0
2020-05-18	AAMC-DELISTED	Stock	4.4456	4.7795	4.2897	4.6925	26673.0
2020-05-18	AAME	Stock	1.78	1.97	1.78	1.93	1300.0
2020-05-18	AAMI	Stock	8.2	8.5	8.185	8.46	325200.0
2020-05-18	AAOI	Stock	8.45	8.64	8.17	8.35	781200.0
2020-05-18	AAON	Stock	32.9133	34.1667	32.8067	34.0467	327000.0
2020-05-18	AAP	Stock	130.61	132.89	128.16	131.11	1806600.0
2020-05-18	AAT	Stock	24.59	26.42	24.59	26.0	416500.0
2020-05-18	AAU-DELISTED	Stock	0.45	0.47	0.42	0.4258	599153.0
2020-05-18	AAUAF-DELISTED	Stock	0.45	0.47	0.42	0.4258	623295.0
2020-05-18	AAWW-DELISTED	Stock	36.92	38.5	36.83	38.41	606113.0
2020-05-18	AAXJ	Stock	64.47	65.53	64.47	65.34	1282134.0
2020-05-18	AAXN-DELISTED	Stock	76.0343	79.0	73.62	74.82	507127.0
2020-05-18	AB	Stock	22.1	23.03	21.83	22.8	645400.0
2020-05-18	ABB-DELISTED	Stock	18.41	18.785	18.36	18.68	2564507.0
2020-05-18	ABBNY-DELISTED	Stock	18.41	18.785	18.36	18.68	2893423.0
2020-05-18	ABBV	Stock	92.0	93.66	91.31	91.47	16300200.0
2020-05-18	ABC-DELISTED	Stock	88.03	90.0	87.85	89.2	826470.0
2020-05-18	ABCB	Stock	20.74	22.09	20.68	21.76	640200.0
2020-05-18	ABEO	Stock	80.0	81.25	73.75	75.25	39296.0
2020-05-18	ABEV	Stock	2.1	2.19	2.08	2.13	42591100.0
2020-05-18	ABG	Stock	67.25	71.06	67.02	70.61	228200.0
2020-05-18	ABM	Stock	32.71	32.9	31.65	32.58	415800.0
2020-05-18	ABMD-DELISTED	Stock	188.88	194.75	188.88	190.82	228131.0
2020-05-18	ABR	Stock	6.65	7.24	6.63	7.2	2838600.0
2020-05-18	ABR.A-DELISTED	Stock	23.71	23.79	23.32	23.76	2172.0
2020-05-18	ABR.B-DELISTED	Stock	22.91	23.22	22.5514	22.9	1221.0
2020-05-18	ABR.C-DELISTED	Stock	24.39	24.92	24.1	24.92	7514.0
2020-05-18	ABT	Stock	91.9	93.0	90.02	90.27	7646500.0
2020-05-18	ABTC	Stock	225000.0	231600.0	217380.0	223500.0	3.6666666666666665
2020-05-18	ABTS	Stock	8.4	9.585	8.4	9.585	1300.0
2020-05-18	ABTX-DELISTED	Stock	23.14	24.495	23.14	24.36	100207.0
2020-05-18	ABUS	Stock	2.25	2.32	1.76	1.87	3837200.0

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

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