PREVIEW / stock_daily / 2018-07-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-12.parquet
  size:    218 KB
  rows:    6,495
  symbols: 2,786

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-12	AAPL	Stock	47.3825	47.8525	47.3275	47.7575	72164400.0
2018-07-12	MSFT	Stock	102.77	104.41	102.73	104.19	24335900.0
2018-07-12	NVDA	Stock	6.234	6.3292	6.224	6.2808	345508000.0
2018-07-12	AMZN	Stock	88.2255	89.9	88.109	89.831	90654000.0
2018-07-12	GOOGL	Stock	58.743	60.0993	58.655	60.063	44148620.0
2018-07-12	META	Stock	203.43	207.08	203.19	206.92	15454700.0
2018-07-12	TSLA	Stock	21.4287	21.5487	20.8513	21.114	85818000.0
2018-07-12	TLT	Stock	122.17	122.47	122.14	122.41	4824734.0
2018-07-12	ES	Stock	59.34	59.42	58.88	59.14	2399200.0
2018-07-12	CL	Stock	65.22	65.63	64.97	65.17	2501300.0
2018-07-12	A	Stock	63.33	63.78	63.29	63.45	1748100.0
2018-07-12	AA	Stock	48.1	48.287	47.15	47.4	1896600.0
2018-07-12	AABA-DELISTED	Stock	74.96	75.5699	74.52	74.57	6744281.0
2018-07-12	AAC-DELISTED	Stock	10.0	10.51	9.78	10.48	146537.0
2018-07-12	AACG	Stock	4.37	4.97	4.35	4.36	6400.0
2018-07-12	AAIC-DELISTED	Stock	10.37	10.4	10.19	10.26	602630.0
2018-07-12	AAL	Stock	36.4	36.77	35.64	36.33	12226300.0
2018-07-12	AAM.A-DELISTED	Stock	25.85	25.85	25.6921	25.75	16032.0
2018-07-12	AAM.B-DELISTED	Stock	25.0	25.08	25.0	25.0499	49733.0
2018-07-12	AAMC-DELISTED	Stock	19.3529	20.5442	19.1912	19.1912	11281.0
2018-07-12	AAME	Stock	2.42	2.42	2.42	2.42	300.0
2018-07-12	AAMI	Stock	14.02	14.08	13.56	13.74	1603900.0
2018-07-12	AAOI	Stock	45.76	49.5	45.548	48.8	2173500.0
2018-07-12	AAON	Stock	23.6	23.9333	23.28	23.6667	181650.0
2018-07-12	AAP	Stock	140.37	140.89	138.19	138.79	441200.0
2018-07-12	AAT	Stock	38.12	38.51	37.95	38.49	218000.0
2018-07-12	AAU-DELISTED	Stock	0.705	0.73	0.7021	0.713	80080.0
2018-07-12	AAUAF-DELISTED	Stock	0.705	0.73	0.7021	0.713	87961.0
2018-07-12	AAV-DELISTED	Stock	3.15	3.25	3.125	3.15	109714.0
2018-07-12	AAWW-DELISTED	Stock	70.4	70.845	69.05	69.55	199786.0
2018-07-12	AAXJ	Stock	71.87	72.06	71.64	71.91	662122.0
2018-07-12	AAXN-DELISTED	Stock	67.47	69.22	66.0	68.95	614141.0
2018-07-12	AB	Stock	29.05	29.19	28.7	28.85	247700.0
2018-07-12	ABAC-DELISTED	Stock	2.35	2.4	2.35	2.3942	9521.0
2018-07-12	ABAX-DELISTED	Stock	83.27	83.34	83.2301	83.3	100967.0
2018-07-12	ABB-DELISTED	Stock	21.37	21.58	21.3225	21.535	2547601.0
2018-07-12	ABBNY-DELISTED	Stock	21.37	21.58	21.3225	21.54	2608381.0
2018-07-12	ABBV	Stock	94.92	95.67	94.1	95.61	4672000.0
2018-07-12	ABC-DELISTED	Stock	87.76	87.99	86.19	86.8	1304818.0
2018-07-12	ABCB	Stock	52.2	52.85	51.2	52.1	357600.0
2018-07-12	ABCD-DELISTED	Stock	11.55	11.8	11.53	11.79	85914.0
2018-07-12	ABDC-DELISTED	Stock	6.35	6.35	6.11	6.16	92142.0
2018-07-12	ABEO	Stock	376.25	385.0	375.0	385.0	24656.0
2018-07-12	ABEV	Stock	4.69	4.75	4.66	4.71	33391300.0
2018-07-12	ABG	Stock	68.65	69.05	67.0	67.45	179900.0
2018-07-12	ABIL-DELISTED	Stock	7.1	8.24	7.0	7.4	454942.0
2018-07-12	ABM	Stock	30.89	31.06	30.57	31.05	810100.0
2018-07-12	ABMD-DELISTED	Stock	408.19	415.02	408.16	414.6	984853.0
2018-07-12	ABR	Stock	10.95	11.0	10.9	10.94	969500.0
2018-07-12	ABR.A-DELISTED	Stock	26.1	26.1	26.053	26.053	1975.0

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

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