PREVIEW / stock_daily / 2019-06-11

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-11.parquet
  size:    220 KB
  rows:    6,549
  symbols: 2,551

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-11	AAPL	Stock	48.715	49.0	48.4	48.7025	107731600.0
2019-06-11	MSFT	Stock	133.88	134.24	131.28	132.1	23913700.0
2019-06-11	NVDA	Stock	3.771	3.809	3.729	3.7688	383872000.0
2019-06-11	AMZN	Stock	94.1625	94.685	92.9	93.185	80854000.0
2019-06-11	GOOGL	Stock	54.8495	55.2003	53.9785	54.052	33516340.0
2019-06-11	META	Stock	178.48	179.98	176.79	178.1	15266600.0
2019-06-11	TSLA	Stock	14.6093	14.7267	14.2333	14.4733	174802500.0
2019-06-11	TLT	Stock	130.42	130.76	130.32	130.58	5115128.0
2019-06-11	ES	Stock	75.84	76.22	75.09	75.48	1292100.0
2019-06-11	CL	Stock	73.19	73.35	72.78	73.33	3184700.0
2019-06-11	A	Stock	72.25	72.6	69.81	70.09	1748200.0
2019-06-11	AA	Stock	22.4	22.5	21.66	21.67	3015200.0
2019-06-11	AABA-DELISTED	Stock	67.22	67.92	66.78	67.1	8969570.0
2019-06-11	AAC-DELISTED	Stock	0.8242	0.8484	0.7822	0.7858	437454.0
2019-06-11	AACG	Stock	2.27	2.28	2.01	2.13	154200.0
2019-06-11	AAIC-DELISTED	Stock	6.91	6.96	6.845	6.89	261357.0
2019-06-11	AAIC.C-DELISTED	Stock	21.99	21.99	21.75	21.93	11914.0
2019-06-11	AAL	Stock	31.1	31.29	30.51	30.58	3461800.0
2019-06-11	AAM.A-DELISTED	Stock	25.67	25.75	25.67	25.68	16813.0
2019-06-11	AAM.B-DELISTED	Stock	25.81	25.89	25.8	25.8	14072.0
2019-06-11	AAMC-DELISTED	Stock	4.1971	4.3794	3.9434	3.9434	24769.0
2019-06-11	AAME	Stock	2.32	2.45	2.3	2.45	3100.0
2019-06-11	AAMI	Stock	11.18	11.306	10.99	11.04	355100.0
2019-06-11	AAOI	Stock	9.72	9.81	9.1	9.12	427400.0
2019-06-11	AAON	Stock	32.6933	32.8933	31.8	31.98	146550.0
2019-06-11	AAP	Stock	153.76	153.84	150.32	152.17	1469200.0
2019-06-11	AAT	Stock	45.6	46.05	44.25	45.35	1113800.0
2019-06-11	AAU-DELISTED	Stock	0.51	0.51	0.47	0.4756	212281.0
2019-06-11	AAUAF-DELISTED	Stock	0.51	0.51	0.47	0.4756	213776.0
2019-06-11	AAWW-DELISTED	Stock	40.9	41.51	40.42	41.42	375961.0
2019-06-11	AAXJ	Stock	68.3	68.3499	67.88	68.08	2062972.0
2019-06-11	AAXN-DELISTED	Stock	72.0	72.35	69.14	70.44	798672.0
2019-06-11	AB	Stock	28.2	28.46	27.85	28.07	340400.0
2019-06-11	ABB-DELISTED	Stock	19.53	19.57	19.365	19.435	1252550.0
2019-06-11	ABBNY-DELISTED	Stock	19.53	19.57	19.365	19.43	1302447.0
2019-06-11	ABBV	Stock	77.49	78.9	77.49	78.17	4210200.0
2019-06-11	ABC-DELISTED	Stock	85.0	85.27	84.4538	84.72	984951.0
2019-06-11	ABCB	Stock	37.53	38.07	37.37	37.98	361600.0
2019-06-11	ABDC-DELISTED	Stock	8.14	8.15	8.09	8.115	12927.0
2019-06-11	ABEO	Stock	137.5	139.0	129.5	131.5	16508.0
2019-06-11	ABEOW-DELISTED	Stock	1.18	1.18	1.17	1.17	268.0
2019-06-11	ABEV	Stock	4.58	4.65	4.55	4.61	26309200.0
2019-06-11	ABG	Stock	79.21	80.49	79.05	79.4	162900.0
2019-06-11	ABIL-DELISTED	Stock	1.12	1.3291	1.12	1.19	609446.0
2019-06-11	ABM	Stock	39.82	39.83	38.98	39.62	436700.0
2019-06-11	ABMD-DELISTED	Stock	274.19	279.69	259.33	262.14	467096.0
2019-06-11	ABR	Stock	12.15	12.16	11.96	12.05	2088200.0
2019-06-11	ABR.A-DELISTED	Stock	25.81	26.0518	25.81	26.0518	2500.0
2019-06-11	ABR.B-DELISTED	Stock	25.66	25.75	25.66	25.75	250.0
2019-06-11	ABR.C-DELISTED	Stock	26.27	26.27	26.0178	26.1829	4350.0

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

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