PREVIEW / stock_daily / 2018-05-22

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-22.parquet
  size:    219 KB
  rows:    6,525
  symbols: 2,823

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-05-22	AAPL	Stock	47.095	47.22	46.695	46.79	60962800.0
2018-05-22	MSFT	Stock	97.68	98.17	97.2	97.5	15441200.0
2018-05-22	NVDA	Stock	6.1195	6.145	6.0063	6.0675	518264000.0
2018-05-22	AMZN	Stock	79.4945	79.4945	78.7625	79.07	42312000.0
2018-05-22	GOOGL	Stock	54.49	54.59	53.613	53.7655	22225980.0
2018-05-22	META	Stock	184.93	185.42	183.43	183.8	12731400.0
2018-05-22	TSLA	Stock	19.184	19.2	18.228	18.334	134187000.0
2018-05-22	TLT	Stock	117.29	117.345	116.851	117.09	4700736.0
2018-05-22	ES	Stock	57.44	57.96	57.39	57.78	1759100.0
2018-05-22	CL	Stock	62.48	62.92	62.28	62.41	4308800.0
2018-05-22	A	Stock	65.62	65.89	64.69	64.84	3415500.0
2018-05-22	AA	Stock	50.68	50.9	49.6	49.69	3607800.0
2018-05-22	AABA-DELISTED	Stock	77.3	77.3188	76.39	76.499	1516800.0
2018-05-22	AAC-DELISTED	Stock	12.31	12.325	11.62	11.69	133022.0
2018-05-22	AACG	Stock	5.3	5.3	5.25	5.26	3100.0
2018-05-22	AAIC-DELISTED	Stock	11.25	11.34	11.22	11.28	439163.0
2018-05-22	AAL	Stock	44.5	45.04	42.83	42.88	6892400.0
2018-05-22	AAM.A-DELISTED	Stock	25.25	25.35	25.1601	25.35	33129.0
2018-05-22	AAM.B-DELISTED	Stock	24.85	24.92	24.75	24.9	38702.0
2018-05-22	AAMC-DELISTED	Stock	19.1176	19.1176	18.6324	18.8824	5620.0
2018-05-22	AAME	Stock	2.85	2.85	2.56	2.65	3500.0
2018-05-22	AAMI	Stock	15.61	15.765	15.56	15.7	191900.0
2018-05-22	AAOI	Stock	33.83	33.91	33.22	33.26	535500.0
2018-05-22	AAON	Stock	21.0333	21.0333	20.7	20.7333	321150.0
2018-05-22	AAP	Stock	123.55	125.89	113.61	115.33	3940200.0
2018-05-22	AAT	Stock	34.64	35.05	34.45	34.92	253100.0
2018-05-22	AAU-DELISTED	Stock	0.75	0.75	0.7187	0.723	103414.0
2018-05-22	AAUAF-DELISTED	Stock	0.75	0.75	0.7186	0.723	106888.0
2018-05-22	AAV-DELISTED	Stock	3.1	3.25	3.1	3.125	197438.0
2018-05-22	AAWW-DELISTED	Stock	69.3	69.65	68.3	68.5	80141.0
2018-05-22	AAXJ	Stock	76.82	77.14	76.515	76.63	499701.0
2018-05-22	AAXN-DELISTED	Stock	60.08	62.2	59.1	61.72	1673589.0
2018-05-22	AB	Stock	28.15	28.6	28.15	28.45	509800.0
2018-05-22	ABAC-DELISTED	Stock	2.2399	2.2399	2.1598	2.1598	4073.0
2018-05-22	ABAX-DELISTED	Stock	83.15	83.25	82.96	83.03	272443.0
2018-05-22	ABB-DELISTED	Stock	24.6	24.72	24.53	24.56	1317768.0
2018-05-22	ABBNY-DELISTED	Stock	24.6	24.72	24.53	24.56	1383037.0
2018-05-22	ABBV	Stock	106.55	107.24	106.1	106.23	9456800.0
2018-05-22	ABC-DELISTED	Stock	84.59	85.74	84.26	84.51	880702.0
2018-05-22	ABCB	Stock	56.8	57.05	56.5	56.5	188100.0
2018-05-22	ABCD-DELISTED	Stock	9.68	9.8	9.33	9.63	278586.0
2018-05-22	ABDC-DELISTED	Stock	6.99	6.99	6.53	6.66	99296.0
2018-05-22	ABEO	Stock	407.5	422.5	393.75	413.0	51692.0
2018-05-22	ABEOW-DELISTED	Stock	11.5	11.62	11.5	11.6	8900.0
2018-05-22	ABEV	Stock	5.49	5.57	5.45	5.52	28847900.0
2018-05-22	ABG	Stock	71.35	71.7	68.7	68.95	204400.0
2018-05-22	ABIL-DELISTED	Stock	2.66	2.69	2.66	2.69	1569.0
2018-05-22	ABLX-DELISTED	Stock	52.975	53.37	52.965	53.37	8900.0
2018-05-22	ABM	Stock	29.84	30.23	29.7	29.85	659800.0
2018-05-22	ABMD-DELISTED	Stock	382.0	387.24	378.51	386.32	348951.0

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

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