PREVIEW / stock_daily / 2019-10-04

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-04.parquet
  size:    219 KB
  rows:    6,552
  symbols: 2,476

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-10-04	AAPL	Stock	56.41	56.8725	55.9725	56.7525	138478800.0
2019-10-04	MSFT	Stock	136.75	138.25	136.42	138.12	22897700.0
2019-10-04	NVDA	Stock	4.535	4.5788	4.4695	4.5492	265524000.0
2019-10-04	AMZN	Stock	86.301	87.029	85.9615	86.9825	49438000.0
2019-10-04	GOOGL	Stock	59.7145	60.623	59.5485	60.548	24573720.0
2019-10-04	META	Stock	179.55	180.98	178.1	180.45	10430200.0
2019-10-04	TSLA	Stock	15.4407	15.652	15.2047	15.4287	119925000.0
2019-10-04	TLT	Stock	145.35	146.03	145.2	145.99	11936986.0
2019-10-04	ES	Stock	84.79	85.71	84.58	85.61	1480000.0
2019-10-04	CL	Stock	70.97	72.14	70.83	72.07	2415100.0
2019-10-04	A	Stock	74.08	75.91	74.06	75.88	1260800.0
2019-10-04	AA	Stock	19.1	19.49	18.94	19.45	2750900.0
2019-10-04	AAC-DELISTED	Stock	0.6658	0.6852	0.6502	0.6654	33956.0
2019-10-04	AACG	Stock	1.65	1.69	1.6	1.68	4300.0
2019-10-04	AAIC-DELISTED	Stock	5.28	5.33	5.24	5.33	253692.0
2019-10-04	AAIC.C-DELISTED	Stock	21.2	21.25	21.1132	21.1132	7503.0
2019-10-04	AAL	Stock	25.33	25.85	25.07	25.83	6446100.0
2019-10-04	AAM.A-DELISTED	Stock	26.51	26.58	26.4803	26.55	13601.0
2019-10-04	AAM.B-DELISTED	Stock	26.79	26.91	26.7355	26.83	16798.0
2019-10-04	AAMC-DELISTED	Stock	3.1412	3.1412	3.0265	3.0471	12254.0
2019-10-04	AAME	Stock	2.65	2.65	2.51	2.51	4300.0
2019-10-04	AAMI	Stock	9.27	9.52	9.25	9.51	508500.0
2019-10-04	AAOI	Stock	10.14	10.53	10.14	10.485	223400.0
2019-10-04	AAON	Stock	29.48	30.2	29.32	30.1933	223950.0
2019-10-04	AAP	Stock	159.54	160.61	157.2	159.94	749000.0
2019-10-04	AAT	Stock	46.25	46.51	46.02	46.5	245900.0
2019-10-04	AAU-DELISTED	Stock	0.6639	0.6856	0.6531	0.6844	132739.0
2019-10-04	AAUAF-DELISTED	Stock	0.6639	0.6856	0.6531	0.6844	134418.0
2019-10-04	AAWW-DELISTED	Stock	23.05	23.36	22.57	22.94	281714.0
2019-10-04	AAXJ	Stock	66.04	66.49	65.91	66.43	555132.0
2019-10-04	AAXN-DELISTED	Stock	54.47	55.09	53.57	54.87	370691.0
2019-10-04	AB	Stock	28.41	28.86	28.4	28.7	136600.0
2019-10-04	ABB-DELISTED	Stock	18.13	18.29	18.08	18.29	2202806.0
2019-10-04	ABBNY-DELISTED	Stock	18.13	18.29	18.08	18.28	2286727.0
2019-10-04	ABBV	Stock	74.22	75.06	73.95	74.66	7007500.0
2019-10-04	ABC-DELISTED	Stock	81.3	81.88	80.27	81.84	573479.0
2019-10-04	ABCB	Stock	39.36	39.79	38.99	39.65	302100.0
2019-10-04	ABDC-DELISTED	Stock	8.8709	8.88	8.72	8.83	36307.0
2019-10-04	ABEO	Stock	56.5	58.5	53.75	56.25	30424.0
2019-10-04	ABEOW-DELISTED	Stock	0.15	0.15	0.15	0.15	200.0
2019-10-04	ABEV	Stock	4.57	4.78	4.55	4.75	30270500.0
2019-10-04	ABG	Stock	96.59	97.13	94.8	97.13	129900.0
2019-10-04	ABIL-DELISTED	Stock	0.5	0.51	0.45	0.4999	47283.0
2019-10-04	ABM	Stock	34.22	34.8	34.04	34.79	279700.0
2019-10-04	ABMD-DELISTED	Stock	168.57	170.9805	167.98	169.16	344536.0
2019-10-04	ABR	Stock	12.92	13.05	12.89	13.03	1214400.0
2019-10-04	ABR.A-DELISTED	Stock	26.35	26.35	26.166	26.2547	3152.0
2019-10-04	ABR.B-DELISTED	Stock	26.0238	26.0238	25.868	25.99	900.0
2019-10-04	ABR.C-DELISTED	Stock	26.48	26.48	26.3785	26.39	600.0
2019-10-04	ABT	Stock	81.3	82.32	81.29	81.99	3390100.0

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

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