PREVIEW / stock_daily / 2021-01-28

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-28.parquet
  size:    244 KB
  rows:    7,377
  symbols: 2,702

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-01-28	AAPL	Stock	139.52	141.99	136.7	137.09	142621100.0
2021-01-28	MSFT	Stock	235.61	242.64	235.09	238.93	49111200.0
2021-01-28	NVDA	Stock	12.9963	13.3398	12.9605	13.051	228316000.0
2021-01-28	AMZN	Stock	161.752	165.084	161.4345	161.881	62984000.0
2021-01-28	GOOGL	Stock	91.55	94.3995	91.55	92.66	55278100.0
2021-01-28	META	Stock	277.18	286.79	264.7	265.0	37758800.0
2021-01-28	TSLA	Stock	273.3333	282.6667	267.0	278.4767	79134000.0
2021-01-28	TLT	Stock	153.4	153.46	152.16	152.92	10667755.0
2021-01-28	ES	Stock	88.72	91.23	88.55	89.14	1464800.0
2021-01-28	CL	Stock	78.04	79.83	78.03	79.15	8037900.0
2021-01-28	A	Stock	119.0	122.67	118.78	121.56	1677900.0
2021-01-28	AA	Stock	19.1	19.3	18.475	18.5	7028600.0
2021-01-28	AACG	Stock	1.3	1.36	1.27	1.27	44800.0
2021-01-28	AACQ-DELISTED	Stock	10.6	10.72	10.51	10.57	839040.0
2021-01-28	AACQU-DELISTED	Stock	11.23	11.35	11.12	11.22	138533.0
2021-01-28	AACQW-DELISTED	Stock	2.0	2.19	1.9	2.01	412787.0
2021-01-28	AAIC-DELISTED	Stock	3.74	3.74	3.63	3.68	147558.0
2021-01-28	AAIC.C-DELISTED	Stock	21.6	21.71	21.6	21.71	896.0
2021-01-28	AAL	Stock	20.33	21.77	16.82	18.1	319607600.0
2021-01-28	AAM.A-DELISTED	Stock	26.58	26.58	26.3493	26.395	7596.0
2021-01-28	AAM.B-DELISTED	Stock	26.67	26.73	26.59	26.71	12811.0
2021-01-28	AAMC-DELISTED	Stock	6.2706	6.2706	5.9442	6.1706	16232.0
2021-01-28	AAME	Stock	2.45	2.45	2.36	2.36	3200.0
2021-01-28	AAMI	Stock	18.6	19.34	18.44	19.2	624000.0
2021-01-28	AAN-DELISTED	Stock	18.11	18.2	17.08	17.46	615700.0
2021-01-28	AAOI	Stock	12.01	12.17	10.87	11.3	1231900.0
2021-01-28	AAON	Stock	50.4667	51.6733	49.1467	49.3533	422100.0
2021-01-28	AAP	Stock	149.62	154.67	148.5	153.34	1634500.0
2021-01-28	AAT	Stock	28.35	29.29	28.12	28.5	391500.0
2021-01-28	AAU-DELISTED	Stock	0.5847	0.61	0.53	0.5887	5148820.0
2021-01-28	AAUAF-DELISTED	Stock	0.5847	0.61	0.53	0.5887	5221845.0
2021-01-28	AAWW-DELISTED	Stock	56.13	56.99	52.4	52.96	447499.0
2021-01-28	AAXJ	Stock	94.64	96.245	94.5	95.89	1309574.0
2021-01-28	AB	Stock	36.51	37.44	36.11	36.87	672000.0
2021-01-28	ABB-DELISTED	Stock	29.99	30.33	29.95	30.15	1798288.0
2021-01-28	ABBNY-DELISTED	Stock	29.99	30.33	29.95	30.15	1939743.0
2021-01-28	ABBV	Stock	104.0	105.14	103.11	104.21	8534300.0
2021-01-28	ABC-DELISTED	Stock	107.38	109.645	106.82	107.0	766035.0
2021-01-28	ABCB	Stock	41.89	42.16	41.02	41.29	571400.0
2021-01-28	ABCL	Stock	46.45	52.5	46.14	51.5	998600.0
2021-01-28	ABCM-DELISTED	Stock	22.72	23.28	22.55	23.09	20990.0
2021-01-28	ABEO	Stock	50.25	52.5	49.5	49.75	88336.0
2021-01-28	ABEV	Stock	2.89	2.95	2.88	2.9	27027100.0
2021-01-28	ABG	Stock	146.7	148.34	139.51	146.86	372900.0
2021-01-28	ABM	Stock	40.16	40.4	38.35	38.45	657900.0
2021-01-28	ABMD-DELISTED	Stock	340.0	387.4	334.37	354.96	692484.0
2021-01-28	ABNB	Stock	202.6	212.84	187.05	187.37	7077700.0
2021-01-28	ABR	Stock	14.27	14.64	14.17	14.57	1124700.0
2021-01-28	ABR.B-DELISTED	Stock	25.25	25.46	25.25	25.44	3435.0
2021-01-28	ABR.C-DELISTED	Stock	26.05	26.0901	26.05	26.0701	2000.0

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

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