PREVIEW / stock_daily / 2019-07-08

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-08.parquet
  size:    221 KB
  rows:    6,588
  symbols: 2,553

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-07-08	AAPL	Stock	50.2025	50.35	49.6025	50.005	101354400.0
2019-07-08	MSFT	Stock	136.4	137.1	135.37	136.96	16779700.0
2019-07-08	NVDA	Stock	3.9458	3.9648	3.9	3.9303	329788000.0
2019-07-08	AMZN	Stock	96.706	97.8	96.4125	97.616	57668000.0
2019-07-08	GOOGL	Stock	56.2935	56.3605	55.588	55.8395	29887420.0
2019-07-08	META	Stock	195.19	196.68	193.64	195.76	9723900.0
2019-07-08	TSLA	Stock	15.416	15.4833	15.244	15.356	88207500.0
2019-07-08	TLT	Stock	133.05	133.22	132.61	132.61	6489997.0
2019-07-08	ES	Stock	77.08	77.44	76.64	77.04	1876400.0
2019-07-08	CL	Stock	73.13	73.55	73.0	73.38	2989300.0
2019-07-08	A	Stock	75.53	75.99	73.5	73.84	2217400.0
2019-07-08	AA	Stock	22.94	23.11	22.21	22.3	3451300.0
2019-07-08	AABA-DELISTED	Stock	69.66	69.66	69.21	69.27	2166523.0
2019-07-08	AAC-DELISTED	Stock	1.08	1.19	1.08	1.18	253397.0
2019-07-08	AACG	Stock	2.51	2.56	2.43	2.43	60100.0
2019-07-08	AAIC-DELISTED	Stock	6.4	6.455	6.26	6.33	713794.0
2019-07-08	AAIC.C-DELISTED	Stock	21.8198	22.0899	21.78	21.78	5932.0
2019-07-08	AAL	Stock	31.99	32.92	31.98	32.79	5328800.0
2019-07-08	AAM.A-DELISTED	Stock	25.9	25.9	25.73	25.76	5285.0
2019-07-08	AAM.B-DELISTED	Stock	26.0	26.0	25.88	25.97	14895.0
2019-07-08	AAMC-DELISTED	Stock	3.6765	4.0588	3.6765	4.0588	24912.0
2019-07-08	AAME	Stock	2.44	2.44	2.41	2.41	500.0
2019-07-08	AAMI	Stock	11.88	12.06	11.82	11.93	567800.0
2019-07-08	AAOI	Stock	9.72	9.78	9.39	9.59	368200.0
2019-07-08	AAON	Stock	32.9	33.66	32.84	33.32	118350.0
2019-07-08	AAP	Stock	160.6	163.23	158.11	158.19	1588100.0
2019-07-08	AAT	Stock	47.64	47.97	47.5	47.76	233700.0
2019-07-08	AAU-DELISTED	Stock	0.61	0.61	0.59	0.5999	167275.0
2019-07-08	AAUAF-DELISTED	Stock	0.61	0.61	0.59	0.5999	176584.0
2019-07-08	AAWW-DELISTED	Stock	42.17	42.3882	41.16	42.28	188692.0
2019-07-08	AAXJ	Stock	69.13	69.24	68.96	69.13	3111069.0
2019-07-08	AAXN-DELISTED	Stock	63.81	63.935	62.05	62.32	439817.0
2019-07-08	AB	Stock	30.06	30.45	29.89	30.21	147200.0
2019-07-08	ABB-DELISTED	Stock	19.11	19.26	19.0833	19.2	1920085.0
2019-07-08	ABBNY-DELISTED	Stock	19.11	19.26	19.0833	19.2	2130752.0
2019-07-08	ABBV	Stock	72.52	73.0	70.88	71.22	13487400.0
2019-07-08	ABC-DELISTED	Stock	87.62	88.06	86.54	87.83	779689.0
2019-07-08	ABCB	Stock	39.07	39.14	38.3	38.64	430000.0
2019-07-08	ABDC-DELISTED	Stock	8.39	8.3982	8.32	8.36	9834.0
2019-07-08	ABEO	Stock	113.75	114.5	108.0	110.0	24736.0
2019-07-08	ABEV	Stock	5.0	5.01	4.89	4.94	30062200.0
2019-07-08	ABG	Stock	83.6	83.79	82.44	82.97	110800.0
2019-07-08	ABIL-DELISTED	Stock	0.934	0.9521	0.9	0.9136	54210.0
2019-07-08	ABM	Stock	40.57	40.88	40.57	40.68	263300.0
2019-07-08	ABMD-DELISTED	Stock	261.03	262.42	254.83	257.7	233184.0
2019-07-08	ABR	Stock	12.35	12.45	12.35	12.4	1274400.0
2019-07-08	ABR.B-DELISTED	Stock	25.838	25.9	25.838	25.9	500.0
2019-07-08	ABR.C-DELISTED	Stock	26.0482	26.075	26.0482	26.075	600.0
2019-07-08	ABT	Stock	85.28	85.28	84.69	85.09	3591100.0
2019-07-08	ABTC	Stock	435000.0	472200.0	401130.0	453150.0	24.0

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

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