PREVIEW / stock_daily / 2019-06-24

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-24.parquet
  size:    221 KB
  rows:    6,581
  symbols: 2,564

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-24	AAPL	Stock	49.635	50.04	49.5425	49.645	72881600.0
2019-06-24	MSFT	Stock	137.0	138.4	137.0	137.78	20628800.0
2019-06-24	NVDA	Stock	3.8155	3.8462	3.768	3.8165	282948000.0
2019-06-24	AMZN	Stock	95.633	95.843	95.065	95.695	45660000.0
2019-06-24	GOOGL	Stock	56.0	56.1785	55.6655	55.835	24237860.0
2019-06-24	META	Stock	192.42	193.98	191.57	192.6	15509000.0
2019-06-24	TSLA	Stock	14.8827	15.0573	14.7347	14.9093	86262000.0
2019-06-24	TLT	Stock	132.16	132.53	132.079	132.41	6378869.0
2019-06-24	ES	Stock	77.83	77.87	77.15	77.39	1353500.0
2019-06-24	CL	Stock	73.54	74.18	73.24	73.97	3508100.0
2019-06-24	A	Stock	73.33	73.68	72.26	73.14	1251600.0
2019-06-24	AA	Stock	22.53	22.693	22.16	22.22	2198400.0
2019-06-24	AABA-DELISTED	Stock	68.94	69.44	68.47	69.09	4176527.0
2019-06-24	AAC-DELISTED	Stock	0.67	0.765	0.66	0.7	439793.0
2019-06-24	AACG	Stock	2.57	2.57	2.3	2.53	77100.0
2019-06-24	AAIC-DELISTED	Stock	7.07	7.07	6.81	6.84	624159.0
2019-06-24	AAIC.C-DELISTED	Stock	21.6522	21.7884	21.56	21.56	4958.0
2019-06-24	AAL	Stock	31.57	31.89	31.31	31.82	8425700.0
2019-06-24	AAM.A-DELISTED	Stock	25.75	25.8108	25.62	25.64	22282.0
2019-06-24	AAM.B-DELISTED	Stock	25.92	25.9936	25.66	25.6872	36691.0
2019-06-24	AAME	Stock	2.34	2.51	2.34	2.51	600.0
2019-06-24	AAMI	Stock	10.87	10.935	10.56	10.83	615800.0
2019-06-24	AAOI	Stock	9.26	9.42	8.99	9.11	631200.0
2019-06-24	AAON	Stock	32.1	32.6667	31.9333	32.3267	174900.0
2019-06-24	AAP	Stock	153.86	153.86	151.66	152.33	1134100.0
2019-06-24	AAT	Stock	47.7	47.81	47.15	47.26	651200.0
2019-06-24	AAU-DELISTED	Stock	0.63	0.6765	0.6296	0.66	312380.0
2019-06-24	AAUAF-DELISTED	Stock	0.63	0.6765	0.6296	0.66	345941.0
2019-06-24	AAWW-DELISTED	Stock	40.65	41.41	39.27	39.55	173754.0
2019-06-24	AAXJ	Stock	69.37	69.455	69.2	69.32	232642.0
2019-06-24	AAXN-DELISTED	Stock	73.35	74.93	72.8019	73.25	573299.0
2019-06-24	AB	Stock	29.53	29.64	29.1	29.29	148000.0
2019-06-24	ABB-DELISTED	Stock	19.99	20.0135	19.91	19.92	2059503.0
2019-06-24	ABBNY-DELISTED	Stock	19.99	20.0135	19.91	19.93	2174998.0
2019-06-24	ABBV	Stock	78.41	79.31	77.85	78.45	5182700.0
2019-06-24	ABC-DELISTED	Stock	84.69	85.14	82.89	83.52	1666418.0
2019-06-24	ABCB	Stock	37.79	38.03	37.36	37.72	237800.0
2019-06-24	ABDC-DELISTED	Stock	8.6447	8.69	8.6102	8.67	30861.0
2019-06-24	ABEO	Stock	118.25	118.25	110.0	110.75	34328.0
2019-06-24	ABEOW-DELISTED	Stock	0.8795	0.8795	0.8	0.85	2500.0
2019-06-24	ABEV	Stock	4.8	4.84	4.78	4.82	15969100.0
2019-06-24	ABG	Stock	81.75	82.04	80.29	80.5	141200.0
2019-06-24	ABIL-DELISTED	Stock	0.8908	0.92	0.8702	0.92	82064.0
2019-06-24	ABM	Stock	39.47	39.55	38.77	38.87	366000.0
2019-06-24	ABMD-DELISTED	Stock	256.06	259.29	252.5	253.08	415099.0
2019-06-24	ABR	Stock	12.31	12.32	12.14	12.17	1166800.0
2019-06-24	ABR.B-DELISTED	Stock	25.8729	25.8729	25.8729	25.8729	500.0
2019-06-24	ABR.C-DELISTED	Stock	26.01	26.01	26.01	26.01	200.0
2019-06-24	ABT	Stock	84.78	85.33	84.64	84.71	4531600.0
2019-06-24	ABTC	Stock	819300.0	833700.0	649860.0	697200.0	28.0

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

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