PREVIEW / stock_daily / 2018-08-09

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-09.parquet
  size:    218 KB
  rows:    6,511
  symbols: 2,748

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-08-09	AAPL	Stock	52.3825	52.445	51.8	52.22	93970400.0
2018-08-09	MSFT	Stock	109.71	110.16	109.6	109.67	13677200.0
2018-08-09	NVDA	Stock	6.4785	6.4812	6.4037	6.4115	204280000.0
2018-08-09	AMZN	Stock	94.1	95.7285	93.874	94.926	97208000.0
2018-08-09	GOOGL	Stock	63.1365	63.5982	63.0051	63.223	27326360.0
2018-08-09	META	Stock	185.85	186.57	182.48	183.09	19732100.0
2018-08-09	TSLA	Stock	24.37	24.4673	23.0487	23.4967	257757000.0
2018-08-09	TLT	Stock	119.23	119.83	119.12	119.79	7144257.0
2018-08-09	ES	Stock	60.98	61.25	60.71	61.14	982400.0
2018-08-09	CL	Stock	66.46	66.67	65.88	65.93	2979200.0
2018-08-09	A	Stock	67.48	67.62	66.61	66.69	1727800.0
2018-08-09	AA	Stock	44.27	44.4	42.81	42.99	3058400.0
2018-08-09	AABA-DELISTED	Stock	70.82	71.45	70.31	70.45	25195414.0
2018-08-09	AAC-DELISTED	Stock	8.77	9.54	8.77	9.28	107089.0
2018-08-09	AACG	Stock	5.9	5.99	5.84	5.89	225800.0
2018-08-09	AAIC-DELISTED	Stock	10.23	10.3034	10.22	10.23	235387.0
2018-08-09	AAL	Stock	38.55	38.74	37.89	37.92	3699400.0
2018-08-09	AAM.A-DELISTED	Stock	25.5	25.5	25.43	25.43	11949.0
2018-08-09	AAM.B-DELISTED	Stock	25.01	25.1	25.0	25.09	23651.0
2018-08-09	AAMC-DELISTED	Stock	18.8383	20.4295	18.8383	20.3088	6212.0
2018-08-09	AAME	Stock	2.5	2.5	2.5	2.5	100.0
2018-08-09	AAMI	Stock	12.35	12.53	12.34	12.47	523100.0
2018-08-09	AAOI	Stock	41.17	42.15	39.75	40.1	1707300.0
2018-08-09	AAON	Stock	25.8667	26.5	25.8667	26.2	491400.0
2018-08-09	AAP	Stock	146.92	148.7	146.46	147.79	763400.0
2018-08-09	AAT	Stock	38.9	39.0	38.6	38.81	128300.0
2018-08-09	AAU-DELISTED	Stock	0.66	0.665	0.6531	0.66	45384.0
2018-08-09	AAUAF-DELISTED	Stock	0.66	0.665	0.6531	0.66	47086.0
2018-08-09	AAV-DELISTED	Stock	3.15	3.2	3.1	3.15	46910.0
2018-08-09	AAWW-DELISTED	Stock	61.8	62.075	61.55	61.675	174168.0
2018-08-09	AAXJ	Stock	72.56	72.7901	72.35	72.38	2415589.0
2018-08-09	AAXN-DELISTED	Stock	60.5	61.86	59.22	59.29	901892.0
2018-08-09	AB	Stock	29.4	29.65	29.35	29.45	232400.0
2018-08-09	ABAC-DELISTED	Stock	2.15	2.24	2.15	2.23	2104.0
2018-08-09	ABB-DELISTED	Stock	23.06	23.1174	22.87	22.89	1961890.0
2018-08-09	ABBNY-DELISTED	Stock	23.06	23.1174	22.87	22.9	2087173.0
2018-08-09	ABBV	Stock	94.2	96.14	93.47	95.47	6176100.0
2018-08-09	ABC-DELISTED	Stock	82.72	84.52	82.35	83.25	1102222.0
2018-08-09	ABCB	Stock	49.4	49.75	48.7	48.88	207200.0
2018-08-09	ABCD-DELISTED	Stock	11.65	11.87	11.5	11.85	134705.0
2018-08-09	ABDC-DELISTED	Stock	6.17	6.27	6.16	6.2	28230.0
2018-08-09	ABEO	Stock	368.75	380.0	361.25	363.75	18408.0
2018-08-09	ABEV	Stock	5.06	5.09	5.01	5.05	42780100.0
2018-08-09	ABG	Stock	75.55	75.9	74.85	75.4	192200.0
2018-08-09	ABIL-DELISTED	Stock	5.35	5.94	4.925	5.05	2312844.0
2018-08-09	ABM	Stock	31.42	31.58	31.15	31.17	547900.0
2018-08-09	ABMD-DELISTED	Stock	377.0	386.58	377.0	380.7	249601.0
2018-08-09	ABR	Stock	11.33	11.51	11.3	11.46	1144800.0
2018-08-09	ABR.A-DELISTED	Stock	26.1119	26.1119	25.8971	25.8971	1485.0
2018-08-09	ABR.B-DELISTED	Stock	25.6788	25.6788	25.6788	25.6788	100.0

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

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