PREVIEW / stock_daily / 2019-07-18

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-18.parquet
  size:    219 KB
  rows:    6,575
  symbols: 2,540

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-18	AAPL	Stock	51.0	51.47	50.925	51.415	74162400.0
2019-07-18	MSFT	Stock	135.55	136.62	134.67	136.42	30381800.0
2019-07-18	NVDA	Stock	4.2533	4.3178	4.1962	4.2545	442192000.0
2019-07-18	AMZN	Stock	99.0005	99.375	97.5775	98.895	69738000.0
2019-07-18	GOOGL	Stock	57.1	57.4085	56.6428	57.362	25475380.0
2019-07-18	META	Stock	200.15	202.47	199.38	200.78	11937900.0
2019-07-18	TSLA	Stock	17.0033	17.05	16.7927	16.9027	71379000.0
2019-07-18	TLT	Stock	131.47	132.32	131.24	132.0	5725713.0
2019-07-18	ES	Stock	77.4	78.42	76.94	78.4	1428500.0
2019-07-18	CL	Stock	73.74	73.95	73.41	73.88	2412700.0
2019-07-18	A	Stock	70.01	70.61	69.66	70.13	2713000.0
2019-07-18	AA	Stock	22.9	24.63	22.52	23.41	10617100.0
2019-07-18	AABA-DELISTED	Stock	70.42	70.66	70.13	70.34	4785777.0
2019-07-18	AAC-DELISTED	Stock	1.21	1.21	1.0	1.01	201119.0
2019-07-18	AACG	Stock	2.84	2.9	2.7	2.85	97500.0
2019-07-18	AAIC-DELISTED	Stock	6.62	6.66	6.55	6.56	512038.0
2019-07-18	AAIC.C-DELISTED	Stock	22.3	22.5	22.2951	22.5	15370.0
2019-07-18	AAL	Stock	33.41	33.82	33.11	33.74	3049300.0
2019-07-18	AAM.A-DELISTED	Stock	25.9682	26.06	25.9682	26.06	21821.0
2019-07-18	AAM.B-DELISTED	Stock	26.18	26.29	26.159	26.29	20394.0
2019-07-18	AAME	Stock	2.41	2.41	2.41	2.41	100.0
2019-07-18	AAMI	Stock	11.02	11.32	11.02	11.21	329200.0
2019-07-18	AAOI	Stock	9.68	9.83	9.54	9.6	472300.0
2019-07-18	AAON	Stock	33.32	33.7533	33.0667	33.7533	121050.0
2019-07-18	AAP	Stock	154.75	158.09	152.33	157.9	1126900.0
2019-07-18	AAT	Stock	46.41	46.59	45.87	46.5	432600.0
2019-07-18	AAU-DELISTED	Stock	0.66	0.6699	0.6153	0.6463	269231.0
2019-07-18	AAUAF-DELISTED	Stock	0.66	0.6699	0.6153	0.6463	273020.0
2019-07-18	AAWW-DELISTED	Stock	41.63	42.6	41.37	42.58	90403.0
2019-07-18	AAXJ	Stock	69.48	69.87	69.36	69.87	386136.0
2019-07-18	AAXN-DELISTED	Stock	64.71	65.83	64.515	65.8	355601.0
2019-07-18	AB	Stock	30.46	30.62	30.21	30.49	217000.0
2019-07-18	ABB-DELISTED	Stock	18.64	18.79	18.57	18.78	2200325.0
2019-07-18	ABBNY-DELISTED	Stock	18.65	18.79	18.57	18.77	3894794.0
2019-07-18	ABBV	Stock	68.57	68.95	68.0	68.25	8573300.0
2019-07-18	ABC-DELISTED	Stock	85.48	87.0	84.55	86.77	941437.0
2019-07-18	ABCB	Stock	37.33	37.73	37.04	37.63	354000.0
2019-07-18	ABDC-DELISTED	Stock	8.28	8.32	8.23	8.29	16962.0
2019-07-18	ABEO	Stock	97.25	99.25	93.25	96.0	21512.0
2019-07-18	ABEV	Stock	4.76	4.89	4.75	4.85	16318600.0
2019-07-18	ABG	Stock	84.35	84.79	83.51	84.15	69700.0
2019-07-18	ABIL-DELISTED	Stock	0.8785	0.8785	0.84	0.8605	13795.0
2019-07-18	ABM	Stock	41.54	41.98	41.16	41.93	328000.0
2019-07-18	ABMD-DELISTED	Stock	259.03	263.405	259.03	262.85	190484.0
2019-07-18	ABR	Stock	12.1	12.17	12.07	12.13	830800.0
2019-07-18	ABR.A-DELISTED	Stock	25.95	26.0	25.95	25.9907	1341.0
2019-07-18	ABR.C-DELISTED	Stock	26.41	26.419	26.25	26.419	1184.0
2019-07-18	ABT	Stock	86.24	87.84	85.32	87.76	8311600.0
2019-07-18	ABTC	Stock	373500.0	435000.0	369060.0	388200.0	36.93333333333333
2019-07-18	ABTS	Stock	29.85	30.45	28.185	28.95	573.0

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

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