PREVIEW / stock_daily / 2021-04-16

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-16.parquet
  size:    253 KB
  rows:    7,757
  symbols: 2,928

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
2021-04-16	AAPL	Stock	134.3	134.67	133.28	134.16	84922400.0
2021-04-16	MSFT	Stock	259.47	261.0	257.6	260.74	24878600.0
2021-04-16	NVDA	Stock	16.053	16.1658	15.8652	15.9125	335208000.0
2021-04-16	AMZN	Stock	169.0	170.34	167.7795	169.972	63720000.0
2021-04-16	GOOGL	Stock	114.462	114.712	113.546	114.1375	26282780.0
2021-04-16	META	Stock	308.17	308.95	304.61	306.18	13059200.0
2021-04-16	TSLA	Stock	242.8833	249.8033	241.5333	246.5933	83938500.0
2021-04-16	TLT	Stock	139.1	139.73	138.9308	139.26	15238401.0
2021-04-16	ES	Stock	89.0	90.19	88.67	89.69	1221900.0
2021-04-16	CL	Stock	80.88	80.96	80.3	80.7	8134800.0
2021-04-16	A	Stock	134.05	134.64	133.16	134.58	4495400.0
2021-04-16	AA	Stock	34.03	36.03	33.865	35.63	17790300.0
2021-04-16	AAC-DELISTED	Stock	9.91	9.91	9.845	9.845	28162.0
2021-04-16	AACG	Stock	3.0	3.03	2.74	2.81	230600.0
2021-04-16	AACQ-DELISTED	Stock	10.01	10.06	9.96	10.02	1111819.0
2021-04-16	AACQU-DELISTED	Stock	10.6	10.69	10.49	10.5	29215.0
2021-04-16	AACQW-DELISTED	Stock	1.64	1.78	1.6	1.63	282596.0
2021-04-16	AAIC-DELISTED	Stock	4.03	4.08	3.95	4.07	243864.0
2021-04-16	AAIC.C-DELISTED	Stock	23.8	23.8	23.7273	23.7932	3019.0
2021-04-16	AAL	Stock	22.06	22.36	21.87	22.03	25958000.0
2021-04-16	AAM.A-DELISTED	Stock	26.09	26.1	26.06	26.09	9927.0
2021-04-16	AAM.B-DELISTED	Stock	26.81	26.85	26.75	26.82	19283.0
2021-04-16	AAME	Stock	3.58	3.96	3.5	3.7	631200.0
2021-04-16	AAMI	Stock	24.01	24.01	23.04	23.14	649900.0
2021-04-16	AAN-DELISTED	Stock	25.0	25.57	24.6	25.54	236200.0
2021-04-16	AAOI	Stock	7.9	7.955	7.68	7.89	432700.0
2021-04-16	AAON	Stock	46.6667	46.6667	46.1133	46.34	105150.0
2021-04-16	AAP	Stock	191.28	193.17	190.55	192.92	677500.0
2021-04-16	AAT	Stock	34.35	34.35	33.59	33.6	174500.0
2021-04-16	AAU-DELISTED	Stock	0.51	0.5279	0.48	0.4979	2089179.0
2021-04-16	AAUAF-DELISTED	Stock	0.51	0.5279	0.48	0.498	2174903.0
2021-04-16	AAWW-DELISTED	Stock	66.49	67.17	65.4	66.95	296479.0
2021-04-16	AAXJ	Stock	94.13	94.24	93.785	94.1	696794.0
2021-04-16	AB	Stock	39.93	40.37	39.87	40.12	262100.0
2021-04-16	ABB-DELISTED	Stock	33.27	33.48	33.15	33.38	1359440.0
2021-04-16	ABBNY-DELISTED	Stock	33.27	33.48	33.15	33.38	1478293.0
2021-04-16	ABBV	Stock	107.49	108.55	107.14	107.91	8207700.0
2021-04-16	ABC-DELISTED	Stock	119.5	119.91	118.665	119.69	993013.0
2021-04-16	ABCB	Stock	51.14	51.61	50.2	51.31	385800.0
2021-04-16	ABCL	Stock	29.31	30.64	28.35	29.82	690700.0
2021-04-16	ABCM-DELISTED	Stock	19.89	20.1	19.84	20.015	27713.0
2021-04-16	ABEO	Stock	37.5	38.0	35.75	37.25	63172.0
2021-04-16	ABEV	Stock	2.81	2.89	2.8	2.88	12667200.0
2021-04-16	ABG	Stock	216.44	216.74	206.93	208.21	140100.0
2021-04-16	ABGI-DELISTED	Stock	10.02	10.02	9.91	10.0	1739.0
2021-04-16	ABM	Stock	53.84	54.01	53.11	53.44	398900.0
2021-04-16	ABMD-DELISTED	Stock	334.55	339.08	329.82	330.11	207558.0
2021-04-16	ABNB	Stock	176.012	179.51	172.94	178.69	3058300.0
2021-04-16	ABR	Stock	16.51	16.6	16.43	16.51	673000.0
2021-04-16	ABR.A-DELISTED	Stock	25.9001	26.0	25.9001	26.0	400.0

> showing 50 of 7,757 rows — these rows as CSV

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