PREVIEW / stock_daily / 2018-07-11

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-11.parquet
  size:    217 KB
  rows:    6,490
  symbols: 2,780

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-11	AAPL	Stock	47.125	47.445	46.9025	46.97	75326000.0
2018-07-11	MSFT	Stock	101.15	102.34	101.1	101.98	19644600.0
2018-07-11	NVDA	Stock	6.2375	6.2725	6.1775	6.1882	367508000.0
2018-07-11	AMZN	Stock	86.8995	87.848	86.7	87.75	64196000.0
2018-07-11	GOOGL	Stock	57.781	59.022	57.7687	58.573	33252660.0
2018-07-11	META	Stock	202.22	204.5	201.75	202.54	12927400.0
2018-07-11	TSLA	Stock	21.0533	21.4627	21.0047	21.264	73261500.0
2018-07-11	TLT	Stock	122.45	122.55	122.09	122.42	6869150.0
2018-07-11	ES	Stock	58.86	59.3	58.75	59.25	1770500.0
2018-07-11	CL	Stock	65.73	65.9	65.17	65.24	2345800.0
2018-07-11	A	Stock	62.59	63.28	62.59	62.86	1780500.0
2018-07-11	AA	Stock	46.91	48.3	46.59	48.06	2847300.0
2018-07-11	AABA-DELISTED	Stock	74.78	74.86	73.7	73.72	5439808.0
2018-07-11	AAC-DELISTED	Stock	9.29	10.15	9.25	10.08	224821.0
2018-07-11	AACG	Stock	4.79	4.84	4.23	4.69	7900.0
2018-07-11	AAIC-DELISTED	Stock	10.34	10.425	10.3	10.35	814352.0
2018-07-11	AAL	Stock	38.31	38.34	35.9	35.96	24894200.0
2018-07-11	AAM.A-DELISTED	Stock	25.77	25.8	25.741	25.78	13075.0
2018-07-11	AAM.B-DELISTED	Stock	25.04	25.04	24.95	25.0	64489.0
2018-07-11	AAMC-DELISTED	Stock	19.2353	19.4265	19.2353	19.4265	1979.0
2018-07-11	AAME	Stock	2.5	2.5	2.45	2.45	2100.0
2018-07-11	AAMI	Stock	14.49	14.62	14.04	14.05	738100.0
2018-07-11	AAOI	Stock	45.4	46.0	44.5	45.76	645900.0
2018-07-11	AAON	Stock	23.3667	23.66	23.3667	23.4333	228450.0
2018-07-11	AAP	Stock	139.82	139.82	136.37	139.08	710200.0
2018-07-11	AAT	Stock	38.01	38.41	37.67	38.07	201500.0
2018-07-11	AAU-DELISTED	Stock	0.73	0.74	0.71	0.71	266502.0
2018-07-11	AAUAF-DELISTED	Stock	0.73	0.74	0.71	0.71	290927.0
2018-07-11	AAV-DELISTED	Stock	3.2	3.3	3.1	3.15	193404.0
2018-07-11	AAWW-DELISTED	Stock	71.2	71.3	69.55	70.35	261839.0
2018-07-11	AAXJ	Stock	71.09	71.4099	70.72	70.92	1007085.0
2018-07-11	AAXN-DELISTED	Stock	66.88	67.9891	66.52	66.96	533510.0
2018-07-11	AB	Stock	29.5	29.55	29.0	29.1	219600.0
2018-07-11	ABAC-DELISTED	Stock	2.39	2.41	2.26	2.36	3153.0
2018-07-11	ABAX-DELISTED	Stock	83.25	83.3	83.17	83.25	132485.0
2018-07-11	ABB-DELISTED	Stock	21.66	21.815	21.46	21.51	1861670.0
2018-07-11	ABBNY-DELISTED	Stock	21.66	21.815	21.46	21.5	1947759.0
2018-07-11	ABBV	Stock	96.26	97.5	94.87	94.96	6230000.0
2018-07-11	ABC-DELISTED	Stock	87.11	87.38	85.62	87.11	1113810.0
2018-07-11	ABCB	Stock	52.95	53.25	51.85	52.15	919400.0
2018-07-11	ABCD-DELISTED	Stock	11.4	11.88	11.4	11.53	130734.0
2018-07-11	ABDC-DELISTED	Stock	6.3	6.39	6.22	6.27	33093.0
2018-07-11	ABEO	Stock	366.25	379.5	347.5	376.25	39740.0
2018-07-11	ABEV	Stock	4.76	4.78	4.6	4.61	28638900.0
2018-07-11	ABG	Stock	69.9	70.85	68.5	68.65	151700.0
2018-07-11	ABIL-DELISTED	Stock	6.69	7.18	6.5	7.0	160713.0
2018-07-11	ABM	Stock	30.78	30.97	30.47	30.77	354700.0
2018-07-11	ABMD-DELISTED	Stock	402.67	408.0	399.18	403.81	295466.0
2018-07-11	ABR	Stock	10.81	10.95	10.81	10.94	1976000.0
2018-07-11	ABR.A-DELISTED	Stock	26.025	26.025	25.9501	25.99	3180.0

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

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