PREVIEW / stock_daily / 2018-11-09

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-09.parquet
  size:    222 KB
  rows:    6,537
  symbols: 2,695

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
2018-11-09	AAPL	Stock	51.3875	51.5025	50.5625	51.1175	137463200.0
2018-11-09	MSFT	Stock	110.85	111.45	108.76	109.57	32039200.0
2018-11-09	NVDA	Stock	5.06	5.233	5.026	5.1418	413240000.0
2018-11-09	AMZN	Stock	86.625	87.196	85.0935	85.6215	118044000.0
2018-11-09	GOOGL	Stock	54.201	54.4175	53.213	53.851	34865960.0
2018-11-09	META	Stock	146.75	147.76	144.07	144.96	17326900.0
2018-11-09	TSLA	Stock	23.2667	23.6	23.0153	23.3673	76482000.0
2018-11-09	TLT	Stock	112.75	113.4967	112.72	113.35	6465323.0
2018-11-09	ES	Stock	64.4	65.5	64.38	65.14	1222300.0
2018-11-09	CL	Stock	61.15	63.99	60.95	63.8	9735400.0
2018-11-09	A	Stock	67.6	67.76	66.7	67.27	2573500.0
2018-11-09	AA	Stock	35.97	36.15	33.82	34.36	4279000.0
2018-11-09	AABA-DELISTED	Stock	61.47	61.69	60.14	60.98	4334048.0
2018-11-09	AAC-DELISTED	Stock	2.97	3.03	2.865	2.98	512915.0
2018-11-09	AACG	Stock	1.11	1.19	1.08	1.09	180300.0
2018-11-09	AAIC-DELISTED	Stock	8.68	8.69	8.59	8.65	318661.0
2018-11-09	AAL	Stock	36.7	37.26	36.03	36.22	6794400.0
2018-11-09	AAM.A-DELISTED	Stock	24.57	24.67	24.5	24.54	20193.0
2018-11-09	AAM.B-DELISTED	Stock	24.524	24.53	24.32	24.4407	20841.0
2018-11-09	AAMC-DELISTED	Stock	13.0735	14.1176	12.6441	13.2059	5790.0
2018-11-09	AAME	Stock	3.8	3.8	3.22	3.22	3700.0
2018-11-09	AAMI	Stock	12.91	13.02	12.58	12.89	381700.0
2018-11-09	AAOI	Stock	21.4	23.38	21.13	21.66	2006000.0
2018-11-09	AAON	Stock	29.0067	29.2	27.9333	28.84	374100.0
2018-11-09	AAP	Stock	172.66	174.71	170.69	171.18	1202300.0
2018-11-09	AAT	Stock	38.97	39.39	38.88	39.38	191900.0
2018-11-09	AAU-DELISTED	Stock	0.5174	0.5175	0.51	0.5127	125740.0
2018-11-09	AAUAF-DELISTED	Stock	0.5174	0.5175	0.51	0.5127	130556.0
2018-11-09	AAWW-DELISTED	Stock	55.89	55.94	54.34	54.43	142655.0
2018-11-09	AAXJ	Stock	64.26	64.45	63.58	63.91	1468899.0
2018-11-09	AAXN-DELISTED	Stock	51.75	53.18	51.1	52.27	895236.0
2018-11-09	AB	Stock	30.04	30.07	29.56	29.95	227200.0
2018-11-09	ABAC-DELISTED	Stock	1.65	1.71	1.65	1.7065	2623.0
2018-11-09	ABB-DELISTED	Stock	20.15	20.24	20.05	20.16	2144319.0
2018-11-09	ABBNY-DELISTED	Stock	20.15	20.24	20.05	20.15	2213948.0
2018-11-09	ABBV	Stock	87.83	89.53	87.56	88.79	9169800.0
2018-11-09	ABC-DELISTED	Stock	88.96	90.31	87.64	88.85	934706.0
2018-11-09	ABCB	Stock	44.5	44.93	43.8	44.39	306300.0
2018-11-09	ABCD-DELISTED	Stock	14.47	14.47	14.38	14.42	181519.0
2018-11-09	ABDC-DELISTED	Stock	6.55	6.58	6.4	6.47	45176.0
2018-11-09	ABEO	Stock	242.75	247.5	225.5	234.0	23676.0
2018-11-09	ABEV	Stock	4.22	4.28	4.15	4.24	37146000.0
2018-11-09	ABG	Stock	68.65	68.98	67.04	67.96	152400.0
2018-11-09	ABIL-DELISTED	Stock	3.24	3.25	2.93	3.02	77586.0
2018-11-09	ABM	Stock	32.47	32.63	31.7	31.91	377900.0
2018-11-09	ABMD-DELISTED	Stock	413.32	413.32	395.64	405.21	404504.0
2018-11-09	ABR	Stock	12.12	12.33	12.08	12.32	1146900.0
2018-11-09	ABR.A-DELISTED	Stock	25.57	25.628	25.55	25.628	3355.0
2018-11-09	ABR.B-DELISTED	Stock	25.68	25.68	25.68	25.68	300.0
2018-11-09	ABR.C-DELISTED	Stock	25.66	25.77	25.63	25.6605	8513.0

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

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