PREVIEW / stock_daily / 2019-05-31

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-31.parquet
  size:    219 KB
  rows:    6,568
  symbols: 2,571

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
2019-05-31	AAPL	Stock	44.0575	44.4975	43.7475	43.7675	108174400.0
2019-05-31	MSFT	Stock	124.23	124.62	123.32	123.68	26646800.0
2019-05-31	NVDA	Stock	3.4285	3.4962	3.3848	3.3865	389720000.0
2019-05-31	AMZN	Stock	89.5005	89.7795	88.635	88.7535	92376000.0
2019-05-31	GOOGL	Stock	55.282	55.6701	55.1675	55.325	31589620.0
2019-05-31	META	Stock	180.28	180.54	177.16	177.47	15226500.0
2019-05-31	TSLA	Stock	12.34	12.6613	12.2733	12.344	156100500.0
2019-05-31	TLT	Stock	130.9	131.9	130.81	131.83	18933634.0
2019-05-31	ES	Stock	72.59	74.0	72.5	73.84	5976900.0
2019-05-31	CL	Stock	70.51	70.66	69.44	69.62	3031300.0
2019-05-31	A	Stock	66.24	67.56	66.07	67.05	2829300.0
2019-05-31	AA	Stock	21.26	21.37	21.02	21.19	2721000.0
2019-05-31	AABA-DELISTED	Stock	59.32	59.65	58.87	59.2	10892366.0
2019-05-31	AAC-DELISTED	Stock	1.05	1.05	0.81	0.9001	949595.0
2019-05-31	AACG	Stock	1.88	1.91	1.82	1.83	61600.0
2019-05-31	AAIC-DELISTED	Stock	6.78	6.82	6.6459	6.69	399429.0
2019-05-31	AAIC.C-DELISTED	Stock	22.75	22.75	22.65	22.6651	4959.0
2019-05-31	AAL	Stock	27.8	27.92	27.11	27.23	7441400.0
2019-05-31	AAM.A-DELISTED	Stock	25.61	25.62	25.46	25.5	48749.0
2019-05-31	AAM.B-DELISTED	Stock	25.35	25.4899	25.32	25.4	82553.0
2019-05-31	AAMC-DELISTED	Stock	4.4882	5.8	4.4794	5.0118	67847.0
2019-05-31	AAME	Stock	2.5	2.5	2.45	2.45	800.0
2019-05-31	AAMI	Stock	10.97	11.04	10.725	10.74	529600.0
2019-05-31	AAOI	Stock	8.87	8.99	8.64	8.66	390600.0
2019-05-31	AAON	Stock	30.3867	30.5933	30.1533	30.26	213450.0
2019-05-31	AAP	Stock	156.0	156.63	154.4	155.0	1487200.0
2019-05-31	AAT	Stock	44.97	45.64	44.63	45.39	207600.0
2019-05-31	AAU-DELISTED	Stock	0.45	0.47	0.4416	0.4597	176587.0
2019-05-31	AAUAF-DELISTED	Stock	0.45	0.47	0.4416	0.4597	183763.0
2019-05-31	AAWW-DELISTED	Stock	37.15	37.2695	35.04	35.395	440696.0
2019-05-31	AAXJ	Stock	65.45	65.96	65.3805	65.83	1400016.0
2019-05-31	AAXN-DELISTED	Stock	66.93	69.03	66.46	66.76	858688.0
2019-05-31	AB	Stock	27.51	27.7	26.71	27.19	287700.0
2019-05-31	ABB-DELISTED	Stock	18.21	18.27	18.145	18.18	3382059.0
2019-05-31	ABBNY-DELISTED	Stock	18.21	18.27	18.145	18.18	4791030.0
2019-05-31	ABBV	Stock	77.31	77.57	76.4	76.71	4003200.0
2019-05-31	ABC-DELISTED	Stock	77.55	78.35	77.07	77.89	609983.0
2019-05-31	ABCB	Stock	35.24	35.91	35.0	35.29	425100.0
2019-05-31	ABDC-DELISTED	Stock	8.32	8.33	8.27	8.3	44324.0
2019-05-31	ABEO	Stock	141.0	142.25	134.5	136.0	23128.0
2019-05-31	ABEOW-DELISTED	Stock	1.6	1.6	1.33	1.36	800.0
2019-05-31	ABEV	Stock	4.37	4.49	4.36	4.47	25676300.0
2019-05-31	ABG	Stock	75.82	76.86	74.1	74.19	176400.0
2019-05-31	ABIL-DELISTED	Stock	1.6	1.84	1.26	1.27	2172376.0
2019-05-31	ABM	Stock	36.15	36.38	35.84	36.25	260200.0
2019-05-31	ABMD-DELISTED	Stock	262.49	264.84	259.4908	262.04	362255.0
2019-05-31	ABR	Stock	12.46	12.46	12.28	12.31	1509200.0
2019-05-31	ABR.A-DELISTED	Stock	25.64	25.9512	25.64	25.915	10871.0
2019-05-31	ABR.B-DELISTED	Stock	25.22	25.86	25.22	25.4	7051.0
2019-05-31	ABR.C-DELISTED	Stock	25.76	25.95	25.76	25.76	7351.0

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

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