PREVIEW / stock_daily / 2021-08-24

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-24.parquet
  size:    259 KB
  rows:    7,908
  symbols: 2,778

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-24	AAPL	Stock	149.45	150.86	149.15	149.62	48606400.0
2021-08-24	MSFT	Stock	305.02	305.65	302.0	302.62	18175800.0
2021-08-24	NVDA	Stock	21.753	21.959	21.535	21.793	297299000.0
2021-08-24	AMZN	Stock	164.0	165.7745	163.729	165.289	51036000.0
2021-08-24	GOOGL	Stock	140.6115	142.08	140.3385	141.2615	19267220.0
2021-08-24	META	Stock	363.66	367.96	361.84	365.51	9235100.0
2021-08-24	TSLA	Stock	236.8933	238.4067	234.2133	236.1633	39249300.0
2021-08-24	TLT	Stock	149.76	150.07	149.28	149.28	13835931.0
2021-08-24	ES	Stock	90.93	91.25	89.75	90.88	1213900.0
2021-08-24	CL	Stock	78.0	78.29	77.66	77.67	2923000.0
2021-08-24	A	Stock	170.23	171.21	169.22	170.57	1238600.0
2021-08-24	AA	Stock	41.83	43.03	41.74	42.13	5672800.0
2021-08-24	AAC-DELISTED	Stock	9.69	9.69	9.67	9.69	7652.0
2021-08-24	AACG	Stock	2.54	2.94	2.54	2.63	230100.0
2021-08-24	AACIU	Stock	9.82	9.855	9.82	9.85	389843.0
2021-08-24	AAIC-DELISTED	Stock	3.78	3.85	3.78	3.79	75115.0
2021-08-24	AAIC.C-DELISTED	Stock	25.095	25.19	25.0	25.05	2153.0
2021-08-24	AAL	Stock	19.4	20.02	19.39	19.83	31550400.0
2021-08-24	AAM.A-DELISTED	Stock	26.22	26.22	26.185	26.19	2552.0
2021-08-24	AAM.B-DELISTED	Stock	27.07	27.191	27.07	27.1	7307.0
2021-08-24	AAMC-DELISTED	Stock	4.0244	4.2659	3.9925	4.0206	40202.0
2021-08-24	AAME	Stock	3.69	3.83	3.68	3.8	22100.0
2021-08-24	AAMI	Stock	26.38	26.935	26.37	26.86	365200.0
2021-08-24	AAN-DELISTED	Stock	26.97	28.11	26.66	27.98	252900.0
2021-08-24	AAOI	Stock	6.79	7.015	6.75	6.88	418000.0
2021-08-24	AAON	Stock	46.1733	46.36	45.8467	45.9667	131550.0
2021-08-24	AAP	Stock	206.6	214.67	205.03	207.78	1473200.0
2021-08-24	AAQC-DELISTED	Stock	9.625	9.625	9.625	9.625	200.0
2021-08-24	AAT	Stock	37.97	38.26	37.7	38.15	131300.0
2021-08-24	AATC	Stock	7.0	7.04	6.87	6.97	25966.0
2021-08-24	AAU-DELISTED	Stock	0.4	0.401	0.3861	0.3896	595289.0
2021-08-24	AAUAF-DELISTED	Stock	0.4	0.401	0.3861	0.3861	605847.0
2021-08-24	AAWW-DELISTED	Stock	74.68	76.1381	73.855	74.5	219318.0
2021-08-24	AAXJ	Stock	86.38	87.195	86.38	87.15	864368.0
2021-08-24	AB	Stock	50.69	51.69	50.69	51.18	343500.0
2021-08-24	ABB-DELISTED	Stock	37.89	38.03	37.795	37.925	711581.0
2021-08-24	ABBNY-DELISTED	Stock	37.89	38.03	37.795	37.95	812937.0
2021-08-24	ABBV	Stock	119.72	119.72	118.42	119.68	3831500.0
2021-08-24	ABC-DELISTED	Stock	119.5	119.5	117.85	117.99	688781.0
2021-08-24	ABCB	Stock	48.89	49.41	48.73	49.18	172700.0
2021-08-24	ABCL	Stock	17.09	17.29	16.8	17.06	1030200.0
2021-08-24	ABCM-DELISTED	Stock	20.58	20.6959	20.42	20.54	26745.0
2021-08-24	ABEO	Stock	31.75	33.0	31.25	32.75	18116.0
2021-08-24	ABEV	Stock	3.21	3.33	3.21	3.27	18444300.0
2021-08-24	ABG	Stock	189.98	192.86	189.62	190.84	132100.0
2021-08-24	ABGI-DELISTED	Stock	9.64	9.64	9.64	9.64	200.0
2021-08-24	ABM	Stock	48.92	49.02	48.18	48.38	279600.0
2021-08-24	ABMD-DELISTED	Stock	350.78	361.255	350.78	357.44	121598.0
2021-08-24	ABNB	Stock	147.0	161.98	146.5	161.42	22096800.0
2021-08-24	ABOS	Stock	17.72	17.948	16.84	17.06	94800.0

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

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