PREVIEW / stock_daily / 2019-08-06

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-06.parquet
  size:    221 KB
  rows:    6,603
  symbols: 2,526

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-06	AAPL	Stock	49.0775	49.5175	48.51	49.25	143299200.0
2019-08-06	MSFT	Stock	133.8	135.68	133.21	134.69	32696700.0
2019-08-06	NVDA	Stock	3.845	3.8908	3.7608	3.8088	361272000.0
2019-08-06	AMZN	Stock	89.6115	89.6885	87.67	89.3915	101406000.0
2019-08-06	GOOGL	Stock	58.276	59.07	58.0763	58.554	36014140.0
2019-08-06	META	Stock	183.69	185.79	183.09	184.51	18035700.0
2019-08-06	TSLA	Stock	15.4587	15.5	15.05	15.3833	83463000.0
2019-08-06	TLT	Stock	138.2	139.98	138.085	139.98	12747356.0
2019-08-06	ES	Stock	76.44	77.67	75.48	77.44	1639000.0
2019-08-06	CL	Stock	69.08	70.17	68.84	69.85	4868600.0
2019-08-06	A	Stock	66.41	67.68	66.04	67.66	2436200.0
2019-08-06	AA	Stock	20.22	20.35	19.35	19.89	3781100.0
2019-08-06	AABA-DELISTED	Stock	69.85	70.0	69.44	69.72	4157603.0
2019-08-06	AAC-DELISTED	Stock	0.7511	0.87	0.73	0.751	144657.0
2019-08-06	AACG	Stock	2.25	2.44	2.25	2.34	40400.0
2019-08-06	AAIC-DELISTED	Stock	6.21	6.25	6.16	6.2	311946.0
2019-08-06	AAIC.C-DELISTED	Stock	22.99	23.2915	22.99	23.05	9315.0
2019-08-06	AAL	Stock	28.85	29.06	28.02	28.36	6010100.0
2019-08-06	AAM.A-DELISTED	Stock	25.96	26.19	25.96	26.16	24126.0
2019-08-06	AAM.B-DELISTED	Stock	26.54	26.6	26.47	26.589	44977.0
2019-08-06	AAMC-DELISTED	Stock	3.1471	3.4412	3.1471	3.2647	21179.0
2019-08-06	AAME	Stock	2.32	2.39	2.12	2.23	8600.0
2019-08-06	AAMI	Stock	9.38	9.49	9.045	9.2	639000.0
2019-08-06	AAOI	Stock	9.83	10.14	9.59	10.12	723200.0
2019-08-06	AAON	Stock	30.98	30.98	29.84	29.96	261900.0
2019-08-06	AAP	Stock	143.09	146.11	141.63	145.64	1594000.0
2019-08-06	AAT	Stock	45.55	46.08	45.29	46.08	396100.0
2019-08-06	AAU-DELISTED	Stock	0.815	0.82	0.68	0.762	473199.0
2019-08-06	AAUAF-DELISTED	Stock	0.815	0.82	0.68	0.7621	486602.0
2019-08-06	AAWW-DELISTED	Stock	31.63	32.38	29.95	30.49	483054.0
2019-08-06	AAXJ	Stock	64.21	64.295	63.57	63.92	2452794.0
2019-08-06	AAXN-DELISTED	Stock	66.16	67.49	65.23	65.315	708291.0
2019-08-06	AB	Stock	27.15	28.27	27.15	28.15	195300.0
2019-08-06	ABB-DELISTED	Stock	17.98	18.03	17.83	17.935	2118465.0
2019-08-06	ABBNY-DELISTED	Stock	17.99	18.03	17.83	17.94	2227151.0
2019-08-06	ABBV	Stock	65.27	65.84	64.29	64.77	10248700.0
2019-08-06	ABC-DELISTED	Stock	89.3	90.99	82.65	84.11	3619296.0
2019-08-06	ABCB	Stock	37.0	37.1	36.14	36.94	292000.0
2019-08-06	ABDC-DELISTED	Stock	8.33	8.33	8.25	8.25	10358.0
2019-08-06	ABEO	Stock	62.0	63.75	58.5	60.5	14136.0
2019-08-06	ABEOW-DELISTED	Stock	0.15	0.15	0.15	0.15	100.0
2019-08-06	ABEV	Stock	5.12	5.17	5.03	5.15	24527800.0
2019-08-06	ABG	Stock	91.0	93.41	91.0	92.85	142300.0
2019-08-06	ABIL-DELISTED	Stock	0.75	0.75	0.654	0.7299	13400.0
2019-08-06	ABM	Stock	39.64	40.32	39.64	40.21	353500.0
2019-08-06	ABMD-DELISTED	Stock	205.8	209.25	197.05	200.36	546969.0
2019-08-06	ABR	Stock	12.3	12.42	12.19	12.39	1386000.0
2019-08-06	ABR.B-DELISTED	Stock	25.82	25.82	25.68	25.792	1153.0
2019-08-06	ABR.C-DELISTED	Stock	26.45	26.555	26.3015	26.555	523.0
2019-08-06	ABT	Stock	83.81	84.89	83.68	84.86	4422500.0

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

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