PREVIEW / stock_daily / 2017-11-28

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-28.parquet
  size:    218 KB
  rows:    6,515
  symbols: 2,926

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
2017-11-28	AAPL	Stock	43.575	43.7175	42.965	43.2675	105715200.0
2017-11-28	MSFT	Stock	84.07	85.06	84.02	84.88	21926000.0
2017-11-28	NVDA	Stock	5.3588	5.3682	5.206	5.2678	512752000.0
2017-11-28	AMZN	Stock	60.244	60.267	59.426	59.68	91188000.0
2017-11-28	GOOGL	Stock	53.6995	54.0	52.727	53.1645	36423420.0
2017-11-28	META	Stock	183.51	184.25	182.09	182.42	14379700.0
2017-11-28	TSLA	Stock	21.0907	21.3333	20.928	21.17	74242500.0
2017-11-28	TLT	Stock	126.77	127.18	126.47	126.79	5983021.0
2017-11-28	ES	Stock	64.57	64.96	64.45	64.56	1217700.0
2017-11-28	CL	Stock	72.31	72.84	72.25	72.76	2703600.0
2017-11-28	A	Stock	69.56	70.93	69.42	70.59	2473400.0
2017-11-28	AA	Stock	41.81	43.75	41.21	43.3	8604200.0
2017-11-28	AAAP-DELISTED	Stock	81.35	81.35	81.25	81.25	958422.0
2017-11-28	AABA-DELISTED	Stock	72.25	72.48	71.49	71.99	11095356.0
2017-11-28	AAC-DELISTED	Stock	8.59	9.03	8.565	8.98	156771.0
2017-11-28	AACG	Stock	5.15	5.16	5.09	5.13	5200.0
2017-11-28	AAIC-DELISTED	Stock	11.74	11.87	11.7299	11.84	338770.0
2017-11-28	AAL	Stock	48.44	49.42	48.2	49.22	3864100.0
2017-11-28	AAM.A-DELISTED	Stock	26.26	26.43	26.26	26.43	43700.0
2017-11-28	AAMC-DELISTED	Stock	22.3529	22.4628	22.2059	22.2059	8106.0
2017-11-28	AAME	Stock	3.63	3.63	3.63	3.63	600.0
2017-11-28	AAMI	Stock	16.07	16.27	16.04	16.09	1672700.0
2017-11-28	AAOI	Stock	41.5	43.33	41.26	42.68	1180000.0
2017-11-28	AAON	Stock	23.6333	24.0	23.5333	24.0	192900.0
2017-11-28	AAP	Stock	89.89	92.91	89.63	92.84	1145400.0
2017-11-28	AAT	Stock	39.3	39.73	39.06	39.71	293600.0
2017-11-28	AAU-DELISTED	Stock	0.9	0.91	0.86	0.8845	297513.0
2017-11-28	AAUAF-DELISTED	Stock	0.9	0.91	0.86	0.8845	306125.0
2017-11-28	AAV-DELISTED	Stock	4.7	4.75	4.65	4.65	120666.0
2017-11-28	AAWW-DELISTED	Stock	54.9	56.4	54.65	56.15	337750.0
2017-11-28	AAXJ	Stock	77.42	77.6	77.15	77.52	1042447.0
2017-11-28	AAXN-DELISTED	Stock	24.46	25.01	24.27	24.86	445909.0
2017-11-28	AB	Stock	25.2	25.55	25.0	25.5	235700.0
2017-11-28	ABAC-DELISTED	Stock	3.23	3.289	3.08	3.1135	25244.0
2017-11-28	ABAX-DELISTED	Stock	49.835	50.28	49.72	49.93	45367.0
2017-11-28	ABB-DELISTED	Stock	25.71	25.875	25.69	25.82	1910382.0
2017-11-28	ABBNY-DELISTED	Stock	25.71	25.875	25.69	25.83	2138659.0
2017-11-28	ABBV	Stock	95.94	96.89	94.83	95.42	5105400.0
2017-11-28	ABC-DELISTED	Stock	81.4	83.185	80.65	83.17	1338737.0
2017-11-28	ABCB	Stock	48.4	49.9	48.3	49.85	242800.0
2017-11-28	ABCD-DELISTED	Stock	5.76	5.86	5.66	5.81	28633.0
2017-11-28	ABDC-DELISTED	Stock	8.0	8.27	7.99	8.25	290091.0
2017-11-28	ABE-DELISTED	Stock	14.2527	14.38	14.2385	14.25	7187.0
2017-11-28	ABEO	Stock	416.25	437.5	408.75	433.75	29892.0
2017-11-28	ABEOW-DELISTED	Stock	11.99	12.26	11.99	12.26	1490.0
2017-11-28	ABEV	Stock	6.38	6.49	6.37	6.43	24501800.0
2017-11-28	ABG	Stock	64.6	65.45	64.15	65.25	214300.0
2017-11-28	ABIL-DELISTED	Stock	0.51	0.53	0.51	0.5178	113988.0
2017-11-28	ABLX-DELISTED	Stock	22.75	22.81	22.466	22.62	171973.0
2017-11-28	ABM	Stock	41.29	42.41	41.06	42.11	316200.0

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

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