PREVIEW / stock_daily / 2019-08-15

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-15.parquet
  size:    221 KB
  rows:    6,616
  symbols: 2,525

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-08-15	AAPL	Stock	50.865	51.285	49.9175	50.435	108909600.0
2019-08-15	MSFT	Stock	134.39	134.58	132.25	133.68	28074400.0
2019-08-15	NVDA	Stock	3.7708	3.7908	3.6848	3.7193	477200000.0
2019-08-15	AMZN	Stock	89.0995	89.4	88.098	88.806	75182000.0
2019-08-15	GOOGL	Stock	58.4215	58.821	58.15	58.466	28614300.0
2019-08-15	META	Stock	180.95	183.2	180.03	182.59	12925900.0
2019-08-15	TSLA	Stock	14.724	14.7707	14.1033	14.376	122394000.0
2019-08-15	TLT	Stock	145.95	148.6	145.58	147.31	23732522.0
2019-08-15	ES	Stock	77.09	79.11	76.97	78.81	1595000.0
2019-08-15	CL	Stock	70.87	71.68	70.61	71.37	3698800.0
2019-08-15	A	Stock	71.94	72.65	69.42	69.59	6701000.0
2019-08-15	AA	Stock	17.6	17.74	16.681	16.92	3973300.0
2019-08-15	AABA-DELISTED	Stock	70.16	70.22	69.85	69.9	3469305.0
2019-08-15	AAC-DELISTED	Stock	0.6892	0.7	0.5	0.6	1429596.0
2019-08-15	AACG	Stock	2.25	2.26	2.06	2.14	52000.0
2019-08-15	AAIC-DELISTED	Stock	5.56	5.62	5.56	5.58	421682.0
2019-08-15	AAIC.C-DELISTED	Stock	22.63	22.63	22.5293	22.5293	900.0
2019-08-15	AAL	Stock	26.2	26.31	25.14	25.41	10057900.0
2019-08-15	AAM.A-DELISTED	Stock	26.415	26.6101	26.415	26.56	10957.0
2019-08-15	AAM.B-DELISTED	Stock	26.56	26.75	26.56	26.65	31629.0
2019-08-15	AAMC-DELISTED	Stock	2.6471	2.8956	2.5077	2.6765	17894.0
2019-08-15	AAME	Stock	2.39	2.41	2.39	2.41	400.0
2019-08-15	AAMI	Stock	8.55	8.59	8.4	8.43	301300.0
2019-08-15	AAOI	Stock	9.21	9.28	8.787	8.88	658300.0
2019-08-15	AAON	Stock	29.7667	30.4267	29.56	30.2467	120300.0
2019-08-15	AAP	Stock	137.21	138.27	135.46	137.5	1960500.0
2019-08-15	AAT	Stock	46.48	46.83	46.32	46.44	269200.0
2019-08-15	AAU-DELISTED	Stock	0.79	0.8099	0.77	0.8098	291329.0
2019-08-15	AAUAF-DELISTED	Stock	0.79	0.8099	0.77	0.8098	310029.0
2019-08-15	AAWW-DELISTED	Stock	26.35	26.64	26.12	26.38	298436.0
2019-08-15	AAXJ	Stock	63.49	63.65	63.15	63.4	1079282.0
2019-08-15	AAXN-DELISTED	Stock	57.85	58.76	56.95	57.4	604354.0
2019-08-15	AB	Stock	26.52	26.92	26.29	26.38	259400.0
2019-08-15	ABB-DELISTED	Stock	18.22	18.315	18.135	18.25	1731994.0
2019-08-15	ABBNY-DELISTED	Stock	18.22	18.315	18.135	18.25	2450262.0
2019-08-15	ABBV	Stock	64.12	64.24	62.66	62.98	9195700.0
2019-08-15	ABC-DELISTED	Stock	86.43	86.88	85.34	85.97	815174.0
2019-08-15	ABCB	Stock	35.55	35.73	35.02	35.25	358200.0
2019-08-15	ABDC-DELISTED	Stock	9.05	9.05	8.7	8.85	182392.0
2019-08-15	ABEO	Stock	57.25	58.0	54.0	54.25	17984.0
2019-08-15	ABEV	Stock	4.73	4.74	4.59	4.64	34098200.0
2019-08-15	ABG	Stock	89.84	89.84	87.46	88.76	142800.0
2019-08-15	ABIL-DELISTED	Stock	0.62	0.6617	0.54	0.5913	26055.0
2019-08-15	ABM	Stock	38.36	38.36	37.56	38.05	320500.0
2019-08-15	ABMD-DELISTED	Stock	190.92	193.145	190.27	191.99	243913.0
2019-08-15	ABR	Stock	12.03	12.15	12.01	12.06	604400.0
2019-08-15	ABR.A-DELISTED	Stock	25.84	25.92	25.83	25.92	500.0
2019-08-15	ABR.B-DELISTED	Stock	25.5684	25.5684	25.5684	25.5684	1189.0
2019-08-15	ABR.C-DELISTED	Stock	26.32	26.45	26.32	26.45	2403.0
2019-08-15	ABT	Stock	84.16	84.73	83.52	83.94	4952600.0

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

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