PREVIEW / stock_daily / 2018-01-24

all stock daily files

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

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-24	AAPL	Stock	44.3125	44.325	43.3	43.555	204420400.0
2018-01-24	MSFT	Stock	92.55	93.43	91.58	91.82	33277500.0
2018-01-24	NVDA	Stock	5.976	6.0123	5.8388	5.895	579972000.0
2018-01-24	AMZN	Stock	68.741	69.408	66.9	67.8755	136150000.0
2018-01-24	GOOGL	Stock	59.249	59.3525	58.3701	58.5645	37128580.0
2018-01-24	META	Stock	189.89	190.66	186.52	186.55	24334500.0
2018-01-24	TSLA	Stock	23.6387	23.65	22.9013	23.0593	79312500.0
2018-01-24	TLT	Stock	122.85	123.13	122.535	123.04	9038909.0
2018-01-24	ES	Stock	61.01	61.48	60.52	61.13	4666600.0
2018-01-24	CL	Stock	76.99	77.15	76.45	76.8	3767900.0
2018-01-24	A	Stock	73.66	73.86	73.05	73.58	1754300.0
2018-01-24	AA	Stock	52.9	53.853	52.39	53.3	2521900.0
2018-01-24	AAAP-DELISTED	Stock	81.95	82.3499	81.95	82.3499	6175.0
2018-01-24	AABA-DELISTED	Stock	77.13	78.88	76.78	77.82	5522503.0
2018-01-24	AAC-DELISTED	Stock	9.07	9.07	8.91	8.95	104488.0
2018-01-24	AACG	Stock	5.24	5.34	5.23	5.25	2600.0
2018-01-24	AAIC-DELISTED	Stock	11.73	11.75	11.61	11.64	388750.0
2018-01-24	AAL	Stock	54.35	55.46	53.45	54.79	16348500.0
2018-01-24	AAM.A-DELISTED	Stock	25.63	25.63	25.2	25.35	62423.0
2018-01-24	AAMC-DELISTED	Stock	20.4853	20.5882	20.4118	20.4896	2591.0
2018-01-24	AAME	Stock	3.45	3.45	3.45	3.45	1700.0
2018-01-24	AAMI	Stock	18.51	18.61	18.305	18.4	559000.0
2018-01-24	AAOI	Stock	34.92	35.45	33.62	34.22	1423900.0
2018-01-24	AAON	Stock	24.1333	24.1867	23.9	24.0333	259050.0
2018-01-24	AAP	Stock	119.26	121.24	118.26	120.99	1198600.0
2018-01-24	AAT	Stock	36.61	36.63	36.1	36.22	160500.0
2018-01-24	AAU-DELISTED	Stock	0.95	0.95	0.87	0.91	556820.0
2018-01-24	AAUAF-DELISTED	Stock	0.95	0.95	0.87	0.92	562701.0
2018-01-24	AAV-DELISTED	Stock	3.65	3.7	3.525	3.6	431680.0
2018-01-24	AAWW-DELISTED	Stock	62.4	62.9	60.95	61.0	100828.0
2018-01-24	AAXJ	Stock	82.56	82.915	82.03	82.46	845606.0
2018-01-24	AAXN-DELISTED	Stock	27.43	27.65	26.9	27.22	357148.0
2018-01-24	AB	Stock	27.6	27.65	27.2	27.4	115800.0
2018-01-24	ABAC-DELISTED	Stock	2.95	2.95	2.8201	2.8201	754.0
2018-01-24	ABAX-DELISTED	Stock	64.32	65.51	63.27	65.11	164431.0
2018-01-24	ABB-DELISTED	Stock	28.61	28.67	28.31	28.405	1973650.0
2018-01-24	ABBNY-DELISTED	Stock	28.61	28.67	28.31	28.39	3268430.0
2018-01-24	ABBV	Stock	105.26	106.23	104.1	105.51	4436500.0
2018-01-24	ABC-DELISTED	Stock	103.29	104.96	102.9	104.62	1795094.0
2018-01-24	ABCB	Stock	54.1	54.6	53.5	53.55	212400.0
2018-01-24	ABCD-DELISTED	Stock	7.07	7.13	6.78	6.78	223745.0
2018-01-24	ABDC-DELISTED	Stock	8.2	8.35	8.1249	8.26	31254.0
2018-01-24	ABE-DELISTED	Stock	15.53	15.55	15.48	15.536	8656.0
2018-01-24	ABEO	Stock	387.5	401.25	376.25	385.0	27560.0
2018-01-24	ABEOW-DELISTED	Stock	10.45	10.72	10.45	10.72	200.0
2018-01-24	ABEV	Stock	6.83	6.9	6.73	6.87	33979700.0
2018-01-24	ABG	Stock	75.5	76.05	74.35	75.85	213800.0
2018-01-24	ABIL-DELISTED	Stock	0.4828	0.5069	0.48	0.486	94327.0
2018-01-24	ABLX-DELISTED	Stock	44.09	44.67	43.41	44.44	115329.0
2018-01-24	ABM	Stock	39.42	40.0	39.1	39.29	463000.0

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

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