PREVIEW / stock_daily / 2018-07-02

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-02.parquet
  size:    217 KB
  rows:    6,487
  symbols: 2,765

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-07-02	AAPL	Stock	45.955	46.825	45.855	46.795	70925200.0
2018-07-02	MSFT	Stock	98.1	100.06	98.0	100.01	19564500.0
2018-07-02	NVDA	Stock	5.8523	6.0598	5.8315	6.056	357572000.0
2018-07-02	AMZN	Stock	84.135	85.6945	83.903	85.689	63714000.0
2018-07-02	GOOGL	Stock	55.7675	57.1495	55.33	57.1055	23220800.0
2018-07-02	META	Stock	193.37	197.45	192.22	197.36	13961600.0
2018-07-02	TSLA	Stock	24.0047	24.3187	21.99	22.338	281397000.0
2018-07-02	TLT	Stock	121.74	121.75	121.2901	121.35	9661972.0
2018-07-02	ES	Stock	58.6	59.09	58.36	59.02	1601600.0
2018-07-02	CL	Stock	64.6	65.11	64.03	64.58	3057200.0
2018-07-02	A	Stock	61.36	61.48	60.79	61.47	1526500.0
2018-07-02	AA	Stock	46.46	47.29	45.49	45.88	2150500.0
2018-07-02	AABA-DELISTED	Stock	71.61	73.5	71.54	73.49	19060054.0
2018-07-02	AAC-DELISTED	Stock	9.37	9.73	9.2801	9.67	104730.0
2018-07-02	AACG	Stock	4.09	4.45	4.06	4.23	2900.0
2018-07-02	AAIC-DELISTED	Stock	10.26	10.4	10.2	10.39	728429.0
2018-07-02	AAL	Stock	37.74	38.4	37.44	38.36	3363500.0
2018-07-02	AAM.A-DELISTED	Stock	25.403	25.69	25.403	25.69	20600.0
2018-07-02	AAM.B-DELISTED	Stock	24.94	25.0	24.8913	25.0	35451.0
2018-07-02	AAMC-DELISTED	Stock	20.5	20.5	19.2654	20.1618	4910.0
2018-07-02	AAME	Stock	2.75	2.75	2.4	2.55	10000.0
2018-07-02	AAMI	Stock	14.08	14.43	14.08	14.39	508300.0
2018-07-02	AAOI	Stock	44.55	47.8	44.0	45.98	1637700.0
2018-07-02	AAON	Stock	21.9667	22.6333	21.8933	22.6333	262200.0
2018-07-02	AAP	Stock	135.0	135.16	133.42	134.7	662500.0
2018-07-02	AAT	Stock	38.19	38.57	37.61	38.22	235200.0
2018-07-02	AAU-DELISTED	Stock	0.71	0.7125	0.7	0.7016	200164.0
2018-07-02	AAUAF-DELISTED	Stock	0.71	0.7125	0.7	0.7016	221095.0
2018-07-02	AAV-DELISTED	Stock	3.1	3.1	3.05	3.1	36839.0
2018-07-02	AAWW-DELISTED	Stock	70.75	72.425	70.75	71.95	149860.0
2018-07-02	AAXJ	Stock	70.41	70.85	70.3	70.78	690139.0
2018-07-02	AAXN-DELISTED	Stock	64.0	64.81	63.01	64.43	515857.0
2018-07-02	AB	Stock	28.45	28.85	28.4	28.8	301500.0
2018-07-02	ABAC-DELISTED	Stock	2.7127	2.81	2.7101	2.8	7471.0
2018-07-02	ABAX-DELISTED	Stock	83.0	83.13	82.98	83.05	127680.0
2018-07-02	ABB-DELISTED	Stock	21.48	21.6	21.44	21.58	1116569.0
2018-07-02	ABBNY-DELISTED	Stock	21.48	21.6	21.44	21.58	1174899.0
2018-07-02	ABBV	Stock	92.06	93.3	91.85	93.11	3854500.0
2018-07-02	ABC-DELISTED	Stock	84.8	85.74	83.59	85.67	1048123.0
2018-07-02	ABCB	Stock	53.1	54.35	53.1	54.3	141400.0
2018-07-02	ABCD-DELISTED	Stock	11.11	11.54	11.1064	11.3	178970.0
2018-07-02	ABDC-DELISTED	Stock	6.41	6.6	6.4	6.5	42060.0
2018-07-02	ABEO	Stock	398.75	411.25	398.25	402.5	23584.0
2018-07-02	ABEV	Stock	4.6	4.69	4.58	4.65	26073700.0
2018-07-02	ABG	Stock	68.1	68.8	67.56	68.8	286900.0
2018-07-02	ABIL-DELISTED	Stock	7.03	7.4404	6.6071	6.8846	120150.0
2018-07-02	ABM	Stock	28.99	29.56	28.68	29.56	1319200.0
2018-07-02	ABMD-DELISTED	Stock	407.0	415.3117	400.52	412.37	308745.0
2018-07-02	ABR	Stock	10.43	10.62	10.43	10.55	1245700.0
2018-07-02	ABR.A-DELISTED	Stock	25.8	25.9787	25.8	25.9787	4138.0

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

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