PREVIEW / stock_daily / 2019-01-28

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-28.parquet
  size:    219 KB
  rows:    6,545
  symbols: 2,655

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
2019-01-28	AAPL	Stock	38.9475	39.0825	38.415	39.075	104768400.0
2019-01-28	MSFT	Stock	106.26	106.48	104.66	105.08	29476700.0
2019-01-28	NVDA	Stock	3.4138	3.541	3.275	3.4502	2511528000.0
2019-01-28	AMZN	Stock	82.1795	82.25	80.7045	81.8945	96754000.0
2019-01-28	GOOGL	Stock	54.5035	54.6682	53.7305	53.993	29334280.0
2019-01-28	META	Stock	148.05	148.96	146.21	147.47	15508500.0
2019-01-28	TSLA	Stock	19.5273	19.8307	19.1833	19.7587	96349500.0
2019-01-28	TLT	Stock	120.54	120.94	120.41	120.41	6435820.0
2019-01-28	ES	Stock	67.42	67.66	66.68	67.11	1549000.0
2019-01-28	CL	Stock	61.71	62.84	61.6	62.74	5768200.0
2019-01-28	A	Stock	72.76	73.28	72.41	73.27	1729600.0
2019-01-28	AA	Stock	28.74	28.83	27.81	27.98	3538100.0
2019-01-28	AABA-DELISTED	Stock	64.48	65.485	63.98	65.24	4539640.0
2019-01-28	AAC-DELISTED	Stock	2.37	2.4	2.2	2.21	182641.0
2019-01-28	AACG	Stock	1.07	1.07	1.0	1.0	22500.0
2019-01-28	AAIC-DELISTED	Stock	8.3	8.48	8.3	8.45	227289.0
2019-01-28	AAL	Stock	34.53	36.62	34.5	36.57	14843500.0
2019-01-28	AAM.A-DELISTED	Stock	24.47	24.56	24.36	24.5124	22976.0
2019-01-28	AAM.B-DELISTED	Stock	24.43	24.5	24.301	24.4458	46709.0
2019-01-28	AAMC-DELISTED	Stock	7.7941	7.8676	7.6471	7.65	4539.0
2019-01-28	AAME	Stock	2.66	2.66	2.66	2.66	100.0
2019-01-28	AAMI	Stock	12.32	12.61	12.27	12.36	597000.0
2019-01-28	AAOI	Stock	17.09	17.49	16.71	16.89	587300.0
2019-01-28	AAON	Stock	23.5867	23.9467	23.42	23.7333	129300.0
2019-01-28	AAP	Stock	151.65	155.05	150.05	154.86	1311500.0
2019-01-28	AAT	Stock	41.2	41.9	41.03	41.74	325200.0
2019-01-28	AAU-DELISTED	Stock	0.7647	0.79	0.7347	0.7649	133516.0
2019-01-28	AAUAF-DELISTED	Stock	0.7647	0.79	0.7347	0.7649	143195.0
2019-01-28	AAWW-DELISTED	Stock	50.55	51.93	50.5	51.3	125141.0
2019-01-28	AAXJ	Stock	66.98	67.19	66.74	67.18	1507837.0
2019-01-28	AAXN-DELISTED	Stock	48.79	49.39	48.345	49.12	236542.0
2019-01-28	AB	Stock	30.1	30.42	30.1	30.32	194400.0
2019-01-28	ABB-DELISTED	Stock	19.15	19.23	19.02	19.22	2251436.0
2019-01-28	ABBNY-DELISTED	Stock	19.15	19.23	19.02	19.21	2334557.0
2019-01-28	ABBV	Stock	80.0	80.1	76.68	77.14	14718800.0
2019-01-28	ABC-DELISTED	Stock	79.47	80.31	78.88	80.13	666911.0
2019-01-28	ABCB	Stock	35.85	37.88	35.85	37.61	642000.0
2019-01-28	ABDC-DELISTED	Stock	6.86	6.88	6.82	6.87	67665.0
2019-01-28	ABEO	Stock	172.5	175.75	167.75	173.5	9404.0
2019-01-28	ABEOW-DELISTED	Stock	2.66	2.8	2.66	2.8	657.0
2019-01-28	ABEV	Stock	4.61	4.74	4.59	4.73	29453900.0
2019-01-28	ABG	Stock	68.76	70.58	68.63	69.56	101700.0
2019-01-28	ABIL-DELISTED	Stock	2.09	2.21	2.05	2.1232	596056.0
2019-01-28	ABM	Stock	33.67	33.86	33.15	33.86	636800.0
2019-01-28	ABMD-DELISTED	Stock	348.9	349.995	333.7612	336.86	297890.0
2019-01-28	ABR	Stock	11.47	11.57	11.43	11.56	614000.0
2019-01-28	ABR.A-DELISTED	Stock	25.6879	25.76	25.6	25.7485	4616.0
2019-01-28	ABT	Stock	70.52	70.63	68.89	69.05	5942500.0
2019-01-28	ABTC	Stock	305400.0	305400.0	304200.0	304200.0	1.5466666666666666
2019-01-28	ABTS	Stock	55.05	55.05	47.25	48.0	1112.0

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

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