PREVIEW / stock_daily / 2021-10-06

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-06.parquet
  size:    257 KB
  rows:    7,858
  symbols: 2,663

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-10-06	AAPL	Stock	139.47	142.15	138.37	142.0	83221100.0
2021-10-06	MSFT	Stock	285.78	293.63	285.51	293.11	28002600.0
2021-10-06	NVDA	Stock	20.12	20.72	20.08	20.7	297202000.0
2021-10-06	AMZN	Stock	160.6765	163.217	159.931	163.1005	50660000.0
2021-10-06	GOOGL	Stock	134.75	137.75	134.55	137.565	24364280.0
2021-10-06	META	Stock	329.74	334.38	325.8	333.64	26443000.0
2021-10-06	TSLA	Stock	258.7333	262.22	257.74	260.9167	43898400.0
2021-10-06	TLT	Stock	144.23	144.715	144.025	144.39	18696687.0
2021-10-06	ES	Stock	84.69	86.32	84.18	86.26	1650100.0
2021-10-06	CL	Stock	74.07	75.19	74.01	75.1	4052700.0
2021-10-06	A	Stock	152.55	154.26	151.62	153.65	1794700.0
2021-10-06	AA	Stock	47.79	48.23	45.8	47.05	7321800.0
2021-10-06	AAC-DELISTED	Stock	9.77	9.77	9.75	9.77	94868.0
2021-10-06	AACG	Stock	2.26	2.26	2.2	2.22	17000.0
2021-10-06	AACIU	Stock	9.965	9.965	9.965	9.965	216.0
2021-10-06	AAIC-DELISTED	Stock	3.7	3.74	3.7	3.72	41745.0
2021-10-06	AAIC.C-DELISTED	Stock	25.26	25.26	25.215	25.215	266.0
2021-10-06	AAL	Stock	20.7	21.01	20.31	20.54	37908500.0
2021-10-06	AAM.A-DELISTED	Stock	25.59	25.74	25.57	25.74	19473.0
2021-10-06	AAM.B-DELISTED	Stock	26.95	26.99	26.73	26.95	21633.0
2021-10-06	AAMC-DELISTED	Stock	7.0	7.0	6.6647	6.9118	27975.0
2021-10-06	AAME	Stock	4.11	4.53	4.11	4.48	89900.0
2021-10-06	AAMI	Stock	25.89	26.571	25.84	26.5	965700.0
2021-10-06	AAN-DELISTED	Stock	27.54	27.88	27.08	27.54	138400.0
2021-10-06	AAOI	Stock	6.8	6.92	6.71	6.87	224800.0
2021-10-06	AAON	Stock	44.92	45.72	44.18	45.0867	197850.0
2021-10-06	AAP	Stock	207.63	211.83	206.33	211.3	512600.0
2021-10-06	AAQC-DELISTED	Stock	9.72	9.74	9.72	9.74	25785.0
2021-10-06	AAT	Stock	37.29	37.88	36.42	37.82	196500.0
2021-10-06	AATC	Stock	7.1905	7.294	7.05	7.05	27691.0
2021-10-06	AAU-DELISTED	Stock	0.37	0.3841	0.37	0.3841	532893.0
2021-10-06	AAUAF-DELISTED	Stock	0.37	0.3841	0.37	0.3841	539109.0
2021-10-06	AAWW-DELISTED	Stock	84.71	85.01	82.79	84.18	383031.0
2021-10-06	AAXJ	Stock	82.94	83.63	82.67	83.62	603761.0
2021-10-06	AB	Stock	50.19	50.47	49.63	50.06	208700.0
2021-10-06	ABB-DELISTED	Stock	32.52	32.835	32.4299	32.79	1209687.0
2021-10-06	ABBNY-DELISTED	Stock	32.52	32.835	32.4299	32.8	1317883.0
2021-10-06	ABBV	Stock	109.3	109.67	108.15	109.32	5710300.0
2021-10-06	ABC-DELISTED	Stock	117.79	118.49	114.74	116.87	649663.0
2021-10-06	ABCB	Stock	52.19	52.26	50.81	52.16	275700.0
2021-10-06	ABCL	Stock	16.18	16.29	15.45	15.55	2424100.0
2021-10-06	ABCM-DELISTED	Stock	20.61	20.9	20.5	20.72	33027.0
2021-10-06	ABEO	Stock	23.25	25.75	22.5	24.0	54348.0
2021-10-06	ABEV	Stock	2.73	2.75	2.67	2.71	19017400.0
2021-10-06	ABG	Stock	198.74	199.31	195.12	196.06	105200.0
2021-10-06	ABM	Stock	46.49	47.02	45.2	46.0	223000.0
2021-10-06	ABMD-DELISTED	Stock	330.0	338.04	329.35	337.23	114453.0
2021-10-06	ABNB	Stock	161.39	167.32	160.63	167.25	2461500.0
2021-10-06	ABOS	Stock	15.22	15.25	14.46	14.85	96100.0
2021-10-06	ABR	Stock	18.84	19.0	18.68	18.99	895700.0

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

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