PREVIEW / stock_daily / 2020-09-16

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-16.parquet
  size:    227 KB
  rows:    6,867
  symbols: 2,447

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-09-16	AAPL	Stock	115.23	116.0	112.04	112.13	154679000.0
2020-09-16	MSFT	Stock	210.62	210.65	204.64	205.05	26328100.0
2020-09-16	NVDA	Stock	12.9572	13.0928	12.5138	12.5145	556384000.0
2020-09-16	AMZN	Stock	158.9995	159.362	153.7075	153.905	90244000.0
2020-09-16	GOOGL	Stock	77.124	77.7185	75.5795	75.6045	22143380.0
2020-09-16	META	Stock	267.29	272.44	261.79	263.52	29183400.0
2020-09-16	TSLA	Stock	146.6233	152.5967	145.1033	147.2533	216837900.0
2020-09-16	TLT	Stock	164.78	164.89	162.9804	163.58	8816914.0
2020-09-16	ES	Stock	83.6	84.46	83.31	83.36	1252000.0
2020-09-16	CL	Stock	77.23	77.76	76.87	76.91	2498900.0
2020-09-16	A	Stock	101.23	101.53	98.08	99.92	1365000.0
2020-09-16	AA	Stock	13.92	14.08	13.705	13.9	5583300.0
2020-09-16	AACG	Stock	1.1	1.12	1.08	1.12	7600.0
2020-09-16	AACQ-DELISTED	Stock	9.97	10.01	9.9225	9.975	45700.0
2020-09-16	AACQU-DELISTED	Stock	10.4301	10.45	10.4	10.45	49043.0
2020-09-16	AACQW-DELISTED	Stock	1.71	1.71	1.63	1.63	686543.0
2020-09-16	AAIC-DELISTED	Stock	2.72	2.82	2.7	2.77	260224.0
2020-09-16	AAIC.C-DELISTED	Stock	18.76	18.975	18.76	18.975	439.0
2020-09-16	AAL	Stock	13.21	13.96	12.98	13.8	75200100.0
2020-09-16	AAM.A-DELISTED	Stock	26.54	26.73	26.21	26.26	31952.0
2020-09-16	AAM.B-DELISTED	Stock	27.27	27.345	27.03	27.03	11818.0
2020-09-16	AAMC-DELISTED	Stock	6.8471	6.8471	6.3206	6.6176	29148.0
2020-09-16	AAME	Stock	1.96	2.05	1.96	2.0	1800.0
2020-09-16	AAMI	Stock	13.32	13.68	13.17	13.47	680700.0
2020-09-16	AAOI	Stock	10.47	10.67	10.36	10.44	342500.0
2020-09-16	AAON	Stock	38.3867	38.9933	38.2733	38.56	305700.0
2020-09-16	AAP	Stock	157.03	157.11	154.3	154.64	512800.0
2020-09-16	AAT	Stock	25.88	26.67	25.82	26.34	350400.0
2020-09-16	AAU-DELISTED	Stock	0.92	1.045	0.83	1.04	2460695.0
2020-09-16	AAUAF-DELISTED	Stock	0.92	1.05	0.83	1.05	2486676.0
2020-09-16	AAWW-DELISTED	Stock	60.5	61.74	59.2402	61.08	395192.0
2020-09-16	AAXJ	Stock	78.75	78.9631	78.38	78.4	1008407.0
2020-09-16	AAXN-DELISTED	Stock	85.0	85.04	83.4	83.72	246962.0
2020-09-16	AB	Stock	27.46	28.31	27.43	27.9	476000.0
2020-09-16	ABB-DELISTED	Stock	26.35	26.42	26.105	26.13	1000544.0
2020-09-16	ABBNY-DELISTED	Stock	26.35	26.42	26.105	26.12	1076008.0
2020-09-16	ABBV	Stock	91.02	91.27	89.69	89.78	6304400.0
2020-09-16	ABC-DELISTED	Stock	95.61	97.96	94.99	96.78	771707.0
2020-09-16	ABCB	Stock	23.35	24.1	23.09	23.73	288400.0
2020-09-16	ABEO	Stock	51.25	51.25	47.25	47.25	40484.0
2020-09-16	ABEV	Stock	2.44	2.45	2.42	2.42	13630500.0
2020-09-16	ABG	Stock	107.44	107.44	101.93	102.96	185900.0
2020-09-16	ABM	Stock	37.01	37.9	36.96	37.53	362900.0
2020-09-16	ABMD-DELISTED	Stock	277.15	282.6111	270.08	274.12	227451.0
2020-09-16	ABR	Stock	11.9	12.23	11.86	12.11	1405900.0
2020-09-16	ABR.A-DELISTED	Stock	25.2	25.46	25.2	25.43	5749.0
2020-09-16	ABR.B-DELISTED	Stock	25.2606	25.2606	25.2606	25.2606	132.0
2020-09-16	ABR.C-DELISTED	Stock	25.5	25.5	25.45	25.45	1743.0
2020-09-16	ABT	Stock	106.95	107.37	105.66	105.7	4242500.0
2020-09-16	ABTC	Stock	134100.0	138300.0	130800.0	134700.0	9.8

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

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