PREVIEW / stock_daily / 2020-08-10

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-10.parquet
  size:    224 KB
  rows:    6,774
  symbols: 2,409

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
2020-08-10	AAPL	Stock	112.6	113.775	110.0	112.7275	212403600.0
2020-08-10	MSFT	Stock	211.67	211.88	206.35	208.25	36716500.0
2020-08-10	NVDA	Stock	11.3343	11.4082	10.8565	11.165	427796000.0
2020-08-10	AMZN	Stock	158.5155	158.6255	155.076	157.408	63346000.0
2020-08-10	GOOGL	Stock	74.54	75.3575	73.8745	74.841	20546580.0
2020-08-10	META	Stock	268.04	273.86	259.69	263.0	30248800.0
2020-08-10	TSLA	Stock	96.5333	97.1667	92.3893	94.5713	112834500.0
2020-08-10	TLT	Stock	170.22	170.25	169.07	169.12	6408461.0
2020-08-10	ES	Stock	89.32	89.47	88.15	88.55	1275300.0
2020-08-10	CL	Stock	76.5	76.9	76.26	76.65	3407300.0
2020-08-10	A	Stock	97.84	97.96	96.95	97.14	900800.0
2020-08-10	AA	Stock	14.86	16.07	14.84	15.57	8087800.0
2020-08-10	AACG	Stock	1.25	1.27	1.21	1.21	18400.0
2020-08-10	AACQU-DELISTED	Stock	10.1	10.15	10.06	10.09	459897.0
2020-08-10	AAIC-DELISTED	Stock	2.8	2.91	2.7866	2.83	312211.0
2020-08-10	AAIC.C-DELISTED	Stock	19.41	19.49	19.22	19.45	1662.0
2020-08-10	AAL	Stock	13.29	14.31	13.21	14.0	121073900.0
2020-08-10	AAM.A-DELISTED	Stock	26.775	26.95	26.66	26.93	5393.0
2020-08-10	AAM.B-DELISTED	Stock	27.422	27.422	27.3	27.33	10364.0
2020-08-10	AAMC-DELISTED	Stock	3.8382	3.8382	3.6794	3.6794	21274.0
2020-08-10	AAME	Stock	1.92	1.92	1.77	1.77	1100.0
2020-08-10	AAMI	Stock	13.52	13.78	13.46	13.53	561300.0
2020-08-10	AAOI	Stock	15.89	15.92	13.705	13.82	1967400.0
2020-08-10	AAON	Stock	39.2	40.1467	38.62	39.6333	284550.0
2020-08-10	AAP	Stock	152.5	154.22	151.95	153.32	595500.0
2020-08-10	AAT	Stock	27.37	28.42	27.37	27.82	240400.0
2020-08-10	AAU-DELISTED	Stock	0.8	0.8	0.72	0.737	533469.0
2020-08-10	AAUAF-DELISTED	Stock	0.8	0.8	0.72	0.7349	577147.0
2020-08-10	AAWW-DELISTED	Stock	59.25	61.0	59.08	60.0	527124.0
2020-08-10	AAXJ	Stock	76.17	76.32	75.68	76.25	1242821.0
2020-08-10	AAXN-DELISTED	Stock	84.24	85.15	82.95	83.12	495138.0
2020-08-10	AB	Stock	28.3	28.45	28.11	28.26	135300.0
2020-08-10	ABB-DELISTED	Stock	25.95	26.07	25.9	26.07	643291.0
2020-08-10	ABBNY-DELISTED	Stock	25.95	26.07	25.9	26.06	705515.0
2020-08-10	ABBV	Stock	92.63	93.67	92.15	92.38	7623600.0
2020-08-10	ABC-DELISTED	Stock	102.26	103.74	101.65	103.07	529471.0
2020-08-10	ABCB	Stock	25.97	26.94	25.88	26.69	393200.0
2020-08-10	ABEO	Stock	72.25	74.75	71.5	74.75	22844.0
2020-08-10	ABEV	Stock	2.5	2.51	2.41	2.43	15931800.0
2020-08-10	ABG	Stock	102.85	103.59	100.41	100.63	288900.0
2020-08-10	ABM	Stock	38.82	39.85	38.69	39.25	455200.0
2020-08-10	ABMD-DELISTED	Stock	306.96	308.6204	298.71	300.12	204059.0
2020-08-10	ABR	Stock	11.55	11.94	11.47	11.77	2219200.0
2020-08-10	ABR.A-DELISTED	Stock	25.61	26.44	25.6099	26.44	7328.0
2020-08-10	ABR.B-DELISTED	Stock	25.32	25.48	24.98	25.47	11330.0
2020-08-10	ABR.C-DELISTED	Stock	26.07	26.4201	26.03	26.27	3808.0
2020-08-10	ABT	Stock	100.94	101.26	100.03	100.04	2776300.0
2020-08-10	ABTC	Stock	196800.0	200250.0	193500.0	195000.0	0.96
2020-08-10	ABTS	Stock	30.9	35.7	18.45	20.7	981507.0
2020-08-10	ABTX-DELISTED	Stock	26.49	27.59	26.36	27.02	53960.0

> showing 50 of 6,774 rows — these rows as CSV

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