PREVIEW / stock_daily / 2018-07-20

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-20.parquet
  size:    216 KB
  rows:    6,457
  symbols: 2,742

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-07-20	AAPL	Stock	47.945	48.1075	47.5425	47.86	82704800.0
2018-07-20	MSFT	Stock	108.08	108.2	106.08	106.27	56004000.0
2018-07-20	NVDA	Stock	6.2982	6.3375	6.2613	6.2722	222352000.0
2018-07-20	AMZN	Stock	91.2505	91.742	90.503	90.685	77688000.0
2018-07-20	GOOGL	Stock	59.962	60.5382	59.8295	59.894	37967520.0
2018-07-20	META	Stock	208.85	211.5	208.5	209.94	16163900.0
2018-07-20	TSLA	Stock	21.4153	21.5493	20.7807	20.9053	77433000.0
2018-07-20	TLT	Stock	121.58	121.59	120.7	120.76	10469693.0
2018-07-20	ES	Stock	58.98	59.05	58.34	58.75	1737600.0
2018-07-20	CL	Stock	65.65	66.13	65.39	65.95	3264300.0
2018-07-20	A	Stock	63.83	64.33	63.68	63.85	1619900.0
2018-07-20	AA	Stock	41.53	41.55	40.03	40.32	9835500.0
2018-07-20	AABA-DELISTED	Stock	73.78	74.07	73.03	73.28	4432379.0
2018-07-20	AAC-DELISTED	Stock	9.63	9.9	9.51	9.55	135581.0
2018-07-20	AACG	Stock	4.36	4.36	4.21	4.21	8000.0
2018-07-20	AAIC-DELISTED	Stock	10.28	10.28	9.88	9.97	1265254.0
2018-07-20	AAL	Stock	37.96	38.38	37.81	37.88	5302700.0
2018-07-20	AAM.A-DELISTED	Stock	25.54	25.6	25.4773	25.5	34851.0
2018-07-20	AAM.B-DELISTED	Stock	24.99	25.03	24.9866	25.03	35697.0
2018-07-20	AAMC-DELISTED	Stock	19.0	19.4117	18.8676	18.8676	4988.0
2018-07-20	AAME	Stock	2.6	2.6	2.5	2.6	5000.0
2018-07-20	AAMI	Stock	13.9	13.99	13.79	13.79	731400.0
2018-07-20	AAOI	Stock	42.37	42.5	41.15	41.78	1309900.0
2018-07-20	AAON	Stock	24.3667	24.7333	24.2333	24.5	171750.0
2018-07-20	AAP	Stock	142.85	143.44	141.73	142.67	585700.0
2018-07-20	AAT	Stock	38.13	38.21	37.49	37.57	142400.0
2018-07-20	AAU-DELISTED	Stock	0.69	0.69	0.689	0.6899	120280.0
2018-07-20	AAUAF-DELISTED	Stock	0.69	0.69	0.689	0.6899	123469.0
2018-07-20	AAV-DELISTED	Stock	3.2	3.325	3.15	3.3	184765.0
2018-07-20	AAWW-DELISTED	Stock	69.2	69.5	68.6	69.0	199531.0
2018-07-20	AAXJ	Stock	71.59	72.07	71.59	72.01	528013.0
2018-07-20	AAXN-DELISTED	Stock	73.49	74.75	72.51	73.84	647226.0
2018-07-20	AB	Stock	29.95	30.1	29.75	29.9	215000.0
2018-07-20	ABAC-DELISTED	Stock	2.48	2.55	2.15	2.21	61330.0
2018-07-20	ABAX-DELISTED	Stock	83.25	83.33	83.21	83.27	114522.0
2018-07-20	ABB-DELISTED	Stock	22.2	22.47	22.18	22.32	3560897.0
2018-07-20	ABBNY-DELISTED	Stock	22.2	22.47	22.18	22.32	3681723.0
2018-07-20	ABBV	Stock	88.71	89.64	86.76	88.91	11791900.0
2018-07-20	ABC-DELISTED	Stock	84.78	85.53	83.31	84.69	1064968.0
2018-07-20	ABCB	Stock	51.5	51.95	51.35	51.85	291300.0
2018-07-20	ABCD-DELISTED	Stock	12.1	12.41	12.05	12.09	104708.0
2018-07-20	ABDC-DELISTED	Stock	6.27	6.51	6.18	6.39	33901.0
2018-07-20	ABEO	Stock	355.0	365.0	355.0	358.75	16680.0
2018-07-20	ABEV	Stock	5.05	5.07	4.92	4.93	37297300.0
2018-07-20	ABG	Stock	69.25	69.45	68.2	69.35	196500.0
2018-07-20	ABIL-DELISTED	Stock	5.33	5.37	5.06	5.06	56722.0
2018-07-20	ABM	Stock	30.08	30.12	29.77	29.94	468000.0
2018-07-20	ABMD-DELISTED	Stock	427.0	429.7755	422.32	423.48	543125.0
2018-07-20	ABR	Stock	11.2	11.28	11.19	11.23	888000.0
2018-07-20	ABR.A-DELISTED	Stock	25.69	25.85	25.68	25.8	3880.0

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

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