PREVIEW / stock_daily / 2018-10-19

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-19.parquet
  size:    220 KB
  rows:    6,522
  symbols: 2,705

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-10-19	AAPL	Stock	54.515	55.315	54.3575	54.8275	132314800.0
2018-10-19	MSFT	Stock	108.93	110.86	108.21	108.66	32785500.0
2018-10-19	NVDA	Stock	6.044	6.0638	5.6925	5.7293	613608000.0
2018-10-19	AMZN	Stock	89.258	90.455	87.65	88.2015	118144000.0
2018-10-19	GOOGL	Stock	55.1855	56.0475	54.8515	55.259	41285780.0
2018-10-19	META	Stock	155.86	157.35	153.55	154.05	19761300.0
2018-10-19	TSLA	Stock	17.826	17.9773	16.9	17.3333	140632500.0
2018-10-19	TLT	Stock	113.85	113.95	113.4103	113.71	10892437.0
2018-10-19	ES	Stock	62.35	63.72	62.24	63.33	1300100.0
2018-10-19	CL	Stock	64.42	65.53	64.25	64.52	6907700.0
2018-10-19	A	Stock	65.81	66.24	64.24	64.47	2418300.0
2018-10-19	AA	Stock	38.9	39.15	37.9	38.6	5061800.0
2018-10-19	AABA-DELISTED	Stock	60.95	61.72	60.33	60.41	3918636.0
2018-10-19	AAC-DELISTED	Stock	6.9	7.31	6.9	6.92	113971.0
2018-10-19	AACG	Stock	1.39	1.39	1.1	1.17	317900.0
2018-10-19	AAIC-DELISTED	Stock	8.43	8.52	8.3315	8.4	625750.0
2018-10-19	AAL	Stock	32.09	32.65	31.81	32.04	10445200.0
2018-10-19	AAM.A-DELISTED	Stock	23.89	24.06	23.84	23.9	54418.0
2018-10-19	AAM.B-DELISTED	Stock	23.86	24.07	23.86	23.91	39527.0
2018-10-19	AAMC-DELISTED	Stock	14.4118	14.4118	14.4118	14.4118	479.0
2018-10-19	AAME	Stock	2.8	2.95	2.8	2.8	2000.0
2018-10-19	AAMI	Stock	11.97	12.15	11.88	11.94	353400.0
2018-10-19	AAOI	Stock	22.9	23.47	21.85	21.91	1074900.0
2018-10-19	AAON	Stock	21.4	21.7267	21.32	21.4733	217050.0
2018-10-19	AAP	Stock	163.3	166.76	162.37	164.33	1406100.0
2018-10-19	AAT	Stock	36.5	36.95	36.5	36.79	85800.0
2018-10-19	AAU-DELISTED	Stock	0.55	0.5618	0.53	0.5368	104535.0
2018-10-19	AAUAF-DELISTED	Stock	0.55	0.5618	0.53	0.5368	107625.0
2018-10-19	AAWW-DELISTED	Stock	52.41	52.92	51.84	52.48	139413.0
2018-10-19	AAXJ	Stock	64.32	64.63	63.8	63.96	840497.0
2018-10-19	AAXN-DELISTED	Stock	58.49	59.86	57.71	58.53	366585.0
2018-10-19	AB	Stock	29.93	30.53	29.61	30.26	239000.0
2018-10-19	ABAC-DELISTED	Stock	1.85	2.2	1.84	1.99	80325.0
2018-10-19	ABB-DELISTED	Stock	20.92	21.14	20.89	20.98	1718641.0
2018-10-19	ABBNY-DELISTED	Stock	20.92	21.14	20.89	20.98	2088153.0
2018-10-19	ABBV	Stock	89.26	89.99	87.97	87.97	7059400.0
2018-10-19	ABC-DELISTED	Stock	93.29	94.85	92.44	92.8	943059.0
2018-10-19	ABCB	Stock	41.03	44.0	40.9	43.44	515700.0
2018-10-19	ABCD-DELISTED	Stock	14.38	14.4	14.37	14.4	269677.0
2018-10-19	ABDC-DELISTED	Stock	5.92	5.98	5.92	5.94	24999.0
2018-10-19	ABEO	Stock	243.0	251.5	233.5	233.5	28124.0
2018-10-19	ABEV	Stock	4.52	4.56	4.43	4.51	22829600.0
2018-10-19	ABG	Stock	58.6	60.85	58.6	59.76	252400.0
2018-10-19	ABIL-DELISTED	Stock	3.16	4.98	3.0884	4.0155	2778981.0
2018-10-19	ABM	Stock	31.84	32.35	31.69	31.8	400200.0
2018-10-19	ABMD-DELISTED	Stock	388.41	391.6962	360.63	362.45	605113.0
2018-10-19	ABR	Stock	11.78	11.93	11.72	11.78	509000.0
2018-10-19	ABR.A-DELISTED	Stock	25.6	25.663	25.4	25.475	1130.0
2018-10-19	ABR.B-DELISTED	Stock	25.4499	25.4499	25.4499	25.4499	200.0
2018-10-19	ABR.C-DELISTED	Stock	25.7899	25.7899	25.7899	25.7899	200.0

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

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