PREVIEW / stock_daily / 2020-11-12

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-12.parquet
  size:    230 KB
  rows:    6,982
  symbols: 2,470

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-11-12	AAPL	Stock	119.62	120.53	118.57	119.21	103162300.0
2020-11-12	MSFT	Stock	217.21	219.11	214.46	215.44	21593900.0
2020-11-12	NVDA	Stock	13.479	13.766	13.316	13.4568	365812000.0
2020-11-12	AMZN	Stock	157.9975	158.794	154.3025	155.514	87240000.0
2020-11-12	GOOGL	Stock	87.1	88.249	86.8985	87.141	26487260.0
2020-11-12	META	Stock	277.18	279.75	274.43	275.08	12899500.0
2020-11-12	TSLA	Stock	138.35	141.0	136.5067	137.2533	59565300.0
2020-11-12	TLT	Stock	156.94	158.4	156.71	158.37	16001553.0
2020-11-12	ES	Stock	94.16	94.44	91.71	92.31	1036900.0
2020-11-12	CL	Stock	85.0	85.12	84.21	84.73	3705200.0
2020-11-12	A	Stock	109.4	111.01	108.9	109.44	1094300.0
2020-11-12	AA	Stock	15.49	16.1	15.16	15.62	5087500.0
2020-11-12	AACG	Stock	1.15	1.25	1.15	1.22	286700.0
2020-11-12	AACQ-DELISTED	Stock	9.725	9.77	9.708	9.77	15780.0
2020-11-12	AACQU-DELISTED	Stock	10.13	10.15	10.13	10.15	15807.0
2020-11-12	AACQW-DELISTED	Stock	1.1886	1.1886	1.1	1.15	28285.0
2020-11-12	AAIC-DELISTED	Stock	2.77	2.8201	2.71	2.81	287670.0
2020-11-12	AAL	Stock	11.97	12.23	11.65	11.74	75511700.0
2020-11-12	AAM.A-DELISTED	Stock	26.36	26.4	26.26	26.3225	13853.0
2020-11-12	AAM.B-DELISTED	Stock	27.1	27.1	26.82	26.98	16658.0
2020-11-12	AAMC-DELISTED	Stock	6.6147	6.6176	6.5294	6.6176	4573.0
2020-11-12	AAMI	Stock	17.23	17.41	16.91	17.26	631200.0
2020-11-12	AAOI	Stock	7.63	7.88	7.59	7.63	710700.0
2020-11-12	AAON	Stock	43.34	43.66	41.38	41.9533	297600.0
2020-11-12	AAP	Stock	156.72	156.72	151.5	153.06	1091700.0
2020-11-12	AAT	Stock	25.74	25.74	24.82	25.17	272400.0
2020-11-12	AAU-DELISTED	Stock	1.09	1.14	1.04	1.05	392338.0
2020-11-12	AAUAF-DELISTED	Stock	1.09	1.14	1.04	1.04	412318.0
2020-11-12	AAWW-DELISTED	Stock	52.3	54.325	51.5	52.48	524612.0
2020-11-12	AAXJ	Stock	83.95	84.28	83.045	83.27	1548611.0
2020-11-12	AAXN-DELISTED	Stock	118.01	119.59	117.0	118.08	290562.0
2020-11-12	AB	Stock	31.75	31.95	30.89	31.39	392200.0
2020-11-12	ABB-DELISTED	Stock	26.98	27.08	26.75	26.83	1478589.0
2020-11-12	ABBNY-DELISTED	Stock	26.98	27.08	26.75	26.82	1576696.0
2020-11-12	ABBV	Stock	97.5	97.75	96.28	97.6	7646600.0
2020-11-12	ABC-DELISTED	Stock	106.71	107.51	105.15	106.15	570749.0
2020-11-12	ABCB	Stock	32.42	32.99	31.86	32.39	599300.0
2020-11-12	ABCM-DELISTED	Stock	18.2	18.96	18.17	18.69	356581.0
2020-11-12	ABEO	Stock	32.0	32.25	29.25	30.25	65644.0
2020-11-12	ABEV	Stock	2.75	2.77	2.67	2.71	21259200.0
2020-11-12	ABG	Stock	120.54	121.13	116.29	117.65	241300.0
2020-11-12	ABM	Stock	38.64	38.81	37.34	37.56	303400.0
2020-11-12	ABMD-DELISTED	Stock	269.8	274.0	266.96	268.66	112018.0
2020-11-12	ABR	Stock	13.36	13.42	12.6	12.9	3464200.0
2020-11-12	ABR.A-DELISTED	Stock	25.86	25.86	25.05	25.3	15110.0
2020-11-12	ABR.B-DELISTED	Stock	25.38	25.44	25.35	25.36	2565.0
2020-11-12	ABR.C-DELISTED	Stock	25.81	26.28	25.58	25.7	17004.0
2020-11-12	ABST-DELISTED	Stock	10.76	10.76	10.4	10.4	26731.0
2020-11-12	ABT	Stock	112.41	112.86	111.3	111.95	2816800.0
2020-11-12	ABTC	Stock	90000.0	93600.0	81000.0	84000.0	73.93333333333334

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

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