PREVIEW / stock_daily / 2021-08-23

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-23.parquet
  size:    259 KB
  rows:    7,947
  symbols: 2,808

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-08-23	AAPL	Stock	148.31	150.19	147.89	149.71	60131800.0
2021-08-23	MSFT	Stock	303.25	305.4	301.85	304.65	22830200.0
2021-08-23	NVDA	Stock	20.971	21.997	20.95	21.958	575807000.0
2021-08-23	AMZN	Stock	160.595	164.045	160.5005	163.2935	65362000.0
2021-08-23	GOOGL	Stock	137.9695	140.8745	137.6075	140.0415	28453400.0
2021-08-23	META	Stock	359.44	365.69	359.1	363.35	10942000.0
2021-08-23	TSLA	Stock	228.48	237.3767	226.9167	235.4333	60794700.0
2021-08-23	TLT	Stock	150.2	150.495	149.92	150.45	10615040.0
2021-08-23	ES	Stock	91.78	92.1	90.79	91.12	1656200.0
2021-08-23	CL	Stock	78.73	78.98	78.33	78.38	3163400.0
2021-08-23	A	Stock	169.43	170.57	168.13	170.0	2061400.0
2021-08-23	AA	Stock	38.6	41.44	38.57	41.11	9678600.0
2021-08-23	AAC-DELISTED	Stock	9.67	9.7	9.66	9.69	127422.0
2021-08-23	AACG	Stock	2.58	2.64	2.5	2.53	57200.0
2021-08-23	AACIU	Stock	9.81	9.83	9.8	9.81	355588.0
2021-08-23	AAIC-DELISTED	Stock	3.75	3.795	3.75	3.77	73347.0
2021-08-23	AAIC.C-DELISTED	Stock	25.1	25.24	25.1	25.1867	6822.0
2021-08-23	AAL	Stock	18.88	19.32	18.81	19.11	23637500.0
2021-08-23	AAM.A-DELISTED	Stock	26.2501	26.2512	26.1215	26.2	9145.0
2021-08-23	AAM.B-DELISTED	Stock	27.05	27.207	27.05	27.2	33049.0
2021-08-23	AAMC-DELISTED	Stock	4.0294	4.039	4.0281	4.039	14851.0
2021-08-23	AAME	Stock	3.6	3.7	3.59	3.67	19800.0
2021-08-23	AAMI	Stock	26.43	26.57	26.29	26.38	210800.0
2021-08-23	AAN-DELISTED	Stock	28.33	28.53	26.74	26.91	255100.0
2021-08-23	AAOI	Stock	6.64	6.8	6.63	6.73	488800.0
2021-08-23	AAON	Stock	45.96	46.5933	45.6667	46.1267	129750.0
2021-08-23	AAP	Stock	210.45	211.2	207.64	207.77	1122300.0
2021-08-23	AAQC-DELISTED	Stock	9.62	9.63	9.6199	9.63	8177.0
2021-08-23	AAT	Stock	38.23	38.25	37.7	37.91	126900.0
2021-08-23	AATC	Stock	6.89	7.05	6.81	7.02	50303.0
2021-08-23	AAU-DELISTED	Stock	0.385	0.4	0.3805	0.3956	473019.0
2021-08-23	AAUAF-DELISTED	Stock	0.385	0.4	0.3805	0.3956	481075.0
2021-08-23	AAWW-DELISTED	Stock	77.44	77.52	74.58	74.68	279851.0
2021-08-23	AAXJ	Stock	84.61	85.41	84.59	85.24	2099429.0
2021-08-23	AB	Stock	50.99	51.24	50.51	50.89	454400.0
2021-08-23	ABB-DELISTED	Stock	37.74	38.01	37.66	37.82	1007481.0
2021-08-23	ABBNY-DELISTED	Stock	37.74	38.01	37.66	37.81	1118664.0
2021-08-23	ABBV	Stock	119.8	120.45	119.22	119.36	4748300.0
2021-08-23	ABC-DELISTED	Stock	120.16	120.24	118.99	119.7	330523.0
2021-08-23	ABCB	Stock	48.78	49.04	48.46	48.79	184100.0
2021-08-23	ABCL	Stock	16.49	17.17	16.15	16.91	1524500.0
2021-08-23	ABCM-DELISTED	Stock	20.32	20.69	20.32	20.65	25737.0
2021-08-23	ABEO	Stock	29.5	32.0	29.5	32.0	22652.0
2021-08-23	ABEV	Stock	3.19	3.21	3.16	3.18	15096000.0
2021-08-23	ABG	Stock	187.37	189.59	184.19	189.12	72100.0
2021-08-23	ABGI-DELISTED	Stock	9.63	9.69	9.63	9.69	35900.0
2021-08-23	ABM	Stock	48.53	48.77	48.19	48.51	372000.0
2021-08-23	ABMD-DELISTED	Stock	348.0	355.935	348.0	352.07	179982.0
2021-08-23	ABNB	Stock	144.9	147.63	144.15	146.79	4727400.0
2021-08-23	ABOS	Stock	17.59	17.78	17.03	17.58	113400.0

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

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