PREVIEW / stock_daily / 2018-01-30

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-30.parquet
  size:    217 KB
  rows:    6,486
  symbols: 2,869

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-30	AAPL	Stock	41.3825	41.8425	41.175	41.7425	184192800.0
2018-01-30	MSFT	Stock	93.3	93.66	92.1	92.74	38635100.0
2018-01-30	NVDA	Stock	6.0278	6.1605	5.9602	6.068	570832000.0
2018-01-30	AMZN	Stock	70.1585	71.9625	69.6	71.891	117438000.0
2018-01-30	GOOGL	Stock	58.886	59.3965	58.7255	58.8685	37337660.0
2018-01-30	META	Stock	187.62	188.18	181.84	187.12	20858600.0
2018-01-30	TSLA	Stock	23.0093	23.218	22.8113	23.0547	70765500.0
2018-01-30	TLT	Stock	122.28	122.37	121.7	122.01	12064454.0
2018-01-30	ES	Stock	62.38	63.15	62.23	62.56	2353000.0
2018-01-30	CL	Stock	73.78	74.76	73.12	74.67	6027700.0
2018-01-30	A	Stock	73.99	74.08	72.93	72.99	1817000.0
2018-01-30	AA	Stock	53.67	53.97	52.52	52.52	3655400.0
2018-01-30	AAAP-DELISTED	Stock	81.95	82.2	81.95	82.11	15908.0
2018-01-30	AABA-DELISTED	Stock	77.58	79.27	76.7606	78.25	5995613.0
2018-01-30	AAC-DELISTED	Stock	9.4	9.48	9.0	9.08	74344.0
2018-01-30	AACG	Stock	5.03	5.04	5.03	5.04	12600.0
2018-01-30	AAIC-DELISTED	Stock	10.8	10.92	10.73	10.77	423187.0
2018-01-30	AAL	Stock	52.45	53.05	52.36	52.59	4741800.0
2018-01-30	AAM.A-DELISTED	Stock	25.25	25.25	25.05	25.1699	52882.0
2018-01-30	AAMC-DELISTED	Stock	19.6912	20.3012	19.6912	20.3012	2088.0
2018-01-30	AAME	Stock	3.75	3.75	3.75	3.75	1300.0
2018-01-30	AAMI	Stock	18.0	18.15	17.84	17.96	806900.0
2018-01-30	AAOI	Stock	32.74	33.42	32.12	32.84	960600.0
2018-01-30	AAON	Stock	24.0	24.1667	23.8333	24.0	309600.0
2018-01-30	AAP	Stock	121.57	122.7	117.58	119.27	1889700.0
2018-01-30	AAT	Stock	34.9	35.04	34.78	34.84	147800.0
2018-01-30	AAU-DELISTED	Stock	0.88	0.89	0.865	0.87	340024.0
2018-01-30	AAUAF-DELISTED	Stock	0.88	0.89	0.865	0.87	365467.0
2018-01-30	AAV-DELISTED	Stock	3.45	3.45	3.25	3.325	196447.0
2018-01-30	AAWW-DELISTED	Stock	58.3	59.0	56.65	57.55	250391.0
2018-01-30	AAXJ	Stock	81.56	81.64	80.98	81.17	1820479.0
2018-01-30	AAXN-DELISTED	Stock	27.13	27.86	26.7308	27.36	1045701.0
2018-01-30	AB	Stock	27.45	27.7	27.2	27.6	264000.0
2018-01-30	ABAC-DELISTED	Stock	2.85	2.94	2.82	2.82	2952.0
2018-01-30	ABAX-DELISTED	Stock	74.19	75.69	73.8	74.24	392893.0
2018-01-30	ABB-DELISTED	Stock	28.12	28.1205	27.88	27.95	1651751.0
2018-01-30	ABBNY-DELISTED	Stock	28.12	28.1205	27.88	27.96	1755385.0
2018-01-30	ABBV	Stock	119.42	121.45	115.87	115.88	11851400.0
2018-01-30	ABC-DELISTED	Stock	102.0	103.65	100.03	102.48	2808291.0
2018-01-30	ABCB	Stock	54.75	55.9	54.6	54.95	222300.0
2018-01-30	ABCD-DELISTED	Stock	7.09	7.18	7.05	7.08	79556.0
2018-01-30	ABDC-DELISTED	Stock	8.13	8.1412	7.95	7.96	65194.0
2018-01-30	ABE-DELISTED	Stock	15.56	15.61	15.46	15.53	12166.0
2018-01-30	ABEO	Stock	401.25	401.25	368.25	382.5	56380.0
2018-01-30	ABEOW-DELISTED	Stock	10.665	10.665	10.55	10.55	1318.0
2018-01-30	ABEV	Stock	6.84	6.87	6.8	6.84	13055400.0
2018-01-30	ABG	Stock	75.05	75.25	73.7	74.2	161400.0
2018-01-30	ABIL-DELISTED	Stock	0.45	0.4708	0.45	0.4699	90311.0
2018-01-30	ABLX-DELISTED	Stock	54.42	54.5	53.8	54.0	1411276.0
2018-01-30	ABM	Stock	38.46	38.94	38.18	38.25	352500.0

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

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