PREVIEW / stock_daily / 2021-08-20

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-20.parquet
  size:    258 KB
  rows:    7,907
  symbols: 2,794

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-20	AAPL	Stock	147.44	148.5	146.78	148.19	60549600.0
2021-08-20	MSFT	Stock	299.72	305.84	298.06	304.36	40817600.0
2021-08-20	NVDA	Stock	19.991	20.865	19.933	20.816	675741000.0
2021-08-20	AMZN	Stock	160.1935	160.3905	158.788	159.9975	67168000.0
2021-08-20	GOOGL	Stock	136.0	137.554	135.25	137.4295	31193160.0
2021-08-20	META	Stock	354.6	359.99	353.31	359.37	8697700.0
2021-08-20	TSLA	Stock	227.6167	230.71	224.5667	226.7533	44525700.0
2021-08-20	TLT	Stock	150.59	150.81	150.11	150.55	12388424.0
2021-08-20	ES	Stock	91.09	92.66	90.56	92.11	2316000.0
2021-08-20	CL	Stock	79.12	79.43	78.56	78.8	3026100.0
2021-08-20	A	Stock	167.83	170.74	167.05	168.13	2023300.0
2021-08-20	AA	Stock	37.5	38.2	37.19	37.71	7819100.0
2021-08-20	AAC-DELISTED	Stock	9.69	9.69	9.66	9.67	53371.0
2021-08-20	AACG	Stock	2.52	2.67	2.52	2.58	31700.0
2021-08-20	AACIU	Stock	9.8045	9.84	9.8045	9.82	4292.0
2021-08-20	AAIC-DELISTED	Stock	3.66	3.79	3.66	3.73	151452.0
2021-08-20	AAIC.C-DELISTED	Stock	25.09	25.11	25.0001	25.11	3235.0
2021-08-20	AAL	Stock	18.64	18.86	18.29	18.5	28979400.0
2021-08-20	AAM.A-DELISTED	Stock	26.29	26.29	26.2301	26.25	5485.0
2021-08-20	AAM.B-DELISTED	Stock	26.99	27.08	26.99	27.08	9835.0
2021-08-20	AAMC-DELISTED	Stock	3.8118	4.0441	3.8118	3.9559	24922.0
2021-08-20	AAME	Stock	3.7	3.75	3.6	3.6	28100.0
2021-08-20	AAMI	Stock	26.2	26.46	26.12	26.3	365700.0
2021-08-20	AAN-DELISTED	Stock	28.21	29.0	27.945	28.11	402800.0
2021-08-20	AAOI	Stock	6.5	6.67	6.488	6.62	283800.0
2021-08-20	AAON	Stock	46.0467	46.5133	45.4133	45.96	185250.0
2021-08-20	AAP	Stock	208.52	209.95	206.79	209.68	511500.0
2021-08-20	AAQC-DELISTED	Stock	9.62	9.63	9.6	9.63	17518.0
2021-08-20	AAT	Stock	37.35	38.03	37.0	37.87	161800.0
2021-08-20	AATC	Stock	6.77	6.8654	6.6	6.83	48315.0
2021-08-20	AAU-DELISTED	Stock	0.365	0.377	0.3649	0.3756	394008.0
2021-08-20	AAUAF-DELISTED	Stock	0.365	0.377	0.3649	0.3727	400019.0
2021-08-20	AAWW-DELISTED	Stock	73.86	76.5	73.61	76.14	231732.0
2021-08-20	AAXJ	Stock	83.44	84.18	83.32	84.02	841969.0
2021-08-20	AB	Stock	50.0	51.39	50.0	50.79	302200.0
2021-08-20	ABB-DELISTED	Stock	37.435	37.69	37.435	37.62	552161.0
2021-08-20	ABBNY-DELISTED	Stock	37.435	37.69	37.435	37.62	637513.0
2021-08-20	ABBV	Stock	118.1	119.47	117.65	118.82	4112500.0
2021-08-20	ABC-DELISTED	Stock	118.97	119.9554	118.63	119.56	332148.0
2021-08-20	ABCB	Stock	47.29	48.41	47.28	48.32	200100.0
2021-08-20	ABCL	Stock	15.8	16.28	15.52	16.04	1470500.0
2021-08-20	ABCM-DELISTED	Stock	20.2	20.3623	20.14	20.26	47080.0
2021-08-20	ABEO	Stock	29.75	30.0	29.25	29.25	14472.0
2021-08-20	ABEV	Stock	3.09	3.21	3.06	3.19	32151300.0
2021-08-20	ABG	Stock	186.38	186.4	182.46	185.75	114600.0
2021-08-20	ABM	Stock	47.65	48.71	47.42	48.36	484600.0
2021-08-20	ABMD-DELISTED	Stock	332.92	348.45	332.92	348.36	127943.0
2021-08-20	ABNB	Stock	142.0	143.949	141.5	143.7	2996200.0
2021-08-20	ABOS	Stock	16.83	17.475	16.74	17.28	164400.0
2021-08-20	ABR	Stock	17.31	17.81	17.16	17.8	1401000.0

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

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