PREVIEW / stock_daily / 2018-12-11

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-11.parquet
  size:    220 KB
  rows:    6,566
  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-12-11	AAPL	Stock	42.915	42.9475	41.75	42.1575	189126800.0
2018-12-11	MSFT	Stock	109.8	110.95	107.44	108.59	42381900.0
2018-12-11	NVDA	Stock	3.889	3.8972	3.625	3.7048	671912000.0
2018-12-11	AMZN	Stock	83.9	83.9735	80.98	82.162	124894000.0
2018-12-11	GOOGL	Stock	53.347	53.52	52.505	53.0825	33851520.0
2018-12-11	META	Stock	143.88	143.88	141.1	142.08	20300300.0
2018-12-11	TSLA	Stock	24.6607	24.8113	24.0153	24.4507	94632000.0
2018-12-11	TLT	Stock	118.97	119.38	118.61	118.88	8071952.0
2018-12-11	ES	Stock	69.84	70.34	69.22	70.17	1460900.0
2018-12-11	CL	Stock	63.98	65.0	63.87	64.55	4703200.0
2018-12-11	A	Stock	71.76	72.44	70.7	71.05	2926000.0
2018-12-11	AA	Stock	29.16	29.44	28.33	28.43	2490500.0
2018-12-11	AABA-DELISTED	Stock	63.38	63.935	62.23	62.55	5085500.0
2018-12-11	AAC-DELISTED	Stock	2.3	2.75	2.25	2.74	840191.0
2018-12-11	AACG	Stock	1.12	1.12	1.03	1.08	76200.0
2018-12-11	AAIC-DELISTED	Stock	8.39	8.47	8.3299	8.35	261064.0
2018-12-11	AAL	Stock	34.36	34.81	33.61	34.1	8055400.0
2018-12-11	AAM.A-DELISTED	Stock	22.5	22.5699	22.3	22.4688	36973.0
2018-12-11	AAM.B-DELISTED	Stock	22.45	22.55	22.2	22.38	101769.0
2018-12-11	AAMC-DELISTED	Stock	14.1647	14.1647	13.1029	14.1176	11567.0
2018-12-11	AAME	Stock	2.37	2.42	2.36	2.42	1700.0
2018-12-11	AAMI	Stock	11.52	11.76	11.31	11.33	976500.0
2018-12-11	AAOI	Stock	20.0	20.32	19.25	19.77	506700.0
2018-12-11	AAON	Stock	23.6933	23.9	23.3667	23.6267	152400.0
2018-12-11	AAP	Stock	167.68	168.89	165.01	165.8	861200.0
2018-12-11	AAT	Stock	42.02	42.23	41.75	41.92	217500.0
2018-12-11	AAU-DELISTED	Stock	0.65	0.6538	0.63	0.6316	97456.0
2018-12-11	AAUAF-DELISTED	Stock	0.65	0.6538	0.63	0.6316	101794.0
2018-12-11	AAWW-DELISTED	Stock	49.39	49.7963	47.12	47.8	213698.0
2018-12-11	AAXJ	Stock	65.21	65.22	64.39	64.85	1344063.0
2018-12-11	AAXN-DELISTED	Stock	45.59	46.29	43.67	44.18	845722.0
2018-12-11	AB	Stock	27.11	27.75	26.64	26.69	1068100.0
2018-12-11	ABAC-DELISTED	Stock	1.38	1.38	1.23	1.24	18407.0
2018-12-11	ABB-DELISTED	Stock	19.25	19.26	18.77	18.87	4365672.0
2018-12-11	ABBNY-DELISTED	Stock	19.25	19.26	18.77	18.87	4486126.0
2018-12-11	ABBV	Stock	88.62	89.44	86.66	88.17	5098100.0
2018-12-11	ABC-DELISTED	Stock	84.39	84.78	81.65	82.48	1015725.0
2018-12-11	ABCB	Stock	37.22	37.55	35.85	36.0	295900.0
2018-12-11	ABCD-DELISTED	Stock	14.47	14.49	14.46	14.47	290656.0
2018-12-11	ABDC-DELISTED	Stock	6.5	6.7	6.4577	6.61	308351.0
2018-12-11	ABEO	Stock	221.5	224.0	199.0	199.25	30828.0
2018-12-11	ABEV	Stock	4.07	4.11	4.01	4.02	23377100.0
2018-12-11	ABG	Stock	64.55	65.16	62.94	63.92	164100.0
2018-12-11	ABIL-DELISTED	Stock	2.43	2.451	2.33	2.35	107409.0
2018-12-11	ABM	Stock	27.84	28.06	26.65	27.01	619100.0
2018-12-11	ABMD-DELISTED	Stock	330.0	330.8	322.595	328.13	287083.0
2018-12-11	ABR	Stock	11.71	11.73	11.57	11.65	1155400.0
2018-12-11	ABR.A-DELISTED	Stock	25.4975	25.4975	25.25	25.25	987.0
2018-12-11	ABR.B-DELISTED	Stock	25.3973	25.3973	25.2809	25.2809	588.0
2018-12-11	ABR.C-DELISTED	Stock	25.91	25.91	25.59	25.59	378.0

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

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