PREVIEW / stock_daily / 2019-06-21

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-21.parquet
  size:    222 KB
  rows:    6,588
  symbols: 2,558

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-06-21	AAPL	Stock	49.7	50.2125	49.5375	49.695	191202400.0
2019-06-21	MSFT	Stock	136.58	137.73	136.46	136.97	36727900.0
2019-06-21	NVDA	Stock	3.8375	3.887	3.7875	3.794	434428000.0
2019-06-21	AMZN	Stock	95.805	96.2975	95.379	95.565	78672000.0
2019-06-21	GOOGL	Stock	55.493	56.3285	55.486	56.2685	50777440.0
2019-06-21	META	Stock	188.75	192.0	188.75	191.14	22751200.0
2019-06-21	TSLA	Stock	14.4147	14.812	14.3667	14.7907	123031500.0
2019-06-21	TLT	Stock	132.51	132.53	131.375	131.43	14495149.0
2019-06-21	ES	Stock	77.29	77.63	76.82	77.4	3823500.0
2019-06-21	CL	Stock	73.68	74.0	72.88	72.95	6209400.0
2019-06-21	A	Stock	73.14	73.54	72.55	73.34	3096200.0
2019-06-21	AA	Stock	22.59	22.74	22.18	22.6	2947700.0
2019-06-21	AABA-DELISTED	Stock	68.58	69.57	68.17	68.94	8008033.0
2019-06-21	AAC-DELISTED	Stock	0.6836	0.7259	0.66	0.6956	472223.0
2019-06-21	AACG	Stock	2.67	2.68	2.43	2.59	143100.0
2019-06-21	AAIC-DELISTED	Stock	6.98	7.045	6.9236	6.97	811430.0
2019-06-21	AAIC.C-DELISTED	Stock	21.75	21.91	21.534	21.65	23013.0
2019-06-21	AAL	Stock	32.03	32.39	31.51	31.57	7481800.0
2019-06-21	AAM.A-DELISTED	Stock	25.8	25.95	25.76	25.76	19020.0
2019-06-21	AAM.B-DELISTED	Stock	25.99	26.04	25.84	25.98	15490.0
2019-06-21	AAMC-DELISTED	Stock	4.0029	4.3382	4.0029	4.1176	20822.0
2019-06-21	AAME	Stock	2.51	2.51	2.51	2.51	1200.0
2019-06-21	AAMI	Stock	11.0	11.033	10.88	10.9	523500.0
2019-06-21	AAOI	Stock	8.86	9.33	8.86	9.29	1019500.0
2019-06-21	AAON	Stock	32.6933	32.86	31.8867	32.0733	315450.0
2019-06-21	AAP	Stock	153.61	154.11	151.76	153.24	1054200.0
2019-06-21	AAT	Stock	47.7	47.81	46.8	47.49	819100.0
2019-06-21	AAU-DELISTED	Stock	0.625	0.6315	0.6	0.6233	195484.0
2019-06-21	AAUAF-DELISTED	Stock	0.625	0.6315	0.6	0.6233	208003.0
2019-06-21	AAWW-DELISTED	Stock	41.75	41.82	40.36	40.61	208737.0
2019-06-21	AAXJ	Stock	69.28	69.47	69.19	69.27	721917.0
2019-06-21	AAXN-DELISTED	Stock	72.48	73.48	70.35	73.34	1396584.0
2019-06-21	AB	Stock	29.23	29.66	29.23	29.53	107700.0
2019-06-21	ABB-DELISTED	Stock	19.82	19.95	19.77	19.88	2433592.0
2019-06-21	ABBNY-DELISTED	Stock	19.82	19.95	19.77	19.89	2525819.0
2019-06-21	ABBV	Stock	78.15	79.08	76.43	78.78	10516900.0
2019-06-21	ABC-DELISTED	Stock	85.38	85.49	84.25	84.48	2136770.0
2019-06-21	ABCB	Stock	37.63	38.29	37.47	37.75	726900.0
2019-06-21	ABDC-DELISTED	Stock	8.59	8.68	8.5777	8.65	38892.0
2019-06-21	ABEO	Stock	120.25	121.0	111.75	115.5	46736.0
2019-06-21	ABEOW-DELISTED	Stock	0.9	0.95	0.9	0.95	900.0
2019-06-21	ABEV	Stock	4.81	4.86	4.8	4.81	31790500.0
2019-06-21	ABG	Stock	83.16	83.85	81.71	81.75	294200.0
2019-06-21	ABIL-DELISTED	Stock	0.9001	0.94	0.87	0.919	200785.0
2019-06-21	ABM	Stock	39.78	40.29	39.42	39.42	404400.0
2019-06-21	ABMD-DELISTED	Stock	260.0	261.45	255.51	256.14	400025.0
2019-06-21	ABR	Stock	12.38	12.38	12.24	12.27	2005400.0
2019-06-21	ABR.A-DELISTED	Stock	26.3386	26.3386	25.91	25.91	2435.0
2019-06-21	ABT	Stock	85.36	85.36	84.41	85.0	8855400.0
2019-06-21	ABTC	Stock	942000.0	1121220.0	804000.0	811500.0	58.46666666666667

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

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