PREVIEW / stock_daily / 2018-09-05

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-05.parquet
  size:    218 KB
  rows:    6,490
  symbols: 2,737

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-09-05	AAPL	Stock	57.2475	57.4175	56.275	56.7175	133332000.0
2018-09-05	MSFT	Stock	111.01	111.42	108.1	108.49	32872400.0
2018-09-05	NVDA	Stock	7.0748	7.1105	6.8788	6.9605	393156000.0
2018-09-05	AMZN	Stock	101.9055	102.019	99.4945	99.741	164412000.0
2018-09-05	GOOGL	Stock	60.461	60.7435	58.767	59.955	53987880.0
2018-09-05	META	Stock	169.49	171.13	166.67	167.18	31226700.0
2018-09-05	TSLA	Stock	19.0033	19.1187	18.4787	18.716	115812000.0
2018-09-05	TLT	Stock	119.76	119.9	119.5464	119.71	9422630.0
2018-09-05	ES	Stock	62.47	63.45	62.44	63.38	953000.0
2018-09-05	CL	Stock	65.05	66.65	64.95	66.59	3977800.0
2018-09-05	A	Stock	67.28	67.4	66.76	66.96	1859600.0
2018-09-05	AA	Stock	43.17	43.226	41.63	42.87	3340700.0
2018-09-05	AABA-DELISTED	Stock	66.36	67.16	65.02	65.62	6234679.0
2018-09-05	AAC-DELISTED	Stock	8.5	8.5	7.7	8.04	296989.0
2018-09-05	AACG	Stock	2.29	2.29	2.02	2.06	276100.0
2018-09-05	AAIC-DELISTED	Stock	10.22	10.305	10.215	10.26	513266.0
2018-09-05	AAL	Stock	40.81	41.37	38.88	39.67	9738800.0
2018-09-05	AAM.A-DELISTED	Stock	25.6	25.669	25.45	25.45	27479.0
2018-09-05	AAM.B-DELISTED	Stock	25.16	25.17	25.0	25.08	64273.0
2018-09-05	AAMC-DELISTED	Stock	18.5441	18.6765	18.5294	18.5294	8017.0
2018-09-05	AAME	Stock	3.0	3.15	2.75	2.85	5400.0
2018-09-05	AAMI	Stock	12.68	12.77	12.6	12.73	218000.0
2018-09-05	AAOI	Stock	36.74	37.26	33.44	34.25	2443600.0
2018-09-05	AAON	Stock	26.4667	26.8333	26.4	26.6333	403200.0
2018-09-05	AAP	Stock	169.41	170.91	166.81	167.0	1018200.0
2018-09-05	AAT	Stock	38.66	39.25	38.47	39.07	129900.0
2018-09-05	AAU-DELISTED	Stock	0.621	0.66	0.621	0.6405	275542.0
2018-09-05	AAUAF-DELISTED	Stock	0.621	0.66	0.621	0.64	283941.0
2018-09-05	AAV-DELISTED	Stock	2.65	2.7	2.6	2.6	215444.0
2018-09-05	AAWW-DELISTED	Stock	61.3	62.05	60.95	61.9	128647.0
2018-09-05	AAXJ	Stock	69.67	69.75	69.21	69.38	1046820.0
2018-09-05	AAXN-DELISTED	Stock	69.7	69.88	66.84	68.75	488196.0
2018-09-05	AB	Stock	29.8	30.5	29.8	30.35	262300.0
2018-09-05	ABAC-DELISTED	Stock	1.68	1.68	1.5	1.61	29595.0
2018-09-05	ABB-DELISTED	Stock	23.42	23.49	23.275	23.3	1521114.0
2018-09-05	ABBNY-DELISTED	Stock	23.42	23.49	23.275	23.31	2587954.0
2018-09-05	ABBV	Stock	94.34	95.25	94.09	95.19	5188800.0
2018-09-05	ABC-DELISTED	Stock	88.64	89.539	88.3	89.44	896075.0
2018-09-05	ABCB	Stock	49.6	50.5	49.5	49.9	194900.0
2018-09-05	ABCD-DELISTED	Stock	13.14	13.14	12.6319	12.88	108466.0
2018-09-05	ABDC-DELISTED	Stock	6.16	6.2	6.11	6.12	22120.0
2018-09-05	ABEO	Stock	377.5	383.25	355.0	372.5	20560.0
2018-09-05	ABEV	Stock	4.34	4.44	4.32	4.4	31727500.0
2018-09-05	ABG	Stock	74.35	74.5	73.2	73.3	75200.0
2018-09-05	ABIL-DELISTED	Stock	3.67	3.67	3.5001	3.54	91261.0
2018-09-05	ABM	Stock	31.34	32.06	31.25	31.92	480900.0
2018-09-05	ABMD-DELISTED	Stock	410.7	410.99	383.12	383.7364	478706.0
2018-09-05	ABR	Stock	11.94	12.11	11.94	12.09	1483000.0
2018-09-05	ABR.A-DELISTED	Stock	25.9316	25.9316	25.9268	25.9268	421.0
2018-09-05	ABR.B-DELISTED	Stock	25.32	25.37	25.32	25.33	8070.0

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

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