PREVIEW / stock_daily / 2019-03-08

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-08.parquet
  size:    219 KB
  rows:    6,517
  symbols: 2,608

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-03-08	AAPL	Stock	42.58	43.2675	42.375	43.2275	95997600.0
2019-03-08	MSFT	Stock	109.16	110.71	108.8	110.51	22818400.0
2019-03-08	NVDA	Stock	3.6415	3.7768	3.62	3.766	422416000.0
2019-03-08	AMZN	Stock	80.2005	81.136	79.3285	81.04	93340000.0
2019-03-08	GOOGL	Stock	56.695	57.6725	56.51	57.4985	23694640.0
2019-03-08	META	Stock	166.2	169.62	165.97	169.6	13184800.0
2019-03-08	TSLA	Stock	18.4607	19.0393	18.3927	18.9427	132294000.0
2019-03-08	TLT	Stock	121.12	121.69	120.845	121.57	7517600.0
2019-03-08	ES	Stock	69.61	69.88	69.1	69.68	1800600.0
2019-03-08	CL	Stock	65.43	65.81	64.94	65.35	2586500.0
2019-03-08	A	Stock	78.18	78.24	77.4	77.98	1483500.0
2019-03-08	AA	Stock	26.93	27.16	26.51	26.82	2864000.0
2019-03-08	AABA-DELISTED	Stock	70.66	71.84	70.52	71.66	7047198.0
2019-03-08	AAC-DELISTED	Stock	2.3	2.34	2.273	2.31	57681.0
2019-03-08	AACG	Stock	1.12	1.12	1.06	1.08	68800.0
2019-03-08	AAIC-DELISTED	Stock	7.98	8.09	7.95	8.03	407052.0
2019-03-08	AAL	Stock	31.9	32.12	31.37	31.91	6200500.0
2019-03-08	AAM.A-DELISTED	Stock	25.09	25.13	24.9501	25.1	10287.0
2019-03-08	AAM.B-DELISTED	Stock	24.71	24.77	24.655	24.68	14601.0
2019-03-08	AAMC-DELISTED	Stock	10.7794	10.7794	10.2853	10.4412	4774.0
2019-03-08	AAME	Stock	2.51	2.69	2.51	2.58	12600.0
2019-03-08	AAMI	Stock	13.59	13.67	13.52	13.56	333800.0
2019-03-08	AAOI	Stock	12.95	13.09	12.85	12.88	709100.0
2019-03-08	AAON	Stock	27.8067	28.1933	27.44	27.7267	168150.0
2019-03-08	AAP	Stock	152.85	153.19	150.5	151.77	1138200.0
2019-03-08	AAT	Stock	44.67	45.5	44.61	45.3	223900.0
2019-03-08	AAU-DELISTED	Stock	0.6	0.6288	0.6	0.6258	224245.0
2019-03-08	AAUAF-DELISTED	Stock	0.6	0.6288	0.6	0.6109	231959.0
2019-03-08	AAWW-DELISTED	Stock	48.4	49.225	48.28	48.94	137799.0
2019-03-08	AAXJ	Stock	67.82	68.21	67.71	68.13	2818512.0
2019-03-08	AAXN-DELISTED	Stock	47.75	47.75	46.28	46.87	909669.0
2019-03-08	AB	Stock	28.81	29.83	28.81	29.0	345600.0
2019-03-08	ABB-DELISTED	Stock	18.64	18.905	18.62	18.9	4161615.0
2019-03-08	ABBNY-DELISTED	Stock	18.63	18.905	18.62	18.9	4265454.0
2019-03-08	ABBV	Stock	77.67	78.04	77.09	77.58	6189100.0
2019-03-08	ABC-DELISTED	Stock	75.81	76.94	75.53	76.4	1238332.0
2019-03-08	ABCB	Stock	37.53	38.24	37.42	38.03	392100.0
2019-03-08	ABDC-DELISTED	Stock	7.35	7.64	7.2	7.64	52090.0
2019-03-08	ABEO	Stock	175.25	183.75	175.0	179.25	12016.0
2019-03-08	ABEV	Stock	4.27	4.3	4.21	4.24	16588000.0
2019-03-08	ABG	Stock	65.95	67.3	65.77	67.03	184300.0
2019-03-08	ABIL-DELISTED	Stock	1.96	1.96	1.6	1.8	339348.0
2019-03-08	ABM	Stock	33.31	33.33	32.05	32.69	1436900.0
2019-03-08	ABMD-DELISTED	Stock	314.0	314.93	305.37	314.2	270836.0
2019-03-08	ABR	Stock	12.67	12.74	12.57	12.67	1192600.0
2019-03-08	ABR.A-DELISTED	Stock	25.69	25.725	25.68	25.725	4613.0
2019-03-08	ABR.B-DELISTED	Stock	25.24	25.5139	25.24	25.5139	1325.0
2019-03-08	ABR.C-DELISTED	Stock	25.8	25.8	25.8	25.8	100.0
2019-03-08	ABT	Stock	76.35	76.68	75.86	76.63	3895400.0
2019-03-08	ABTC	Stock	304500.0	304500.0	302400.0	304170.0	2.1599999999999997

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

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