PREVIEW / stock_daily / 2019-12-13

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-13.parquet
  size:    222 KB
  rows:    6,603
  symbols: 2,454

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
2019-12-13	AAPL	Stock	67.865	68.825	67.7325	68.7875	133587600.0
2019-12-13	MSFT	Stock	153.0	154.89	152.83	154.53	23845400.0
2019-12-13	NVDA	Stock	5.6048	5.7245	5.5455	5.5998	454704000.0
2019-12-13	AMZN	Stock	88.25	88.4495	87.75	88.047	54914000.0
2019-12-13	GOOGL	Stock	67.395	67.5675	67.083	67.3435	33173680.0
2019-12-13	META	Stock	196.4	196.8	193.17	194.11	18798000.0
2019-12-13	TSLA	Stock	24.07	24.3473	23.6427	23.8927	98563500.0
2019-12-13	TLT	Stock	138.12	139.61	137.23	139.04	11335349.0
2019-12-13	ES	Stock	80.85	81.48	80.25	81.34	1001300.0
2019-12-13	CL	Stock	67.23	68.87	67.07	68.69	5179600.0
2019-12-13	A	Stock	84.67	84.74	83.59	83.71	1811200.0
2019-12-13	AA	Stock	21.42	21.59	20.59	20.69	4333800.0
2019-12-13	AACG	Stock	1.38	1.42	1.37	1.42	26000.0
2019-12-13	AAIC-DELISTED	Stock	5.83	5.88	5.82	5.84	204720.0
2019-12-13	AAIC.C-DELISTED	Stock	21.63	21.77	21.5	21.62	3002.0
2019-12-13	AAL	Stock	27.93	28.13	27.37	27.48	5965200.0
2019-12-13	AAM.A-DELISTED	Stock	26.2794	26.52	26.2676	26.52	17104.0
2019-12-13	AAM.B-DELISTED	Stock	26.5	27.27	26.5	27.27	33320.0
2019-12-13	AAMC-DELISTED	Stock	4.1441	4.2676	3.9176	4.1471	10190.0
2019-12-13	AAME	Stock	1.92	2.02	1.79	1.95	6100.0
2019-12-13	AAMI	Stock	10.7	10.79	10.25	10.29	320700.0
2019-12-13	AAOI	Stock	11.3	11.434	10.87	10.935	551100.0
2019-12-13	AAON	Stock	33.52	33.7867	33.0667	33.32	186750.0
2019-12-13	AAP	Stock	156.22	156.51	154.22	155.21	768600.0
2019-12-13	AAT	Stock	44.95	45.07	44.27	44.7	325300.0
2019-12-13	AAU-DELISTED	Stock	0.507	0.52	0.507	0.5174	185825.0
2019-12-13	AAUAF-DELISTED	Stock	0.507	0.52	0.507	0.517	190915.0
2019-12-13	AAWW-DELISTED	Stock	28.27	28.2724	27.365	27.68	205273.0
2019-12-13	AAXJ	Stock	72.61	73.11	72.25	72.42	1469950.0
2019-12-13	AAXN-DELISTED	Stock	71.71	72.8187	71.46	72.49	276013.0
2019-12-13	AB	Stock	30.25	30.5	29.94	30.42	1496400.0
2019-12-13	ABB-DELISTED	Stock	23.76	23.895	23.5	23.51	4137962.0
2019-12-13	ABBNY-DELISTED	Stock	23.77	23.895	23.5	23.51	4263410.0
2019-12-13	ABBV	Stock	88.78	89.09	87.33	87.84	5975200.0
2019-12-13	ABC-DELISTED	Stock	86.81	87.6076	84.76	84.86	742518.0
2019-12-13	ABCB	Stock	44.0	44.36	43.74	44.22	368800.0
2019-12-13	ABDC-DELISTED	Stock	9.06	9.2	9.06	9.08	28502.0
2019-12-13	ABEO	Stock	100.0	103.0	90.25	91.25	28588.0
2019-12-13	ABEOW-DELISTED	Stock	0.0208	0.0429	0.0208	0.04	11245.0
2019-12-13	ABEV	Stock	4.57	4.63	4.56	4.58	9596500.0
2019-12-13	ABG	Stock	122.67	122.67	114.97	116.67	245100.0
2019-12-13	ABIL-DELISTED	Stock	0.6	0.6	0.5405	0.555	58061.0
2019-12-13	ABM	Stock	37.88	37.97	36.87	37.09	355000.0
2019-12-13	ABMD-DELISTED	Stock	179.15	183.13	175.25	181.84	296989.0
2019-12-13	ABR	Stock	14.03	14.21	14.03	14.14	1083900.0
2019-12-13	ABR.A-DELISTED	Stock	26.2016	26.35	26.1132	26.35	2330.0
2019-12-13	ABR.B-DELISTED	Stock	25.9087	25.9087	25.75	25.75	767.0
2019-12-13	ABR.C-DELISTED	Stock	26.27	26.55	26.09	26.55	3340.0
2019-12-13	ABT	Stock	85.78	86.71	85.78	86.35	3872000.0
2019-12-13	ABTC	Stock	368100.0	381300.0	348300.0	350400.0	4.760000000000001

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

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