PREVIEW / stock_daily / 2018-09-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-26.parquet
  size:    220 KB
  rows:    6,538
  symbols: 2,753

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-26	AAPL	Stock	55.25	55.9375	54.94	55.105	95938800.0
2018-09-26	MSFT	Stock	114.47	115.06	113.74	113.98	19352000.0
2018-09-26	NVDA	Stock	6.7153	6.756	6.657	6.673	268548000.0
2018-09-26	AMZN	Stock	98.425	99.7625	98.076	98.7425	86270000.0
2018-09-26	GOOGL	Stock	59.6845	60.362	59.2698	59.703	37650480.0
2018-09-26	META	Stock	164.3	169.3	164.21	166.95	25252200.0
2018-09-26	TSLA	Stock	20.1273	20.926	20.074	20.6387	117648000.0
2018-09-26	TLT	Stock	116.93	117.58	116.66	117.5	9512864.0
2018-09-26	ES	Stock	60.91	61.1	60.15	60.2	1511500.0
2018-09-26	CL	Stock	67.25	67.8	67.01	67.1	2288700.0
2018-09-26	A	Stock	70.57	70.99	70.05	70.33	1830300.0
2018-09-26	AA	Stock	41.3	41.3	39.58	40.48	7849600.0
2018-09-26	AABA-DELISTED	Stock	68.17	68.97	67.945	68.14	3247095.0
2018-09-26	AAC-DELISTED	Stock	7.32	7.35	7.05	7.19	117685.0
2018-09-26	AACG	Stock	1.07	1.13	1.02	1.02	66900.0
2018-09-26	AAIC-DELISTED	Stock	10.08	10.12	10.01	10.05	583083.0
2018-09-26	AAL	Stock	40.84	41.48	40.78	41.04	4623700.0
2018-09-26	AAM.A-DELISTED	Stock	24.961	25.02	24.88	25.02	22877.0
2018-09-26	AAM.B-DELISTED	Stock	24.67	24.75	24.61	24.69	57807.0
2018-09-26	AAMC-DELISTED	Stock	17.3971	17.3971	16.5882	16.5882	1877.0
2018-09-26	AAME	Stock	2.42	2.6	2.3	2.6	3600.0
2018-09-26	AAMI	Stock	12.56	12.65	12.515	12.58	775300.0
2018-09-26	AAOI	Stock	33.38	33.66	31.26	31.34	1215000.0
2018-09-26	AAON	Stock	25.8333	25.9333	25.2	25.3	261900.0
2018-09-26	AAP	Stock	167.91	170.67	166.35	169.33	754200.0
2018-09-26	AAT	Stock	37.21	37.31	36.72	36.75	127300.0
2018-09-26	AAU-DELISTED	Stock	0.65	0.6507	0.6365	0.6466	58033.0
2018-09-26	AAUAF-DELISTED	Stock	0.65	0.6507	0.6365	0.6466	58867.0
2018-09-26	AAWW-DELISTED	Stock	62.55	64.35	62.35	63.45	179781.0
2018-09-26	AAXJ	Stock	70.77	71.44	70.63	70.74	2520642.0
2018-09-26	AAXN-DELISTED	Stock	67.15	67.7099	66.09	66.39	363801.0
2018-09-26	AB	Stock	30.55	30.7	30.45	30.5	126900.0
2018-09-26	ABAC-DELISTED	Stock	2.1	2.2	2.1	2.181	14325.0
2018-09-26	ABB-DELISTED	Stock	23.66	23.91	23.615	23.75	1551100.0
2018-09-26	ABBNY-DELISTED	Stock	23.66	23.91	23.615	23.75	1603830.0
2018-09-26	ABBV	Stock	94.29	95.11	93.85	94.18	4656200.0
2018-09-26	ABC-DELISTED	Stock	89.61	91.4822	89.61	90.32	1097282.0
2018-09-26	ABCB	Stock	47.15	47.2	46.1	46.2	296700.0
2018-09-26	ABCD-DELISTED	Stock	11.88	11.89	11.6	11.64	39380.0
2018-09-26	ABDC-DELISTED	Stock	6.28	6.28	6.13	6.16	68352.0
2018-09-26	ABEO	Stock	343.75	346.25	321.25	323.75	15692.0
2018-09-26	ABEV	Stock	4.57	4.71	4.54	4.64	23085000.0
2018-09-26	ABG	Stock	70.35	70.9	69.8	70.0	158900.0
2018-09-26	ABIL-DELISTED	Stock	3.72	3.7587	3.5212	3.6	40240.0
2018-09-26	ABM	Stock	33.56	33.69	32.72	32.72	489800.0
2018-09-26	ABMD-DELISTED	Stock	443.49	453.9999	438.52	444.98	655758.0
2018-09-26	ABR	Stock	11.46	11.47	11.23	11.23	1200400.0
2018-09-26	ABR.A-DELISTED	Stock	25.5	25.55	25.5	25.55	1201.0
2018-09-26	ABR.B-DELISTED	Stock	25.7	25.7	25.5727	25.5727	700.0
2018-09-26	ABR.C-DELISTED	Stock	26.14	26.14	26.01	26.0636	1800.0

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

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