PREVIEW / stock_daily / 2021-11-16

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-16.parquet
  size:    262 KB
  rows:    7,996
  symbols: 2,669

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-11-16	AAPL	Stock	149.94	151.49	149.34	151.0	59256200.0
2021-11-16	MSFT	Stock	335.68	340.67	335.51	339.51	20886800.0
2021-11-16	NVDA	Stock	29.759	30.39	29.706	30.203	264484000.0
2021-11-16	AMZN	Stock	176.95	178.825	176.2575	177.035	44342000.0
2021-11-16	GOOGL	Stock	148.1495	148.7625	147.3125	147.876	18904000.0
2021-11-16	META	Stock	343.83	346.65	340.87	342.96	18181100.0
2021-11-16	TSLA	Stock	334.4367	352.4	334.06	351.5767	79627200.0
2021-11-16	TLT	Stock	145.69	146.38	144.85	145.11	12998708.0
2021-11-16	ES	Stock	83.69	83.99	83.22	83.37	974000.0
2021-11-16	CL	Stock	78.5	78.78	77.84	77.88	3140500.0
2021-11-16	A	Stock	157.05	163.0	156.96	161.39	1276300.0
2021-11-16	AA	Stock	49.86	50.0	47.96	48.2	8759700.0
2021-11-16	AAC-DELISTED	Stock	9.84	9.85	9.81	9.82	214778.0
2021-11-16	AACG	Stock	2.15	2.21	2.15	2.15	14100.0
2021-11-16	AACIU	Stock	9.92	9.92	9.92	9.92	165.0
2021-11-16	AACIW-DELISTED	Stock	0.5	0.57	0.5	0.5201	42702.0
2021-11-16	AAIC-DELISTED	Stock	3.78	3.8	3.7474	3.75	263930.0
2021-11-16	AAIC.C-DELISTED	Stock	25.685	25.685	25.685	25.685	100.0
2021-11-16	AAL	Stock	20.23	20.25	19.54	19.84	36075200.0
2021-11-16	AAM.A-DELISTED	Stock	25.85	25.87	25.76	25.76	6663.0
2021-11-16	AAM.B-DELISTED	Stock	26.86	27.0	26.8105	26.88	16283.0
2021-11-16	AAMC-DELISTED	Stock	7.3529	7.3529	6.9882	7.275	14719.0
2021-11-16	AAME	Stock	4.25	4.34	4.15	4.15	17000.0
2021-11-16	AAMI	Stock	30.51	30.85	30.42	30.5	2021400.0
2021-11-16	AAN-DELISTED	Stock	25.47	25.731	25.175	25.23	147000.0
2021-11-16	AAOI	Stock	6.0	6.085	5.931	6.01	698800.0
2021-11-16	AAON	Stock	51.1933	51.7667	50.7867	51.3933	165000.0
2021-11-16	AAP	Stock	238.78	239.91	230.27	235.69	1585200.0
2021-11-16	AAQC-DELISTED	Stock	9.78	9.8	9.75	9.76	26204.0
2021-11-16	AAT	Stock	38.79	38.86	38.31	38.59	180100.0
2021-11-16	AATC	Stock	6.95	6.98	6.85	6.87	20267.0
2021-11-16	AAU-DELISTED	Stock	0.3943	0.4	0.375	0.3835	752576.0
2021-11-16	AAUAF-DELISTED	Stock	0.3943	0.4	0.375	0.384	869356.0
2021-11-16	AAWW-DELISTED	Stock	87.54	89.04	87.13	88.02	297555.0
2021-11-16	AAXJ	Stock	88.02	88.17587	87.73	88.0	555372.0
2021-11-16	AB	Stock	55.63	56.38	55.6	56.16	110800.0
2021-11-16	ABB-DELISTED	Stock	34.89	35.2262	34.87	35.11	1293573.0
2021-11-16	ABBNY-DELISTED	Stock	34.89	35.2262	34.87	35.1	2223534.0
2021-11-16	ABBV	Stock	116.61	117.47	116.34	116.42	3476400.0
2021-11-16	ABC-DELISTED	Stock	124.35	125.33	123.81	123.87	540903.0
2021-11-16	ABCB	Stock	53.9	54.17	53.3	53.9	391800.0
2021-11-16	ABCL	Stock	16.3	16.68	15.94	16.36	1600300.0
2021-11-16	ABCM-DELISTED	Stock	22.58	22.94	22.51	22.88	28449.0
2021-11-16	ABEO	Stock	22.75	22.75	21.5	21.75	19016.0
2021-11-16	ABEV	Stock	3.14	3.18	3.12	3.12	22860500.0
2021-11-16	ABG	Stock	183.46	185.8	180.24	183.55	215300.0
2021-11-16	ABM	Stock	48.79	49.14	48.44	48.8	377400.0
2021-11-16	ABMD-DELISTED	Stock	348.1	354.43	344.68	351.78	62670.0
2021-11-16	ABNB	Stock	205.59	209.93	203.47	207.04	4431300.0
2021-11-16	ABOS	Stock	11.89	11.89	10.58	10.73	55600.0

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

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