PREVIEW / stock_daily / 2020-12-04

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-04.parquet
  size:    237 KB
  rows:    7,156
  symbols: 2,595

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-12-04	AAPL	Stock	122.6	122.86	121.52	122.25	78260400.0
2020-12-04	MSFT	Stock	214.22	215.38	213.18	214.36	24666000.0
2020-12-04	NVDA	Stock	13.4485	13.56	13.3888	13.5582	202244000.0
2020-12-04	AMZN	Stock	159.9105	159.9105	157.938	158.129	58272000.0
2020-12-04	GOOGL	Stock	91.011	91.475	90.6795	91.188	20544840.0
2020-12-04	META	Stock	280.3	283.46	279.3	279.7	10880300.0
2020-12-04	TSLA	Stock	197.0033	199.68	195.1667	199.68	88203900.0
2020-12-04	TLT	Stock	155.69	155.785	154.77	155.2	12734642.0
2020-12-04	ES	Stock	86.51	87.13	84.7	85.54	1743400.0
2020-12-04	CL	Stock	85.24	85.68	84.42	85.03	3142600.0
2020-12-04	A	Stock	113.6	115.24	113.45	115.15	1118100.0
2020-12-04	AA	Stock	22.33	24.17	22.33	23.73	7697800.0
2020-12-04	AACG	Stock	1.19	1.24	1.18	1.18	42400.0
2020-12-04	AACQ-DELISTED	Stock	9.95	9.9575	9.92	9.95	167051.0
2020-12-04	AACQU-DELISTED	Stock	10.56	10.57	10.44	10.5	6948.0
2020-12-04	AACQW-DELISTED	Stock	1.4914	1.6	1.41	1.548	64821.0
2020-12-04	AAIC-DELISTED	Stock	3.4	3.65	3.38	3.58	309652.0
2020-12-04	AAIC.C-DELISTED	Stock	21.58	21.7	21.58	21.7	1536.0
2020-12-04	AAL	Stock	16.4	16.93	16.12	16.4	117387600.0
2020-12-04	AAM.A-DELISTED	Stock	26.2695	26.67	26.2695	26.53	42923.0
2020-12-04	AAM.B-DELISTED	Stock	27.19	27.25	27.065	27.09	30161.0
2020-12-04	AAMC-DELISTED	Stock	6.7735	7.028	6.7647	7.028	7732.0
2020-12-04	AAME	Stock	2.1	2.18	2.1	2.18	4600.0
2020-12-04	AAMI	Stock	19.18	19.5	18.98	19.4	297700.0
2020-12-04	AAN-DELISTED	Stock	18.75	19.32	18.66	19.0	1390600.0
2020-12-04	AAOI	Stock	8.18	8.485	8.18	8.45	461100.0
2020-12-04	AAON	Stock	41.54	42.0333	41.2733	41.6333	252450.0
2020-12-04	AAP	Stock	149.96	152.82	149.96	152.47	607700.0
2020-12-04	AAT	Stock	30.85	31.3	30.77	31.08	140300.0
2020-12-04	AAU-DELISTED	Stock	0.83	0.83	0.7525	0.7752	1487168.0
2020-12-04	AAUAF-DELISTED	Stock	0.83	0.83	0.7525	0.7815	1548487.0
2020-12-04	AAWW-DELISTED	Stock	56.29	57.1144	55.79	56.27	369605.0
2020-12-04	AAXJ	Stock	87.8	88.06	87.68	88.06	975576.0
2020-12-04	AAXN-DELISTED	Stock	123.85	124.93	123.15	124.13	169544.0
2020-12-04	AB	Stock	33.57	33.8	33.2	33.41	325800.0
2020-12-04	ABB-DELISTED	Stock	26.91	27.22	26.84	27.09	1960815.0
2020-12-04	ABBNY-DELISTED	Stock	26.91	27.22	26.84	27.09	2087324.0
2020-12-04	ABBV	Stock	105.02	107.31	105.02	107.28	7235800.0
2020-12-04	ABC-DELISTED	Stock	101.71	102.99	100.41	102.99	660485.0
2020-12-04	ABCB	Stock	35.99	36.47	35.5	36.26	546200.0
2020-12-04	ABCM-DELISTED	Stock	18.9	19.24	18.85	19.01	34375.0
2020-12-04	ABEO	Stock	38.75	39.25	37.25	37.75	49580.0
2020-12-04	ABEV	Stock	2.87	2.93	2.85	2.91	28848800.0
2020-12-04	ABG	Stock	130.94	138.66	130.32	137.71	187900.0
2020-12-04	ABM	Stock	38.94	39.62	38.94	39.62	291700.0
2020-12-04	ABMD-DELISTED	Stock	265.41	277.33	265.41	272.48	140686.0
2020-12-04	ABR	Stock	13.7	13.84	13.58	13.66	1182500.0
2020-12-04	ABR.A-DELISTED	Stock	25.44	25.54	25.39	25.42	3053.0
2020-12-04	ABR.B-DELISTED	Stock	25.24	25.33	25.22	25.33	1520.0
2020-12-04	ABR.C-DELISTED	Stock	25.81	25.9	25.7	25.8701	2800.0

> showing 50 of 7,156 rows — these rows as CSV

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