PREVIEW / stock_daily / 2018-10-18

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-18.parquet
  size:    220 KB
  rows:    6,528
  symbols: 2,718

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-10-18	AAPL	Stock	54.465	54.935	53.25	54.005	130325200.0
2018-10-18	MSFT	Stock	110.1	110.53	107.83	108.5	32506200.0
2018-10-18	NVDA	Stock	6.1465	6.1852	5.9273	5.9883	524020000.0
2018-10-18	AMZN	Stock	91.0745	91.5075	88.3935	88.536	117480000.0
2018-10-18	GOOGL	Stock	56.5	56.6175	54.317	54.8955	46151920.0
2018-10-18	META	Stock	158.51	158.66	153.28	154.92	21675100.0
2018-10-18	TSLA	Stock	17.9527	18.0667	17.5333	17.594	81318000.0
2018-10-18	TLT	Stock	113.62	114.39	113.55	113.96	5728828.0
2018-10-18	ES	Stock	62.62	62.75	61.81	62.18	1654400.0
2018-10-18	CL	Stock	62.8	63.13	62.33	62.64	3947300.0
2018-10-18	A	Stock	67.12	67.2	65.26	65.75	2327300.0
2018-10-18	AA	Stock	38.61	40.68	38.6	38.85	13826700.0
2018-10-18	AABA-DELISTED	Stock	61.25	61.555	59.74	60.0432	5544670.0
2018-10-18	AAC-DELISTED	Stock	6.88	6.97	6.85	6.9	120142.0
2018-10-18	AACG	Stock	1.28	1.89	1.21	1.31	1507700.0
2018-10-18	AAIC-DELISTED	Stock	8.63	8.65	8.44	8.48	302063.0
2018-10-18	AAL	Stock	33.58	33.76	31.87	32.06	12778300.0
2018-10-18	AAM.A-DELISTED	Stock	23.9784	24.02	23.79	23.84	40661.0
2018-10-18	AAM.B-DELISTED	Stock	23.84	23.9759	23.84	23.92	24256.0
2018-10-18	AAMC-DELISTED	Stock	14.7647	14.7676	13.9176	13.9176	3903.0
2018-10-18	AAME	Stock	2.75	2.97	2.51	2.95	7700.0
2018-10-18	AAMI	Stock	12.35	12.38	11.98	12.0	351600.0
2018-10-18	AAOI	Stock	22.98	23.38	22.21	22.85	841200.0
2018-10-18	AAON	Stock	21.6	21.9067	21.3867	21.46	168450.0
2018-10-18	AAP	Stock	159.72	163.0	158.52	162.19	1393600.0
2018-10-18	AAT	Stock	36.63	37.06	36.39	36.58	65000.0
2018-10-18	AAU-DELISTED	Stock	0.5366	0.5555	0.5311	0.5419	117661.0
2018-10-18	AAUAF-DELISTED	Stock	0.5366	0.5555	0.5311	0.5419	120059.0
2018-10-18	AAWW-DELISTED	Stock	53.4	53.4	52.06	52.44	231454.0
2018-10-18	AAXJ	Stock	64.07	64.1195	62.98	63.26	1144061.0
2018-10-18	AAXN-DELISTED	Stock	61.11	61.9	58.17	58.23	425409.0
2018-10-18	AB	Stock	30.64	30.64	29.83	29.87	408800.0
2018-10-18	ABAC-DELISTED	Stock	1.882	1.95	1.83	1.87	15859.0
2018-10-18	ABB-DELISTED	Stock	21.34	21.42	21.11	21.225	2905964.0
2018-10-18	ABBNY-DELISTED	Stock	21.34	21.42	21.11	21.21	3275783.0
2018-10-18	ABBV	Stock	91.85	92.4	89.22	89.9	4422300.0
2018-10-18	ABC-DELISTED	Stock	93.96	94.28	92.54	93.37	669813.0
2018-10-18	ABCB	Stock	43.8	44.06	42.8	43.08	352600.0
2018-10-18	ABCD-DELISTED	Stock	14.37	14.39	14.37	14.38	254000.0
2018-10-18	ABDC-DELISTED	Stock	5.95	5.98	5.92	5.945	36772.0
2018-10-18	ABEO	Stock	249.0	250.25	238.5	242.75	22120.0
2018-10-18	ABEV	Stock	4.61	4.62	4.45	4.45	24868900.0
2018-10-18	ABG	Stock	60.47	60.56	58.92	59.04	656700.0
2018-10-18	ABIL-DELISTED	Stock	3.09	3.25	2.98	3.16	21664.0
2018-10-18	ABM	Stock	32.43	32.64	31.53	31.86	450400.0
2018-10-18	ABMD-DELISTED	Stock	389.47	389.96	380.0542	386.53	303863.0
2018-10-18	ABR	Stock	11.91	11.99	11.8	11.84	580900.0
2018-10-18	ABR.A-DELISTED	Stock	25.51	25.51	25.51	25.51	100.0
2018-10-18	ABR.B-DELISTED	Stock	25.3	25.3	25.3	25.3	256.0
2018-10-18	ABR.C-DELISTED	Stock	25.735	25.7691	25.65	25.71	2329.0

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

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