PREVIEW / stock_daily / 2019-03-29

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-29.parquet
  size:    220 KB
  rows:    6,547
  symbols: 2,611

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-03-29	AAPL	Stock	47.4575	47.52	47.135	47.4875	94256000.0
2019-03-29	MSFT	Stock	118.07	118.32	116.96	117.94	25399800.0
2019-03-29	NVDA	Stock	4.4985	4.5135	4.4478	4.489	456896000.0
2019-03-29	AMZN	Stock	89.329	89.643	88.8315	89.0375	66416000.0
2019-03-29	GOOGL	Stock	59.009	59.1985	58.319	58.8445	30892300.0
2019-03-29	META	Stock	166.39	167.19	164.81	166.69	13455500.0
2019-03-29	TSLA	Stock	18.58	18.6773	18.3	18.6573	89869500.0
2019-03-29	TLT	Stock	125.68	126.47	125.64	126.44	10841631.0
2019-03-29	ES	Stock	70.22	70.99	69.94	70.95	2487800.0
2019-03-29	CL	Stock	67.5	68.61	67.37	68.54	4598700.0
2019-03-29	A	Stock	80.16	80.67	79.95	80.38	1585100.0
2019-03-29	AA	Stock	28.28	28.8	28.01	28.16	3382500.0
2019-03-29	AABA-DELISTED	Stock	73.18	74.19	72.91	74.15	7723647.0
2019-03-29	AAC-DELISTED	Stock	1.78	1.86	1.71	1.845	118366.0
2019-03-29	AACG	Stock	0.99	1.02	0.98	0.99	7100.0
2019-03-29	AAIC-DELISTED	Stock	7.95	7.985	7.87	7.96	534014.0
2019-03-29	AAIC.C-DELISTED	Stock	23.04	23.1799	23.0194	23.05	10532.0
2019-03-29	AAL	Stock	31.14	31.89	30.84	31.76	6980800.0
2019-03-29	AAM.A-DELISTED	Stock	24.75	24.97	24.75	24.82	86427.0
2019-03-29	AAM.B-DELISTED	Stock	24.46	24.7	24.46	24.54	90884.0
2019-03-29	AAMC-DELISTED	Stock	10.1882	10.1882	8.8235	9.1913	5233.0
2019-03-29	AAME	Stock	2.6	2.6	2.55	2.55	1200.0
2019-03-29	AAMI	Stock	13.41	13.57	13.31	13.56	651200.0
2019-03-29	AAOI	Stock	12.31	12.39	12.12	12.2	660200.0
2019-03-29	AAON	Stock	30.7133	31.1267	30.5133	30.7867	329250.0
2019-03-29	AAP	Stock	169.89	171.57	168.6	170.53	1856200.0
2019-03-29	AAT	Stock	46.26	46.44	45.5	45.86	765800.0
2019-03-29	AAU-DELISTED	Stock	0.6	0.6199	0.58	0.5814	94965.0
2019-03-29	AAUAF-DELISTED	Stock	0.6	0.6199	0.58	0.5814	97752.0
2019-03-29	AAWW-DELISTED	Stock	49.12	51.75	49.0415	50.53	443305.0
2019-03-29	AAXJ	Stock	70.68	70.805	70.335	70.69	2777728.0
2019-03-29	AAXN-DELISTED	Stock	54.37	55.07	53.93	54.38	453178.0
2019-03-29	AB	Stock	29.06	29.06	28.56	28.89	183100.0
2019-03-29	ABB-DELISTED	Stock	18.83	18.94	18.765	18.87	1185305.0
2019-03-29	ABBNY-DELISTED	Stock	18.83	18.94	18.765	18.87	1242680.0
2019-03-29	ABBV	Stock	80.08	80.9	79.96	80.59	7105900.0
2019-03-29	ABC-DELISTED	Stock	78.31	79.64	78.01	79.53	1087059.0
2019-03-29	ABCB	Stock	34.88	35.06	34.29	34.35	298800.0
2019-03-29	ABDC-DELISTED	Stock	7.53	7.75	7.47	7.5	74524.0
2019-03-29	ABEO	Stock	184.0	186.25	180.0	184.0	11108.0
2019-03-29	ABEV	Stock	4.31	4.37	4.27	4.3	21349000.0
2019-03-29	ABG	Stock	68.89	69.98	68.63	69.36	271600.0
2019-03-29	ABIL-DELISTED	Stock	1.74	1.7751	1.68	1.7173	58041.0
2019-03-29	ABM	Stock	36.0	36.63	35.9	36.35	422900.0
2019-03-29	ABMD-DELISTED	Stock	285.14	291.99	284.73	285.56	545186.0
2019-03-29	ABR	Stock	13.02	13.12	12.95	12.97	1157300.0
2019-03-29	ABR.A-DELISTED	Stock	25.77	25.84	25.665	25.7855	1690.0
2019-03-29	ABR.B-DELISTED	Stock	25.77	25.8371	25.68	25.8371	1200.0
2019-03-29	ABR.C-DELISTED	Stock	26.0683	26.075	25.9614	26.075	2026.0
2019-03-29	ABT	Stock	79.86	79.99	79.11	79.94	5891200.0

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

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