PREVIEW / stock_daily / 2020-09-02

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-02.parquet
  size:    226 KB
  rows:    6,833
  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-02	AAPL	Stock	137.59	137.98	127.0	131.4	200119000.0
2020-09-02	MSFT	Stock	227.97	232.86	227.35	231.65	34080800.0
2020-09-02	NVDA	Stock	14.7038	14.7268	13.9	14.3465	874012000.0
2020-09-02	AMZN	Stock	177.35	177.6125	174.3345	176.5725	78630000.0
2020-09-02	GOOGL	Stock	83.4005	86.3051	83.0095	85.8695	49521440.0
2020-09-02	META	Stock	298.88	303.6	293.05	302.5	24341400.0
2020-09-02	TSLA	Stock	159.6633	159.68	135.04	149.1233	288528300.0
2020-09-02	TLT	Stock	163.51	165.56	163.49	165.42	15167718.0
2020-09-02	ES	Stock	83.76	86.76	83.18	86.47	1155600.0
2020-09-02	CL	Stock	78.13	79.79	78.01	79.47	3405200.0
2020-09-02	A	Stock	101.0	103.66	100.46	103.42	1462500.0
2020-09-02	AA	Stock	14.73	14.87	14.41	14.67	5691200.0
2020-09-02	AACG	Stock	1.12	1.18	1.12	1.13	17200.0
2020-09-02	AACQU-DELISTED	Stock	10.1	10.13	10.03	10.115	48411.0
2020-09-02	AAIC-DELISTED	Stock	2.72	2.77	2.675	2.75	278521.0
2020-09-02	AAIC.C-DELISTED	Stock	19.4	19.4	19.08	19.1901	747.0
2020-09-02	AAL	Stock	12.94	13.34	12.67	13.23	58889600.0
2020-09-02	AAM.A-DELISTED	Stock	26.6	26.74	26.465	26.64	5975.0
2020-09-02	AAM.B-DELISTED	Stock	27.01	27.25	27.0	27.18	15460.0
2020-09-02	AAMC-DELISTED	Stock	6.9103	6.9103	6.4235	6.4578	38767.0
2020-09-02	AAME	Stock	2.05	2.08	1.94	2.03	2800.0
2020-09-02	AAMI	Stock	13.99	14.26	13.74	14.19	353100.0
2020-09-02	AAOI	Stock	11.74	12.68	11.74	12.63	1122200.0
2020-09-02	AAON	Stock	38.3333	38.7533	37.9333	38.5267	270600.0
2020-09-02	AAP	Stock	156.44	159.56	155.54	158.1	635600.0
2020-09-02	AAT	Stock	25.41	25.78	25.09	25.76	214500.0
2020-09-02	AAU-DELISTED	Stock	0.7	0.7017	0.68	0.6856	279254.0
2020-09-02	AAUAF-DELISTED	Stock	0.7	0.7017	0.68	0.6886	306635.0
2020-09-02	AAWW-DELISTED	Stock	57.58	57.7	55.79	57.0	216131.0
2020-09-02	AAXJ	Stock	79.17	79.17	78.285	79.07	2595754.0
2020-09-02	AAXN-DELISTED	Stock	88.14	88.74	86.145	88.14	319771.0
2020-09-02	AB	Stock	28.7	29.0	28.43	28.91	222400.0
2020-09-02	ABB-DELISTED	Stock	25.75	25.88	25.61	25.85	1394116.0
2020-09-02	ABBNY-DELISTED	Stock	25.75	25.88	25.61	25.85	1497966.0
2020-09-02	ABBV	Stock	92.07	94.24	91.9	93.95	9139200.0
2020-09-02	ABC-DELISTED	Stock	94.35	98.79	94.35	98.29	1189464.0
2020-09-02	ABCB	Stock	24.38	24.88	24.19	24.66	278400.0
2020-09-02	ABEO	Stock	58.25	59.75	53.75	54.0	77148.0
2020-09-02	ABEV	Stock	2.36	2.41	2.34	2.38	17005500.0
2020-09-02	ABG	Stock	108.31	109.77	107.75	109.67	159900.0
2020-09-02	ABM	Stock	38.15	38.89	37.99	38.67	138300.0
2020-09-02	ABMD-DELISTED	Stock	307.34	315.35	301.05	312.8	262673.0
2020-09-02	ABR	Stock	11.38	11.42	11.09	11.35	1244200.0
2020-09-02	ABR.A-DELISTED	Stock	25.56	25.56	25.11	25.18	6676.0
2020-09-02	ABR.B-DELISTED	Stock	25.0	25.0441	24.95	25.0164	1100.0
2020-09-02	ABR.C-DELISTED	Stock	25.545	25.64	25.5041	25.5401	4650.0
2020-09-02	ABT	Stock	106.45	109.91	105.88	109.44	5843700.0
2020-09-02	ABTC	Stock	165000.0	177900.0	153600.0	154200.0	7.333333333333333
2020-09-02	ABTS	Stock	32.25	33.6	30.0	33.15	32147.0
2020-09-02	ABTX-DELISTED	Stock	25.45	25.67	25.21	25.48	12260.0

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

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