PREVIEW / stock_daily / 2018-11-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-26.parquet
  size:    221 KB
  rows:    6,570
  symbols: 2,708

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-11-26	AAPL	Stock	43.56	43.7375	42.565	43.655	179994000.0
2018-11-26	MSFT	Stock	104.79	106.63	104.58	106.47	32336200.0
2018-11-26	NVDA	Stock	3.7472	3.8368	3.664	3.8263	814832000.0
2018-11-26	AMZN	Stock	76.95	79.2405	76.211	79.0665	125154000.0
2018-11-26	GOOGL	Stock	52.2	52.85	51.9885	52.797	31558820.0
2018-11-26	META	Stock	133.0	137.0	132.78	136.38	24263600.0
2018-11-26	TSLA	Stock	21.6667	23.0813	21.6667	23.0667	119881500.0
2018-11-26	TLT	Stock	114.86	115.06	114.78	114.88	6599041.0
2018-11-26	ES	Stock	66.91	67.16	66.31	66.8	1934800.0
2018-11-26	CL	Stock	62.02	62.93	61.91	62.74	5082200.0
2018-11-26	A	Stock	68.94	69.3	68.39	69.25	2406300.0
2018-11-26	AA	Stock	32.4	32.86	32.01	32.57	2348200.0
2018-11-26	AABA-DELISTED	Stock	63.48	64.71	63.21	64.38	5301542.0
2018-11-26	AAC-DELISTED	Stock	2.0	2.05	1.95	1.99	362776.0
2018-11-26	AACG	Stock	1.12	1.14	1.03	1.08	82800.0
2018-11-26	AAIC-DELISTED	Stock	8.35	8.44	8.3	8.38	219966.0
2018-11-26	AAL	Stock	38.3	38.62	37.7	38.1	9203100.0
2018-11-26	AAM.A-DELISTED	Stock	24.0689	24.1899	23.93	23.93	22142.0
2018-11-26	AAM.B-DELISTED	Stock	24.19	24.19	23.78	23.86	44450.0
2018-11-26	AAMC-DELISTED	Stock	13.9706	13.9706	13.0262	13.6471	19448.0
2018-11-26	AAME	Stock	2.94	3.11	2.66	2.85	28100.0
2018-11-26	AAMI	Stock	13.05	13.29	12.92	12.98	285700.0
2018-11-26	AAOI	Stock	20.5	21.32	20.12	20.41	1169000.0
2018-11-26	AAON	Stock	25.16	25.6267	25.0267	25.34	221400.0
2018-11-26	AAP	Stock	178.91	180.77	176.92	177.72	658800.0
2018-11-26	AAT	Stock	39.72	39.79	39.32	39.63	112800.0
2018-11-26	AAU-DELISTED	Stock	0.51	0.52	0.5	0.5	74622.0
2018-11-26	AAUAF-DELISTED	Stock	0.51	0.52	0.5	0.5	87411.0
2018-11-26	AAWW-DELISTED	Stock	51.13	52.19	50.605	51.51	134716.0
2018-11-26	AAXJ	Stock	65.67	65.85	65.55	65.82	2752058.0
2018-11-26	AAXN-DELISTED	Stock	47.26	47.6907	46.0401	46.86	283287.0
2018-11-26	AB	Stock	30.37	30.61	29.89	29.92	272500.0
2018-11-26	ABAC-DELISTED	Stock	1.5	1.529	1.5	1.529	3200.0
2018-11-26	ABB-DELISTED	Stock	20.1	20.22	20.05	20.13	3031710.0
2018-11-26	ABBNY-DELISTED	Stock	20.1	20.22	20.05	20.13	3471073.0
2018-11-26	ABBV	Stock	86.39	87.25	85.21	86.24	5227900.0
2018-11-26	ABC-DELISTED	Stock	88.63	89.23	88.02	88.94	678911.0
2018-11-26	ABCB	Stock	42.89	43.63	42.89	43.16	172500.0
2018-11-26	ABCD-DELISTED	Stock	14.5	14.5	14.43	14.455	633865.0
2018-11-26	ABDC-DELISTED	Stock	6.45	6.5	6.3221	6.37	43749.0
2018-11-26	ABEO	Stock	204.75	211.75	202.5	210.0	16940.0
2018-11-26	ABEOW-DELISTED	Stock	4.18	4.18	4.18	4.18	1000.0
2018-11-26	ABEV	Stock	4.14	4.17	4.04	4.06	21904600.0
2018-11-26	ABG	Stock	70.69	71.96	69.99	71.51	470900.0
2018-11-26	ABIL-DELISTED	Stock	3.44	3.45	2.95	2.97	2163848.0
2018-11-26	ABM	Stock	30.51	30.74	29.98	30.44	393600.0
2018-11-26	ABMD-DELISTED	Stock	301.4	312.27	295.2006	311.15	540199.0
2018-11-26	ABR	Stock	12.08	12.17	12.02	12.15	1301100.0
2018-11-26	ABR.A-DELISTED	Stock	25.24	25.36	25.24	25.249	1300.0
2018-11-26	ABR.B-DELISTED	Stock	25.1683	25.1683	25.1	25.1438	1599.0

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

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