PREVIEW / stock_daily / 2019-06-12

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-12.parquet
  size:    219 KB
  rows:    6,553
  symbols: 2,552

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-12	AAPL	Stock	48.4875	48.9925	48.3475	48.5475	73012800.0
2019-06-12	MSFT	Stock	131.4	131.97	130.71	131.49	17092500.0
2019-06-12	NVDA	Stock	3.725	3.7312	3.6398	3.655	358892000.0
2019-06-12	AMZN	Stock	92.699	93.25	92.219	92.766	53566000.0
2019-06-12	GOOGL	Stock	53.9975	54.126	53.48	53.955	23673000.0
2019-06-12	META	Stock	178.38	179.27	172.88	175.04	17699800.0
2019-06-12	TSLA	Stock	14.8633	14.892	13.9333	13.9507	227962500.0
2019-06-12	TLT	Stock	130.39	130.75	130.3	130.68	5278799.0
2019-06-12	ES	Stock	75.84	76.6	75.84	76.51	849900.0
2019-06-12	CL	Stock	73.63	74.09	72.85	73.05	3230000.0
2019-06-12	A	Stock	70.08	70.29	68.93	70.29	1546800.0
2019-06-12	AA	Stock	21.5	21.64	21.08	21.17	2638500.0
2019-06-12	AABA-DELISTED	Stock	66.55	66.89	65.88	66.17	4395433.0
2019-06-12	AAC-DELISTED	Stock	0.8	0.8079	0.71	0.7311	772538.0
2019-06-12	AACG	Stock	2.12	2.19	2.08	2.13	76900.0
2019-06-12	AAIC-DELISTED	Stock	6.89	6.9195	6.855	6.87	214279.0
2019-06-12	AAIC.C-DELISTED	Stock	21.735	21.86	21.735	21.818	1925.0
2019-06-12	AAL	Stock	30.56	31.13	30.45	31.1	5185700.0
2019-06-12	AAM.A-DELISTED	Stock	25.75	25.75	25.6	25.69	13212.0
2019-06-12	AAM.B-DELISTED	Stock	25.88	25.88	25.74	25.77	29934.0
2019-06-12	AAMC-DELISTED	Stock	4.25	4.3059	4.1176	4.1176	6827.0
2019-06-12	AAME	Stock	2.39	2.44	2.39	2.44	1200.0
2019-06-12	AAMI	Stock	11.0	11.15	10.98	11.04	366800.0
2019-06-12	AAOI	Stock	9.1	9.2	8.918	9.05	278500.0
2019-06-12	AAON	Stock	31.92	32.3867	31.8267	31.8733	102750.0
2019-06-12	AAP	Stock	152.09	152.68	149.03	150.54	796500.0
2019-06-12	AAT	Stock	45.05	45.32	44.62	45.11	4650900.0
2019-06-12	AAU-DELISTED	Stock	0.477	0.49	0.47	0.4805	128432.0
2019-06-12	AAUAF-DELISTED	Stock	0.477	0.49	0.47	0.4805	130501.0
2019-06-12	AAWW-DELISTED	Stock	41.26	41.43	40.47	40.58	295083.0
2019-06-12	AAXJ	Stock	67.42	67.44	67.06	67.15	374310.0
2019-06-12	AAXN-DELISTED	Stock	70.24	70.485	69.24	70.34	707335.0
2019-06-12	AB	Stock	28.62	28.96	28.17	28.87	454700.0
2019-06-12	ABB-DELISTED	Stock	19.37	19.38	19.26	19.27	1278947.0
2019-06-12	ABBNY-DELISTED	Stock	19.37	19.38	19.26	19.26	1353792.0
2019-06-12	ABBV	Stock	78.25	79.25	78.18	78.57	4165700.0
2019-06-12	ABC-DELISTED	Stock	84.67	85.41	84.27	85.36	888369.0
2019-06-12	ABCB	Stock	38.0	38.13	37.66	37.75	298400.0
2019-06-12	ABDC-DELISTED	Stock	8.1	8.12	8.06	8.08	34970.0
2019-06-12	ABEO	Stock	131.0	135.5	129.5	134.5	26496.0
2019-06-12	ABEV	Stock	4.58	4.64	4.52	4.54	17706500.0
2019-06-12	ABG	Stock	79.36	79.61	77.69	79.21	82300.0
2019-06-12	ABIL-DELISTED	Stock	1.25	1.25	1.13	1.16	81988.0
2019-06-12	ABM	Stock	39.47	40.29	39.22	39.83	469500.0
2019-06-12	ABMD-DELISTED	Stock	259.99	270.0255	252.57	254.64	449477.0
2019-06-12	ABR	Stock	12.03	12.29	11.99	12.18	1577000.0
2019-06-12	ABR.A-DELISTED	Stock	26.16	26.16	26.16	26.16	480.0
2019-06-12	ABR.B-DELISTED	Stock	25.74	25.8859	25.5507	25.5507	3728.0
2019-06-12	ABR.C-DELISTED	Stock	25.9211	26.24	25.9211	26.1182	4794.0
2019-06-12	ABT	Stock	81.29	81.97	81.26	81.95	3332300.0

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

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