PREVIEW / stock_daily / 2018-02-01

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-01.parquet
  size:    217 KB
  rows:    6,488
  symbols: 2,879

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-01	AAPL	Stock	41.7925	42.155	41.69	41.945	188923200.0
2018-02-01	MSFT	Stock	94.79	96.07	93.58	94.26	47227900.0
2018-02-01	NVDA	Stock	5.963	6.1725	5.9515	6.0125	519224000.0
2018-02-01	AMZN	Stock	72.25	72.994	69.257	69.5	182276000.0
2018-02-01	GOOGL	Stock	58.7995	59.3725	58.468	59.0795	73514180.0
2018-02-01	META	Stock	188.22	195.32	187.89	193.09	54211300.0
2018-02-01	TSLA	Stock	23.4	23.9773	23.242	23.2833	62965500.0
2018-02-01	TLT	Stock	122.48	122.53	120.625	120.7	18632780.0
2018-02-01	ES	Stock	63.14	63.42	59.33	60.16	5772000.0
2018-02-01	CL	Stock	74.33	74.63	73.18	73.33	3900300.0
2018-02-01	A	Stock	73.18	73.78	72.51	72.83	2008200.0
2018-02-01	AA	Stock	51.41	52.5	51.27	52.42	3176500.0
2018-02-01	AAAP-DELISTED	Stock	80.1	81.25	79.9	81.25	17620.0
2018-02-01	AABA-DELISTED	Stock	76.48	78.36	75.6911	75.99	6997315.0
2018-02-01	AAC-DELISTED	Stock	8.9	8.9	8.5	8.64	87684.0
2018-02-01	AACG	Stock	5.0	5.0	4.75	4.76	8400.0
2018-02-01	AAIC-DELISTED	Stock	10.5	10.765	10.498	10.61	489184.0
2018-02-01	AAL	Stock	54.0	54.64	53.59	53.88	3623100.0
2018-02-01	AAM.A-DELISTED	Stock	25.43	25.43	25.2306	25.2777	37173.0
2018-02-01	AAMC-DELISTED	Stock	19.5882	19.9118	19.2647	19.9118	11825.0
2018-02-01	AAMI	Stock	18.0	18.0	17.03	17.66	1405100.0
2018-02-01	AAOI	Stock	32.5	33.6	32.342	33.49	627300.0
2018-02-01	AAON	Stock	24.1667	24.3667	23.9667	24.1	190200.0
2018-02-01	AAP	Stock	116.24	118.83	115.83	117.29	760600.0
2018-02-01	AAT	Stock	35.25	35.43	34.33	34.59	326600.0
2018-02-01	AAU-DELISTED	Stock	0.8959	0.9047	0.86	0.9001	121902.0
2018-02-01	AAUAF-DELISTED	Stock	0.8959	0.9047	0.86	0.9001	124744.0
2018-02-01	AAV-DELISTED	Stock	3.2	3.3	3.15	3.3	232422.0
2018-02-01	AAWW-DELISTED	Stock	56.0	57.3	55.7	56.65	153542.0
2018-02-01	AAXJ	Stock	81.04	81.29	80.5	80.6	1785975.0
2018-02-01	AAXN-DELISTED	Stock	26.33	26.37	25.75	25.83	651002.0
2018-02-01	AB	Stock	27.2	27.6	27.05	27.25	413000.0
2018-02-01	ABAC-DELISTED	Stock	2.81	2.83	2.6553	2.77	5329.0
2018-02-01	ABAX-DELISTED	Stock	71.4	73.2	70.28	72.67	174378.0
2018-02-01	ABB-DELISTED	Stock	27.96	28.13	27.92	28.06	1532526.0
2018-02-01	ABBNY-DELISTED	Stock	27.96	28.13	27.92	28.06	1605739.0
2018-02-01	ABBV	Stock	112.24	117.53	112.23	116.34	9943500.0
2018-02-01	ABC-DELISTED	Stock	97.74	99.81	95.73	99.29	2415013.0
2018-02-01	ABCB	Stock	53.4	54.55	53.3	54.5	192100.0
2018-02-01	ABCD-DELISTED	Stock	7.0	7.01	6.82	6.95	89096.0
2018-02-01	ABDC-DELISTED	Stock	7.92	7.98	7.85	7.92	91717.0
2018-02-01	ABE-DELISTED	Stock	15.5918	15.62	15.505	15.6	4854.0
2018-02-01	ABEO	Stock	381.25	397.5	370.0	391.25	31204.0
2018-02-01	ABEOW-DELISTED	Stock	10.24	10.5	10.24	10.5	300.0
2018-02-01	ABEV	Stock	6.95	7.04	6.91	6.95	29936700.0
2018-02-01	ABG	Stock	72.7	73.15	71.45	71.85	225500.0
2018-02-01	ABIL-DELISTED	Stock	0.465	0.478	0.415	0.422	224433.0
2018-02-01	ABLX-DELISTED	Stock	54.54	54.85	54.48	54.74	594195.0
2018-02-01	ABM	Stock	37.98	38.11	37.54	37.73	405500.0
2018-02-01	ABMD-DELISTED	Stock	238.0	253.88	238.0	252.6	788416.0

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

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