PREVIEW / stock_daily / 2019-07-17

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-17.parquet
  size:    220 KB
  rows:    6,544
  symbols: 2,516

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-17	AAPL	Stock	51.0125	51.2725	50.8175	50.8375	56430000.0
2019-07-17	MSFT	Stock	137.7	137.93	136.22	136.27	20211000.0
2019-07-17	NVDA	Stock	4.1788	4.2498	4.1492	4.2428	348204000.0
2019-07-17	AMZN	Stock	100.3525	100.6	99.6015	99.6015	51176000.0
2019-07-17	GOOGL	Stock	57.546	57.922	57.331	57.337	19537880.0
2019-07-17	META	Stock	204.18	204.36	201.59	201.8	12083700.0
2019-07-17	TSLA	Stock	17.0447	17.2207	16.89	16.9907	146470500.0
2019-07-17	TLT	Stock	131.06	132.0184	131.05	131.99	9662156.0
2019-07-17	ES	Stock	77.64	77.9	77.28	77.36	2110500.0
2019-07-17	CL	Stock	73.95	74.14	73.64	73.75	2775100.0
2019-07-17	A	Stock	70.31	70.56	69.59	69.59	2402300.0
2019-07-17	AA	Stock	23.32	23.37	22.82	23.15	3304800.0
2019-07-17	AABA-DELISTED	Stock	70.45	70.86	70.38	70.47	1827094.0
2019-07-17	AAC-DELISTED	Stock	1.14	1.21	1.14	1.18	122770.0
2019-07-17	AACG	Stock	2.85	2.9	2.7	2.77	148200.0
2019-07-17	AAIC-DELISTED	Stock	6.67	6.68	6.56	6.63	393359.0
2019-07-17	AAIC.C-DELISTED	Stock	22.2	22.3	22.165	22.23	10398.0
2019-07-17	AAL	Stock	34.34	34.42	33.11	33.26	5881900.0
2019-07-17	AAM.A-DELISTED	Stock	25.9	26.0	25.9	25.95	10317.0
2019-07-17	AAM.B-DELISTED	Stock	26.0073	26.18	26.0073	26.1	14764.0
2019-07-17	AAMC-DELISTED	Stock	3.5676	3.5676	3.5294	3.5294	3788.0
2019-07-17	AAME	Stock	2.4	2.41	2.4	2.41	400.0
2019-07-17	AAMI	Stock	11.81	11.81	10.91	11.09	615900.0
2019-07-17	AAOI	Stock	9.83	10.01	9.66	9.68	425200.0
2019-07-17	AAON	Stock	33.6467	34.0	33.34	33.3467	108750.0
2019-07-17	AAP	Stock	161.15	161.41	156.35	157.67	1116100.0
2019-07-17	AAT	Stock	46.99	47.06	46.19	46.44	658400.0
2019-07-17	AAU-DELISTED	Stock	0.603	0.6443	0.595	0.6379	254950.0
2019-07-17	AAUAF-DELISTED	Stock	0.603	0.6443	0.595	0.6305	258803.0
2019-07-17	AAWW-DELISTED	Stock	42.14	42.22	41.12	41.77	128827.0
2019-07-17	AAXJ	Stock	69.64	69.8	69.42	69.5	703061.0
2019-07-17	AAXN-DELISTED	Stock	64.22	65.44	63.81	64.82	487729.0
2019-07-17	AB	Stock	30.65	30.76	30.22	30.46	179600.0
2019-07-17	ABB-DELISTED	Stock	18.99	18.99	18.735	18.75	2052060.0
2019-07-17	ABBNY-DELISTED	Stock	18.99	18.99	18.735	18.74	2162086.0
2019-07-17	ABBV	Stock	69.33	69.86	68.31	68.32	12205000.0
2019-07-17	ABC-DELISTED	Stock	88.39	88.522	84.62	85.45	1782081.0
2019-07-17	ABCB	Stock	37.74	37.74	37.19	37.29	338300.0
2019-07-17	ABDC-DELISTED	Stock	8.33	8.33	8.2315	8.28	20390.0
2019-07-17	ABEO	Stock	100.25	101.0	96.75	98.0	21476.0
2019-07-17	ABEOW-DELISTED	Stock	0.4814	0.55	0.4814	0.55	4000.0
2019-07-17	ABEV	Stock	4.77	4.83	4.74	4.74	14710700.0
2019-07-17	ABG	Stock	83.91	84.35	83.23	84.21	77000.0
2019-07-17	ABIL-DELISTED	Stock	0.9	0.905	0.8031	0.87	49295.0
2019-07-17	ABM	Stock	41.22	41.65	40.99	41.17	304400.0
2019-07-17	ABMD-DELISTED	Stock	254.34	261.55	254.34	260.06	250950.0
2019-07-17	ABR	Stock	12.26	12.31	12.15	12.15	973400.0
2019-07-17	ABR.A-DELISTED	Stock	25.9855	26.049	25.95	26.03	3050.0
2019-07-17	ABR.C-DELISTED	Stock	26.33	26.3509	26.25	26.3473	6152.0
2019-07-17	ABT	Stock	85.89	86.75	85.43	85.76	9381400.0

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

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