PREVIEW / stock_daily / 2018-12-10

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-10.parquet
  size:    220 KB
  rows:    6,566
  symbols: 2,694

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
2018-12-10	AAPL	Stock	41.25	42.5225	40.8325	42.4	248104000.0
2018-12-10	MSFT	Stock	104.8	107.98	103.89	107.59	40801500.0
2018-12-10	NVDA	Stock	3.645	3.8215	3.6412	3.7965	629472000.0
2018-12-10	AMZN	Stock	81.192	82.8995	79.5435	82.0515	149896000.0
2018-12-10	GOOGL	Stock	52.147	52.98	51.65	52.659	33652920.0
2018-12-10	META	Stock	139.6	143.05	139.01	141.85	26422200.0
2018-12-10	TSLA	Stock	24.0	24.3987	23.5413	24.3433	99202500.0
2018-12-10	TLT	Stock	118.87	119.28	118.44	118.9	8777672.0
2018-12-10	ES	Stock	69.42	69.82	68.18	69.64	1809500.0
2018-12-10	CL	Stock	63.0	63.71	62.18	63.54	3903500.0
2018-12-10	A	Stock	70.43	70.71	68.57	70.59	2347200.0
2018-12-10	AA	Stock	28.64	29.14	27.85	28.32	2915600.0
2018-12-10	AABA-DELISTED	Stock	62.7	62.84	60.95	62.22	9381930.0
2018-12-10	AAC-DELISTED	Stock	2.13	2.31	2.13	2.26	276312.0
2018-12-10	AACG	Stock	1.06	1.1	1.06	1.08	55000.0
2018-12-10	AAIC-DELISTED	Stock	8.41	8.42	8.16	8.3	331733.0
2018-12-10	AAL	Stock	33.67	34.17	32.61	33.84	8569100.0
2018-12-10	AAM.A-DELISTED	Stock	22.6	22.89	22.13	22.4734	42226.0
2018-12-10	AAM.B-DELISTED	Stock	22.45	22.725	22.2101	22.4452	60421.0
2018-12-10	AAMC-DELISTED	Stock	14.7059	14.7059	14.1176	14.4118	141437.0
2018-12-10	AAME	Stock	2.34	2.42	2.34	2.42	3100.0
2018-12-10	AAMI	Stock	11.7	11.75	11.13	11.36	947500.0
2018-12-10	AAOI	Stock	19.08	19.82	18.94	19.74	511500.0
2018-12-10	AAON	Stock	23.42	23.46	22.9533	23.3733	266700.0
2018-12-10	AAP	Stock	167.81	167.82	163.41	166.17	1471200.0
2018-12-10	AAT	Stock	42.24	42.24	41.22	41.68	218800.0
2018-12-10	AAU-DELISTED	Stock	0.68	0.68	0.63	0.6338	263402.0
2018-12-10	AAUAF-DELISTED	Stock	0.68	0.68	0.63	0.6338	274935.0
2018-12-10	AAWW-DELISTED	Stock	50.1	50.1	47.5	48.57	201678.0
2018-12-10	AAXJ	Stock	64.33	64.58	63.49	64.38	1460685.0
2018-12-10	AAXN-DELISTED	Stock	43.31	44.82	43.31	44.3	518745.0
2018-12-10	AB	Stock	27.5	27.87	25.88	27.11	1475100.0
2018-12-10	ABAC-DELISTED	Stock	1.38	1.4132	1.2749	1.32	7433.0
2018-12-10	ABB-DELISTED	Stock	19.0	19.07	18.74	18.94	2802581.0
2018-12-10	ABBNY-DELISTED	Stock	19.0	19.07	18.74	18.94	3138542.0
2018-12-10	ABBV	Stock	86.67	87.88	84.6	87.61	5229400.0
2018-12-10	ABC-DELISTED	Stock	84.42	84.42	80.45	83.55	992552.0
2018-12-10	ABCB	Stock	37.47	37.81	36.16	36.7	252700.0
2018-12-10	ABCD-DELISTED	Stock	14.48	14.49	14.46	14.48	219555.0
2018-12-10	ABDC-DELISTED	Stock	6.41	6.4376	6.28	6.41	63351.0
2018-12-10	ABEO	Stock	213.0	238.75	206.75	225.25	64732.0
2018-12-10	ABEOW-DELISTED	Stock	5.0	5.0	4.5901	4.5901	220.0
2018-12-10	ABEV	Stock	4.04	4.05	3.96	4.02	16852600.0
2018-12-10	ABG	Stock	64.53	64.53	62.4	63.48	378000.0
2018-12-10	ABIL-DELISTED	Stock	2.38	2.41	2.22	2.35	165596.0
2018-12-10	ABM	Stock	28.23	28.39	27.36	27.57	347300.0
2018-12-10	ABMD-DELISTED	Stock	317.9	326.785	312.46	323.65	325731.0
2018-12-10	ABR	Stock	11.8	11.86	11.44	11.6	1919800.0
2018-12-10	ABR.A-DELISTED	Stock	25.49	25.495	25.2	25.31	7224.0
2018-12-10	ABR.B-DELISTED	Stock	25.2201	25.2805	25.2201	25.2805	550.0

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

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