PREVIEW / stock_daily / 2020-09-17

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-17.parquet
  size:    226 KB
  rows:    6,876
  symbols: 2,446

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-17	AAPL	Stock	109.72	112.2	108.71	110.34	178011000.0
2020-09-17	MSFT	Stock	200.05	204.33	199.96	202.91	34011300.0
2020-09-17	NVDA	Stock	12.1323	12.5898	12.0348	12.4635	792512000.0
2020-09-17	AMZN	Stock	150.4625	151.4715	148.6275	150.4365	128982000.0
2020-09-17	GOOGL	Stock	74.2905	74.933	73.123	74.352	40007120.0
2020-09-17	META	Stock	258.28	261.5	250.19	254.82	31281400.0
2020-09-17	TSLA	Stock	138.5333	145.93	136.0	141.1433	230337600.0
2020-09-17	TLT	Stock	164.9	164.96	163.801	164.08	7813922.0
2020-09-17	ES	Stock	82.71	82.78	81.4	81.93	1351700.0
2020-09-17	CL	Stock	76.58	77.21	76.17	76.71	2525300.0
2020-09-17	A	Stock	99.25	100.46	98.58	99.6	1246400.0
2020-09-17	AA	Stock	13.61	13.64	13.21	13.45	7479500.0
2020-09-17	AACG	Stock	1.09	1.1	1.07	1.09	6700.0
2020-09-17	AACQ-DELISTED	Stock	10.48	10.48	9.93	9.93	68587.0
2020-09-17	AACQU-DELISTED	Stock	10.49	10.49	10.42	10.47	27955.0
2020-09-17	AACQW-DELISTED	Stock	1.7	1.7	1.5898	1.66	349664.0
2020-09-17	AAIC-DELISTED	Stock	2.76	2.79	2.7357	2.76	160164.0
2020-09-17	AAIC.C-DELISTED	Stock	18.9898	19.077	18.75	19.0	7376.0
2020-09-17	AAL	Stock	13.5	14.08	13.36	13.63	50194400.0
2020-09-17	AAM.A-DELISTED	Stock	26.28	26.4488	26.25	26.32	10424.0
2020-09-17	AAM.B-DELISTED	Stock	27.13	27.25	26.97	27.11	9348.0
2020-09-17	AAMC-DELISTED	Stock	6.3706	6.8941	6.1647	6.2853	37981.0
2020-09-17	AAME	Stock	2.0	2.19	2.0	2.1	6800.0
2020-09-17	AAMI	Stock	13.35	13.37	13.09	13.29	614700.0
2020-09-17	AAOI	Stock	10.19	10.52	10.057	10.43	321800.0
2020-09-17	AAON	Stock	38.16	39.2	37.9333	38.54	313350.0
2020-09-17	AAP	Stock	152.56	154.95	152.0	154.76	630700.0
2020-09-17	AAT	Stock	26.01	26.48	25.83	26.02	277900.0
2020-09-17	AAU-DELISTED	Stock	1.06	1.09	1.0	1.0199	1460355.0
2020-09-17	AAUAF-DELISTED	Stock	1.06	1.09	1.0	1.02	1541533.0
2020-09-17	AAWW-DELISTED	Stock	59.62	61.36	59.16	61.08	283921.0
2020-09-17	AAXJ	Stock	77.46	78.08	77.46	77.95	1541993.0
2020-09-17	AAXN-DELISTED	Stock	83.0	83.239	81.65	82.79	194114.0
2020-09-17	AB	Stock	27.74	28.07	27.47	27.81	318000.0
2020-09-17	ABB-DELISTED	Stock	25.87	26.11	25.82	26.08	857874.0
2020-09-17	ABBNY-DELISTED	Stock	25.87	26.11	25.82	26.07	923503.0
2020-09-17	ABBV	Stock	89.3	90.81	89.18	89.63	5604700.0
2020-09-17	ABC-DELISTED	Stock	95.67	96.92	94.67	96.81	540841.0
2020-09-17	ABCB	Stock	23.34	23.84	23.16	23.63	260200.0
2020-09-17	ABEO	Stock	48.0	50.5	46.75	49.0	40620.0
2020-09-17	ABEV	Stock	2.39	2.55	2.38	2.54	35229400.0
2020-09-17	ABG	Stock	101.27	103.66	99.49	101.09	318100.0
2020-09-17	ABM	Stock	37.2	39.12	36.86	38.43	507800.0
2020-09-17	ABMD-DELISTED	Stock	272.75	277.05	268.1	276.42	205196.0
2020-09-17	ABR	Stock	11.94	12.23	11.84	12.17	891700.0
2020-09-17	ABR.A-DELISTED	Stock	25.3	25.44	25.2	25.2	2374.0
2020-09-17	ABR.B-DELISTED	Stock	25.25	25.25	23.48	24.63	12657.0
2020-09-17	ABR.C-DELISTED	Stock	25.4	25.5	25.4	25.49	4281.0
2020-09-17	ABT	Stock	104.96	106.75	104.39	106.66	4283500.0
2020-09-17	ABTC	Stock	133800.0	134700.0	126000.0	132300.0	6.546666666666667

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

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