PREVIEW / stock_daily / 2021-07-26

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-26.parquet
  size:    258 KB
  rows:    7,903
  symbols: 2,818

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-07-26	AAPL	Stock	148.27	149.83	147.7	148.99	72434100.0
2021-07-26	MSFT	Stock	289.0	289.69	286.64	289.05	23176100.0
2021-07-26	NVDA	Stock	19.311	19.442	18.914	19.294	203943000.0
2021-07-26	AMZN	Stock	183.6585	185.604	182.3625	184.991	58002000.0
2021-07-26	GOOGL	Stock	133.3282	134.237	132.3015	134.035	30571480.0
2021-07-26	META	Stock	369.58	374.44	368.22	372.46	14925200.0
2021-07-26	TSLA	Stock	216.99	222.7333	215.7033	219.2067	76009800.0
2021-07-26	TLT	Stock	148.995	149.06	147.88	148.06	10737870.0
2021-07-26	ES	Stock	85.99	86.41	85.04	85.82	1145000.0
2021-07-26	CL	Stock	83.15	84.3	82.95	84.09	5947500.0
2021-07-26	A	Stock	151.73	152.17	149.77	150.25	1767700.0
2021-07-26	AA	Stock	37.59	39.02	37.02	38.96	8950300.0
2021-07-26	AAC-DELISTED	Stock	9.77	9.77	9.73	9.75	316973.0
2021-07-26	AACG	Stock	4.03	4.03	3.22	3.22	741300.0
2021-07-26	AAIC-DELISTED	Stock	3.83	3.95	3.81	3.92	134106.0
2021-07-26	AAIC.C-DELISTED	Stock	25.2	25.2299	25.2	25.2	3498.0
2021-07-26	AAL	Stock	21.03	22.11	20.94	22.08	31508800.0
2021-07-26	AAM.A-DELISTED	Stock	26.35	26.4577	26.35	26.45	5698.0
2021-07-26	AAM.B-DELISTED	Stock	27.01	27.12	27.01	27.1	4669.0
2021-07-26	AAMC-DELISTED	Stock	4.9088	4.9088	4.591	4.7724	25520.0
2021-07-26	AAME	Stock	4.09	4.09	3.9	3.9	28900.0
2021-07-26	AAMI	Stock	23.99	24.2	23.86	24.2	173300.0
2021-07-26	AAN-DELISTED	Stock	27.65	28.22	27.0	27.72	503500.0
2021-07-26	AAOI	Stock	7.53	7.53	7.3	7.35	348800.0
2021-07-26	AAON	Stock	40.4733	40.48	39.8867	40.0	157050.0
2021-07-26	AAP	Stock	214.88	215.72	212.95	214.09	419400.0
2021-07-26	AAQC-DELISTED	Stock	9.66	9.6899	9.66	9.67	20077.0
2021-07-26	AAT	Stock	36.73	37.15	36.37	36.69	213900.0
2021-07-26	AATC	Stock	6.42	6.57	6.38	6.4	15799.0
2021-07-26	AAU-DELISTED	Stock	0.4167	0.43	0.405	0.409	638128.0
2021-07-26	AAUAF-DELISTED	Stock	0.4167	0.43	0.405	0.4063	667300.0
2021-07-26	AAWW-DELISTED	Stock	65.98	66.91	65.1404	66.27	209844.0
2021-07-26	AAXJ	Stock	87.73	88.23	87.425	87.7	3185372.0
2021-07-26	AB	Stock	46.75	47.4	46.5	47.32	221900.0
2021-07-26	ABB-DELISTED	Stock	36.825	36.97	36.74	36.97	1042671.0
2021-07-26	ABBNY-DELISTED	Stock	36.825	36.97	36.74	36.95	1160321.0
2021-07-26	ABBV	Stock	118.13	118.47	117.27	117.79	3730100.0
2021-07-26	ABC-DELISTED	Stock	121.48	122.49	120.31	120.79	440594.0
2021-07-26	ABCB	Stock	46.38	47.37	46.12	47.05	462500.0
2021-07-26	ABCL	Stock	15.88	16.44	15.01	15.39	1914500.0
2021-07-26	ABCM-DELISTED	Stock	18.23	18.31	17.91	18.01	94723.0
2021-07-26	ABEO	Stock	35.0	38.5	30.25	33.0	400832.0
2021-07-26	ABEV	Stock	3.19	3.28	3.18	3.25	19983100.0
2021-07-26	ABG	Stock	195.19	197.34	194.02	196.98	125900.0
2021-07-26	ABGI-DELISTED	Stock	9.8	9.8	9.7	9.76	124155.0
2021-07-26	ABM	Stock	46.35	46.86	45.64	46.16	421900.0
2021-07-26	ABMD-DELISTED	Stock	326.44	327.16	318.01	325.0	132349.0
2021-07-26	ABNB	Stock	139.13	142.19	137.2	142.0	6489500.0
2021-07-26	ABOS	Stock	17.17	19.68	16.56	16.57	135000.0
2021-07-26	ABR	Stock	17.78	18.05	17.7	17.97	1003000.0

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

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