PREVIEW / stock_daily / 2018-01-02

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-02.parquet
  size:    218 KB
  rows:    6,532
  symbols: 2,900

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-01-02	AAPL	Stock	42.54	43.075	42.315	43.065	102223600.0
2018-01-02	MSFT	Stock	86.13	86.31	85.5	85.95	22483800.0
2018-01-02	NVDA	Stock	4.8945	4.9875	4.8625	4.9838	355616000.0
2018-01-02	AMZN	Stock	58.6	59.5	58.5255	59.4505	53890000.0
2018-01-02	GOOGL	Stock	52.651	53.799	52.651	53.6605	31765360.0
2018-01-02	META	Stock	177.68	181.58	177.55	181.42	18151900.0
2018-01-02	TSLA	Stock	20.8	21.474	20.7333	21.3687	65283000.0
2018-01-02	TLT	Stock	126.49	126.51	125.07	125.49	16238206.0
2018-01-02	ES	Stock	63.18	63.44	62.53	63.15	4243900.0
2018-01-02	CL	Stock	75.43	76.0	74.84	75.14	4352500.0
2018-01-02	A	Stock	67.42	67.89	67.34	67.6	1047800.0
2018-01-02	AA	Stock	54.06	55.22	53.91	55.17	2928900.0
2018-01-02	AAAP-DELISTED	Stock	81.61	81.84	81.61	81.77	571758.0
2018-01-02	AABA-DELISTED	Stock	70.77	73.35	70.55	73.14	10330452.0
2018-01-02	AAC-DELISTED	Stock	9.02	9.36	9.0	9.24	95875.0
2018-01-02	AACG	Stock	4.65	5.5	4.65	5.43	44800.0
2018-01-02	AAIC-DELISTED	Stock	11.8	11.83	11.65	11.78	484989.0
2018-01-02	AAL	Stock	52.33	53.1	51.9	52.99	4084700.0
2018-01-02	AAM.A-DELISTED	Stock	26.34	26.34	25.76	26.03	39331.0
2018-01-02	AAME	Stock	3.46	3.46	3.25	3.25	2300.0
2018-01-02	AAMI	Stock	16.84	16.84	16.51	16.67	509100.0
2018-01-02	AAOI	Stock	37.8	38.77	37.62	37.91	964200.0
2018-01-02	AAON	Stock	24.6333	24.7	24.4333	24.6333	227700.0
2018-01-02	AAP	Stock	100.9	107.93	99.71	106.09	2624500.0
2018-01-02	AAT	Stock	38.3	38.38	38.06	38.16	200600.0
2018-01-02	AAU-DELISTED	Stock	1.03	1.05	1.03	1.03	155605.0
2018-01-02	AAUAF-DELISTED	Stock	1.03	1.05	1.03	1.03	159644.0
2018-01-02	AAV-DELISTED	Stock	4.35	4.55	4.35	4.55	595524.0
2018-01-02	AAWW-DELISTED	Stock	58.6	59.675	57.45	58.0	299211.0
2018-01-02	AAXJ	Stock	77.39	77.88	77.36	77.88	1128518.0
2018-01-02	AAXN-DELISTED	Stock	26.52	26.58	26.22	26.55	398021.0
2018-01-02	AB	Stock	25.05	25.25	24.96	25.2	271700.0
2018-01-02	ABAC-DELISTED	Stock	3.01	3.03	2.74	2.85	12665.0
2018-01-02	ABAX-DELISTED	Stock	49.57	50.83	48.58	50.0	175137.0
2018-01-02	ABB-DELISTED	Stock	26.95	27.04	26.85	27.0	1741769.0
2018-01-02	ABBNY-DELISTED	Stock	26.95	27.04	26.85	27.02	2125832.0
2018-01-02	ABBV	Stock	97.14	98.9	96.75	98.41	4561300.0
2018-01-02	ABC-DELISTED	Stock	92.15	94.07	92.12	94.04	968682.0
2018-01-02	ABCB	Stock	48.5	48.85	47.9	48.55	344300.0
2018-01-02	ABCD-DELISTED	Stock	5.6	5.73	5.57	5.61	105867.0
2018-01-02	ABDC-DELISTED	Stock	8.36	8.58	8.33	8.55	96427.0
2018-01-02	ABE-DELISTED	Stock	14.62	14.84	14.62	14.75	9125.0
2018-01-02	ABEO	Stock	397.5	430.0	389.75	430.0	25644.0
2018-01-02	ABEOW-DELISTED	Stock	11.88	11.88	11.88	11.88	200.0
2018-01-02	ABEV	Stock	6.54	6.63	6.53	6.61	16191800.0
2018-01-02	ABG	Stock	64.3	64.5	62.8	63.25	243800.0
2018-01-02	ABIL-DELISTED	Stock	0.4521	0.4856	0.4401	0.466	70860.0
2018-01-02	ABLX-DELISTED	Stock	24.44	24.7	24.32	24.5	78102.0
2018-01-02	ABM	Stock	37.86	38.19	37.41	37.75	653200.0
2018-01-02	ABMD-DELISTED	Stock	188.13	193.355	188.05	192.43	176602.0

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

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