PREVIEW / stock_daily / 2018-05-21

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-21.parquet
  size:    217 KB
  rows:    6,511
  symbols: 2,817

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-21	AAPL	Stock	47.0	47.3175	46.7275	46.9075	73603200.0
2018-05-21	MSFT	Stock	97.0	98.01	96.8	97.6	19422500.0
2018-05-21	NVDA	Stock	6.247	6.2508	6.0123	6.106	640624000.0
2018-05-21	AMZN	Stock	79.25	79.6025	78.75	79.273	58504000.0
2018-05-21	GOOGL	Stock	53.95	54.665	53.9	54.2005	25179980.0
2018-05-21	META	Stock	183.77	185.3	183.13	184.49	13532900.0
2018-05-21	TSLA	Stock	18.7553	19.4327	18.7533	18.966	137739000.0
2018-05-21	TLT	Stock	117.13	117.38	116.95	117.27	4448525.0
2018-05-21	ES	Stock	57.49	57.55	56.94	57.47	1742000.0
2018-05-21	CL	Stock	62.49	62.74	62.17	62.25	4456000.0
2018-05-21	A	Stock	64.75	65.99	64.68	65.55	4527300.0
2018-05-21	AA	Stock	51.2	51.2	50.15	50.37	2446600.0
2018-05-21	AABA-DELISTED	Stock	76.69	77.55	76.54	77.02	3403862.0
2018-05-21	AAC-DELISTED	Stock	11.9	12.45	11.9	12.32	116113.0
2018-05-21	AACG	Stock	5.16	5.16	5.16	5.16	3900.0
2018-05-21	AAIC-DELISTED	Stock	11.12	11.26	11.05	11.26	526896.0
2018-05-21	AAL	Stock	43.74	44.79	43.63	44.28	4930200.0
2018-05-21	AAM.A-DELISTED	Stock	25.16	25.25	25.136	25.222	46734.0
2018-05-21	AAM.B-DELISTED	Stock	24.8	24.85	24.72	24.8	112943.0
2018-05-21	AAME	Stock	2.85	2.85	2.7	2.7	1900.0
2018-05-21	AAMI	Stock	15.6	15.76	15.46	15.58	243300.0
2018-05-21	AAOI	Stock	33.65	33.88	33.07	33.51	640700.0
2018-05-21	AAON	Stock	21.1	21.1667	20.8667	21.0	311250.0
2018-05-21	AAP	Stock	118.4	119.64	116.38	119.15	1482900.0
2018-05-21	AAT	Stock	34.27	34.74	33.89	34.63	364700.0
2018-05-21	AAU-DELISTED	Stock	0.79	0.79	0.7	0.7042	369451.0
2018-05-21	AAUAF-DELISTED	Stock	0.79	0.79	0.7	0.7319	385697.0
2018-05-21	AAV-DELISTED	Stock	3.1	3.15	3.1	3.15	77279.0
2018-05-21	AAWW-DELISTED	Stock	69.4	69.95	69.05	69.2	132540.0
2018-05-21	AAXJ	Stock	76.74	76.92	76.45	76.71	259377.0
2018-05-21	AAXN-DELISTED	Stock	58.28	59.73	57.72	59.66	1118073.0
2018-05-21	AB	Stock	27.95	28.4	27.91	28.05	408100.0
2018-05-21	ABAC-DELISTED	Stock	2.24	2.24	2.24	2.24	550.0
2018-05-21	ABAX-DELISTED	Stock	83.43	83.78	82.92	83.03	731820.0
2018-05-21	ABB-DELISTED	Stock	24.59	24.61	24.4738	24.51	969568.0
2018-05-21	ABBNY-DELISTED	Stock	24.59	24.61	24.4738	24.5	1227017.0
2018-05-21	ABBV	Stock	107.0	107.25	105.95	106.23	5797300.0
2018-05-21	ABC-DELISTED	Stock	85.23	85.61	84.04	84.33	799681.0
2018-05-21	ABCB	Stock	56.15	56.85	56.15	56.75	160500.0
2018-05-21	ABCD-DELISTED	Stock	10.0	10.13	9.62	9.66	229494.0
2018-05-21	ABDC-DELISTED	Stock	6.79	7.16	6.79	6.99	79158.0
2018-05-21	ABEO	Stock	478.75	478.75	388.75	400.5	128604.0
2018-05-21	ABEOW-DELISTED	Stock	10.8	11.0	10.8	11.0	2000.0
2018-05-21	ABEV	Stock	5.57	5.57	5.41	5.46	28954000.0
2018-05-21	ABG	Stock	70.15	71.0	69.9	70.8	129100.0
2018-05-21	ABIL-DELISTED	Stock	2.76	2.76	2.66	2.66	2542.0
2018-05-21	ABLX-DELISTED	Stock	52.955	52.97	52.67	52.89	9312.0
2018-05-21	ABM	Stock	29.87	30.06	29.5	30.02	812800.0
2018-05-21	ABMD-DELISTED	Stock	387.28	389.7852	378.71	379.03	487413.0
2018-05-21	ABR	Stock	9.27	9.37	9.25	9.35	999400.0

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

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