PREVIEW / stock_daily / 2019-05-29

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-29.parquet
  size:    219 KB
  rows:    6,551
  symbols: 2,570

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-29	AAPL	Stock	44.105	44.8375	44.0	44.345	113924800.0
2019-05-29	MSFT	Stock	125.38	125.39	124.04	124.94	22763100.0
2019-05-29	NVDA	Stock	3.5352	3.5705	3.4735	3.5085	559800000.0
2019-05-29	AMZN	Stock	91.156	91.5	90.3765	90.9595	85580000.0
2019-05-29	GOOGL	Stock	56.635	56.75	55.5975	55.997	36230200.0
2019-05-29	META	Stock	183.5	184.56	181.35	182.19	12797700.0
2019-05-29	TSLA	Stock	12.4733	12.826	12.336	12.6573	179529000.0
2019-05-29	TLT	Stock	129.67	129.9	129.0	129.09	13260571.0
2019-05-29	ES	Stock	74.29	74.29	72.57	72.89	1387500.0
2019-05-29	CL	Stock	69.92	70.22	69.66	69.97	3580200.0
2019-05-29	A	Stock	66.59	67.99	66.59	67.3	3722100.0
2019-05-29	AA	Stock	22.23	22.51	21.95	22.46	2261000.0
2019-05-29	AABA-DELISTED	Stock	61.1	61.35	59.9	60.28	6395686.0
2019-05-29	AAC-DELISTED	Stock	1.2	1.2473	1.09	1.1	267790.0
2019-05-29	AACG	Stock	2.0	2.0	1.92	1.96	49600.0
2019-05-29	AAIC-DELISTED	Stock	7.0	7.01	6.85	6.93	470246.0
2019-05-29	AAIC.C-DELISTED	Stock	23.37	23.41	23.1301	23.23	3825.0
2019-05-29	AAL	Stock	28.51	28.55	27.92	28.41	6248100.0
2019-05-29	AAM.A-DELISTED	Stock	25.78	25.83	25.71	25.82	13948.0
2019-05-29	AAM.B-DELISTED	Stock	25.68	25.7899	25.67	25.74	22927.0
2019-05-29	AAMC-DELISTED	Stock	6.0398	6.0464	3.0882	4.1382	456457.0
2019-05-29	AAMI	Stock	11.65	11.65	11.32	11.43	426400.0
2019-05-29	AAOI	Stock	8.74	9.09	8.63	8.95	612100.0
2019-05-29	AAON	Stock	30.7467	31.4733	30.4733	30.82	327300.0
2019-05-29	AAP	Stock	154.18	156.07	151.57	155.78	1665200.0
2019-05-29	AAT	Stock	45.76	45.76	44.49	44.68	226700.0
2019-05-29	AAU-DELISTED	Stock	0.4365	0.44	0.4306	0.437	79896.0
2019-05-29	AAUAF-DELISTED	Stock	0.4365	0.44	0.4306	0.437	81657.0
2019-05-29	AAWW-DELISTED	Stock	38.54	38.76	37.38	37.51	392026.0
2019-05-29	AAXJ	Stock	65.3	65.72	65.19	65.65	1956729.0
2019-05-29	AAXN-DELISTED	Stock	67.7	68.86	67.55	68.04	444405.0
2019-05-29	AB	Stock	27.82	28.18	27.59	28.06	203000.0
2019-05-29	ABB-DELISTED	Stock	18.36	18.39	18.25	18.32	5280320.0
2019-05-29	ABBNY-DELISTED	Stock	18.36	18.39	18.25	18.32	5460077.0
2019-05-29	ABBV	Stock	77.57	78.28	77.1	78.06	4182200.0
2019-05-29	ABC-DELISTED	Stock	80.53	80.575	78.19	78.29	1278840.0
2019-05-29	ABCB	Stock	35.5	36.33	35.04	36.15	240300.0
2019-05-29	ABDC-DELISTED	Stock	8.52	8.52	8.27	8.355	31418.0
2019-05-29	ABEO	Stock	152.75	155.5	148.75	154.25	20472.0
2019-05-29	ABEOW-DELISTED	Stock	2.01	2.03	2.01	2.02	600.0
2019-05-29	ABEV	Stock	4.31	4.38	4.29	4.33	19966000.0
2019-05-29	ABG	Stock	76.76	77.04	74.89	76.9	78900.0
2019-05-29	ABIL-DELISTED	Stock	1.2	1.3532	1.15	1.2549	331137.0
2019-05-29	ABM	Stock	36.38	36.59	36.09	36.53	229400.0
2019-05-29	ABMD-DELISTED	Stock	268.93	270.0	260.045	260.37	519071.0
2019-05-29	ABR	Stock	12.87	12.89	12.59	12.62	1796000.0
2019-05-29	ABR.A-DELISTED	Stock	26.06	26.06	25.75	26.0396	7018.0
2019-05-29	ABR.B-DELISTED	Stock	25.7759	25.86	25.694	25.7586	2218.0
2019-05-29	ABT	Stock	75.37	75.97	74.94	75.67	4013100.0
2019-05-29	ABTC	Stock	305100.0	306300.0	305100.0	306300.0	0.6266666666666667

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

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