PREVIEW / stock_daily / 2021-05-11

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-11.parquet
  size:    256 KB
  rows:    7,856
  symbols: 2,975

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-11	AAPL	Stock	123.5	126.27	122.77	125.91	126142800.0
2021-05-11	MSFT	Stock	244.55	246.6	242.57	246.23	33641600.0
2021-05-11	NVDA	Stock	13.825	14.3548	13.75	14.3062	285584000.0
2021-05-11	AMZN	Stock	156.814	161.9	156.3685	161.1955	92396000.0
2021-05-11	GOOGL	Stock	112.1535	114.014	111.696	113.503	34185840.0
2021-05-11	META	Stock	300.75	306.84	299.69	306.53	18920100.0
2021-05-11	TSLA	Stock	199.7467	209.0333	198.5333	205.7333	139511700.0
2021-05-11	TLT	Stock	137.23	137.48	136.77	137.04	15158611.0
2021-05-11	ES	Stock	85.63	85.72	83.43	84.02	1582200.0
2021-05-11	CL	Stock	83.57	83.63	82.19	82.44	5119300.0
2021-05-11	A	Stock	130.27	131.84	129.3	131.42	1336600.0
2021-05-11	AA	Stock	39.07	42.15	38.96	41.32	9042100.0
2021-05-11	AAC-DELISTED	Stock	9.81	9.86	9.78	9.84	587051.0
2021-05-11	AACG	Stock	2.82	2.93	2.77	2.88	84000.0
2021-05-11	AACQ-DELISTED	Stock	9.89	9.91	9.84	9.87	1740414.0
2021-05-11	AACQU-DELISTED	Stock	10.5	10.5604	10.29	10.37	21578.0
2021-05-11	AACQW-DELISTED	Stock	1.75	1.79	1.41	1.6	404262.0
2021-05-11	AAIC-DELISTED	Stock	4.0	4.05	3.98	4.01	121483.0
2021-05-11	AAIC.C-DELISTED	Stock	24.6409	24.655	24.48	24.5	1585.0
2021-05-11	AAL	Stock	21.07	21.7	20.91	21.57	37417800.0
2021-05-11	AAM.A-DELISTED	Stock	26.12	26.14	26.05	26.08	13646.0
2021-05-11	AAM.B-DELISTED	Stock	27.0	27.0184	26.86	26.86	10514.0
2021-05-11	AAMC-DELISTED	Stock	5.0324	5.0324	4.8588	4.8853	29070.0
2021-05-11	AAME	Stock	3.91	3.98	3.84	3.94	94600.0
2021-05-11	AAMI	Stock	22.25	22.81	21.95	22.61	406200.0
2021-05-11	AAN-DELISTED	Stock	30.32	31.97	30.21	31.71	249700.0
2021-05-11	AAOI	Stock	7.3	7.6	7.11	7.35	683300.0
2021-05-11	AAON	Stock	43.44	43.9933	43.02	43.4933	169650.0
2021-05-11	AAP	Stock	207.93	207.94	201.83	204.21	741200.0
2021-05-11	AAQC-DELISTED	Stock	9.8214	9.8214	9.7496	9.75	2483.0
2021-05-11	AAT	Stock	34.51	34.51	33.82	34.23	202000.0
2021-05-11	AAU-DELISTED	Stock	0.53	0.5388	0.51	0.5219	1065910.0
2021-05-11	AAUAF-DELISTED	Stock	0.53	0.5388	0.51	0.522	1104827.0
2021-05-11	AAWW-DELISTED	Stock	72.0	72.36	70.92	72.25	290845.0
2021-05-11	AAXJ	Stock	90.44	91.93	90.4	91.74	2109882.0
2021-05-11	AB	Stock	44.01	44.01	42.86	43.45	644800.0
2021-05-11	ABB-DELISTED	Stock	33.1	33.42	32.97	33.385	1265280.0
2021-05-11	ABBNY-DELISTED	Stock	33.1	33.42	32.97	33.38	1389772.0
2021-05-11	ABBV	Stock	115.48	116.57	114.38	114.89	5784600.0
2021-05-11	ABC-DELISTED	Stock	122.87	123.33	119.51	120.11	769427.0
2021-05-11	ABCB	Stock	55.3	56.62	55.0	55.5	854000.0
2021-05-11	ABCL	Stock	26.5	28.499	26.25	28.25	577900.0
2021-05-11	ABCM-DELISTED	Stock	20.4	20.89	20.37	20.65	346433.0
2021-05-11	ABEO	Stock	32.0	35.5	31.5	32.75	108712.0
2021-05-11	ABEV	Stock	3.13	3.28	3.13	3.27	28064300.0
2021-05-11	ABG	Stock	201.8	202.25	193.9	200.54	184700.0
2021-05-11	ABGI-DELISTED	Stock	9.96	9.96	9.8	9.91	6678.0
2021-05-11	ABM	Stock	51.5	52.32	50.94	51.88	340500.0
2021-05-11	ABMD-DELISTED	Stock	279.12	282.29	276.01	280.3	214089.0
2021-05-11	ABNB	Stock	139.1	144.35	136.01	142.73	8257400.0

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

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