PREVIEW / stock_daily / 2018-07-31

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-31.parquet
  size:    219 KB
  rows:    6,528
  symbols: 2,782

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-31	AAPL	Stock	47.575	48.035	47.335	47.5725	157492000.0
2018-07-31	MSFT	Stock	106.49	106.72	105.38	106.08	27655200.0
2018-07-31	NVDA	Stock	6.0928	6.197	6.0535	6.1215	283988000.0
2018-07-31	AMZN	Stock	89.3245	90.0915	86.966	88.872	114774000.0
2018-07-31	GOOGL	Stock	61.5855	62.0605	60.8095	61.361	39382220.0
2018-07-31	META	Stock	170.67	174.24	170.0	172.58	40356500.0
2018-07-31	TSLA	Stock	19.4833	19.888	19.2713	19.876	76153500.0
2018-07-31	TLT	Stock	119.79	119.86	119.555	119.7	6797432.0
2018-07-31	ES	Stock	60.01	60.81	59.65	60.72	2144400.0
2018-07-31	CL	Stock	66.5	67.35	66.43	67.01	4741600.0
2018-07-31	A	Stock	64.93	66.69	64.54	66.04	2539200.0
2018-07-31	AA	Stock	42.68	43.61	42.655	43.27	2557600.0
2018-07-31	AABA-DELISTED	Stock	73.14	74.1	72.16	73.51	8930216.0
2018-07-31	AAC-DELISTED	Stock	10.6	10.675	10.26	10.39	93365.0
2018-07-31	AACG	Stock	4.35	4.64	4.35	4.46	1800.0
2018-07-31	AAIC-DELISTED	Stock	10.47	10.54	10.4	10.52	820255.0
2018-07-31	AAL	Stock	39.26	39.87	39.14	39.54	5761100.0
2018-07-31	AAM.A-DELISTED	Stock	25.35	25.48	25.32	25.39	15882.0
2018-07-31	AAM.B-DELISTED	Stock	25.07	25.07	25.0	25.0344	80714.0
2018-07-31	AAMC-DELISTED	Stock	18.1471	20.1324	18.125	19.2794	13223.0
2018-07-31	AAME	Stock	2.45	2.6	2.32	2.6	1800.0
2018-07-31	AAMI	Stock	14.27	14.37	14.17	14.25	1350600.0
2018-07-31	AAOI	Stock	37.99	39.143	37.43	38.43	476700.0
2018-07-31	AAON	Stock	24.6	25.2	24.52	25.1667	353550.0
2018-07-31	AAP	Stock	140.87	141.98	139.8	141.23	463100.0
2018-07-31	AAT	Stock	37.78	38.65	37.59	38.43	277800.0
2018-07-31	AAU-DELISTED	Stock	0.65	0.6867	0.65	0.6819	35922.0
2018-07-31	AAUAF-DELISTED	Stock	0.65	0.6867	0.65	0.6819	38921.0
2018-07-31	AAV-DELISTED	Stock	3.4	3.49	3.35	3.45	125121.0
2018-07-31	AAWW-DELISTED	Stock	65.65	67.1	65.65	67.05	489220.0
2018-07-31	AAXJ	Stock	72.65	73.19	72.55	73.05	400877.0
2018-07-31	AAXN-DELISTED	Stock	66.5	68.32	66.3502	67.92	662312.0
2018-07-31	AB	Stock	30.5	30.6	30.05	30.2	473800.0
2018-07-31	ABAC-DELISTED	Stock	2.22	2.3352	2.154	2.3352	15016.0
2018-07-31	ABAX-DELISTED	Stock	83.11	83.24	83.03	83.05	312085.0
2018-07-31	ABB-DELISTED	Stock	23.05	23.12	22.995	23.03	1469749.0
2018-07-31	ABBNY-DELISTED	Stock	23.05	23.12	22.995	23.02	1539675.0
2018-07-31	ABBV	Stock	91.65	92.63	91.33	92.23	8691800.0
2018-07-31	ABC-DELISTED	Stock	83.21	83.49	81.78	81.83	1313068.0
2018-07-31	ABCB	Stock	47.45	48.35	45.95	46.6	1099700.0
2018-07-31	ABCD-DELISTED	Stock	11.97	12.13	11.6977	11.86	83653.0
2018-07-31	ABDC-DELISTED	Stock	5.95	6.07	5.8	6.07	79913.0
2018-07-31	ABEO	Stock	341.25	361.25	338.75	361.25	25892.0
2018-07-31	ABEOW-DELISTED	Stock	8.75	9.2102	8.75	9.11	550.0
2018-07-31	ABEV	Stock	5.23	5.24	5.1	5.14	25830900.0
2018-07-31	ABG	Stock	70.7	70.7	69.5	70.3	245500.0
2018-07-31	ABIL-DELISTED	Stock	3.11	3.2799	3.0949	3.255	45917.0
2018-07-31	ABM	Stock	31.0	31.22	30.73	31.2	2277500.0
2018-07-31	ABMD-DELISTED	Stock	358.4	363.96	344.11	354.48	876927.0
2018-07-31	ABR	Stock	11.38	11.41	11.26	11.37	1190700.0

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

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