PREVIEW / stock_daily / 2021-05-26

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-26.parquet
  size:    256 KB
  rows:    7,871
  symbols: 2,964

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-05-26	AAPL	Stock	126.96	127.39	126.42	126.85	56575900.0
2021-05-26	MSFT	Stock	251.43	252.94	250.75	251.49	17771600.0
2021-05-26	NVDA	Stock	15.7342	15.7938	15.5863	15.7	370440000.0
2021-05-26	AMZN	Stock	163.7295	164.7865	162.9255	163.258	47680000.0
2021-05-26	GOOGL	Stock	118.326	119.4495	118.3231	119.0155	21571960.0
2021-05-26	META	Stock	328.35	329.83	325.82	327.66	9686900.0
2021-05-26	TSLA	Stock	202.52	208.7233	200.5	206.3767	85917900.0
2021-05-26	TLT	Stock	139.59	139.91	138.88	139.22	9793707.0
2021-05-26	ES	Stock	82.14	82.34	81.28	81.5	1234400.0
2021-05-26	CL	Stock	84.88	84.88	84.2	84.43	2601700.0
2021-05-26	A	Stock	136.3	138.0	133.25	133.29	2498400.0
2021-05-26	AA	Stock	35.38	36.585	35.38	36.55	5991000.0
2021-05-26	AAC-DELISTED	Stock	9.8	9.855	9.78	9.82	217619.0
2021-05-26	AACG	Stock	2.84	2.95	2.73	2.91	52300.0
2021-05-26	AACQ-DELISTED	Stock	9.94	9.97	9.9385	9.95	1574225.0
2021-05-26	AACQU-DELISTED	Stock	10.47	10.52	10.42	10.52	24900.0
2021-05-26	AACQW-DELISTED	Stock	1.71	1.8	1.7	1.77	130669.0
2021-05-26	AAIC-DELISTED	Stock	4.05	4.06	3.98	4.0	197180.0
2021-05-26	AAIC.C-DELISTED	Stock	24.8899	24.9	24.8514	24.9	2832.0
2021-05-26	AAL	Stock	23.53	23.95	23.2	23.9	29812700.0
2021-05-26	AAM.A-DELISTED	Stock	26.27	26.27	26.15	26.17	12905.0
2021-05-26	AAM.B-DELISTED	Stock	27.18	27.18	27.1134	27.12	2251.0
2021-05-26	AAMC-DELISTED	Stock	5.2176	5.2176	5.0088	5.0529	10628.0
2021-05-26	AAME	Stock	4.12	4.37	4.03	4.33	70700.0
2021-05-26	AAMI	Stock	22.26	22.645	22.05	22.42	256400.0
2021-05-26	AAN-DELISTED	Stock	34.54	36.07	34.54	36.07	242500.0
2021-05-26	AAOI	Stock	7.75	8.09	7.7	8.04	469600.0
2021-05-26	AAON	Stock	44.22	44.78	44.1667	44.3667	189000.0
2021-05-26	AAP	Stock	188.54	189.52	187.42	189.01	716100.0
2021-05-26	AAQC-DELISTED	Stock	9.705	9.705	9.63	9.64	11044.0
2021-05-26	AAT	Stock	35.21	35.85	35.21	35.65	222000.0
2021-05-26	AAU-DELISTED	Stock	0.56	0.56	0.5255	0.535	773760.0
2021-05-26	AAUAF-DELISTED	Stock	0.56	0.56	0.5255	0.539	805960.0
2021-05-26	AAWW-DELISTED	Stock	73.22	75.089	72.78	75.01	173208.0
2021-05-26	AAXJ	Stock	93.7063	93.99	93.58	93.9	572075.0
2021-05-26	AB	Stock	43.93	44.36	43.46	44.3	229400.0
2021-05-26	ABB-DELISTED	Stock	33.61	33.82	33.58	33.77	1941064.0
2021-05-26	ABBNY-DELISTED	Stock	33.61	33.82	33.58	33.77	2083601.0
2021-05-26	ABBV	Stock	114.53	114.74	113.76	114.7	5802600.0
2021-05-26	ABC-DELISTED	Stock	114.94	115.51	112.68	114.67	1007943.0
2021-05-26	ABCB	Stock	53.67	54.41	52.42	54.17	539000.0
2021-05-26	ABCL	Stock	32.31	32.56	28.11	28.5	1947700.0
2021-05-26	ABCM-DELISTED	Stock	20.2	20.42	19.99	20.4	89057.0
2021-05-26	ABEO	Stock	37.75	42.25	37.25	41.25	120328.0
2021-05-26	ABEV	Stock	3.32	3.35	3.28	3.29	17982400.0
2021-05-26	ABG	Stock	195.33	197.94	194.39	195.66	123800.0
2021-05-26	ABGI-DELISTED	Stock	9.97	9.97	9.9	9.95	6771.0
2021-05-26	ABM	Stock	49.29	49.81	49.27	49.74	304000.0
2021-05-26	ABMD-DELISTED	Stock	283.52	284.93	277.21	282.02	136085.0
2021-05-26	ABNB	Stock	134.94	135.76	133.721	134.75	8179200.0

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

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