PREVIEW / stock_daily / 2019-03-18

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-18.parquet
  size:    221 KB
  rows:    6,554
  symbols: 2,620

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
2019-03-18	AAPL	Stock	46.45	47.0975	46.4475	47.005	104879200.0
2019-03-18	MSFT	Stock	116.17	117.61	116.05	117.57	31207600.0
2019-03-18	NVDA	Stock	4.277	4.3312	4.1965	4.2238	486992000.0
2019-03-18	AMZN	Stock	85.635	87.5	85.6315	87.1075	108582000.0
2019-03-18	GOOGL	Stock	59.4845	59.7475	59.0738	59.4275	24444060.0
2019-03-18	META	Stock	163.57	163.9	159.28	160.47	37524200.0
2019-03-18	TSLA	Stock	18.4	18.5367	17.82	17.966	154215000.0
2019-03-18	TLT	Stock	121.57	121.87	121.5169	121.68	3893364.0
2019-03-18	ES	Stock	71.6	71.76	70.94	71.26	2108000.0
2019-03-18	CL	Stock	67.25	67.35	66.1	66.29	2939900.0
2019-03-18	A	Stock	81.1	81.29	80.49	80.97	1617700.0
2019-03-18	AA	Stock	28.0	28.86	27.927	28.64	3522200.0
2019-03-18	AABA-DELISTED	Stock	74.03	74.3769	73.52	73.8	3341251.0
2019-03-18	AAC-DELISTED	Stock	2.48	2.55	2.39	2.46	136592.0
2019-03-18	AACG	Stock	1.07	1.07	1.03	1.07	48800.0
2019-03-18	AAIC-DELISTED	Stock	8.19	8.38	8.19	8.38	488009.0
2019-03-18	AAIC.C-DELISTED	Stock	23.4	23.5	23.335	23.4	42643.0
2019-03-18	AAL	Stock	31.5	31.58	31.03	31.38	6832700.0
2019-03-18	AAM.A-DELISTED	Stock	25.03	25.1493	25.03	25.1	20973.0
2019-03-18	AAM.B-DELISTED	Stock	25.04	25.04	24.93	25.0	57177.0
2019-03-18	AAMC-DELISTED	Stock	10.3489	10.7982	10.3376	10.6529	12594.0
2019-03-18	AAME	Stock	2.92	2.92	2.92	2.92	100.0
2019-03-18	AAMI	Stock	13.43	13.84	13.43	13.83	764000.0
2019-03-18	AAOI	Stock	13.99	14.25	13.92	14.07	573400.0
2019-03-18	AAON	Stock	28.0467	28.6067	28.0333	28.5333	177900.0
2019-03-18	AAP	Stock	155.22	162.95	155.08	161.57	2116100.0
2019-03-18	AAT	Stock	45.77	46.03	45.38	45.67	167500.0
2019-03-18	AAU-DELISTED	Stock	0.57	0.5854	0.57	0.5753	211247.0
2019-03-18	AAUAF-DELISTED	Stock	0.57	0.5854	0.57	0.57	249177.0
2019-03-18	AAWW-DELISTED	Stock	50.03	50.2	49.295	49.89	135870.0
2019-03-18	AAXJ	Stock	70.77	70.98	70.64	70.96	1053168.0
2019-03-18	AAXN-DELISTED	Stock	48.12	50.06	48.09	50.02	728404.0
2019-03-18	AB	Stock	29.27	29.47	29.22	29.39	181500.0
2019-03-18	ABB-DELISTED	Stock	19.44	19.64	19.42	19.61	1608377.0
2019-03-18	ABBNY-DELISTED	Stock	19.44	19.64	19.42	19.61	1700844.0
2019-03-18	ABBV	Stock	81.34	81.75	80.28	80.65	5550100.0
2019-03-18	ABC-DELISTED	Stock	80.49	81.3	80.2	80.4	668225.0
2019-03-18	ABCB	Stock	37.96	38.64	37.96	38.33	241900.0
2019-03-18	ABDC-DELISTED	Stock	7.55	7.65	7.51	7.58	18230.0
2019-03-18	ABEO	Stock	205.0	206.25	194.75	202.25	16180.0
2019-03-18	ABEOW-DELISTED	Stock	3.75	3.75	3.75	3.75	200.0
2019-03-18	ABEV	Stock	4.39	4.56	4.38	4.53	33538900.0
2019-03-18	ABG	Stock	68.2	69.26	67.64	68.94	120300.0
2019-03-18	ABIL-DELISTED	Stock	2.12	2.15	1.95	1.99	389505.0
2019-03-18	ABM	Stock	34.48	34.81	34.18	34.66	455500.0
2019-03-18	ABMD-DELISTED	Stock	334.68	336.0	328.67	333.25	340533.0
2019-03-18	ABR	Stock	12.86	12.96	12.86	12.94	838100.0
2019-03-18	ABR.A-DELISTED	Stock	25.7	25.8279	25.6201	25.7595	1910.0
2019-03-18	ABR.B-DELISTED	Stock	25.39	25.39	25.39	25.39	200.0
2019-03-18	ABR.C-DELISTED	Stock	25.62	25.7647	25.58	25.68	2087.0

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

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