PREVIEW / stock_daily / 2021-05-25

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-25.parquet
  size:    255 KB
  rows:    7,846
  symbols: 2,947

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-05-25	AAPL	Stock	127.82	128.32	126.32	126.9	72009500.0
2021-05-25	MSFT	Stock	251.77	252.75	250.82	251.72	17704300.0
2021-05-25	NVDA	Stock	15.766	15.8185	15.4825	15.6478	435408000.0
2021-05-25	AMZN	Stock	163.3335	163.991	160.688	162.9525	65222000.0
2021-05-25	GOOGL	Stock	118.6	119.2	117.75	118.1435	22439640.0
2021-05-25	META	Stock	327.08	329.18	324.8	327.79	16437000.0
2021-05-25	TSLA	Stock	202.4367	204.6633	198.57	201.5633	84017700.0
2021-05-25	TLT	Stock	138.63	139.5	138.62	139.46	12346882.0
2021-05-25	ES	Stock	83.32	83.57	81.92	82.33	1447100.0
2021-05-25	CL	Stock	84.47	84.68	83.9	84.59	3472800.0
2021-05-25	A	Stock	133.41	134.8	133.01	133.23	1890600.0
2021-05-25	AA	Stock	36.46	36.93	34.94	35.15	5868500.0
2021-05-25	AAC-DELISTED	Stock	9.8	9.86	9.79	9.82	54321.0
2021-05-25	AACG	Stock	2.84	2.9	2.71	2.77	48600.0
2021-05-25	AACQ-DELISTED	Stock	9.94	9.95	9.87	9.89	247116.0
2021-05-25	AACQU-DELISTED	Stock	10.27	10.3554	10.27	10.3554	1800.0
2021-05-25	AACQW-DELISTED	Stock	1.65	1.73	1.58	1.64	169991.0
2021-05-25	AAIC-DELISTED	Stock	4.02	4.09	3.96	4.01	155709.0
2021-05-25	AAIC.C-DELISTED	Stock	24.9599	24.9599	24.7	24.89	4498.0
2021-05-25	AAL	Stock	23.45	24.17	23.11	23.21	50630500.0
2021-05-25	AAM.A-DELISTED	Stock	26.34	26.34	26.189	26.25	12603.0
2021-05-25	AAM.B-DELISTED	Stock	27.09	27.17	27.09	27.17	6075.0
2021-05-25	AAMC-DELISTED	Stock	5.0441	5.2426	5.0441	5.2206	14889.0
2021-05-25	AAME	Stock	4.14	4.17	3.93	4.09	94600.0
2021-05-25	AAMI	Stock	22.69	22.89	22.19	22.21	413800.0
2021-05-25	AAN-DELISTED	Stock	34.9	35.29	34.135	34.21	203800.0
2021-05-25	AAOI	Stock	7.91	7.99	7.7	7.71	509000.0
2021-05-25	AAON	Stock	44.2667	44.6867	43.8067	43.9733	223950.0
2021-05-25	AAP	Stock	191.47	191.94	187.16	188.0	1146400.0
2021-05-25	AAQC-DELISTED	Stock	9.65	9.66	9.62	9.64	6132.0
2021-05-25	AAT	Stock	36.0	36.05	35.14	35.14	318100.0
2021-05-25	AAU-DELISTED	Stock	0.55	0.56	0.546	0.554	494775.0
2021-05-25	AAUAF-DELISTED	Stock	0.55	0.56	0.546	0.5584	511104.0
2021-05-25	AAWW-DELISTED	Stock	73.78	74.27	72.885	73.25	337249.0
2021-05-25	AAXJ	Stock	93.49	93.49	92.98	93.3	1101282.0
2021-05-25	AB	Stock	44.56	44.97	43.69	43.69	379400.0
2021-05-25	ABB-DELISTED	Stock	33.83	33.945	33.6249	33.68	1208960.0
2021-05-25	ABBNY-DELISTED	Stock	33.83	33.945	33.6249	33.67	1296949.0
2021-05-25	ABBV	Stock	115.97	116.0	114.19	114.56	6574200.0
2021-05-25	ABC-DELISTED	Stock	118.12	118.5494	114.6	115.03	1157775.0
2021-05-25	ABCB	Stock	56.26	57.25	53.13	53.17	650600.0
2021-05-25	ABCL	Stock	32.26	33.638	32.06	32.56	800100.0
2021-05-25	ABCM-DELISTED	Stock	19.97	20.21	19.85	20.1	110009.0
2021-05-25	ABEO	Stock	38.5	38.75	37.0	37.25	33396.0
2021-05-25	ABEV	Stock	3.36	3.37	3.3	3.3	23692700.0
2021-05-25	ABG	Stock	198.99	201.98	193.66	193.84	106000.0
2021-05-25	ABGI-DELISTED	Stock	9.875	9.94	9.82	9.94	11882.0
2021-05-25	ABM	Stock	49.62	50.03	49.16	49.26	472700.0
2021-05-25	ABMD-DELISTED	Stock	281.0	285.0	281.0	284.13	137293.0
2021-05-25	ABNB	Stock	137.4	137.85	133.56	133.99	10435800.0

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

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