PREVIEW / stock_daily / 2019-11-14

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-14.parquet
  size:    220 KB
  rows:    6,579
  symbols: 2,460

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-11-14	AAPL	Stock	65.9375	66.22	65.525	65.66	89182800.0
2019-11-14	MSFT	Stock	147.02	148.41	147.0	148.06	19729800.0
2019-11-14	NVDA	Stock	5.2232	5.247	5.163	5.2448	518080000.0
2019-11-14	AMZN	Stock	87.5715	88.3295	87.478	87.73	45296000.0
2019-11-14	GOOGL	Stock	64.75	65.786	64.697	65.4575	29000780.0
2019-11-14	META	Stock	192.93	194.03	191.45	193.15	9040500.0
2019-11-14	TSLA	Stock	23.074	23.5893	22.8607	23.29	96973500.0
2019-11-14	TLT	Stock	137.8	138.44	137.67	137.91	10272804.0
2019-11-14	ES	Stock	81.16	81.18	80.63	80.8	2512000.0
2019-11-14	CL	Stock	66.63	67.01	66.54	66.64	2956200.0
2019-11-14	A	Stock	77.21	77.45	76.48	76.76	1113500.0
2019-11-14	AA	Stock	21.05	21.4	20.71	20.99	2919400.0
2019-11-14	AACG	Stock	1.71	1.74	1.71	1.73	9400.0
2019-11-14	AAIC-DELISTED	Stock	5.77	5.83	5.69	5.7	202012.0
2019-11-14	AAIC.C-DELISTED	Stock	21.9	21.95	21.81	21.81	10508.0
2019-11-14	AAL	Stock	28.75	28.9	28.46	28.77	4393200.0
2019-11-14	AAM.A-DELISTED	Stock	26.58	26.58	26.4827	26.51	12868.0
2019-11-14	AAM.B-DELISTED	Stock	26.99	26.99	26.8	26.8336	22096.0
2019-11-14	AAMC-DELISTED	Stock	3.3971	3.5588	3.3971	3.5588	2292.0
2019-11-14	AAME	Stock	1.71	1.71	1.6	1.6	1800.0
2019-11-14	AAMI	Stock	9.37	9.55	9.363	9.47	536900.0
2019-11-14	AAOI	Stock	11.27	11.4	10.85	10.9	939400.0
2019-11-14	AAON	Stock	33.68	33.9467	33.5067	33.64	133650.0
2019-11-14	AAP	Stock	157.95	157.97	155.02	156.83	882000.0
2019-11-14	AAT	Stock	46.88	46.99	46.56	46.88	164900.0
2019-11-14	AAU-DELISTED	Stock	0.54	0.54	0.5	0.523	316002.0
2019-11-14	AAUAF-DELISTED	Stock	0.54	0.54	0.5	0.523	328810.0
2019-11-14	AAWW-DELISTED	Stock	25.29	25.56	24.95	25.11	202601.0
2019-11-14	AAXJ	Stock	69.71	69.82	69.41	69.67	2082239.0
2019-11-14	AAXN-DELISTED	Stock	64.65	67.05	64.44	66.69	489357.0
2019-11-14	AB	Stock	29.9	29.91	29.58	29.85	142400.0
2019-11-14	ABB-DELISTED	Stock	21.87	21.93	21.83	21.89	1093353.0
2019-11-14	ABBNY-DELISTED	Stock	21.87	21.93	21.83	21.89	1151295.0
2019-11-14	ABBV	Stock	86.48	87.75	85.93	87.63	5425600.0
2019-11-14	ABC-DELISTED	Stock	86.84	87.12	85.79	86.13	778939.0
2019-11-14	ABCB	Stock	43.64	43.84	43.32	43.54	260500.0
2019-11-14	ABDC-DELISTED	Stock	8.97	9.04	8.97	9.04	12008.0
2019-11-14	ABEO	Stock	60.75	62.5	56.25	56.75	8032.0
2019-11-14	ABEV	Stock	4.14	4.2	4.13	4.15	22570100.0
2019-11-14	ABG	Stock	109.21	111.36	108.46	109.42	134100.0
2019-11-14	ABIL-DELISTED	Stock	0.386	0.4099	0.3	0.318	188366.0
2019-11-14	ABM	Stock	37.94	38.43	37.69	38.31	138900.0
2019-11-14	ABMD-DELISTED	Stock	219.77	222.79	217.75	220.96	179339.0
2019-11-14	ABR	Stock	14.85	15.08	14.82	15.07	1211400.0
2019-11-14	ABR.A-DELISTED	Stock	25.75	25.8752	25.75	25.8	2700.0
2019-11-14	ABR.B-DELISTED	Stock	25.44	25.52	25.44	25.48	7800.0
2019-11-14	ABR.C-DELISTED	Stock	26.35	26.3891	26.07	26.27	6600.0
2019-11-14	ABT	Stock	84.09	84.39	83.68	84.12	4474200.0
2019-11-14	ABTC	Stock	111300.0	116400.0	94800.0	114000.0	3.293333333333333
2019-11-14	ABTS	Stock	36.0	36.15	35.25	36.0	600.0

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

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