PREVIEW / stock_daily / 2019-04-15

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-15.parquet
  size:    220 KB
  rows:    6,556
  symbols: 2,589

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-04-15	AAPL	Stock	49.645	49.9625	49.5025	49.8075	70146400.0
2019-04-15	MSFT	Stock	120.94	121.58	120.57	121.05	15792600.0
2019-04-15	NVDA	Stock	4.7425	4.7475	4.5775	4.6175	440092000.0
2019-04-15	AMZN	Stock	92.1	92.3425	90.945	92.2435	74488000.0
2019-04-15	GOOGL	Stock	61.2045	61.4648	60.728	61.3265	23799480.0
2019-04-15	META	Stock	178.5	180.5	176.87	179.65	10834800.0
2019-04-15	TSLA	Stock	17.9087	17.9253	17.242	17.7587	150579000.0
2019-04-15	TLT	Stock	122.775	122.99	122.72	122.98	3070036.0
2019-04-15	ES	Stock	70.67	71.1	70.58	70.78	1468000.0
2019-04-15	CL	Stock	68.51	68.89	68.43	68.71	2907500.0
2019-04-15	A	Stock	81.0	81.13	79.91	80.4	1627300.0
2019-04-15	AA	Stock	28.38	28.4	27.57	27.74	4164500.0
2019-04-15	AABA-DELISTED	Stock	76.6	76.6	74.26	74.37	6628939.0
2019-04-15	AAC-DELISTED	Stock	2.07	2.17	2.0	2.15	164941.0
2019-04-15	AACG	Stock	2.6	3.44	2.6	3.25	9311000.0
2019-04-15	AAIC-DELISTED	Stock	7.61	7.6309	7.48	7.51	477852.0
2019-04-15	AAIC.C-DELISTED	Stock	23.55	23.55	23.3334	23.4075	4925.0
2019-04-15	AAL	Stock	34.65	35.24	33.68	33.75	6390600.0
2019-04-15	AAM.A-DELISTED	Stock	24.95	24.9572	24.845	24.945	16036.0
2019-04-15	AAM.B-DELISTED	Stock	24.7994	24.93	24.7748	24.87	29953.0
2019-04-15	AAME	Stock	2.31	2.31	2.31	2.31	3500.0
2019-04-15	AAMI	Stock	14.53	14.642	14.32	14.4	358500.0
2019-04-15	AAOI	Stock	12.75	12.76	12.1	12.36	1121300.0
2019-04-15	AAON	Stock	30.8267	31.7533	30.7667	31.7333	277500.0
2019-04-15	AAP	Stock	180.54	181.78	179.03	181.43	913200.0
2019-04-15	AAT	Stock	45.72	45.82	45.41	45.82	206600.0
2019-04-15	AAU-DELISTED	Stock	0.59	0.59	0.56	0.5698	115645.0
2019-04-15	AAUAF-DELISTED	Stock	0.59	0.59	0.56	0.5698	129722.0
2019-04-15	AAWW-DELISTED	Stock	51.56	51.99	49.58	49.74	153281.0
2019-04-15	AAXJ	Stock	72.93	72.97	72.37	72.6	1030843.0
2019-04-15	AAXN-DELISTED	Stock	61.84	62.17	60.5	60.73	284187.0
2019-04-15	AB	Stock	29.4	29.53	29.31	29.39	153500.0
2019-04-15	ABB-DELISTED	Stock	19.9	19.91	19.77	19.8	1164087.0
2019-04-15	ABBNY-DELISTED	Stock	19.9	19.91	19.77	19.8	1211125.0
2019-04-15	ABBV	Stock	80.96	81.51	80.37	81.03	3495500.0
2019-04-15	ABC-DELISTED	Stock	75.06	76.16	74.6	76.1	686918.0
2019-04-15	ABCB	Stock	36.07	36.08	34.9	35.16	198000.0
2019-04-15	ABDC-DELISTED	Stock	7.89	8.06	7.89	8.06	49252.0
2019-04-15	ABEO	Stock	194.25	194.5	186.0	192.0	11952.0
2019-04-15	ABEV	Stock	4.45	4.48	4.42	4.48	24394600.0
2019-04-15	ABG	Stock	75.29	75.9	74.74	75.39	179900.0
2019-04-15	ABIL-DELISTED	Stock	1.7	1.75	1.61	1.75	128249.0
2019-04-15	ABM	Stock	37.5	37.67	37.34	37.49	194700.0
2019-04-15	ABMD-DELISTED	Stock	271.45	276.79	270.68	272.3	506029.0
2019-04-15	ABR	Stock	13.74	13.79	13.52	13.65	1094800.0
2019-04-15	ABR.A-DELISTED	Stock	25.8	25.81	25.7601	25.81	1400.0
2019-04-15	ABR.B-DELISTED	Stock	25.47	25.63	25.47	25.53	1772.0
2019-04-15	ABR.C-DELISTED	Stock	26.29	26.29	26.2	26.2652	1000.0
2019-04-15	ABT	Stock	78.11	78.46	77.46	77.5	6095100.0
2019-04-15	ABTC	Stock	303600.0	303600.0	300930.0	303360.0	0.96

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

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