PREVIEW / stock_daily / 2021-12-07

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-07.parquet
  size:    262 KB
  rows:    8,028
  symbols: 2,661

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-12-07	AAPL	Stock	169.08	171.58	168.34	171.18	120405400.0
2021-12-07	MSFT	Stock	331.64	335.8	330.1	334.92	31021900.0
2021-12-07	NVDA	Stock	30.957	32.449	30.651	32.427	593053000.0
2021-12-07	AMZN	Stock	174.6	177.4995	173.3345	176.1645	66410000.0
2021-12-07	GOOGL	Stock	145.5965	147.5312	145.2275	147.2695	32240300.0
2021-12-07	META	Stock	321.57	326.54	321.0	322.81	18794000.0
2021-12-07	TSLA	Stock	348.0667	352.5567	342.27	350.5833	56084700.0
2021-12-07	TLT	Stock	151.72	152.525	150.8601	151.0	22115851.0
2021-12-07	ES	Stock	85.78	87.48	85.55	87.3	1541200.0
2021-12-07	CL	Stock	78.25	78.82	77.67	77.81	3952500.0
2021-12-07	A	Stock	152.84	156.24	152.61	153.8	1422700.0
2021-12-07	AA	Stock	47.07	48.05	46.73	46.94	5637700.0
2021-12-07	AAC-DELISTED	Stock	9.79	9.81	9.7821	9.79	75565.0
2021-12-07	AACG	Stock	1.38	1.59	1.27	1.53	32100.0
2021-12-07	AACIW-DELISTED	Stock	0.5186	0.5186	0.51	0.5177	650.0
2021-12-07	AAIC-DELISTED	Stock	3.68	3.69	3.64	3.64	90024.0
2021-12-07	AAIC.C-DELISTED	Stock	25.47	25.47	25.45	25.46	828.0
2021-12-07	AAL	Stock	18.32	18.71	17.72	17.89	50249900.0
2021-12-07	AAM.A-DELISTED	Stock	25.33	25.47	25.27	25.32	11435.0
2021-12-07	AAM.B-DELISTED	Stock	26.14	26.3	26.13	26.13	16884.0
2021-12-07	AAME	Stock	3.75	3.9	3.72	3.75	11000.0
2021-12-07	AAMI	Stock	26.95	29.469	26.8	28.7	9019500.0
2021-12-07	AAN-DELISTED	Stock	24.11	24.3	23.5	23.87	255200.0
2021-12-07	AAOI	Stock	5.56	5.74	5.54	5.68	406000.0
2021-12-07	AAON	Stock	53.6667	54.5667	53.6667	54.1067	445050.0
2021-12-07	AAP	Stock	231.88	236.75	231.19	234.95	762000.0
2021-12-07	AAQC-DELISTED	Stock	9.72	9.74	9.71	9.73	4673.0
2021-12-07	AAT	Stock	36.84	36.84	36.22	36.31	208400.0
2021-12-07	AATC	Stock	6.37	6.74	6.32	6.42	57589.0
2021-12-07	AAU-DELISTED	Stock	0.318	0.32	0.3151	0.3189	360370.0
2021-12-07	AAUAF-DELISTED	Stock	0.318	0.32	0.3151	0.3189	365461.0
2021-12-07	AAWW-DELISTED	Stock	88.11	89.77	87.37	87.71	593606.0
2021-12-07	AAXJ	Stock	85.0	85.25	84.86	85.2	1420235.0
2021-12-07	AB	Stock	52.81	53.42	52.16	52.88	441500.0
2021-12-07	ABB-DELISTED	Stock	35.82	36.375	35.82	36.26	2104822.0
2021-12-07	ABBNY-DELISTED	Stock	35.82	36.375	35.82	36.27	2357920.0
2021-12-07	ABBV	Stock	121.98	122.14	121.0	121.51	6123300.0
2021-12-07	ABC-DELISTED	Stock	119.34	120.64	118.46	119.6	583628.0
2021-12-07	ABCB	Stock	50.75	50.93	49.11	49.48	299800.0
2021-12-07	ABCL	Stock	13.68	14.61	13.68	14.55	1878400.0
2021-12-07	ABCM-DELISTED	Stock	22.61	23.29	22.58	22.86	94999.0
2021-12-07	ABEO	Stock	14.75	16.25	14.75	15.75	36160.0
2021-12-07	ABEV	Stock	2.84	2.87	2.84	2.86	16413400.0
2021-12-07	ABG	Stock	177.25	178.28	170.45	173.23	336100.0
2021-12-07	ABGI-DELISTED	Stock	9.75	9.78	9.71	9.73	564433.0
2021-12-07	ABM	Stock	46.67	46.79	45.58	45.72	383200.0
2021-12-07	ABMD-DELISTED	Stock	314.23	326.79	314.23	320.74	273440.0
2021-12-07	ABNB	Stock	185.61	187.5	182.02	183.14	6264600.0
2021-12-07	ABOS	Stock	7.54	7.76	7.18	7.54	141300.0
2021-12-07	ABR	Stock	17.99	18.34	17.98	18.26	1612100.0

> showing 50 of 8,028 rows — these rows as CSV

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