PREVIEW / stock_daily / 2021-03-25

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-25.parquet
  size:    252 KB
  rows:    7,674
  symbols: 2,888

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-03-25	AAPL	Stock	119.54	121.66	119.0	120.59	98844700.0
2021-03-25	MSFT	Stock	235.3	236.94	231.57	232.34	34061900.0
2021-03-25	NVDA	Stock	12.4995	12.7148	12.272	12.5353	295144000.0
2021-03-25	AMZN	Stock	153.6495	155.489	151.857	152.313	71270000.0
2021-03-25	GOOGL	Stock	101.4525	102.282	99.8045	101.623	35615740.0
2021-03-25	META	Stock	280.98	288.06	277.75	278.74	24505600.0
2021-03-25	TSLA	Stock	204.3333	215.1667	203.1667	213.4633	117674700.0
2021-03-25	TLT	Stock	138.3862	138.655	137.09	137.14	20781964.0
2021-03-25	ES	Stock	86.12	87.17	85.5	86.03	1318800.0
2021-03-25	CL	Stock	78.3	78.54	77.47	77.89	4769500.0
2021-03-25	A	Stock	120.86	122.33	119.88	121.9	967300.0
2021-03-25	AA	Stock	28.03	29.765	27.55	29.66	6403000.0
2021-03-25	AAC-DELISTED	Stock	9.95	9.95	9.52	9.87	115125.0
2021-03-25	AACG	Stock	4.0	4.14	3.77	3.97	207300.0
2021-03-25	AACQ-DELISTED	Stock	9.86	10.09	9.72	10.05	2634450.0
2021-03-25	AACQU-DELISTED	Stock	10.55	10.755	10.47	10.54	11314.0
2021-03-25	AACQW-DELISTED	Stock	1.75	1.9	1.493	1.85	539291.0
2021-03-25	AAIC-DELISTED	Stock	3.85	4.05	3.83	4.03	216118.0
2021-03-25	AAIC.C-DELISTED	Stock	22.825	23.0	22.776	23.0	402.0
2021-03-25	AAL	Stock	21.25	22.92	21.02	22.77	49746900.0
2021-03-25	AAM.A-DELISTED	Stock	25.945	25.97	25.91	25.97	4465.0
2021-03-25	AAM.B-DELISTED	Stock	26.69	26.82	26.69	26.82	13547.0
2021-03-25	AAMC-DELISTED	Stock	5.0324	5.2912	4.6099	4.9059	77887.0
2021-03-25	AAME	Stock	4.0	4.2	3.86	3.95	219100.0
2021-03-25	AAMI	Stock	18.66	19.41	18.39	19.34	403000.0
2021-03-25	AAN-DELISTED	Stock	24.19	25.63	23.69	25.47	202000.0
2021-03-25	AAOI	Stock	7.68	7.979	7.53	7.84	496600.0
2021-03-25	AAON	Stock	45.9933	47.5467	45.8733	47.22	187800.0
2021-03-25	AAP	Stock	180.48	186.51	179.5	185.65	627900.0
2021-03-25	AAT	Stock	32.2	33.09	31.47	32.82	266000.0
2021-03-25	AAU-DELISTED	Stock	0.54	0.5485	0.5236	0.5466	3502565.0
2021-03-25	AAUAF-DELISTED	Stock	0.54	0.5485	0.5236	0.5466	3567207.0
2021-03-25	AAWW-DELISTED	Stock	54.26	56.08	53.36	55.6	323800.0
2021-03-25	AAXJ	Stock	89.99	90.79	89.9	90.43	896549.0
2021-03-25	AB	Stock	39.53	39.9	38.85	39.41	673500.0
2021-03-25	ABB-DELISTED	Stock	30.68	31.105	30.35	31.08	1863692.0
2021-03-25	ABBNY-DELISTED	Stock	30.68	31.105	30.35	31.08	2011250.0
2021-03-25	ABBV	Stock	102.9	104.15	102.05	103.88	6281500.0
2021-03-25	ABC-DELISTED	Stock	115.38	117.635	114.11	117.36	449100.0
2021-03-25	ABCB	Stock	51.27	53.1	50.8	52.68	460400.0
2021-03-25	ABCL	Stock	27.05	28.0	26.19	26.58	1788300.0
2021-03-25	ABCM-DELISTED	Stock	19.71	19.98	19.5	19.72	39073.0
2021-03-25	ABEO	Stock	44.0	48.25	43.5	47.0	79208.0
2021-03-25	ABEV	Stock	2.66	2.71	2.65	2.68	18310300.0
2021-03-25	ABG	Stock	182.76	192.95	179.16	191.49	244300.0
2021-03-25	ABGI-DELISTED	Stock	9.75	9.83	9.7	9.74	14985.0
2021-03-25	ABM	Stock	49.57	50.48	48.77	49.98	325900.0
2021-03-25	ABMD-DELISTED	Stock	294.43	296.31	284.59	293.91	120162.0
2021-03-25	ABNB	Stock	173.1	179.54	170.5	176.16	5264100.0
2021-03-25	ABR	Stock	15.95	16.42	15.62	16.29	1251300.0

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

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