PREVIEW / stock_daily / 2018-12-13

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-13.parquet
  size:    220 KB
  rows:    6,560
  symbols: 2,695

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-13	AAPL	Stock	42.6225	43.1425	42.3875	42.7375	127594400.0
2018-12-13	MSFT	Stock	109.58	110.87	108.63	109.45	31333400.0
2018-12-13	NVDA	Stock	3.7698	3.8345	3.686	3.7222	471384000.0
2018-12-13	AMZN	Stock	84.0	84.606	82.075	82.919	105426000.0
2018-12-13	GOOGL	Stock	53.7835	54.421	53.2497	53.677	24988060.0
2018-12-13	META	Stock	145.57	145.85	143.19	145.01	18148600.0
2018-12-13	TSLA	Stock	24.6767	25.1627	24.45	25.1193	110488500.0
2018-12-13	TLT	Stock	118.46	118.58	117.98	118.07	5564328.0
2018-12-13	ES	Stock	69.52	70.47	69.52	70.23	1826100.0
2018-12-13	CL	Stock	65.36	65.88	65.13	65.47	4066900.0
2018-12-13	A	Stock	72.14	72.68	70.9	71.14	2200600.0
2018-12-13	AA	Stock	29.27	29.313	28.52	29.1	2557700.0
2018-12-13	AABA-DELISTED	Stock	63.34	63.34	62.32	62.74	4773338.0
2018-12-13	AAC-DELISTED	Stock	2.42	2.4314	2.27	2.36	180333.0
2018-12-13	AACG	Stock	1.09	1.16	1.03	1.05	194700.0
2018-12-13	AAIC-DELISTED	Stock	8.33	8.375	8.3099	8.35	228579.0
2018-12-13	AAL	Stock	34.3	34.69	32.38	32.46	10279700.0
2018-12-13	AAM.A-DELISTED	Stock	22.3	22.411	22.16	22.2044	36192.0
2018-12-13	AAM.B-DELISTED	Stock	22.27	22.42	22.1	22.14	53560.0
2018-12-13	AAMC-DELISTED	Stock	13.5353	14.4176	13.5353	14.4176	7983.0
2018-12-13	AAME	Stock	2.41	2.41	2.35	2.35	1800.0
2018-12-13	AAMI	Stock	11.57	11.63	11.29	11.36	254500.0
2018-12-13	AAOI	Stock	20.03	20.13	19.02	19.1	406600.0
2018-12-13	AAON	Stock	23.9933	24.1933	23.68	23.8733	197250.0
2018-12-13	AAP	Stock	166.82	167.98	165.13	166.29	1008100.0
2018-12-13	AAT	Stock	41.27	41.99	41.18	41.92	167000.0
2018-12-13	AAU-DELISTED	Stock	0.69	0.69	0.631	0.6378	151945.0
2018-12-13	AAUAF-DELISTED	Stock	0.69	0.69	0.631	0.6378	157386.0
2018-12-13	AAWW-DELISTED	Stock	48.71	50.04	46.05	46.51	182840.0
2018-12-13	AAXJ	Stock	66.2	66.33	65.87	65.92	3135222.0
2018-12-13	AAXN-DELISTED	Stock	46.0	46.0	44.85	45.13	491034.0
2018-12-13	AB	Stock	27.14	27.67	26.9	27.55	538300.0
2018-12-13	ABAC-DELISTED	Stock	1.13	1.18	1.1	1.14	20198.0
2018-12-13	ABB-DELISTED	Stock	20.0	20.01	19.7	19.81	2411553.0
2018-12-13	ABBNY-DELISTED	Stock	20.0	20.01	19.7	19.81	2492941.0
2018-12-13	ABBV	Stock	89.37	89.99	87.37	87.71	4078600.0
2018-12-13	ABC-DELISTED	Stock	82.93	83.34	81.28	81.87	844634.0
2018-12-13	ABCB	Stock	36.41	36.41	34.61	34.82	388300.0
2018-12-13	ABCD-DELISTED	Stock	14.47	14.5	14.47	14.49	258668.0
2018-12-13	ABDC-DELISTED	Stock	6.93	7.05	6.65	6.725	152091.0
2018-12-13	ABEO	Stock	209.75	215.0	189.0	189.5	34360.0
2018-12-13	ABEOW-DELISTED	Stock	3.75	3.75	3.75	3.75	100.0
2018-12-13	ABEV	Stock	4.14	4.19	4.1	4.15	20699500.0
2018-12-13	ABG	Stock	64.59	65.52	64.08	65.09	225500.0
2018-12-13	ABIL-DELISTED	Stock	2.39	2.39	2.2	2.22	303772.0
2018-12-13	ABM	Stock	27.36	27.39	26.21	26.31	463900.0
2018-12-13	ABMD-DELISTED	Stock	332.42	338.2093	317.2617	319.82	336628.0
2018-12-13	ABR	Stock	11.77	11.85	11.51	11.51	839700.0
2018-12-13	ABR.A-DELISTED	Stock	25.3995	25.45	25.3995	25.45	460.0
2018-12-13	ABR.B-DELISTED	Stock	25.31	25.71	25.3041	25.3041	1200.0

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

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