PREVIEW / stock_daily / 2020-05-14

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-14.parquet
  size:    215 KB
  rows:    6,619
  symbols: 2,361

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-14	AAPL	Stock	76.1275	77.4475	75.3825	77.385	158929200.0
2020-05-14	MSFT	Stock	177.54	180.69	175.68	180.53	41873900.0
2020-05-14	NVDA	Stock	7.8418	8.036	7.6875	8.0305	602312000.0
2020-05-14	AMZN	Stock	118.0505	119.5685	117.6605	119.4425	72962000.0
2020-05-14	GOOGL	Stock	66.676	67.8685	66.165	67.843	36660340.0
2020-05-14	META	Stock	202.56	206.93	200.69	206.81	17178900.0
2020-05-14	TSLA	Stock	52.0	53.5573	50.9333	53.5553	205233000.0
2020-05-14	TLT	Stock	167.32	168.15	167.05	167.14	10080361.0
2020-05-14	ES	Stock	76.07	77.45	73.61	77.27	1788700.0
2020-05-14	CL	Stock	68.11	68.29	65.54	67.06	4999800.0
2020-05-14	A	Stock	79.29	81.66	78.72	81.64	2285900.0
2020-05-14	AA	Stock	6.74	7.045	6.38	6.81	8896400.0
2020-05-14	AACG	Stock	0.76	0.76	0.71	0.72	12900.0
2020-05-14	AAIC-DELISTED	Stock	2.15	2.37	2.08	2.33	312145.0
2020-05-14	AAIC.C-DELISTED	Stock	16.0	16.09	15.7	15.99	5522.0
2020-05-14	AAL	Stock	8.77	9.19	8.25	9.15	72320500.0
2020-05-14	AAM.A-DELISTED	Stock	25.3	25.65	25.1172	25.64	16132.0
2020-05-14	AAM.B-DELISTED	Stock	25.0	25.67	25.0	25.6	15432.0
2020-05-14	AAMC-DELISTED	Stock	4.1853	4.6	4.1853	4.2118	11033.0
2020-05-14	AAME	Stock	1.88	1.88	1.72	1.87	1400.0
2020-05-14	AAMI	Stock	7.48	7.82	7.47	7.81	400200.0
2020-05-14	AAOI	Stock	8.5	8.61	8.27	8.5	640100.0
2020-05-14	AAON	Stock	30.4867	30.72	29.6533	30.6267	379200.0
2020-05-14	AAP	Stock	117.78	121.26	116.76	121.13	1385500.0
2020-05-14	AAT	Stock	23.31	24.91	22.64	24.58	473700.0
2020-05-14	AAU-DELISTED	Stock	0.4	0.41	0.375	0.41	610440.0
2020-05-14	AAUAF-DELISTED	Stock	0.4	0.41	0.375	0.41	640766.0
2020-05-14	AAWW-DELISTED	Stock	34.3635	37.6	34.3124	37.37	364864.0
2020-05-14	AAXJ	Stock	62.81	64.11	62.58	64.03	690196.0
2020-05-14	AAXN-DELISTED	Stock	78.8	79.08	74.74	75.6	642755.0
2020-05-14	AB	Stock	20.65	21.61	20.04	21.55	477500.0
2020-05-14	ABB-DELISTED	Stock	16.97	17.51	16.8	17.5	2371356.0
2020-05-14	ABBNY-DELISTED	Stock	16.97	17.51	16.8	17.51	2582000.0
2020-05-14	ABBV	Stock	87.62	90.48	87.43	89.94	13379500.0
2020-05-14	ABC-DELISTED	Stock	83.01	84.15	81.51	84.04	1160737.0
2020-05-14	ABCB	Stock	17.95	19.05	17.12	18.97	550400.0
2020-05-14	ABEO	Stock	80.5	81.75	75.0	80.25	39072.0
2020-05-14	ABEV	Stock	1.97	2.05	1.91	2.04	31487400.0
2020-05-14	ABG	Stock	56.45	60.74	56.01	60.65	325400.0
2020-05-14	ABM	Stock	29.08	30.51	28.21	30.42	469500.0
2020-05-14	ABMD-DELISTED	Stock	183.98	184.62	181.26	184.34	203882.0
2020-05-14	ABR	Stock	5.93	6.45	5.67	6.43	3180800.0
2020-05-14	ABR.A-DELISTED	Stock	22.9743	23.7832	22.89	23.7832	2183.0
2020-05-14	ABR.B-DELISTED	Stock	22.71	23.5	22.51	23.38	7221.0
2020-05-14	ABR.C-DELISTED	Stock	23.24	23.658	22.6	23.35	2853.0
2020-05-14	ABT	Stock	90.5	91.78	89.34	91.78	8189200.0
2020-05-14	ABTC	Stock	211500.0	222000.0	204300.0	212100.0	2.0666666666666664
2020-05-14	ABTS	Stock	10.5	10.68	9.75	10.635	1393.0
2020-05-14	ABTX-DELISTED	Stock	21.68	22.74	21.02	22.47	90596.0
2020-05-14	ABUS	Stock	1.8	1.84	1.56	1.84	844700.0

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

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