PREVIEW / stock_daily / 2020-08-26

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-26.parquet
  size:    224 KB
  rows:    6,793
  symbols: 2,411

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-08-26	AAPL	Stock	126.18	126.9925	125.0825	126.5225	163022400.0
2020-08-26	MSFT	Stock	217.88	222.09	217.36	221.15	39600800.0
2020-08-26	NVDA	Stock	12.7992	12.8685	12.6778	12.773	321244000.0
2020-08-26	AMZN	Stock	167.5555	172.587	167.2285	172.0925	130174000.0
2020-08-26	GOOGL	Stock	80.315	82.6395	80.0488	82.2065	52187260.0
2020-08-26	META	Stock	284.0	304.67	284.0	303.91	69015200.0
2020-08-26	TSLA	Stock	137.3333	144.4	136.9087	143.5447	213591000.0
2020-08-26	TLT	Stock	164.05	164.325	163.28	164.03	8276618.0
2020-08-26	ES	Stock	84.54	84.64	83.04	84.01	1185200.0
2020-08-26	CL	Stock	78.28	79.17	78.02	78.65	3476800.0
2020-08-26	A	Stock	98.18	99.73	98.05	99.33	1072300.0
2020-08-26	AA	Stock	15.09	15.44	15.02	15.07	3158500.0
2020-08-26	AACG	Stock	1.08	1.11	1.08	1.1	19800.0
2020-08-26	AACQU-DELISTED	Stock	10.045	10.08	10.02	10.02	152108.0
2020-08-26	AAIC-DELISTED	Stock	2.78	2.8	2.75	2.77	183860.0
2020-08-26	AAIC.C-DELISTED	Stock	19.2061	19.4	19.06	19.1355	7973.0
2020-08-26	AAL	Stock	13.11	13.15	12.7	12.79	44056800.0
2020-08-26	AAM.A-DELISTED	Stock	26.83	26.95	26.71	26.89	16256.0
2020-08-26	AAM.B-DELISTED	Stock	27.39	27.68	27.39	27.68	18691.0
2020-08-26	AAMC-DELISTED	Stock	6.4029	7.0588	6.4029	6.4618	91603.0
2020-08-26	AAME	Stock	2.17	2.17	1.88	1.94	13600.0
2020-08-26	AAMI	Stock	13.8	14.15	13.475	14.01	968300.0
2020-08-26	AAOI	Stock	12.0	12.14	11.74	11.79	732200.0
2020-08-26	AAON	Stock	38.8733	38.9667	38.4333	38.66	209550.0
2020-08-26	AAP	Stock	155.77	157.58	155.45	156.48	575600.0
2020-08-26	AAT	Stock	25.94	26.02	25.11	25.31	213100.0
2020-08-26	AAU-DELISTED	Stock	0.6594	0.67	0.6216	0.6655	459359.0
2020-08-26	AAUAF-DELISTED	Stock	0.6594	0.67	0.6216	0.67	477020.0
2020-08-26	AAWW-DELISTED	Stock	57.51	57.57	55.92	56.31	376385.0
2020-08-26	AAXJ	Stock	78.935	79.15	78.66	79.06	634994.0
2020-08-26	AAXN-DELISTED	Stock	85.01	86.42	84.28	85.24	365590.0
2020-08-26	AB	Stock	28.84	28.89	28.3	28.41	227500.0
2020-08-26	ABB-DELISTED	Stock	25.95	26.25	25.9035	26.1791	849250.0
2020-08-26	ABBNY-DELISTED	Stock	25.95	26.25	25.9035	26.17	1220524.0
2020-08-26	ABBV	Stock	93.5	94.41	92.94	94.35	5682800.0
2020-08-26	ABC-DELISTED	Stock	97.92	98.01	96.3104	97.66	510041.0
2020-08-26	ABCB	Stock	25.1	25.15	24.42	24.62	272800.0
2020-08-26	ABEO	Stock	61.0	61.0	58.0	58.25	13784.0
2020-08-26	ABEV	Stock	2.32	2.35	2.24	2.29	33683800.0
2020-08-26	ABG	Stock	104.21	104.72	99.77	100.22	170400.0
2020-08-26	ABM	Stock	37.46	37.67	36.9	37.33	202800.0
2020-08-26	ABMD-DELISTED	Stock	308.52	309.18	302.37	306.21	147243.0
2020-08-26	ABR	Stock	11.45	11.54	11.33	11.36	698500.0
2020-08-26	ABR.A-DELISTED	Stock	25.18	25.33	25.18	25.33	500.0
2020-08-26	ABR.B-DELISTED	Stock	25.02	25.07	25.0001	25.03	495.0
2020-08-26	ABR.C-DELISTED	Stock	25.5	25.56	25.39	25.56	3260.0
2020-08-26	ABT	Stock	101.99	103.29	101.26	103.19	2968800.0
2020-08-26	ABTC	Stock	180000.0	191700.0	175200.0	185100.0	4.573333333333333
2020-08-26	ABTS	Stock	29.7	31.95	28.2	31.5	23867.0
2020-08-26	ABTX-DELISTED	Stock	25.78	25.91	25.22	25.36	35693.0

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

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