PREVIEW / stock_daily / 2020-08-17

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-17.parquet
  size:    224 KB
  rows:    6,786
  symbols: 2,403

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
2020-08-17	AAPL	Stock	116.0625	116.0875	113.9625	114.6075	119561600.0
2020-08-17	MSFT	Stock	209.6	211.19	208.92	210.28	20184800.0
2020-08-17	NVDA	Stock	11.8512	12.4098	11.8173	12.337	621300000.0
2020-08-17	AMZN	Stock	158.656	159.7485	157.709	159.1205	53824000.0
2020-08-17	GOOGL	Stock	75.7985	76.189	75.25	75.812	19998680.0
2020-08-17	META	Stock	262.5	264.1	259.4	261.16	13351100.0
2020-08-17	TSLA	Stock	111.8	123.0573	111.522	122.376	303634500.0
2020-08-17	TLT	Stock	163.97	164.46	163.43	163.59	6901480.0
2020-08-17	ES	Stock	86.94	88.5	86.65	87.46	992600.0
2020-08-17	CL	Stock	76.86	77.77	76.83	77.21	2762300.0
2020-08-17	A	Stock	97.67	98.68	97.09	97.51	1989300.0
2020-08-17	AA	Stock	14.75	14.9	14.36	14.5	2527700.0
2020-08-17	AACG	Stock	1.09	1.16	1.09	1.14	18500.0
2020-08-17	AACQU-DELISTED	Stock	10.24	10.24	10.03	10.1	370695.0
2020-08-17	AAIC-DELISTED	Stock	2.85	2.85	2.77	2.82	147886.0
2020-08-17	AAIC.C-DELISTED	Stock	19.2725	19.2725	19.05	19.195	2675.0
2020-08-17	AAL	Stock	13.32	13.38	12.61	12.62	56206600.0
2020-08-17	AAM.A-DELISTED	Stock	26.71	26.81	26.64	26.73	10782.0
2020-08-17	AAM.B-DELISTED	Stock	27.28	27.32	27.2	27.29	11221.0
2020-08-17	AAMC-DELISTED	Stock	4.8235	6.4044	4.4853	5.8529	427224.0
2020-08-17	AAME	Stock	1.97	2.15	1.96	2.08	3000.0
2020-08-17	AAMI	Stock	13.44	13.59	13.33	13.49	388300.0
2020-08-17	AAOI	Stock	13.36	13.52	12.96	13.35	1010000.0
2020-08-17	AAON	Stock	38.6867	39.6467	38.6333	39.6467	276000.0
2020-08-17	AAP	Stock	160.08	161.48	158.98	161.0	2043400.0
2020-08-17	AAT	Stock	27.1	27.27	26.68	26.87	137000.0
2020-08-17	AAU-DELISTED	Stock	0.7759	0.7881	0.732	0.7696	957950.0
2020-08-17	AAUAF-DELISTED	Stock	0.7759	0.7881	0.732	0.7809	1001758.0
2020-08-17	AAWW-DELISTED	Stock	60.61	61.13	58.85	59.3	368321.0
2020-08-17	AAXJ	Stock	77.32	77.85	77.24	77.78	502460.0
2020-08-17	AAXN-DELISTED	Stock	80.07	80.65	79.35	79.79	293980.0
2020-08-17	AB	Stock	29.17	29.26	28.6	28.77	194700.0
2020-08-17	ABB-DELISTED	Stock	26.57	26.66	26.51	26.54	843984.0
2020-08-17	ABBNY-DELISTED	Stock	26.57	26.66	26.51	26.54	908890.0
2020-08-17	ABBV	Stock	95.29	97.26	95.26	96.35	7251400.0
2020-08-17	ABC-DELISTED	Stock	104.21	104.28	103.1	103.44	323139.0
2020-08-17	ABCB	Stock	26.14	26.14	25.38	25.72	280000.0
2020-08-17	ABEO	Stock	74.75	74.75	70.25	72.0	117396.0
2020-08-17	ABEV	Stock	2.44	2.47	2.33	2.36	22238700.0
2020-08-17	ABG	Stock	109.22	110.22	107.78	108.92	101600.0
2020-08-17	ABM	Stock	38.02	38.02	37.23	37.29	250200.0
2020-08-17	ABMD-DELISTED	Stock	307.76	313.8	305.68	309.95	119983.0
2020-08-17	ABR	Stock	11.33	11.37	11.02	11.09	1536700.0
2020-08-17	ABR.A-DELISTED	Stock	25.49	25.49	24.98	25.285	15327.0
2020-08-17	ABR.B-DELISTED	Stock	25.05	25.13	24.999	25.13	2760.0
2020-08-17	ABR.C-DELISTED	Stock	25.31	25.53	25.07	25.49	9384.0
2020-08-17	ABT	Stock	100.3	101.42	100.21	100.71	4657400.0
2020-08-17	ABTC	Stock	173100.0	173820.0	168000.0	168900.0	2.2133333333333334
2020-08-17	ABTS	Stock	22.8	24.6	22.755	23.4	6613.0
2020-08-17	ABTX-DELISTED	Stock	26.64	26.64	25.72	25.95	34081.0

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

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