PREVIEW / stock_daily / 2018-05-07

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-07.parquet
  size:    218 KB
  rows:    6,519
  symbols: 2,835

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-05-07	AAPL	Stock	46.295	46.9175	46.1875	46.29	169805600.0
2018-05-07	MSFT	Stock	95.17	96.71	95.1	96.22	24242000.0
2018-05-07	NVDA	Stock	6.0822	6.2748	6.0723	6.217	687616000.0
2018-05-07	AMZN	Stock	79.467	80.3475	79.3915	80.007	76038000.0
2018-05-07	GOOGL	Stock	52.6945	53.25	52.5135	52.973	34399420.0
2018-05-07	META	Stock	177.35	179.5	177.17	177.97	18697200.0
2018-05-07	TSLA	Stock	19.8333	20.3973	19.678	20.1847	130173000.0
2018-05-07	TLT	Stock	118.97	119.0152	118.735	118.8	3647906.0
2018-05-07	ES	Stock	59.1	59.18	58.6	58.73	1672200.0
2018-05-07	CL	Stock	63.87	64.01	62.79	62.82	4296300.0
2018-05-07	A	Stock	67.16	67.98	67.07	67.39	1468700.0
2018-05-07	AA	Stock	54.8	55.38	54.32	54.55	3891600.0
2018-05-07	AABA-DELISTED	Stock	73.25	75.97	73.25	75.36	4771501.0
2018-05-07	AAC-DELISTED	Stock	11.57	12.0677	11.35	11.77	160488.0
2018-05-07	AACG	Stock	5.18	5.2	5.03	5.1	2200.0
2018-05-07	AAIC-DELISTED	Stock	11.23	11.435	11.215	11.27	781860.0
2018-05-07	AAL	Stock	42.92	43.23	42.12	42.44	5331000.0
2018-05-07	AAM.A-DELISTED	Stock	24.5	24.85	24.5	24.7092	149524.0
2018-05-07	AAM.B-DELISTED	Stock	24.36	24.6504	24.36	24.6	154680.0
2018-05-07	AAMC-DELISTED	Stock	18.9118	19.2647	18.9118	19.2647	1884.0
2018-05-07	AAME	Stock	3.1	3.3	3.1	3.13	1700.0
2018-05-07	AAMI	Stock	15.47	15.5	15.18	15.44	504500.0
2018-05-07	AAOI	Stock	32.0	33.99	31.59	33.64	1249300.0
2018-05-07	AAON	Stock	19.7	19.9667	19.4	19.8	788100.0
2018-05-07	AAP	Stock	116.99	117.5	115.09	116.14	672500.0
2018-05-07	AAT	Stock	34.36	34.96	34.31	34.93	545300.0
2018-05-07	AAU-DELISTED	Stock	0.81	0.8328	0.8028	0.8067	74474.0
2018-05-07	AAUAF-DELISTED	Stock	0.81	0.8328	0.8028	0.8067	79177.0
2018-05-07	AAV-DELISTED	Stock	3.05	3.1	2.9	2.95	406008.0
2018-05-07	AAWW-DELISTED	Stock	67.25	67.85	67.05	67.75	117239.0
2018-05-07	AAXJ	Stock	75.17	75.72	75.04	75.47	317875.0
2018-05-07	AAXN-DELISTED	Stock	45.19	45.48	43.68	44.93	1099390.0
2018-05-07	AB	Stock	26.75	27.1	26.57	27.0	294200.0
2018-05-07	ABAC-DELISTED	Stock	2.15	2.4283	2.15	2.3377	14751.0
2018-05-07	ABAX-DELISTED	Stock	69.69	69.69	68.38	68.77	112155.0
2018-05-07	ABB-DELISTED	Stock	23.58	23.8	23.57	23.68	1046296.0
2018-05-07	ABBNY-DELISTED	Stock	23.58	23.8	23.57	23.68	1107762.0
2018-05-07	ABBV	Stock	100.75	101.27	99.24	99.63	6151500.0
2018-05-07	ABC-DELISTED	Stock	86.45	87.48	84.6	84.69	1120961.0
2018-05-07	ABCB	Stock	53.3	54.15	52.7	53.9	215800.0
2018-05-07	ABCD-DELISTED	Stock	10.48	10.55	9.931	10.0	260477.0
2018-05-07	ABDC-DELISTED	Stock	6.25	6.4761	6.13	6.38	46234.0
2018-05-07	ABEO	Stock	461.25	486.25	461.25	475.0	20660.0
2018-05-07	ABEOW-DELISTED	Stock	13.9743	13.9743	13.9743	13.9743	120.0
2018-05-07	ABEV	Stock	6.32	6.37	6.22	6.26	15160900.0
2018-05-07	ABG	Stock	70.65	70.65	68.35	69.1	178700.0
2018-05-07	ABIL-DELISTED	Stock	2.56	2.77	2.56	2.6399	17216.0
2018-05-07	ABLX-DELISTED	Stock	53.43	53.73	53.43	53.72	1195.0
2018-05-07	ABM	Stock	30.37	30.37	30.09	30.14	730700.0
2018-05-07	ABMD-DELISTED	Stock	348.3	354.395	344.31	347.7	520917.0

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

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