PREVIEW / stock_daily / 2018-06-08

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-08.parquet
  size:    218 KB
  rows:    6,472
  symbols: 2,774

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-08	AAPL	Stock	47.7925	48.0	47.4425	47.925	106627200.0
2018-06-08	MSFT	Stock	101.09	101.95	100.54	101.63	22165100.0
2018-06-08	NVDA	Stock	6.499	6.6	6.48	6.557	360456000.0
2018-06-08	AMZN	Stock	84.056	84.472	83.6505	84.1995	59102000.0
2018-06-08	GOOGL	Stock	56.5605	56.939	56.1615	56.6355	27284520.0
2018-06-08	META	Stock	187.53	189.48	186.43	189.1	12677100.0
2018-06-08	TSLA	Stock	21.2667	21.632	21.1433	21.1773	123078000.0
2018-06-08	TLT	Stock	119.56	119.85	119.44	119.53	6790574.0
2018-06-08	ES	Stock	53.8	54.03	53.37	53.56	1391000.0
2018-06-08	CL	Stock	62.95	63.82	62.9	63.34	4782400.0
2018-06-08	A	Stock	65.35	66.37	65.15	65.73	3853800.0
2018-06-08	AA	Stock	49.01	49.49	48.44	48.52	2299300.0
2018-06-08	AABA-DELISTED	Stock	78.83	80.88	78.5716	80.58	6015222.0
2018-06-08	AAC-DELISTED	Stock	10.25	10.5	10.25	10.34	64348.0
2018-06-08	AACG	Stock	5.22	5.22	5.22	5.22	1400.0
2018-06-08	AAIC-DELISTED	Stock	11.47	11.53	11.22	11.23	941785.0
2018-06-08	AAL	Stock	43.96	43.97	42.96	43.11	6273000.0
2018-06-08	AAM.A-DELISTED	Stock	25.49	25.6	25.44	25.56	31223.0
2018-06-08	AAM.B-DELISTED	Stock	24.8	24.84	24.7456	24.8301	45385.0
2018-06-08	AAMC-DELISTED	Stock	20.5882	20.5882	19.6764	20.4189	42010.0
2018-06-08	AAME	Stock	2.65	2.75	2.65	2.65	3100.0
2018-06-08	AAMI	Stock	15.72	15.86	15.57	15.84	354100.0
2018-06-08	AAOI	Stock	44.49	46.859	44.277	45.36	913200.0
2018-06-08	AAON	Stock	21.9667	22.2667	21.5	22.1667	317100.0
2018-06-08	AAP	Stock	129.91	132.67	128.51	131.71	863800.0
2018-06-08	AAT	Stock	37.19	37.38	37.1	37.23	182900.0
2018-06-08	AAU-DELISTED	Stock	0.73	0.75	0.72	0.75	105351.0
2018-06-08	AAUAF-DELISTED	Stock	0.73	0.75	0.72	0.75	115814.0
2018-06-08	AAV-DELISTED	Stock	3.1	3.175	3.055	3.125	112272.0
2018-06-08	AAWW-DELISTED	Stock	70.95	71.35	70.55	70.95	95727.0
2018-06-08	AAXJ	Stock	77.33	77.74	77.14	77.51	467557.0
2018-06-08	AAXN-DELISTED	Stock	63.16	65.74	63.1	65.28	989970.0
2018-06-08	AB	Stock	28.9	29.3	28.7	29.25	227700.0
2018-06-08	ABAC-DELISTED	Stock	2.32	2.389	2.3079	2.3623	7247.0
2018-06-08	ABAX-DELISTED	Stock	83.05	83.34	83.05	83.18	170826.0
2018-06-08	ABB-DELISTED	Stock	23.07	23.17	22.99	23.13	1986432.0
2018-06-08	ABBNY-DELISTED	Stock	23.07	23.17	22.99	23.13	2039752.0
2018-06-08	ABBV	Stock	99.28	100.5	99.0	100.43	4012900.0
2018-06-08	ABC-DELISTED	Stock	86.6	87.089	85.13	86.085	1048893.0
2018-06-08	ABCB	Stock	57.45	57.6	57.25	57.5	329500.0
2018-06-08	ABCD-DELISTED	Stock	10.17	10.71	10.1136	10.61	141540.0
2018-06-08	ABDC-DELISTED	Stock	6.66	6.75	6.66	6.74	13200.0
2018-06-08	ABEO	Stock	408.75	425.0	403.25	406.25	29832.0
2018-06-08	ABEOW-DELISTED	Stock	11.75	11.7501	11.7	11.7	1100.0
2018-06-08	ABEV	Stock	5.0	5.12	4.95	5.09	33903000.0
2018-06-08	ABG	Stock	73.3	74.3	72.75	74.2	82200.0
2018-06-08	ABIL-DELISTED	Stock	2.49	2.51	2.4	2.4337	4062.0
2018-06-08	ABM	Stock	32.08	32.37	30.07	30.3	1516100.0
2018-06-08	ABMD-DELISTED	Stock	405.29	414.94	405.2	409.77	383800.0
2018-06-08	ABR	Stock	9.52	9.59	9.51	9.54	634200.0

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

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