PREVIEW / stock_daily / 2020-09-18

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-18.parquet
  size:    228 KB
  rows:    6,887
  symbols: 2,449

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-18	AAPL	Stock	110.4	110.88	106.09	106.84	287104900.0
2020-09-18	MSFT	Stock	202.8	203.65	196.25	200.39	55225300.0
2020-09-18	NVDA	Stock	12.5938	12.6325	11.9888	12.1893	698460000.0
2020-09-18	AMZN	Stock	151.587	151.89	145.277	147.7455	177852000.0
2020-09-18	GOOGL	Stock	74.415	74.76	71.581	72.5545	63055760.0
2020-09-18	META	Stock	258.4	259.2	250.05	252.53	28130800.0
2020-09-18	TSLA	Stock	149.3133	150.3333	142.9333	147.3833	259220400.0
2020-09-18	TLT	Stock	164.17	164.24	163.34	163.57	7246282.0
2020-09-18	ES	Stock	81.63	81.83	78.66	78.86	3739000.0
2020-09-18	CL	Stock	76.3	76.94	75.28	75.83	4563600.0
2020-09-18	A	Stock	99.14	100.59	98.46	99.38	2162400.0
2020-09-18	AA	Stock	13.49	13.805	13.3	13.32	7734500.0
2020-09-18	AACG	Stock	1.08	1.08	1.06	1.06	12200.0
2020-09-18	AACQ-DELISTED	Stock	10.0	10.0	9.93	9.93	354272.0
2020-09-18	AACQU-DELISTED	Stock	10.5	10.5	10.42	10.4284	25043.0
2020-09-18	AACQW-DELISTED	Stock	1.7	1.7	1.64	1.6716	229931.0
2020-09-18	AAIC-DELISTED	Stock	2.76	2.79	2.7	2.73	698275.0
2020-09-18	AAIC.C-DELISTED	Stock	18.94	19.19	18.76	19.19	2600.0
2020-09-18	AAL	Stock	13.51	13.59	13.03	13.19	56403600.0
2020-09-18	AAM.A-DELISTED	Stock	26.466	26.466	26.16	26.24	4256.0
2020-09-18	AAM.B-DELISTED	Stock	27.14	27.14	26.86	27.0329	9625.0
2020-09-18	AAMC-DELISTED	Stock	6.4059	6.4059	6.05	6.2118	6355.0
2020-09-18	AAME	Stock	2.06	2.18	2.04	2.14	9600.0
2020-09-18	AAMI	Stock	13.42	13.47	13.21	13.39	1408600.0
2020-09-18	AAOI	Stock	10.52	10.54	10.17	10.29	778000.0
2020-09-18	AAON	Stock	38.86	39.46	37.96	38.18	778950.0
2020-09-18	AAP	Stock	154.38	155.97	152.54	153.88	717100.0
2020-09-18	AAT	Stock	26.11	26.11	25.09	25.16	710300.0
2020-09-18	AAU-DELISTED	Stock	1.05	1.05	0.9201	0.9439	1293354.0
2020-09-18	AAUAF-DELISTED	Stock	1.05	1.05	0.9201	0.9472	1347200.0
2020-09-18	AAWW-DELISTED	Stock	61.48	63.0	60.7	61.23	666944.0
2020-09-18	AAXJ	Stock	78.2	78.2	77.52	77.62	1147401.0
2020-09-18	AAXN-DELISTED	Stock	83.15	83.35	80.75	82.56	628775.0
2020-09-18	AB	Stock	27.89	28.1	27.66	27.75	799200.0
2020-09-18	ABB-DELISTED	Stock	26.07	26.235	25.84	25.86	1726175.0
2020-09-18	ABBNY-DELISTED	Stock	26.05	26.235	25.84	25.86	1815507.0
2020-09-18	ABBV	Stock	89.49	90.5	88.86	90.11	10076300.0
2020-09-18	ABC-DELISTED	Stock	96.62	97.375	95.965	96.82	1242300.0
2020-09-18	ABCB	Stock	23.84	23.93	22.87	23.0	1142500.0
2020-09-18	ABEO	Stock	55.0	58.5	51.25	52.0	131696.0
2020-09-18	ABEV	Stock	2.49	2.51	2.39	2.39	32220200.0
2020-09-18	ABG	Stock	102.12	103.4	98.14	98.28	407800.0
2020-09-18	ABM	Stock	38.67	39.35	38.09	38.57	1071900.0
2020-09-18	ABMD-DELISTED	Stock	275.23	275.94	260.9506	265.14	356208.0
2020-09-18	ABR	Stock	12.14	12.4	12.02	12.21	1750000.0
2020-09-18	ABR.A-DELISTED	Stock	25.39	25.46	25.245	25.36	3650.0
2020-09-18	ABR.B-DELISTED	Stock	24.65	24.99	24.65	24.91	5166.0
2020-09-18	ABR.C-DELISTED	Stock	25.45	25.45	25.429	25.429	500.0
2020-09-18	ABT	Stock	106.56	107.99	106.14	106.86	7622400.0
2020-09-18	ABTC	Stock	130200.0	131700.0	123600.0	126600.0	6.306666666666667

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

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