PREVIEW / stock_daily / 2019-07-16

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-16.parquet
  size:    221 KB
  rows:    6,584
  symbols: 2,550

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-16	AAPL	Stock	51.1475	51.5275	50.875	51.125	67467200.0
2019-07-16	MSFT	Stock	138.96	139.05	136.52	137.08	22726100.0
2019-07-16	NVDA	Stock	4.1667	4.2042	4.121	4.177	341444000.0
2019-07-16	AMZN	Stock	100.529	101.316	100.061	100.495	52364000.0
2019-07-16	GOOGL	Stock	57.3365	57.929	57.3365	57.673	25352820.0
2019-07-16	META	Stock	203.89	205.47	203.1	203.84	12132700.0
2019-07-16	TSLA	Stock	16.62	16.902	16.5287	16.8253	122235000.0
2019-07-16	TLT	Stock	130.17	130.6	129.955	130.58	6172721.0
2019-07-16	ES	Stock	77.09	77.73	76.6	77.09	1811800.0
2019-07-16	CL	Stock	74.21	74.64	73.96	74.5	3485400.0
2019-07-16	A	Stock	70.0	70.36	69.33	69.95	3067200.0
2019-07-16	AA	Stock	23.25	23.925	23.09	23.32	2881500.0
2019-07-16	AABA-DELISTED	Stock	70.04	70.74	70.04	70.515	1994224.0
2019-07-16	AAC-DELISTED	Stock	1.15	1.1521	1.1	1.14	174467.0
2019-07-16	AACG	Stock	2.66	2.91	2.66	2.81	390800.0
2019-07-16	AAIC-DELISTED	Stock	6.58	6.705	6.58	6.66	661972.0
2019-07-16	AAIC.C-DELISTED	Stock	22.0644	22.0644	22.0644	22.0644	2000.0
2019-07-16	AAL	Stock	33.7	34.67	33.7	34.22	6353600.0
2019-07-16	AAM.A-DELISTED	Stock	25.87	25.99	25.87	25.96	23151.0
2019-07-16	AAM.B-DELISTED	Stock	26.0	26.07	25.99	26.07	21682.0
2019-07-16	AAMC-DELISTED	Stock	3.4824	3.4824	3.4824	3.4824	598.0
2019-07-16	AAME	Stock	2.25	2.38	2.25	2.36	1700.0
2019-07-16	AAMI	Stock	11.65	11.89	11.467	11.85	400600.0
2019-07-16	AAOI	Stock	9.96	10.302	9.8	9.82	455700.0
2019-07-16	AAON	Stock	33.5933	33.98	32.9867	33.7733	225000.0
2019-07-16	AAP	Stock	158.87	162.71	158.87	161.76	763600.0
2019-07-16	AAT	Stock	46.92	47.12	46.52	46.9	328800.0
2019-07-16	AAU-DELISTED	Stock	0.68	0.68	0.5793	0.611	634522.0
2019-07-16	AAUAF-DELISTED	Stock	0.68	0.68	0.5793	0.611	705781.0
2019-07-16	AAWW-DELISTED	Stock	42.49	43.65	42.32	42.4	131664.0
2019-07-16	AAXJ	Stock	69.84	70.04	69.67	69.67	385027.0
2019-07-16	AAXN-DELISTED	Stock	63.79	64.0769	62.83	63.89	350333.0
2019-07-16	AB	Stock	30.55	30.88	30.49	30.78	187100.0
2019-07-16	ABB-DELISTED	Stock	18.93	19.06	18.92	18.94	1286655.0
2019-07-16	ABBNY-DELISTED	Stock	18.93	19.06	18.92	18.95	1342050.0
2019-07-16	ABBV	Stock	70.15	70.3	69.13	69.16	10141600.0
2019-07-16	ABC-DELISTED	Stock	89.87	89.9	88.755	88.99	740786.0
2019-07-16	ABCB	Stock	37.79	38.22	37.57	37.85	426700.0
2019-07-16	ABDC-DELISTED	Stock	8.33	8.3305	8.225	8.26	32521.0
2019-07-16	ABEO	Stock	106.25	106.5	99.25	99.75	28668.0
2019-07-16	ABEV	Stock	4.85	4.86	4.76	4.78	18581100.0
2019-07-16	ABG	Stock	83.42	84.42	82.8	84.05	79300.0
2019-07-16	ABIL-DELISTED	Stock	0.8912	0.9228	0.888	0.9045	9393.0
2019-07-16	ABM	Stock	41.49	41.63	41.19	41.34	395800.0
2019-07-16	ABMD-DELISTED	Stock	261.88	261.99	253.4	253.75	258429.0
2019-07-16	ABR	Stock	12.34	12.36	12.28	12.29	752000.0
2019-07-16	ABR.A-DELISTED	Stock	25.9	26.0778	25.9	26.0778	1110.0
2019-07-16	ABR.C-DELISTED	Stock	26.1262	26.25	26.0851	26.235	3700.0
2019-07-16	ABT	Stock	84.11	84.24	82.9	83.16	3886700.0
2019-07-16	ABTC	Stock	405000.0	405000.0	384000.0	386700.0	9.4

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

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