PREVIEW / stock_daily / 2019-07-26

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-26.parquet
  size:    221 KB
  rows:    6,595
  symbols: 2,536

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-26	AAPL	Stock	51.87	52.4325	51.785	51.935	70475600.0
2019-07-26	MSFT	Stock	140.37	141.68	140.3	141.34	19037600.0
2019-07-26	NVDA	Stock	4.3618	4.4238	4.3618	4.3768	274160000.0
2019-07-26	AMZN	Stock	97.1	97.545	96.2255	97.1525	98542000.0
2019-07-26	GOOGL	Stock	61.4	63.4197	61.4	62.261	121215900.0
2019-07-26	META	Stock	200.19	202.88	196.25	199.75	24434000.0
2019-07-26	TSLA	Stock	15.128	15.3507	14.8167	15.2027	150415500.0
2019-07-26	TLT	Stock	131.7	131.78	131.25	131.47	6188692.0
2019-07-26	ES	Stock	76.19	76.56	75.87	76.24	1571900.0
2019-07-26	CL	Stock	71.92	73.78	71.79	73.69	4036200.0
2019-07-26	A	Stock	70.13	70.19	69.35	69.5	2392600.0
2019-07-26	AA	Stock	22.85	23.3	22.63	23.13	2506700.0
2019-07-26	AABA-DELISTED	Stock	70.99	71.265	70.69	71.04	1319940.0
2019-07-26	AAC-DELISTED	Stock	1.02	1.03	0.9601	0.9856	92745.0
2019-07-26	AACG	Stock	2.64	2.65	2.6	2.6	71500.0
2019-07-26	AAIC-DELISTED	Stock	6.58	6.65	6.58	6.61	213116.0
2019-07-26	AAIC.C-DELISTED	Stock	23.06	23.23	23.06	23.1484	5165.0
2019-07-26	AAL	Stock	32.0	32.25	31.16	31.24	7875200.0
2019-07-26	AAM.A-DELISTED	Stock	26.42	26.58	26.41	26.41	7493.0
2019-07-26	AAM.B-DELISTED	Stock	26.81	26.95	26.81	26.9002	30055.0
2019-07-26	AAMC-DELISTED	Stock	3.1059	3.2353	3.1059	3.2353	3335.0
2019-07-26	AAME	Stock	2.38	2.38	2.31	2.31	700.0
2019-07-26	AAMI	Stock	10.99	11.24	10.9	11.15	205800.0
2019-07-26	AAOI	Stock	9.18	9.4	9.14	9.31	385600.0
2019-07-26	AAON	Stock	33.86	34.6	33.86	34.5067	130500.0
2019-07-26	AAP	Stock	150.1	152.83	149.5	152.62	881500.0
2019-07-26	AAT	Stock	46.73	47.04	46.44	46.94	223900.0
2019-07-26	AAU-DELISTED	Stock	0.76	0.7728	0.7402	0.7676	183780.0
2019-07-26	AAUAF-DELISTED	Stock	0.76	0.7728	0.7402	0.76	203258.0
2019-07-26	AAWW-DELISTED	Stock	43.8	45.77	43.2547	45.72	162991.0
2019-07-26	AAXJ	Stock	69.72	69.72	69.44	69.5	879882.0
2019-07-26	AAXN-DELISTED	Stock	68.48	70.55	68.48	69.51	447018.0
2019-07-26	AB	Stock	29.18	29.89	29.18	29.74	185200.0
2019-07-26	ABB-DELISTED	Stock	18.82	18.83	18.64	18.67	3688827.0
2019-07-26	ABBNY-DELISTED	Stock	18.82	18.83	18.64	18.68	3992453.0
2019-07-26	ABBV	Stock	67.64	69.14	67.37	67.76	12259300.0
2019-07-26	ABC-DELISTED	Stock	86.26	86.685	85.585	86.12	568877.0
2019-07-26	ABCB	Stock	39.01	40.03	38.6	39.76	548600.0
2019-07-26	ABDC-DELISTED	Stock	8.24	8.3103	8.23	8.31	4002.0
2019-07-26	ABEO	Stock	78.0	80.0	74.0	79.5	44156.0
2019-07-26	ABEV	Stock	5.2	5.27	5.14	5.24	21620700.0
2019-07-26	ABG	Stock	88.95	93.93	88.95	89.5	329500.0
2019-07-26	ABIL-DELISTED	Stock	0.7801	0.7986	0.7601	0.777	53499.0
2019-07-26	ABM	Stock	41.5	42.18	41.27	42.01	254800.0
2019-07-26	ABMD-DELISTED	Stock	274.26	275.11	271.02	272.6	197336.0
2019-07-26	ABR	Stock	12.05	12.15	12.0	12.11	655500.0
2019-07-26	ABR.A-DELISTED	Stock	26.2212	26.2212	26.1203	26.15	1495.0
2019-07-26	ABR.B-DELISTED	Stock	25.8307	25.8307	25.8307	25.8307	625.0
2019-07-26	ABR.C-DELISTED	Stock	26.3074	26.6	26.3074	26.6	700.0
2019-07-26	ABT	Stock	88.35	88.62	87.3	87.75	4177700.0

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

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