PREVIEW / stock_daily / 2018-06-01

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-01.parquet
  size:    218 KB
  rows:    6,520
  symbols: 2,802

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-06-01	AAPL	Stock	46.9975	47.565	46.9375	47.56	93770000.0
2018-06-01	MSFT	Stock	99.28	100.86	99.17	100.79	28655600.0
2018-06-01	NVDA	Stock	6.35	6.4468	6.3413	6.4405	421968000.0
2018-06-01	AMZN	Stock	81.8515	82.3365	81.7545	82.077	66268000.0
2018-06-01	GOOGL	Stock	55.6435	56.908	55.6005	56.75	63202000.0
2018-06-01	META	Stock	193.07	194.55	192.07	193.99	17307200.0
2018-06-01	TSLA	Stock	19.0573	19.4633	18.9227	19.4547	81366000.0
2018-06-01	TLT	Stock	120.17	120.705	119.85	120.3	8718753.0
2018-06-01	ES	Stock	56.65	56.92	55.59	55.8	2536100.0
2018-06-01	CL	Stock	63.25	63.44	62.28	62.69	3758600.0
2018-06-01	A	Stock	62.47	63.23	62.44	62.78	2277900.0
2018-06-01	AA	Stock	48.39	48.62	47.47	47.64	2442100.0
2018-06-01	AABA-DELISTED	Stock	77.58	80.0	77.58	78.98	3162645.0
2018-06-01	AAC-DELISTED	Stock	10.82	10.82	10.37	10.41	111019.0
2018-06-01	AACG	Stock	5.27	5.27	5.08	5.15	1300.0
2018-06-01	AAIC-DELISTED	Stock	11.5	11.55	11.41	11.55	424422.0
2018-06-01	AAL	Stock	44.05	44.09	43.35	44.0	5472300.0
2018-06-01	AAM.A-DELISTED	Stock	25.0	25.07	24.9	25.07	36966.0
2018-06-01	AAM.B-DELISTED	Stock	24.3999	24.4	24.25	24.39	95211.0
2018-06-01	AAMC-DELISTED	Stock	18.5777	20.4265	18.5777	19.8676	6531.0
2018-06-01	AAME	Stock	2.8	2.95	2.7	2.9	4700.0
2018-06-01	AAMI	Stock	15.68	15.85	15.66	15.8	398600.0
2018-06-01	AAOI	Stock	46.87	46.99	42.5	45.02	3614600.0
2018-06-01	AAON	Stock	20.4667	21.1867	20.4	20.7	493500.0
2018-06-01	AAP	Stock	128.84	129.67	127.26	128.34	993000.0
2018-06-01	AAT	Stock	36.36	36.91	36.13	36.46	438500.0
2018-06-01	AAU-DELISTED	Stock	0.73	0.73	0.7046	0.716	194574.0
2018-06-01	AAUAF-DELISTED	Stock	0.73	0.73	0.7046	0.715	201181.0
2018-06-01	AAV-DELISTED	Stock	2.95	3.095	2.95	3.025	251352.0
2018-06-01	AAWW-DELISTED	Stock	68.8	69.9	68.0	69.3	190795.0
2018-06-01	AAXJ	Stock	76.35	76.87	76.35	76.87	502904.0
2018-06-01	AAXN-DELISTED	Stock	63.97	65.4	63.441	65.29	950252.0
2018-06-01	AB	Stock	28.5	28.85	28.45	28.55	319800.0
2018-06-01	ABAC-DELISTED	Stock	2.1575	2.2	2.1575	2.17	1650.0
2018-06-01	ABAX-DELISTED	Stock	82.96	83.12	82.7	82.73	220482.0
2018-06-01	ABB-DELISTED	Stock	23.09	23.27	23.07	23.22	1304274.0
2018-06-01	ABBNY-DELISTED	Stock	23.09	23.27	23.07	23.23	1371355.0
2018-06-01	ABBV	Stock	97.93	99.43	97.9	98.05	14837300.0
2018-06-01	ABC-DELISTED	Stock	82.66	83.63	82.14	83.32	866824.0
2018-06-01	ABCB	Stock	56.05	56.75	56.05	56.35	222700.0
2018-06-01	ABCD-DELISTED	Stock	10.03	10.21	9.91	10.11	117773.0
2018-06-01	ABDC-DELISTED	Stock	6.78	6.92	6.66	6.81	31471.0
2018-06-01	ABEO	Stock	448.75	453.75	423.75	437.5	37768.0
2018-06-01	ABEOW-DELISTED	Stock	12.17	12.17	12.15	12.15	500.0
2018-06-01	ABEV	Stock	5.32	5.35	5.24	5.27	23776300.0
2018-06-01	ABG	Stock	69.1	71.25	67.05	70.2	155900.0
2018-06-01	ABIL-DELISTED	Stock	2.21	2.43	2.21	2.32	6457.0
2018-06-01	ABLX-DELISTED	Stock	52.79	52.79	42.23	52.37	4643.0
2018-06-01	ABM	Stock	28.64	28.69	28.39	28.49	694800.0
2018-06-01	ABMD-DELISTED	Stock	384.9	399.47	380.17	392.17	640808.0

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

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