PREVIEW / stock_daily / 2020-09-23

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-23.parquet
  size:    227 KB
  rows:    6,901
  symbols: 2,471

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
2020-09-23	AAPL	Stock	111.62	112.11	106.77	107.12	150718700.0
2020-09-23	MSFT	Stock	207.9	208.1	200.03	200.59	30803800.0
2020-09-23	NVDA	Stock	12.5755	12.727	12.0793	12.1238	647012000.0
2020-09-23	AMZN	Stock	156.0215	156.35	149.619	149.993	113054000.0
2020-09-23	GOOGL	Stock	72.6045	72.654	70.134	70.4695	37725980.0
2020-09-23	META	Stock	255.26	257.99	248.15	249.02	19641300.0
2020-09-23	TSLA	Stock	135.0533	137.3833	125.2933	126.7867	285222600.0
2020-09-23	TLT	Stock	164.3	164.53	163.48	164.49	6224763.0
2020-09-23	ES	Stock	78.93	79.36	78.16	78.29	1258300.0
2020-09-23	CL	Stock	76.17	76.23	75.03	75.14	2962100.0
2020-09-23	A	Stock	98.6	98.91	96.57	96.91	1148700.0
2020-09-23	AA	Stock	12.01	12.39	11.57	11.64	5418900.0
2020-09-23	AACG	Stock	1.09	1.09	1.07	1.08	4600.0
2020-09-23	AACQ-DELISTED	Stock	9.9311	9.95	9.92	9.95	46216.0
2020-09-23	AACQU-DELISTED	Stock	10.27	10.4089	10.27	10.365	22078.0
2020-09-23	AACQW-DELISTED	Stock	1.6	1.6003	1.4429	1.48	359837.0
2020-09-23	AAIC-DELISTED	Stock	2.67	2.7	2.46	2.47	319547.0
2020-09-23	AAIC.C-DELISTED	Stock	19.06	19.1999	18.75	19.05	8456.0
2020-09-23	AAL	Stock	12.53	12.74	11.91	11.93	45292600.0
2020-09-23	AAM.A-DELISTED	Stock	26.18	26.2669	25.81	26.0	20126.0
2020-09-23	AAM.B-DELISTED	Stock	27.21	27.21	26.65	26.7234	12595.0
2020-09-23	AAMC-DELISTED	Stock	5.5882	6.2071	5.5882	6.0735	10282.0
2020-09-23	AAME	Stock	1.99	2.0	1.97	1.98	1800.0
2020-09-23	AAMI	Stock	12.99	13.15	12.55	12.55	406100.0
2020-09-23	AAOI	Stock	11.1	11.32	10.4	10.46	737800.0
2020-09-23	AAON	Stock	38.0467	38.72	37.0	37.52	340950.0
2020-09-23	AAP	Stock	150.57	150.94	146.3	146.45	618900.0
2020-09-23	AAT	Stock	23.7	23.9	22.97	23.03	425000.0
2020-09-23	AAU-DELISTED	Stock	0.9125	0.9199	0.8279	0.83	1095310.0
2020-09-23	AAUAF-DELISTED	Stock	0.9125	0.9199	0.8279	0.8418	1167653.0
2020-09-23	AAWW-DELISTED	Stock	60.09	63.47	60.08	60.65	455328.0
2020-09-23	AAXJ	Stock	76.34	76.43	75.42	75.58	1091668.0
2020-09-23	AAXN-DELISTED	Stock	87.0	88.69	86.0	86.71	464539.0
2020-09-23	AB	Stock	27.3	27.57	26.9	27.01	236600.0
2020-09-23	ABB-DELISTED	Stock	25.2	25.24	24.7801	24.8	1342401.0
2020-09-23	ABBNY-DELISTED	Stock	25.22	25.24	24.7801	24.8	1429211.0
2020-09-23	ABBV	Stock	89.0	89.27	87.12	87.14	6253000.0
2020-09-23	ABC-DELISTED	Stock	95.62	96.0	94.05	94.14	421517.0
2020-09-23	ABCB	Stock	22.76	23.08	21.13	21.18	864300.0
2020-09-23	ABEO	Stock	47.75	48.0	44.0	45.75	41132.0
2020-09-23	ABEV	Stock	2.32	2.33	2.24	2.24	16472700.0
2020-09-23	ABG	Stock	99.89	101.18	95.87	95.93	171500.0
2020-09-23	ABM	Stock	37.5	37.69	36.16	36.18	517100.0
2020-09-23	ABMD-DELISTED	Stock	266.55	268.44	259.4	260.12	173372.0
2020-09-23	ABR	Stock	11.54	11.74	11.04	11.06	1213900.0
2020-09-23	ABR.A-DELISTED	Stock	25.45	25.45	25.255	25.255	500.0
2020-09-23	ABR.B-DELISTED	Stock	25.0	25.121	24.27	25.121	5436.0
2020-09-23	ABR.C-DELISTED	Stock	25.46	25.55	25.23	25.55	1600.0
2020-09-23	ABT	Stock	104.99	104.99	102.23	102.73	4040100.0
2020-09-23	ABTC	Stock	126300.0	127860.0	114600.0	116100.0	3.3866666666666663

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

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