PREVIEW / stock_daily / 2017-06-12

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-12.parquet
  size:    215 KB
  rows:    6,466
  symbols: 3,007

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
2017-06-12	AAPL	Stock	36.435	36.5225	35.6275	36.355	289229200.0
2017-06-12	MSFT	Stock	69.25	69.94	68.13	69.78	47761700.0
2017-06-12	NVDA	Stock	3.647	3.7925	3.5528	3.7492	1697532000.0
2017-06-12	AMZN	Stock	48.35	48.7975	47.25	48.2455	188944000.0
2017-06-12	GOOGL	Stock	47.936	48.4	46.8398	48.0905	84042180.0
2017-06-12	META	Stock	148.17	149.2	144.56	148.44	33170200.0
2017-06-12	TSLA	Stock	23.866	24.3	23.3747	23.934	157765500.0
2017-06-12	TLT	Stock	124.21	124.99	124.139	124.36	4335780.0
2017-06-12	ES	Stock	62.34	62.68	61.67	62.25	1207900.0
2017-06-12	CL	Stock	75.86	76.0	75.08	75.55	2571700.0
2017-06-12	A	Stock	59.14	59.41	58.12	58.99	2579600.0
2017-06-12	AA	Stock	32.82	33.21	31.78	31.78	4719500.0
2017-06-12	AAAP-DELISTED	Stock	36.41	36.5	36.0	36.05	62148.0
2017-06-12	AABA-DELISTED	Stock	53.79	54.55	52.6	53.12	51355505.0
2017-06-12	AAC-DELISTED	Stock	6.43	6.69	6.43	6.55	34981.0
2017-06-12	AACG	Stock	4.4	4.98	4.22	4.95	75000.0
2017-06-12	AAIC-DELISTED	Stock	14.6	14.79	14.55	14.66	553575.0
2017-06-12	AAL	Stock	50.1	50.22	48.1	49.48	8597900.0
2017-06-12	AAM.A-DELISTED	Stock	25.47	25.47	25.32	25.32	82126.0
2017-06-12	AAMC-DELISTED	Stock	24.2059	25.2941	24.2059	25.2941	8524.0
2017-06-12	AAME	Stock	3.68	3.8	3.65	3.8	1300.0
2017-06-12	AAMI	Stock	14.75	14.895	14.43	14.46	1638900.0
2017-06-12	AAOI	Stock	63.52	66.89	60.02	64.61	4931200.0
2017-06-12	AAON	Stock	24.9333	25.2	23.9933	24.8667	225150.0
2017-06-12	AAP	Stock	128.11	130.95	127.63	130.95	1466200.0
2017-06-12	AAT	Stock	40.6	41.33	40.6	41.08	323700.0
2017-06-12	AAU-DELISTED	Stock	1.32	1.37	1.3	1.3581	203428.0
2017-06-12	AAUAF-DELISTED	Stock	1.32	1.37	1.3	1.33	206420.0
2017-06-12	AAV-DELISTED	Stock	6.1	6.2	6.0	6.175	128768.0
2017-06-12	AAWW-DELISTED	Stock	53.35	54.2	52.85	53.05	148450.0
2017-06-12	AAXJ	Stock	67.38	67.45	67.08	67.37	437843.0
2017-06-12	AAXN-DELISTED	Stock	24.33	24.46	24.11	24.19	285117.0
2017-06-12	AB	Stock	23.2	23.3	23.05	23.1	335500.0
2017-06-12	ABAC-DELISTED	Stock	2.01	2.1	2.01	2.0531	4855.0
2017-06-12	ABAX-DELISTED	Stock	51.84	52.0	50.87	51.3	71425.0
2017-06-12	ABB-DELISTED	Stock	25.04	25.12	24.94	25.105	1927107.0
2017-06-12	ABBNY-DELISTED	Stock	25.04	25.12	24.94	25.11	1975940.0
2017-06-12	ABBV	Stock	69.79	69.9	69.25	69.53	6084300.0
2017-06-12	ABC-DELISTED	Stock	91.89	92.75	91.89	92.3747	617721.0
2017-06-12	ABCB	Stock	49.25	49.8	47.85	48.4	211900.0
2017-06-12	ABCD-DELISTED	Stock	5.03	5.03	4.91	4.95	46753.0
2017-06-12	ABCO-DELISTED	Stock	51.15	51.25	50.65	51.0	491097.0
2017-06-12	ABDC-DELISTED	Stock	13.15	13.29	13.15	13.27	41251.0
2017-06-12	ABE-DELISTED	Stock	13.87	13.87	13.82	13.83	1444.0
2017-06-12	ABEO	Stock	127.5	128.75	117.5	117.5	13844.0
2017-06-12	ABEV	Stock	5.4	5.45	5.4	5.43	24994500.0
2017-06-12	ABG	Stock	55.35	57.7	55.35	57.7	199400.0
2017-06-12	ABIL-DELISTED	Stock	1.21	1.45	1.081	1.17	2774839.0
2017-06-12	ABM	Stock	43.0	43.11	40.52	40.68	638000.0
2017-06-12	ABMD-DELISTED	Stock	139.94	141.085	134.8	139.975	448131.0

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

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