PREVIEW / stock_daily / 2018-02-20

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-20.parquet
  size:    216 KB
  rows:    6,486
  symbols: 2,859

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-02-20	AAPL	Stock	43.0125	43.565	42.855	42.9625	135722000.0
2018-02-20	MSFT	Stock	91.48	93.06	91.01	92.72	30911700.0
2018-02-20	NVDA	Stock	6.1188	6.2968	6.115	6.227	686240000.0
2018-02-20	AMZN	Stock	72.3245	74.4385	72.3245	73.4175	129984000.0
2018-02-20	GOOGL	Stock	54.638	55.8145	54.5	55.1795	33753120.0
2018-02-20	META	Stock	175.77	177.95	175.11	176.01	21204900.0
2018-02-20	TSLA	Stock	22.298	22.7227	22.1	22.318	60141000.0
2018-02-20	TLT	Stock	118.28	118.51	117.78	118.19	8268822.0
2018-02-20	ES	Stock	58.78	59.01	57.96	58.17	1145100.0
2018-02-20	CL	Stock	70.8	70.97	69.79	70.03	3016700.0
2018-02-20	A	Stock	71.5	71.85	70.7	71.08	2580400.0
2018-02-20	AA	Stock	46.84	48.74	46.76	48.07	4589500.0
2018-02-20	AABA-DELISTED	Stock	72.83	75.26	72.78	74.61	5132739.0
2018-02-20	AAC-DELISTED	Stock	8.27	8.39	8.06	8.13	85167.0
2018-02-20	AACG	Stock	5.34	5.34	5.34	5.34	200.0
2018-02-20	AAIC-DELISTED	Stock	11.4	11.475	11.15	11.23	698552.0
2018-02-20	AAL	Stock	51.23	52.23	51.1	51.72	3379700.0
2018-02-20	AAM.A-DELISTED	Stock	25.34	25.42	25.283	25.42	27605.0
2018-02-20	AAMC-DELISTED	Stock	18.8824	18.8824	18.7941	18.7941	1068.0
2018-02-20	AAMI	Stock	15.74	15.86	15.47	15.57	662300.0
2018-02-20	AAOI	Stock	32.2	33.98	32.0	33.33	1211200.0
2018-02-20	AAON	Stock	23.2333	23.4	22.8333	22.9	96600.0
2018-02-20	AAP	Stock	107.4	108.38	103.72	105.35	2369200.0
2018-02-20	AAT	Stock	32.46	32.73	32.06	32.22	415000.0
2018-02-20	AAU-DELISTED	Stock	0.98	0.98	0.9	0.92	112817.0
2018-02-20	AAUAF-DELISTED	Stock	0.98	0.98	0.9	0.9201	125378.0
2018-02-20	AAV-DELISTED	Stock	3.0	3.05	2.85	2.9	329132.0
2018-02-20	AAWW-DELISTED	Stock	55.15	55.5	54.25	54.75	238656.0
2018-02-20	AAXJ	Stock	77.75	78.13	77.52	77.86	686016.0
2018-02-20	AAXN-DELISTED	Stock	28.66	28.94	28.06	28.07	532279.0
2018-02-20	AB	Stock	27.3	27.95	27.3	27.75	624400.0
2018-02-20	ABAC-DELISTED	Stock	2.05	2.15	2.05	2.1458	8190.0
2018-02-20	ABAX-DELISTED	Stock	68.62	69.085	67.2701	67.39	80064.0
2018-02-20	ABB-DELISTED	Stock	25.23	25.47	25.19	25.25	2447252.0
2018-02-20	ABBNY-DELISTED	Stock	25.23	25.47	25.19	25.25	2578106.0
2018-02-20	ABBV	Stock	117.72	121.55	117.22	117.98	8751400.0
2018-02-20	ABC-DELISTED	Stock	98.98	100.05	98.52	99.94	1477647.0
2018-02-20	ABCB	Stock	54.35	55.2	53.7	53.95	136200.0
2018-02-20	ABCD-DELISTED	Stock	7.13	7.48	7.13	7.3	54131.0
2018-02-20	ABDC-DELISTED	Stock	7.52	7.7	7.39	7.68	81660.0
2018-02-20	ABE-DELISTED	Stock	15.08	15.08	15.01	15.05	7379.0
2018-02-20	ABEO	Stock	313.75	315.0	287.0	290.0	40256.0
2018-02-20	ABEOW-DELISTED	Stock	7.35	7.35	7.34	7.34	500.0
2018-02-20	ABEV	Stock	6.8	6.94	6.8	6.9	17134600.0
2018-02-20	ABG	Stock	68.6	69.75	67.85	67.95	110800.0
2018-02-20	ABIL-DELISTED	Stock	0.3875	0.3875	0.3802	0.3822	78448.0
2018-02-20	ABLX-DELISTED	Stock	54.13	54.305	54.0	54.03	91796.0
2018-02-20	ABM	Stock	36.41	36.96	36.41	36.71	381700.0
2018-02-20	ABMD-DELISTED	Stock	267.9	273.27	264.45	270.64	355121.0
2018-02-20	ABR	Stock	8.43	8.45	8.3	8.39	461500.0

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

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