PREVIEW / stock_daily / 2020-10-27

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-27.parquet
  size:    228 KB
  rows:    6,938
  symbols: 2,466

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-10-27	AAPL	Stock	115.49	117.28	114.54	116.6	92276800.0
2020-10-27	MSFT	Stock	211.59	214.67	210.33	213.25	36700300.0
2020-10-27	NVDA	Stock	13.306	13.442	13.1915	13.3968	250520000.0
2020-10-27	AMZN	Stock	161.247	164.583	160.565	164.3165	85820000.0
2020-10-27	GOOGL	Stock	79.4466	80.1	78.8495	79.944	25902760.0
2020-10-27	META	Stock	278.76	284.51	276.31	283.29	16287200.0
2020-10-27	TSLA	Stock	141.2533	143.5	140.0333	141.56	68059500.0
2020-10-27	TLT	Stock	160.23	160.7	159.895	160.55	6062330.0
2020-10-27	ES	Stock	92.23	92.76	91.05	91.88	1778400.0
2020-10-27	CL	Stock	79.22	79.64	78.79	78.85	2828600.0
2020-10-27	A	Stock	105.11	106.66	105.11	106.04	1111400.0
2020-10-27	AA	Stock	12.93	13.215	12.77	13.03	3815500.0
2020-10-27	AACG	Stock	1.11	1.13	1.11	1.12	14500.0
2020-10-27	AACQ-DELISTED	Stock	9.74	9.74	9.68	9.685	601230.0
2020-10-27	AACQU-DELISTED	Stock	10.0578	10.09	10.0402	10.0719	4813.0
2020-10-27	AACQW-DELISTED	Stock	1.29	1.29	1.1776	1.1776	37558.0
2020-10-27	AAIC-DELISTED	Stock	2.68	2.68	2.545	2.56	168760.0
2020-10-27	AAIC.C-DELISTED	Stock	18.89	18.9	18.89	18.9	303.0
2020-10-27	AAL	Stock	11.77	11.79	11.2	11.23	65803400.0
2020-10-27	AAM.A-DELISTED	Stock	26.38	26.38	26.15	26.2	5698.0
2020-10-27	AAM.B-DELISTED	Stock	27.14	27.14	26.93	26.9705	6039.0
2020-10-27	AAMC-DELISTED	Stock	7.2647	7.2647	6.7647	6.7647	21270.0
2020-10-27	AAME	Stock	2.04	2.31	2.04	2.13	4300.0
2020-10-27	AAMI	Stock	14.42	14.495	14.06	14.06	414800.0
2020-10-27	AAOI	Stock	10.07	10.2	9.79	9.96	353100.0
2020-10-27	AAON	Stock	40.5467	40.72	40.02	40.0667	200700.0
2020-10-27	AAP	Stock	150.47	151.91	150.0	150.41	775600.0
2020-10-27	AAT	Stock	23.56	23.82	22.4	22.4	332900.0
2020-10-27	AAU-DELISTED	Stock	0.935	0.99	0.9	0.989	459307.0
2020-10-27	AAUAF-DELISTED	Stock	0.935	0.99	0.9	0.989	479808.0
2020-10-27	AAWW-DELISTED	Stock	62.4	63.46	61.34	62.17	233297.0
2020-10-27	AAXJ	Stock	80.11	80.55	79.88	80.45	760965.0
2020-10-27	AAXN-DELISTED	Stock	102.21	102.556	100.595	101.02	200694.0
2020-10-27	AB	Stock	30.94	30.97	29.92	30.45	623400.0
2020-10-27	ABB-DELISTED	Stock	26.03	26.05	25.58	25.585	1250515.0
2020-10-27	ABBNY-DELISTED	Stock	26.03	26.05	25.58	25.58	1370780.0
2020-10-27	ABBV	Stock	84.0	84.26	82.68	82.71	6705600.0
2020-10-27	ABC-DELISTED	Stock	98.55	99.77	97.58	97.66	555211.0
2020-10-27	ABCB	Stock	29.0	29.75	27.94	28.07	404800.0
2020-10-27	ABCM-DELISTED	Stock	19.24	19.8	19.0	19.46	296908.0
2020-10-27	ABEO	Stock	32.25	32.25	29.5	29.5	51444.0
2020-10-27	ABEV	Stock	2.53	2.54	2.42	2.44	31387200.0
2020-10-27	ABG	Stock	114.79	115.5	105.52	106.04	419100.0
2020-10-27	ABM	Stock	35.94	36.71	35.1	36.39	372000.0
2020-10-27	ABMD-DELISTED	Stock	287.91	293.47	285.35	290.22	227303.0
2020-10-27	ABR	Stock	11.48	11.94	11.48	11.68	933400.0
2020-10-27	ABR.A-DELISTED	Stock	25.2	25.4699	25.11	25.16	2702.0
2020-10-27	ABR.B-DELISTED	Stock	25.17	25.25	25.0935	25.22	1300.0
2020-10-27	ABR.C-DELISTED	Stock	25.67	25.8252	25.53	25.6285	2420.0
2020-10-27	ABT	Stock	108.89	109.75	108.33	108.58	4518000.0

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

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