PREVIEW / stock_daily / 2019-08-02

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-02.parquet
  size:    221 KB
  rows:    6,604
  symbols: 2,530

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-02	AAPL	Stock	51.3825	51.6075	50.4075	51.005	163448400.0
2019-08-02	MSFT	Stock	138.09	138.32	135.26	136.9	30791600.0
2019-08-02	NVDA	Stock	4.0298	4.0995	3.982	4.0298	428348000.0
2019-08-02	AMZN	Stock	92.2535	92.318	90.401	91.162	99124000.0
2019-08-02	GOOGL	Stock	60.15	60.475	59.5	59.816	34909000.0
2019-08-02	META	Stock	191.1	192.62	188.07	189.02	15297000.0
2019-08-02	TSLA	Stock	15.4233	15.7513	15.282	15.6227	92047500.0
2019-08-02	TLT	Stock	135.66	136.51	135.4	136.51	15143050.0
2019-08-02	ES	Stock	76.73	77.75	76.29	76.7	1866500.0
2019-08-02	CL	Stock	71.3	71.77	70.83	71.2	3813500.0
2019-08-02	A	Stock	69.12	69.13	67.56	68.08	2803500.0
2019-08-02	AA	Stock	21.15	21.325	20.31	20.71	3516600.0
2019-08-02	AABA-DELISTED	Stock	69.8	70.13	69.62	69.96	2886267.0
2019-08-02	AAC-DELISTED	Stock	0.8702	0.92	0.855	0.87	61071.0
2019-08-02	AACG	Stock	2.6	2.61	2.48	2.52	109300.0
2019-08-02	AAIC-DELISTED	Stock	6.39	6.42	6.305	6.36	283582.0
2019-08-02	AAIC.C-DELISTED	Stock	23.1487	23.3	23.1353	23.3	4569.0
2019-08-02	AAL	Stock	29.7	29.81	29.07	29.45	6475900.0
2019-08-02	AAM.A-DELISTED	Stock	26.2236	26.34	26.22	26.31	16197.0
2019-08-02	AAM.B-DELISTED	Stock	26.89	26.98	26.88	26.98	4292.0
2019-08-02	AAMC-DELISTED	Stock	2.5362	2.9676	2.2853	2.9676	33854.0
2019-08-02	AAME	Stock	2.35	2.35	2.35	2.35	800.0
2019-08-02	AAMI	Stock	9.81	9.92	9.51	9.74	591300.0
2019-08-02	AAOI	Stock	9.94	10.02	9.45	9.96	623800.0
2019-08-02	AAON	Stock	34.12	34.12	30.6333	31.0667	461850.0
2019-08-02	AAP	Stock	149.6	150.04	145.71	145.78	1212700.0
2019-08-02	AAT	Stock	46.62	46.88	46.24	46.83	332900.0
2019-08-02	AAU-DELISTED	Stock	0.76	0.76	0.69	0.695	191082.0
2019-08-02	AAUAF-DELISTED	Stock	0.76	0.76	0.69	0.705	194847.0
2019-08-02	AAWW-DELISTED	Stock	34.61	35.1324	32.13	32.74	796612.0
2019-08-02	AAXJ	Stock	66.06	66.23	65.55	65.65	1631667.0
2019-08-02	AAXN-DELISTED	Stock	68.09	69.24	67.5	69.07	448483.0
2019-08-02	AB	Stock	28.91	29.22	28.47	28.72	160000.0
2019-08-02	ABB-DELISTED	Stock	18.62	18.69	18.395	18.63	2757218.0
2019-08-02	ABBNY-DELISTED	Stock	18.62	18.69	18.395	18.63	2945204.0
2019-08-02	ABBV	Stock	65.5	65.79	65.03	65.35	9653900.0
2019-08-02	ABC-DELISTED	Stock	91.95	92.89	88.7	90.42	937550.0
2019-08-02	ABCB	Stock	38.46	38.55	37.53	38.17	267900.0
2019-08-02	ABDC-DELISTED	Stock	8.35	8.35	8.26	8.34	17261.0
2019-08-02	ABEO	Stock	63.0	65.0	60.5	60.5	19092.0
2019-08-02	ABEOW-DELISTED	Stock	0.27	0.27	0.27	0.27	100.0
2019-08-02	ABEV	Stock	5.28	5.31	5.21	5.24	19844600.0
2019-08-02	ABG	Stock	91.2	92.91	91.01	92.16	134200.0
2019-08-02	ABIL-DELISTED	Stock	0.7648	0.79	0.76	0.76	11981.0
2019-08-02	ABM	Stock	40.95	40.97	40.42	40.69	193900.0
2019-08-02	ABMD-DELISTED	Stock	197.97	204.82	197.01	200.6	878520.0
2019-08-02	ABR	Stock	12.42	12.84	12.4	12.78	2374300.0
2019-08-02	ABR.B-DELISTED	Stock	25.9	25.9	25.8834	25.8999	4651.0
2019-08-02	ABR.C-DELISTED	Stock	26.78	26.78	26.65	26.78	1948.0
2019-08-02	ABT	Stock	85.95	86.2	84.74	85.82	4756400.0

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

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