PREVIEW / stock_daily / 2018-01-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-12.parquet
  size:    218 KB
  rows:    6,489
  symbols: 2,877

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-01-12	AAPL	Stock	44.045	44.34	43.9125	44.2725	101672400.0
2018-01-12	MSFT	Stock	88.67	89.78	88.45	89.6	24271500.0
2018-01-12	NVDA	Stock	5.59	5.6248	5.5335	5.5745	359916000.0
2018-01-12	AMZN	Stock	63.6695	65.288	63.6695	65.26	108874000.0
2018-01-12	GOOGL	Stock	55.505	56.5651	55.4005	56.5325	38586120.0
2018-01-12	META	Stock	178.06	181.48	177.4	179.37	77551300.0
2018-01-12	TSLA	Stock	22.5753	22.694	22.2447	22.4147	72376500.0
2018-01-12	TLT	Stock	124.1	124.79	123.91	124.52	9987129.0
2018-01-12	ES	Stock	61.42	61.92	61.22	61.35	2804700.0
2018-01-12	CL	Stock	74.76	74.83	74.21	74.62	2338200.0
2018-01-12	A	Stock	70.73	71.86	70.5	71.73	1448100.0
2018-01-12	AA	Stock	57.05	57.5	56.11	56.76	4216600.0
2018-01-12	AAAP-DELISTED	Stock	81.85	81.89	81.81	81.825	159278.0
2018-01-12	AABA-DELISTED	Stock	76.45	76.5905	75.68	75.84	3210154.0
2018-01-12	AAC-DELISTED	Stock	9.28	9.48	9.16	9.26	83339.0
2018-01-12	AACG	Stock	5.25	5.5	5.25	5.49	6300.0
2018-01-12	AAIC-DELISTED	Stock	11.81	11.93	11.8	11.91	307631.0
2018-01-12	AAL	Stock	56.56	58.73	56.56	58.47	7505800.0
2018-01-12	AAM.A-DELISTED	Stock	26.0564	26.16	25.7833	25.98	24216.0
2018-01-12	AAME	Stock	3.3	3.35	3.3	3.35	3700.0
2018-01-12	AAMI	Stock	17.94	18.37	17.94	18.34	417100.0
2018-01-12	AAOI	Stock	36.31	36.67	35.35	35.85	837300.0
2018-01-12	AAON	Stock	24.2667	24.4467	23.5	24.3667	335550.0
2018-01-12	AAP	Stock	114.38	116.05	113.02	115.94	1579100.0
2018-01-12	AAT	Stock	36.34	36.34	35.86	36.04	128900.0
2018-01-12	AAU-DELISTED	Stock	1.0	1.02	0.9877	1.01	165353.0
2018-01-12	AAUAF-DELISTED	Stock	1.0	1.02	0.9877	1.01	180078.0
2018-01-12	AAV-DELISTED	Stock	3.75	3.9	3.6	3.8	688337.0
2018-01-12	AAWW-DELISTED	Stock	61.55	62.25	60.9	62.0	480369.0
2018-01-12	AAXJ	Stock	79.48	80.15	79.3822	80.15	1162092.0
2018-01-12	AAXN-DELISTED	Stock	26.99	27.75	26.87	27.56	513380.0
2018-01-12	AB	Stock	27.3	27.7	27.15	27.2	277100.0
2018-01-12	ABAC-DELISTED	Stock	2.98	3.03	2.85	2.97	5491.0
2018-01-12	ABAX-DELISTED	Stock	62.29	62.91	61.6601	62.42	195416.0
2018-01-12	ABB-DELISTED	Stock	27.87	28.125	27.84	28.09	1263144.0
2018-01-12	ABBNY-DELISTED	Stock	27.87	28.125	27.84	28.09	1555373.0
2018-01-12	ABBV	Stock	99.34	100.64	98.66	100.34	4372600.0
2018-01-12	ABC-DELISTED	Stock	98.5	99.0	97.55	98.99	1265761.0
2018-01-12	ABCB	Stock	52.7	53.45	52.55	53.4	183200.0
2018-01-12	ABCD-DELISTED	Stock	6.31	6.7899	6.31	6.66	203748.0
2018-01-12	ABDC-DELISTED	Stock	8.72	9.0	8.61	8.87	215455.0
2018-01-12	ABE-DELISTED	Stock	15.22	15.2892	15.2	15.21	10623.0
2018-01-12	ABEO	Stock	397.5	398.75	386.25	392.5	14564.0
2018-01-12	ABEOW-DELISTED	Stock	10.835	10.835	10.5784	10.61	13258.0
2018-01-12	ABEV	Stock	6.7	6.79	6.64	6.67	25879400.0
2018-01-12	ABG	Stock	74.7	76.15	74.5	75.3	227500.0
2018-01-12	ABIL-DELISTED	Stock	0.495	0.5795	0.4799	0.56	923882.0
2018-01-12	ABLX-DELISTED	Stock	44.53	44.64	41.55	41.82	608352.0
2018-01-12	ABM	Stock	38.96	39.16	38.7	38.87	390300.0
2018-01-12	ABMD-DELISTED	Stock	210.72	216.1534	210.36	215.19	204810.0

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

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