PREVIEW / stock_daily / 2021-04-15

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-15.parquet
  size:    254 KB
  rows:    7,755
  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-15	AAPL	Stock	133.82	135.0	133.64	134.5	89347100.0
2021-04-15	MSFT	Stock	257.93	259.93	257.73	259.5	25627500.0
2021-04-15	NVDA	Stock	15.6625	16.2143	15.6315	16.1373	598480000.0
2021-04-15	AMZN	Stock	168.55	169.85	167.6	168.9545	64672000.0
2021-04-15	GOOGL	Stock	113.0975	114.8	112.5585	114.2625	29174980.0
2021-04-15	META	Stock	306.34	310.14	304.1	307.82	14558300.0
2021-04-15	TSLA	Stock	247.7	247.8967	240.4367	246.2833	83546700.0
2021-04-15	TLT	Stock	139.49	140.98	139.455	140.35	23896725.0
2021-04-15	ES	Stock	88.06	88.93	87.79	88.79	1624800.0
2021-04-15	CL	Stock	79.77	80.76	79.57	80.46	4010400.0
2021-04-15	A	Stock	132.0	133.94	132.0	133.28	2121300.0
2021-04-15	AA	Stock	33.46	33.62	32.15	32.84	6132600.0
2021-04-15	AAC-DELISTED	Stock	9.9	9.92	9.82	9.8675	246381.0
2021-04-15	AACG	Stock	3.35	3.83	3.05	3.09	1646200.0
2021-04-15	AACQ-DELISTED	Stock	10.16	10.18	10.0	10.04	1246914.0
2021-04-15	AACQU-DELISTED	Stock	10.74	10.74	10.42	10.55	5546.0
2021-04-15	AACQW-DELISTED	Stock	1.74	1.76	1.61	1.65	210786.0
2021-04-15	AAIC-DELISTED	Stock	4.01	4.0352	3.95	3.98	137313.0
2021-04-15	AAIC.C-DELISTED	Stock	23.7999	23.8	23.57	23.57	5627.0
2021-04-15	AAL	Stock	22.65	22.67	21.7	22.13	34424100.0
2021-04-15	AAM.A-DELISTED	Stock	26.0801	26.14	26.05	26.13	16978.0
2021-04-15	AAM.B-DELISTED	Stock	26.79	26.8	26.76	26.8	8276.0
2021-04-15	AAMC-DELISTED	Stock	5.4412	6.1324	5.4265	5.9882	33674.0
2021-04-15	AAME	Stock	3.68	3.7	3.47	3.55	123900.0
2021-04-15	AAMI	Stock	23.67	23.99	23.48	23.84	434600.0
2021-04-15	AAN-DELISTED	Stock	25.02	25.155	24.55	24.91	191500.0
2021-04-15	AAOI	Stock	8.35	8.35	7.8	7.88	696400.0
2021-04-15	AAON	Stock	46.2533	46.6733	45.84	46.4533	142500.0
2021-04-15	AAP	Stock	188.29	190.2	188.09	189.46	609300.0
2021-04-15	AAT	Stock	33.62	34.0	33.4	33.99	394100.0
2021-04-15	AAU-DELISTED	Stock	0.5067	0.514	0.493	0.5116	1467881.0
2021-04-15	AAUAF-DELISTED	Stock	0.5067	0.514	0.493	0.5117	1497949.0
2021-04-15	AAWW-DELISTED	Stock	65.33	65.88	64.42	65.71	227859.0
2021-04-15	AAXJ	Stock	93.95	93.98	93.54	93.9	610560.0
2021-04-15	AB	Stock	40.26	40.58	39.58	39.88	523500.0
2021-04-15	ABB-DELISTED	Stock	32.71	32.95	32.59	32.93	1329403.0
2021-04-15	ABBNY-DELISTED	Stock	32.71	32.95	32.59	32.93	1455394.0
2021-04-15	ABBV	Stock	105.99	106.95	105.62	106.89	5730500.0
2021-04-15	ABC-DELISTED	Stock	118.44	119.54	118.03	119.07	970182.0
2021-04-15	ABCB	Stock	50.77	50.77	48.91	50.37	322900.0
2021-04-15	ABCL	Stock	29.62	30.24	28.43	29.0	1795800.0
2021-04-15	ABCM-DELISTED	Stock	19.75	20.1	19.7	19.865	66362.0
2021-04-15	ABEO	Stock	40.0	41.0	37.5	37.5	50092.0
2021-04-15	ABEV	Stock	2.85	2.88	2.82	2.85	14268700.0
2021-04-15	ABG	Stock	210.2	216.88	209.86	215.17	239700.0
2021-04-15	ABGI-DELISTED	Stock	9.9152	10.02	9.9101	10.01	2126.0
2021-04-15	ABM	Stock	53.53	53.53	52.77	53.28	310800.0
2021-04-15	ABMD-DELISTED	Stock	333.48	339.46	332.815	337.74	176459.0
2021-04-15	ABNB	Stock	177.0	178.24	174.25	175.35	2894900.0
2021-04-15	ABR	Stock	16.48	16.52	16.27	16.43	663500.0

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

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