PREVIEW / stock_daily / 2021-05-17

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-17.parquet
  size:    255 KB
  rows:    7,822
  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-17	AAPL	Stock	126.82	126.93	125.17	126.27	74244600.0
2021-05-17	MSFT	Stock	246.55	246.59	243.52	245.18	24970200.0
2021-05-17	NVDA	Stock	14.157	14.1692	13.8535	14.1655	216980000.0
2021-05-17	AMZN	Stock	162.2965	164.6375	161.7295	163.5195	74478000.0
2021-05-17	GOOGL	Stock	113.1785	114.489	112.7755	114.446	21597380.0
2021-05-17	META	Stock	313.55	315.68	311.58	315.46	15401300.0
2021-05-17	TSLA	Stock	191.85	196.5767	187.0667	192.2767	97171200.0
2021-05-17	TLT	Stock	136.83	137.17	136.565	136.79	6113792.0
2021-05-17	ES	Stock	85.2	85.76	83.96	84.06	1436000.0
2021-05-17	CL	Stock	83.79	84.27	83.38	83.55	3522100.0
2021-05-17	A	Stock	130.84	131.05	129.91	130.11	886700.0
2021-05-17	AA	Stock	39.55	40.7	38.57	40.68	4774500.0
2021-05-17	AAC-DELISTED	Stock	9.82	9.82	9.77	9.77	62219.0
2021-05-17	AACG	Stock	2.77	2.96	2.72	2.96	52700.0
2021-05-17	AACQ-DELISTED	Stock	9.84	9.93	9.84	9.86	292825.0
2021-05-17	AACQU-DELISTED	Stock	10.8221	10.8221	10.28	10.37	700.0
2021-05-17	AACQW-DELISTED	Stock	1.54	1.55	1.45	1.48	70838.0
2021-05-17	AAIC-DELISTED	Stock	3.99	4.05	3.98	4.02	223567.0
2021-05-17	AAIC.C-DELISTED	Stock	24.11	24.4	24.11	24.3972	10052.0
2021-05-17	AAL	Stock	22.32	23.4	22.1	23.35	40716100.0
2021-05-17	AAM.A-DELISTED	Stock	26.29	26.32	26.19	26.3	7799.0
2021-05-17	AAM.B-DELISTED	Stock	27.05	27.1695	27.0	27.13	8220.0
2021-05-17	AAMC-DELISTED	Stock	4.7118	5.0382	4.6382	4.8735	182798.0
2021-05-17	AAME	Stock	4.17	4.64	4.16	4.48	228600.0
2021-05-17	AAMI	Stock	22.85	23.0	22.57	22.92	275300.0
2021-05-17	AAN-DELISTED	Stock	32.14	33.125	32.02	32.73	255900.0
2021-05-17	AAOI	Stock	7.47	7.91	7.36	7.78	535500.0
2021-05-17	AAON	Stock	45.52	45.52	44.9333	45.2467	201900.0
2021-05-17	AAP	Stock	203.91	204.76	202.01	204.58	825300.0
2021-05-17	AAQC-DELISTED	Stock	9.715	9.75	9.68	9.75	686.0
2021-05-17	AAT	Stock	36.11	36.14	35.09	35.41	542800.0
2021-05-17	AAU-DELISTED	Stock	0.51	0.558	0.5033	0.5538	1943764.0
2021-05-17	AAUAF-DELISTED	Stock	0.51	0.558	0.5033	0.5565	1972857.0
2021-05-17	AAWW-DELISTED	Stock	74.09	75.4	73.5	74.71	156669.0
2021-05-17	AAXJ	Stock	90.14	90.63	89.96	90.61	1030155.0
2021-05-17	AB	Stock	44.3	44.35	43.28	43.68	395500.0
2021-05-17	ABB-DELISTED	Stock	33.86	33.9653	33.683	33.83	1538433.0
2021-05-17	ABBNY-DELISTED	Stock	33.86	33.9653	33.683	33.83	2041107.0
2021-05-17	ABBV	Stock	116.77	117.71	116.56	116.89	6183200.0
2021-05-17	ABC-DELISTED	Stock	116.31	118.82	113.87	118.11	846736.0
2021-05-17	ABCB	Stock	56.75	57.88	55.8	56.51	200800.0
2021-05-17	ABCL	Stock	31.5	36.05	31.5	34.17	896100.0
2021-05-17	ABCM-DELISTED	Stock	20.05	20.2	19.93	20.02	53588.0
2021-05-17	ABEO	Stock	34.75	36.25	33.75	34.0	35004.0
2021-05-17	ABEV	Stock	3.27	3.37	3.26	3.34	20300600.0
2021-05-17	ABG	Stock	209.47	210.63	206.14	206.49	148400.0
2021-05-17	ABGI-DELISTED	Stock	9.7801	9.98	9.7801	9.98	7002.0
2021-05-17	ABM	Stock	53.06	53.47	52.46	52.88	202700.0
2021-05-17	ABMD-DELISTED	Stock	266.12	269.22	263.93	267.96	116620.0
2021-05-17	ABNB	Stock	137.156	137.79	130.253	132.5	39755000.0

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

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