PREVIEW / stock_daily / 2021-07-23

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-23.parquet
  size:    256 KB
  rows:    7,856
  symbols: 2,790

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-07-23	AAPL	Stock	147.55	148.72	146.92	148.56	71447400.0
2021-07-23	MSFT	Stock	287.37	289.99	286.5	289.67	22768100.0
2021-07-23	NVDA	Stock	19.656	19.7	19.25	19.558	195672000.0
2021-07-23	AMZN	Stock	182.0	183.3055	181.102	182.832	48726000.0
2021-07-23	GOOGL	Stock	130.4305	133.399	129.8005	133.015	41506420.0
2021-07-23	META	Stock	360.91	375.33	357.19	369.79	33694300.0
2021-07-23	TSLA	Stock	215.4533	216.2667	212.4333	214.46	43814700.0
2021-07-23	TLT	Stock	147.94	148.655	147.89	148.5	12639262.0
2021-07-23	ES	Stock	84.93	86.26	84.74	86.22	834500.0
2021-07-23	CL	Stock	81.72	83.46	81.53	83.28	3107500.0
2021-07-23	A	Stock	150.59	152.41	150.43	152.31	2132000.0
2021-07-23	AA	Stock	37.52	37.87	36.49	37.06	5840600.0
2021-07-23	AAC-DELISTED	Stock	9.79	9.79	9.74	9.76	17963.0
2021-07-23	AACG	Stock	3.26	4.27	3.16	4.13	2327700.0
2021-07-23	AAIC-DELISTED	Stock	3.87	3.91	3.8399	3.88	486110.0
2021-07-23	AAIC.C-DELISTED	Stock	25.1809	25.1809	25.1809	25.1809	200.0
2021-07-23	AAL	Stock	21.35	21.69	21.02	21.2	29379200.0
2021-07-23	AAM.A-DELISTED	Stock	26.53	26.53	26.445	26.5	3577.0
2021-07-23	AAM.B-DELISTED	Stock	27.08	27.08	26.97	27.07	4878.0
2021-07-23	AAMC-DELISTED	Stock	5.0029	5.0029	4.9089	4.9089	10224.0
2021-07-23	AAME	Stock	3.99	4.16	3.8	4.12	54800.0
2021-07-23	AAMI	Stock	23.83	24.23	23.738	23.92	234400.0
2021-07-23	AAN-DELISTED	Stock	27.86	28.0	26.7	27.29	361100.0
2021-07-23	AAOI	Stock	7.37	7.418	7.18	7.33	407900.0
2021-07-23	AAON	Stock	40.1933	40.5067	39.8333	40.4333	168450.0
2021-07-23	AAP	Stock	210.58	215.09	210.58	214.95	360300.0
2021-07-23	AAQC-DELISTED	Stock	9.6728	9.6728	9.6728	9.6728	200.0
2021-07-23	AAT	Stock	36.94	37.1	36.37	36.57	300200.0
2021-07-23	AATC	Stock	6.58	6.58	6.33	6.41	43512.0
2021-07-23	AAU-DELISTED	Stock	0.4247	0.4299	0.416	0.416	522527.0
2021-07-23	AAUAF-DELISTED	Stock	0.4247	0.4299	0.416	0.4201	544243.0
2021-07-23	AAWW-DELISTED	Stock	65.37	65.67	64.17	65.63	137539.0
2021-07-23	AAXJ	Stock	90.04	90.26	89.32	89.93	1227352.0
2021-07-23	AB	Stock	46.2	46.7	46.01	46.62	182300.0
2021-07-23	ABB-DELISTED	Stock	36.77	36.84	36.51	36.71	1123257.0
2021-07-23	ABBNY-DELISTED	Stock	36.77	36.84	36.51	36.7	1319073.0
2021-07-23	ABBV	Stock	117.98	118.67	117.57	118.19	4411100.0
2021-07-23	ABC-DELISTED	Stock	120.05	122.56	119.91	121.28	729727.0
2021-07-23	ABCB	Stock	45.69	46.29	45.06	45.97	405000.0
2021-07-23	ABCL	Stock	16.05	16.35	15.72	15.79	1387500.0
2021-07-23	ABCM-DELISTED	Stock	18.21	18.4977	18.085	18.28	45156.0
2021-07-23	ABEO	Stock	33.75	33.75	32.0	32.75	30276.0
2021-07-23	ABEV	Stock	3.24	3.26	3.17	3.19	14149200.0
2021-07-23	ABG	Stock	195.53	197.0	192.54	196.51	79600.0
2021-07-23	ABGI-DELISTED	Stock	9.7901	9.83	9.79	9.83	928.0
2021-07-23	ABM	Stock	45.5	46.07	45.18	45.91	368900.0
2021-07-23	ABMD-DELISTED	Stock	327.44	328.84	323.84	328.16	80981.0
2021-07-23	ABNB	Stock	139.8	140.0	137.41	138.73	2811100.0
2021-07-23	ABOS	Stock	16.87	17.309	16.48	17.08	95500.0
2021-07-23	ABR	Stock	17.72	17.82	17.54	17.7	732100.0

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

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