PREVIEW / stock_daily / 2019-06-17

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-17.parquet
  size:    219 KB
  rows:    6,546
  symbols: 2,533

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-06-17	AAPL	Stock	48.225	48.74	48.0425	48.4725	58676400.0
2019-06-17	MSFT	Stock	132.63	133.73	132.53	132.85	14517800.0
2019-06-17	NVDA	Stock	3.6142	3.663	3.5913	3.6258	276040000.0
2019-06-17	AMZN	Stock	93.825	94.7845	93.7725	94.3015	52686000.0
2019-06-17	GOOGL	Stock	54.455	55.064	54.4	54.6945	19769820.0
2019-06-17	META	Stock	185.01	189.5	184.41	189.01	29459900.0
2019-06-17	TSLA	Stock	14.3653	15.1333	14.2847	15.002	184752000.0
2019-06-17	TLT	Stock	131.39	131.76	131.13	131.69	6046416.0
2019-06-17	ES	Stock	77.44	77.57	76.28	76.5	1605700.0
2019-06-17	CL	Stock	73.35	73.58	72.8	73.41	2702200.0
2019-06-17	A	Stock	70.25	70.6	69.89	70.29	1149200.0
2019-06-17	AA	Stock	21.53	21.99	21.2	21.65	3228900.0
2019-06-17	AABA-DELISTED	Stock	66.05	67.07	66.0	66.88	7908593.0
2019-06-17	AAC-DELISTED	Stock	0.7	0.7482	0.6988	0.715	361466.0
2019-06-17	AACG	Stock	2.07	2.15	2.03	2.11	22000.0
2019-06-17	AAIC-DELISTED	Stock	6.96	7.07	6.92	6.93	372828.0
2019-06-17	AAIC.C-DELISTED	Stock	21.51	21.6176	21.51	21.54	8191.0
2019-06-17	AAL	Stock	32.1	32.92	32.1	32.56	3420700.0
2019-06-17	AAM.A-DELISTED	Stock	25.78	25.82	25.7368	25.7714	14004.0
2019-06-17	AAM.B-DELISTED	Stock	25.87	25.95	25.86	25.93	23418.0
2019-06-17	AAMC-DELISTED	Stock	4.0647	4.1324	4.0441	4.0441	18948.0
2019-06-17	AAME	Stock	2.33	2.39	2.33	2.39	1000.0
2019-06-17	AAMI	Stock	10.73	10.81	10.63	10.71	285000.0
2019-06-17	AAOI	Stock	8.87	9.06	8.78	8.87	272300.0
2019-06-17	AAON	Stock	32.1333	32.4133	31.8667	32.02	153450.0
2019-06-17	AAP	Stock	152.52	153.84	151.66	151.74	694300.0
2019-06-17	AAT	Stock	47.4	47.8	46.92	47.36	921800.0
2019-06-17	AAU-DELISTED	Stock	0.57	0.57	0.53	0.5339	148047.0
2019-06-17	AAUAF-DELISTED	Stock	0.57	0.57	0.53	0.5339	153882.0
2019-06-17	AAWW-DELISTED	Stock	40.99	41.14	40.17	40.28	120569.0
2019-06-17	AAXJ	Stock	66.16	66.4	66.09	66.25	1071736.0
2019-06-17	AAXN-DELISTED	Stock	70.83	71.0276	66.61	68.16	795636.0
2019-06-17	AB	Stock	29.58	29.6	28.98	28.98	195800.0
2019-06-17	ABB-DELISTED	Stock	18.79	18.87	18.73	18.735	1326469.0
2019-06-17	ABBNY-DELISTED	Stock	18.79	18.87	18.73	18.73	1498269.0
2019-06-17	ABBV	Stock	78.4	79.05	78.4	78.65	3083200.0
2019-06-17	ABC-DELISTED	Stock	85.46	85.61	84.39	85.33	781829.0
2019-06-17	ABCB	Stock	38.25	38.57	37.67	37.8	250200.0
2019-06-17	ABDC-DELISTED	Stock	8.49	8.49	8.39	8.48	25945.0
2019-06-17	ABEO	Stock	130.5	136.5	129.5	134.25	31440.0
2019-06-17	ABEV	Stock	4.53	4.61	4.53	4.55	25615200.0
2019-06-17	ABG	Stock	79.79	81.16	79.79	80.59	122800.0
2019-06-17	ABIL-DELISTED	Stock	1.13	1.16	1.05	1.09	101848.0
2019-06-17	ABM	Stock	39.99	40.33	39.89	40.0	408000.0
2019-06-17	ABMD-DELISTED	Stock	251.64	259.27	250.22	256.32	298802.0
2019-06-17	ABR	Stock	12.35	12.43	12.32	12.33	1130600.0
2019-06-17	ABR.A-DELISTED	Stock	26.19	26.19	26.078	26.078	756.0
2019-06-17	ABR.B-DELISTED	Stock	25.84	25.8899	25.84	25.85	788.0
2019-06-17	ABR.C-DELISTED	Stock	25.9851	26.1302	25.9605	26.1302	2830.0
2019-06-17	ABT	Stock	82.39	82.58	81.67	82.05	4095900.0

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

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