PREVIEW / stock_daily / 2020-04-23

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-23.parquet
  size:    214 KB
  rows:    6,577
  symbols: 2,340

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-04-23	AAPL	Stock	68.9675	70.4375	68.7175	68.7575	124814400.0
2020-04-23	MSFT	Stock	174.11	175.06	170.91	171.42	32790800.0
2020-04-23	NVDA	Stock	7.196	7.3285	7.075	7.1002	424160000.0
2020-04-23	AMZN	Stock	119.999	121.211	119.104	119.9725	101332000.0
2020-04-23	GOOGL	Stock	63.287	64.4075	63.0265	63.5585	34202440.0
2020-04-23	META	Stock	184.08	187.05	183.15	185.13	21426600.0
2020-04-23	TSLA	Stock	48.5067	48.9333	46.8753	47.042	198550500.0
2020-04-23	TLT	Stock	169.87	170.93	169.605	170.44	5968584.0
2020-04-23	ES	Stock	87.83	88.48	85.14	86.56	1434300.0
2020-04-23	CL	Stock	71.05	71.6	70.7	71.23	4041800.0
2020-04-23	A	Stock	76.6	77.49	75.05	75.09	2097700.0
2020-04-23	AA	Stock	7.91	8.08	7.235	7.29	20737000.0
2020-04-23	AACG	Stock	0.78	0.78	0.74	0.74	3900.0
2020-04-23	AAIC-DELISTED	Stock	2.72	2.84	2.63	2.64	275158.0
2020-04-23	AAIC.C-DELISTED	Stock	17.23	17.4999	16.75	17.25	5119.0
2020-04-23	AAL	Stock	10.36	10.67	10.24	10.25	54598500.0
2020-04-23	AAM.A-DELISTED	Stock	25.4182	25.54	25.22	25.3	12971.0
2020-04-23	AAM.B-DELISTED	Stock	25.49	25.6	25.191	25.43	28911.0
2020-04-23	AAMC-DELISTED	Stock	4.2235	4.2235	3.8382	3.9706	47947.0
2020-04-23	AAMI	Stock	6.18	6.56	6.1	6.45	645300.0
2020-04-23	AAOI	Stock	8.49	8.995	8.41	8.76	495900.0
2020-04-23	AAON	Stock	30.4267	32.2733	30.2667	31.98	372900.0
2020-04-23	AAP	Stock	114.5	118.38	112.8	113.39	895300.0
2020-04-23	AAT	Stock	26.1	26.57	25.68	26.13	376700.0
2020-04-23	AAU-DELISTED	Stock	0.38	0.4105	0.372	0.379	517377.0
2020-04-23	AAUAF-DELISTED	Stock	0.38	0.4105	0.372	0.379	538021.0
2020-04-23	AAWW-DELISTED	Stock	28.05	28.46	27.18	27.85	506568.0
2020-04-23	AAXJ	Stock	63.19	63.62	62.59	62.66	1039207.0
2020-04-23	AAXN-DELISTED	Stock	74.05	75.2499	70.6	70.67	367524.0
2020-04-23	AB	Stock	19.66	20.72	19.52	19.6	409400.0
2020-04-23	ABB-DELISTED	Stock	17.08	17.48	17.045	17.06	1964226.0
2020-04-23	ABBNY-DELISTED	Stock	17.11	17.48	17.045	17.06	2174015.0
2020-04-23	ABBV	Stock	82.18	83.83	81.96	82.04	7869600.0
2020-04-23	ABC-DELISTED	Stock	87.39	89.14	86.88	87.27	848460.0
2020-04-23	ABCB	Stock	22.19	22.83	21.65	21.77	363800.0
2020-04-23	ABEO	Stock	59.75	62.25	58.75	60.0	34200.0
2020-04-23	ABEV	Stock	2.17	2.2	2.11	2.12	27604400.0
2020-04-23	ABG	Stock	52.49	56.57	52.29	54.5	223000.0
2020-04-23	ABM	Stock	30.72	31.64	30.72	31.15	409000.0
2020-04-23	ABMD-DELISTED	Stock	168.79	171.25	167.025	170.89	313047.0
2020-04-23	ABR	Stock	6.0	6.38	5.87	6.14	1468000.0
2020-04-23	ABR.A-DELISTED	Stock	20.53	21.7437	20.53	21.3	2026.0
2020-04-23	ABR.B-DELISTED	Stock	21.52	21.52	19.8215	20.8963	1260.0
2020-04-23	ABR.C-DELISTED	Stock	21.95	22.49	21.2	22.3837	700.0
2020-04-23	ABT	Stock	95.87	97.45	93.35	93.94	10567500.0
2020-04-23	ABTC	Stock	236700.0	251100.0	232200.0	246600.0	2.3333333333333335
2020-04-23	ABTS	Stock	11.85	11.94	10.71	11.46	627.0
2020-04-23	ABTX-DELISTED	Stock	22.19	23.13	21.52	22.44	66470.0
2020-04-23	ABUS	Stock	1.19	1.23	1.17	1.23	489300.0
2020-04-23	ACA	Stock	38.08	39.36	37.77	38.32	376469.0

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

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