PREVIEW / stock_daily / 2019-10-22

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-22.parquet
  size:    220 KB
  rows:    6,566
  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-10-22	AAPL	Stock	60.29	60.55	59.905	59.99	82293600.0
2019-10-22	MSFT	Stock	138.97	140.01	136.26	136.37	27431000.0
2019-10-22	NVDA	Stock	4.9575	5.0632	4.8825	4.8903	328720000.0
2019-10-22	AMZN	Stock	89.4075	89.489	88.1	88.2865	42234000.0
2019-10-22	GOOGL	Stock	62.224	62.4365	61.9925	62.06	25636420.0
2019-10-22	META	Stock	190.0	190.65	181.5	182.34	19537600.0
2019-10-22	TSLA	Stock	16.9547	17.222	16.7233	17.0387	69012000.0
2019-10-22	TLT	Stock	139.38	139.529	138.635	139.34	6690041.0
2019-10-22	ES	Stock	86.36	86.54	85.67	85.86	946500.0
2019-10-22	CL	Stock	68.55	68.6	66.97	67.06	3864500.0
2019-10-22	A	Stock	75.68	76.33	74.64	74.69	1271800.0
2019-10-22	AA	Stock	20.45	21.03	19.92	20.73	4071100.0
2019-10-22	AAC-DELISTED	Stock	0.39	0.44	0.39	0.43	311374.0
2019-10-22	AACG	Stock	1.8	1.82	1.78	1.78	24800.0
2019-10-22	AAIC-DELISTED	Stock	5.69	5.87	5.64	5.87	392694.0
2019-10-22	AAIC.C-DELISTED	Stock	21.2	21.26	21.2	21.26	13394.0
2019-10-22	AAL	Stock	28.5	28.69	27.82	28.26	8022000.0
2019-10-22	AAM.A-DELISTED	Stock	26.6804	26.6804	26.57	26.68	6637.0
2019-10-22	AAM.B-DELISTED	Stock	27.04	27.12	27.0	27.12	13098.0
2019-10-22	AAMC-DELISTED	Stock	4.5441	4.6765	4.1176	4.3235	35788.0
2019-10-22	AAME	Stock	2.31	2.46	2.25	2.25	10600.0
2019-10-22	AAMI	Stock	9.69	9.72	9.47	9.49	257800.0
2019-10-22	AAOI	Stock	10.1	10.49	9.65	10.3	960700.0
2019-10-22	AAON	Stock	31.9733	31.9933	31.42	31.7267	134250.0
2019-10-22	AAP	Stock	166.4	167.25	164.13	165.98	575300.0
2019-10-22	AAT	Stock	47.82	47.82	47.35	47.5	246800.0
2019-10-22	AAU-DELISTED	Stock	0.652	0.6611	0.65	0.6518	158890.0
2019-10-22	AAUAF-DELISTED	Stock	0.652	0.6611	0.65	0.6506	166543.0
2019-10-22	AAWW-DELISTED	Stock	22.49	23.9238	22.35	23.81	354321.0
2019-10-22	AAXJ	Stock	68.78	68.9	68.59	68.68	838750.0
2019-10-22	AAXN-DELISTED	Stock	52.3	53.42	51.7786	53.23	681830.0
2019-10-22	AB	Stock	28.32	28.51	27.83	27.84	354300.0
2019-10-22	ABB-DELISTED	Stock	19.48	19.62	19.44	19.49	1813696.0
2019-10-22	ABBNY-DELISTED	Stock	19.48	19.62	19.44	19.48	1890065.0
2019-10-22	ABBV	Stock	78.05	78.66	77.75	77.87	6062000.0
2019-10-22	ABC-DELISTED	Stock	86.81	87.11	85.59	86.06	675749.0
2019-10-22	ABCB	Stock	41.72	43.31	41.46	42.68	938000.0
2019-10-22	ABDC-DELISTED	Stock	8.89	8.9089	8.87	8.9	8952.0
2019-10-22	ABEO	Stock	56.75	61.25	56.75	59.75	14924.0
2019-10-22	ABEOW-DELISTED	Stock	0.12	0.12	0.12	0.12	385.0
2019-10-22	ABEV	Stock	4.61	4.69	4.58	4.59	18203700.0
2019-10-22	ABG	Stock	99.15	99.51	90.28	96.64	763300.0
2019-10-22	ABIL-DELISTED	Stock	0.5	0.52	0.4883	0.52	16887.0
2019-10-22	ABM	Stock	37.61	38.14	37.5	37.94	277900.0
2019-10-22	ABMD-DELISTED	Stock	176.68	177.5305	170.58	170.84	310953.0
2019-10-22	ABR	Stock	13.65	13.65	13.47	13.47	1780500.0
2019-10-22	ABR.A-DELISTED	Stock	26.21	26.2699	26.21	26.2699	730.0
2019-10-22	ABR.B-DELISTED	Stock	26.17	26.18	26.04	26.0485	2296.0
2019-10-22	ABR.C-DELISTED	Stock	26.3	26.3	26.25	26.3	4250.0
2019-10-22	ABT	Stock	81.81	82.28	80.5	80.54	4764000.0

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

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