PREVIEW / stock_daily / 2020-09-01

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-01.parquet
  size:    225 KB
  rows:    6,831
  symbols: 2,427

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-01	AAPL	Stock	132.76	134.8	130.53	134.18	151948100.0
2020-09-01	MSFT	Stock	225.51	227.45	224.43	227.27	25725500.0
2020-09-01	NVDA	Stock	13.48	13.9938	13.4365	13.821	511316000.0
2020-09-01	AMZN	Stock	174.479	175.6935	173.35	174.956	68644000.0
2020-09-01	GOOGL	Stock	81.608	82.961	81.4765	82.754	22675320.0
2020-09-01	META	Stock	294.71	301.49	292.71	295.44	17295900.0
2020-09-01	TSLA	Stock	167.38	167.4967	156.8367	158.35	269523300.0
2020-09-01	TLT	Stock	161.76	164.07	161.18	163.86	10587634.0
2020-09-01	ES	Stock	85.1	85.36	83.43	83.66	1429800.0
2020-09-01	CL	Stock	79.15	79.17	77.8	78.09	2968800.0
2020-09-01	A	Stock	100.92	101.29	100.25	101.12	1159700.0
2020-09-01	AA	Stock	14.64	15.18	14.24	15.09	4085200.0
2020-09-01	AACG	Stock	1.16	1.18	1.1	1.17	43500.0
2020-09-01	AACQU-DELISTED	Stock	10.01	10.12	10.01	10.03	84712.0
2020-09-01	AAIC-DELISTED	Stock	2.71	2.75	2.67	2.74	243225.0
2020-09-01	AAIC.C-DELISTED	Stock	19.05	19.43	19.05	19.43	1080.0
2020-09-01	AAL	Stock	12.86	13.84	12.66	13.1	72849700.0
2020-09-01	AAM.A-DELISTED	Stock	26.8	26.8	26.54	26.6	7873.0
2020-09-01	AAM.B-DELISTED	Stock	27.1	27.18	27.01	27.08	11454.0
2020-09-01	AAMC-DELISTED	Stock	7.2353	7.3912	6.6221	6.8015	62448.0
2020-09-01	AAME	Stock	1.91	2.04	1.91	2.03	4900.0
2020-09-01	AAMI	Stock	13.83	14.02	13.72	13.94	688500.0
2020-09-01	AAOI	Stock	11.63	11.776	11.33	11.675	516800.0
2020-09-01	AAON	Stock	37.7667	38.2067	37.2	38.0933	466500.0
2020-09-01	AAP	Stock	155.78	157.78	154.43	156.39	634800.0
2020-09-01	AAT	Stock	25.3	25.56	25.09	25.46	185600.0
2020-09-01	AAU-DELISTED	Stock	0.71	0.74	0.7	0.7078	449467.0
2020-09-01	AAUAF-DELISTED	Stock	0.71	0.74	0.7	0.7097	457118.0
2020-09-01	AAWW-DELISTED	Stock	56.55	58.1	55.65	57.37	365662.0
2020-09-01	AAXJ	Stock	78.37	79.07	78.34	79.07	3881671.0
2020-09-01	AAXN-DELISTED	Stock	85.2	88.65	84.78	87.45	362008.0
2020-09-01	AB	Stock	28.4	28.74	28.19	28.67	213900.0
2020-09-01	ABB-DELISTED	Stock	25.5	25.835	25.35	25.79	2257971.0
2020-09-01	ABBNY-DELISTED	Stock	25.5	25.835	25.35	25.79	2412058.0
2020-09-01	ABBV	Stock	95.52	95.92	91.29	92.24	15783600.0
2020-09-01	ABC-DELISTED	Stock	97.45	97.75	93.165	94.32	790755.0
2020-09-01	ABCB	Stock	24.26	24.81	24.15	24.5	224000.0
2020-09-01	ABEO	Stock	58.75	60.25	57.5	58.75	24684.0
2020-09-01	ABEV	Stock	2.35	2.38	2.33	2.35	28472200.0
2020-09-01	ABG	Stock	105.37	108.14	104.88	108.12	148300.0
2020-09-01	ABM	Stock	38.0	38.23	37.6	38.19	156700.0
2020-09-01	ABMD-DELISTED	Stock	307.72	310.25	303.5	307.34	190600.0
2020-09-01	ABR	Stock	11.21	11.75	11.15	11.39	1821100.0
2020-09-01	ABR.A-DELISTED	Stock	25.5	25.58	25.3877	25.5028	1004.0
2020-09-01	ABR.B-DELISTED	Stock	25.195	25.195	25.195	25.195	127.0
2020-09-01	ABR.C-DELISTED	Stock	25.5394	25.575	25.5	25.5	2462.0
2020-09-01	ABT	Stock	108.93	109.07	105.58	106.55	7963100.0
2020-09-01	ABTC	Stock	182400.0	192300.0	160500.0	168900.0	6.493333333333333
2020-09-01	ABTS	Stock	31.8	33.6	30.3	33.15	44033.0
2020-09-01	ABTX-DELISTED	Stock	25.32	25.8	24.835	25.58	21493.0

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

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