PREVIEW / stock_daily / 2019-05-13

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-13.parquet
  size:    220 KB
  rows:    6,550
  symbols: 2,574

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-05-13	AAPL	Stock	46.9275	47.37	45.7125	46.43	229722400.0
2019-05-13	MSFT	Stock	124.11	125.55	123.04	123.35	33944900.0
2019-05-13	NVDA	Stock	4.0875	4.1108	3.9452	3.9612	656912000.0
2019-05-13	AMZN	Stock	91.828	92.327	90.9	91.134	115668000.0
2019-05-13	GOOGL	Stock	57.262	57.5985	56.275	56.8295	45633720.0
2019-05-13	META	Stock	183.5	185.43	180.84	181.54	16833300.0
2019-05-13	TSLA	Stock	15.4673	15.498	14.9667	15.134	162522000.0
2019-05-13	TLT	Stock	125.4	125.93	125.25	125.73	10501611.0
2019-05-13	ES	Stock	71.63	73.07	71.28	72.99	1218600.0
2019-05-13	CL	Stock	70.88	71.65	70.6	71.56	2601300.0
2019-05-13	A	Stock	75.75	75.91	73.23	73.84	3547300.0
2019-05-13	AA	Stock	24.33	24.65	23.97	24.54	4367000.0
2019-05-13	AABA-DELISTED	Stock	68.71	69.78	68.14	68.65	6311194.0
2019-05-13	AAC-DELISTED	Stock	1.7	1.7367	1.63	1.66	94747.0
2019-05-13	AACG	Stock	2.3	2.68	2.22	2.58	1491600.0
2019-05-13	AAIC-DELISTED	Stock	7.57	7.61	7.5	7.52	290389.0
2019-05-13	AAIC.C-DELISTED	Stock	23.3138	23.32	23.3138	23.32	1135.0
2019-05-13	AAL	Stock	33.16	33.2	31.98	32.14	7040900.0
2019-05-13	AAM.A-DELISTED	Stock	25.43	25.59	25.43	25.59	7912.0
2019-05-13	AAM.B-DELISTED	Stock	25.57	25.59	25.4973	25.58	15118.0
2019-05-13	AAMC-DELISTED	Stock	6.7618	6.7646	6.6441	6.6441	3998.0
2019-05-13	AAME	Stock	2.45	2.45	2.45	2.45	100.0
2019-05-13	AAMI	Stock	13.34	13.34	12.34	12.41	825600.0
2019-05-13	AAOI	Stock	10.37	10.45	9.917	10.16	830900.0
2019-05-13	AAON	Stock	31.42	31.6333	30.58	31.04	227850.0
2019-05-13	AAP	Stock	155.13	156.0	153.41	155.37	1395400.0
2019-05-13	AAT	Stock	45.45	45.74	45.26	45.46	156800.0
2019-05-13	AAU-DELISTED	Stock	0.4745	0.4785	0.4561	0.457	175836.0
2019-05-13	AAUAF-DELISTED	Stock	0.4745	0.4785	0.45	0.45	178530.0
2019-05-13	AAWW-DELISTED	Stock	40.68	41.51	40.1097	40.51	241831.0
2019-05-13	AAXJ	Stock	66.75	66.91	66.13	66.43	2854698.0
2019-05-13	AAXN-DELISTED	Stock	62.22	65.04	62.0	64.81	576185.0
2019-05-13	AB	Stock	28.83	28.96	28.6	28.84	186900.0
2019-05-13	ABB-DELISTED	Stock	18.77	18.81	18.62	18.71	2217205.0
2019-05-13	ABBNY-DELISTED	Stock	18.77	18.81	18.62	18.71	2307135.0
2019-05-13	ABBV	Stock	76.3	77.3	76.17	76.87	3858400.0
2019-05-13	ABC-DELISTED	Stock	76.04	76.27	74.67	75.68	825850.0
2019-05-13	ABCB	Stock	35.88	36.2	35.27	35.57	313400.0
2019-05-13	ABDC-DELISTED	Stock	8.34	8.42	8.31	8.35	14114.0
2019-05-13	ABEO	Stock	186.25	192.5	176.0	176.25	14528.0
2019-05-13	ABEV	Stock	4.29	4.32	4.25	4.29	37587000.0
2019-05-13	ABG	Stock	79.03	79.41	77.77	78.52	162500.0
2019-05-13	ABIL-DELISTED	Stock	1.32	1.34	1.185	1.22	123828.0
2019-05-13	ABM	Stock	37.6	37.6	37.04	37.29	211000.0
2019-05-13	ABMD-DELISTED	Stock	251.0	254.59	248.727	252.44	490485.0
2019-05-13	ABR	Stock	13.0	13.12	12.79	13.08	1535900.0
2019-05-13	ABR.A-DELISTED	Stock	26.26	26.38	26.26	26.38	1555.0
2019-05-13	ABR.B-DELISTED	Stock	25.96	26.07	25.81	25.935	12057.0
2019-05-13	ABR.C-DELISTED	Stock	26.5989	26.95	26.5989	26.875	8531.0
2019-05-13	ABT	Stock	75.17	75.79	74.96	75.5	5166700.0

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

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