PREVIEW / stock_daily / 2018-05-04

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-04.parquet
  size:    217 KB
  rows:    6,477
  symbols: 2,814

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-04	AAPL	Stock	44.5625	46.0625	44.5425	45.9575	224805200.0
2018-05-04	MSFT	Stock	93.32	95.37	92.92	95.16	22531300.0
2018-05-04	NVDA	Stock	5.7958	5.9798	5.7782	5.9765	400660000.0
2018-05-04	AMZN	Stock	78.1225	79.245	78.1095	79.0475	68872000.0
2018-05-04	GOOGL	Stock	50.9805	52.594	50.9025	52.55	36892000.0
2018-05-04	META	Stock	173.08	176.98	173.06	176.61	17677800.0
2018-05-04	TSLA	Stock	18.8667	19.7907	18.6347	19.606	128541000.0
2018-05-04	TLT	Stock	119.23	119.23	118.49	118.99	4283487.0
2018-05-04	ES	Stock	59.09	59.25	58.67	59.04	1828000.0
2018-05-04	CL	Stock	63.41	64.02	63.33	63.71	3904400.0
2018-05-04	A	Stock	66.03	67.25	65.54	67.0	1330800.0
2018-05-04	AA	Stock	53.04	54.46	52.65	54.39	2598700.0
2018-05-04	AABA-DELISTED	Stock	70.02	73.08	69.58	72.74	7448914.0
2018-05-04	AAC-DELISTED	Stock	11.65	11.65	11.05	11.52	161320.0
2018-05-04	AACG	Stock	5.18	5.18	5.17	5.17	400.0
2018-05-04	AAIC-DELISTED	Stock	11.07	11.31	11.07	11.27	895551.0
2018-05-04	AAL	Stock	41.75	43.45	41.75	42.86	5540900.0
2018-05-04	AAM.A-DELISTED	Stock	24.27	24.45	24.27	24.38	59143.0
2018-05-04	AAM.B-DELISTED	Stock	24.24	24.38	24.24	24.35	27131.0
2018-05-04	AAMC-DELISTED	Stock	17.9412	19.9265	17.6471	19.8235	4607.0
2018-05-04	AAMI	Stock	15.02	15.46	14.86	15.38	641800.0
2018-05-04	AAOI	Stock	31.86	32.54	31.3	31.84	857500.0
2018-05-04	AAON	Stock	20.7333	20.78	19.3667	19.7667	718200.0
2018-05-04	AAP	Stock	115.0	117.73	113.84	116.67	860800.0
2018-05-04	AAT	Stock	33.85	34.27	33.77	34.16	369200.0
2018-05-04	AAU-DELISTED	Stock	0.8021	0.806	0.79	0.8028	138334.0
2018-05-04	AAUAF-DELISTED	Stock	0.8021	0.806	0.79	0.8028	139996.0
2018-05-04	AAV-DELISTED	Stock	3.0	3.1	3.0	3.025	207234.0
2018-05-04	AAWW-DELISTED	Stock	67.5	67.7	65.0	67.2	245760.0
2018-05-04	AAXJ	Stock	74.83	76.04	74.63	75.89	1224889.0
2018-05-04	AAXN-DELISTED	Stock	42.24	45.5	42.24	44.54	2467989.0
2018-05-04	AB	Stock	26.5	26.7	26.2	26.65	308300.0
2018-05-04	ABAC-DELISTED	Stock	2.458	2.5082	2.3	2.33	28165.0
2018-05-04	ABAX-DELISTED	Stock	66.78	69.91	66.78	69.0	92968.0
2018-05-04	ABB-DELISTED	Stock	23.19	23.5	23.16	23.445	1135855.0
2018-05-04	ABBNY-DELISTED	Stock	23.19	23.5	23.16	23.44	1303672.0
2018-05-04	ABBV	Stock	99.9	100.93	99.12	100.17	5224400.0
2018-05-04	ABC-DELISTED	Stock	84.51	87.3	83.49	86.38	1717244.0
2018-05-04	ABCB	Stock	51.9	53.6	51.6	53.2	194400.0
2018-05-04	ABCD-DELISTED	Stock	10.03	10.54	10.0	10.41	177867.0
2018-05-04	ABDC-DELISTED	Stock	6.25	6.34	6.25	6.29	76238.0
2018-05-04	ABEO	Stock	450.0	465.0	450.0	460.0	17832.0
2018-05-04	ABEOW-DELISTED	Stock	13.1	13.3	12.95	13.3	7000.0
2018-05-04	ABEV	Stock	6.31	6.42	6.29	6.33	21894300.0
2018-05-04	ABG	Stock	69.25	71.33	69.25	70.55	274800.0
2018-05-04	ABIL-DELISTED	Stock	2.93	2.93	2.77	2.82	21432.0
2018-05-04	ABLX-DELISTED	Stock	53.77	53.87	53.37	53.735	15533.0
2018-05-04	ABM	Stock	30.16	30.44	29.87	30.32	760800.0
2018-05-04	ABMD-DELISTED	Stock	335.52	352.145	328.0	349.32	569300.0
2018-05-04	ABR	Stock	8.8	9.18	8.75	9.16	1997400.0

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

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