PREVIEW / stock_daily / 2018-11-20

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-20.parquet
  size:    221 KB
  rows:    6,586
  symbols: 2,725

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-11-20	AAPL	Stock	44.5925	45.3675	43.8775	44.245	271300800.0
2018-11-20	MSFT	Stock	101.8	102.97	99.35	101.71	64052500.0
2018-11-20	NVDA	Stock	3.3515	3.8565	3.3328	3.727	1692032000.0
2018-11-20	AMZN	Stock	71.875	76.7375	71.0	74.773	217576000.0
2018-11-20	GOOGL	Stock	50.3645	51.8675	50.1105	51.5225	54458680.0
2018-11-20	META	Stock	127.03	134.16	126.85	132.43	41939500.0
2018-11-20	TSLA	Stock	22.7833	23.32	22.2367	23.166	120070500.0
2018-11-20	TLT	Stock	115.24	115.46	114.93	115.06	6332804.0
2018-11-20	ES	Stock	67.77	68.31	66.98	67.64	2193300.0
2018-11-20	CL	Stock	62.94	63.59	62.28	62.31	3866400.0
2018-11-20	A	Stock	66.25	68.43	64.93	67.52	8187200.0
2018-11-20	AA	Stock	32.42	33.2	31.98	32.68	2938300.0
2018-11-20	AABA-DELISTED	Stock	59.25	61.65	59.25	60.9	6415635.0
2018-11-20	AAC-DELISTED	Stock	1.97	1.99	1.7	1.935	567373.0
2018-11-20	AACG	Stock	1.08	1.08	0.94	0.99	104000.0
2018-11-20	AAIC-DELISTED	Stock	8.41	8.5	8.23	8.32	520549.0
2018-11-20	AAL	Stock	35.05	36.39	34.86	35.59	7059600.0
2018-11-20	AAM.A-DELISTED	Stock	23.97	23.97	23.76	23.8765	31896.0
2018-11-20	AAM.B-DELISTED	Stock	23.95	23.9699	23.72	23.91	65529.0
2018-11-20	AAMC-DELISTED	Stock	13.6765	14.164	12.3941	13.2412	15314.0
2018-11-20	AAME	Stock	3.07	3.13	3.02	3.1	9300.0
2018-11-20	AAMI	Stock	12.69	12.82	12.45	12.55	703300.0
2018-11-20	AAOI	Stock	19.18	20.13	19.02	19.65	507600.0
2018-11-20	AAON	Stock	25.58	25.62	24.2533	24.4	408900.0
2018-11-20	AAP	Stock	174.05	177.67	171.12	171.53	891900.0
2018-11-20	AAT	Stock	39.74	40.47	39.49	39.55	284300.0
2018-11-20	AAU-DELISTED	Stock	0.52	0.5229	0.4839	0.494	179230.0
2018-11-20	AAUAF-DELISTED	Stock	0.52	0.5229	0.4839	0.494	219479.0
2018-11-20	AAWW-DELISTED	Stock	51.86	52.395	50.35	50.37	284057.0
2018-11-20	AAXJ	Stock	64.16	64.5	63.7	63.91	1362250.0
2018-11-20	AAXN-DELISTED	Stock	45.16	46.28	43.7	45.19	1236719.0
2018-11-20	AB	Stock	29.32	29.71	28.78	29.35	329200.0
2018-11-20	ABAC-DELISTED	Stock	1.55	1.59	1.5102	1.527	3041.0
2018-11-20	ABB-DELISTED	Stock	19.57	19.78	19.495	19.69	2465863.0
2018-11-20	ABBNY-DELISTED	Stock	19.57	19.78	19.495	19.69	2642692.0
2018-11-20	ABBV	Stock	89.0	89.71	87.86	88.09	5372900.0
2018-11-20	ABC-DELISTED	Stock	90.05	91.53	87.96	88.87	1776933.0
2018-11-20	ABCB	Stock	43.55	43.6	42.26	42.46	229700.0
2018-11-20	ABCD-DELISTED	Stock	14.42	14.47	14.42	14.425	355044.0
2018-11-20	ABDC-DELISTED	Stock	6.47	6.47	6.27	6.355	50053.0
2018-11-20	ABEO	Stock	182.75	195.0	181.25	191.5	21072.0
2018-11-20	ABEOW-DELISTED	Stock	3.58	3.58	3.58	3.58	19900.0
2018-11-20	ABEV	Stock	4.24	4.28	4.16	4.18	19297300.0
2018-11-20	ABG	Stock	68.02	69.83	66.89	67.21	284100.0
2018-11-20	ABIL-DELISTED	Stock	2.92	2.92	2.75	2.82	30065.0
2018-11-20	ABM	Stock	31.02	31.08	29.9	30.0	325700.0
2018-11-20	ABMD-DELISTED	Stock	288.92	307.92	280.83	302.29	696597.0
2018-11-20	ABR	Stock	11.92	11.99	11.62	11.82	1795500.0
2018-11-20	ABR.A-DELISTED	Stock	25.26	25.26	25.09	25.1725	2514.0
2018-11-20	ABR.B-DELISTED	Stock	25.06	25.2376	25.06	25.2376	300.0

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

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