PREVIEW / stock_daily / 2020-11-05

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-05.parquet
  size:    229 KB
  rows:    6,987
  symbols: 2,486

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-05	AAPL	Stock	117.95	119.62	116.87	119.03	126387100.0
2020-11-05	MSFT	Stock	222.04	224.12	221.15	223.29	36080100.0
2020-11-05	NVDA	Stock	14.1625	14.339	13.991	14.16	319028000.0
2020-11-05	AMZN	Stock	165.9985	168.34	164.444	166.1	115786000.0
2020-11-05	GOOGL	Stock	88.5225	89.5909	87.0515	88.125	39758140.0
2020-11-05	META	Stock	291.9	297.38	288.95	294.68	23823600.0
2020-11-05	TSLA	Stock	142.7667	146.6667	141.3333	146.03	85243500.0
2020-11-05	TLT	Stock	161.64	161.74	160.58	161.36	18537530.0
2020-11-05	ES	Stock	91.76	93.57	91.76	92.2	1188600.0
2020-11-05	CL	Stock	84.75	84.75	82.98	83.01	3914000.0
2020-11-05	A	Stock	110.57	111.93	109.67	110.34	1143100.0
2020-11-05	AA	Stock	13.31	14.3	13.31	14.05	5732700.0
2020-11-05	AACG	Stock	1.14	1.15	1.11	1.13	56300.0
2020-11-05	AACQ-DELISTED	Stock	9.735	9.77	9.7001	9.77	29762.0
2020-11-05	AACQU-DELISTED	Stock	10.1	10.1	10.035	10.05	66130.0
2020-11-05	AACQW-DELISTED	Stock	1.22	1.22	1.1038	1.1137	28094.0
2020-11-05	AAIC-DELISTED	Stock	2.77	2.834	2.66	2.67	262980.0
2020-11-05	AAIC.C-DELISTED	Stock	18.93	18.95	18.93	18.95	299.0
2020-11-05	AAL	Stock	11.12	11.67	11.09	11.6	54890800.0
2020-11-05	AAM.A-DELISTED	Stock	26.26	26.31	26.2	26.31	18862.0
2020-11-05	AAM.B-DELISTED	Stock	26.84	27.03	26.84	27.03	8066.0
2020-11-05	AAME	Stock	2.03	2.03	2.03	2.03	300.0
2020-11-05	AAMI	Stock	14.62	15.405	14.54	15.17	849300.0
2020-11-05	AAOI	Stock	9.17	10.2	9.015	10.02	1102500.0
2020-11-05	AAON	Stock	40.6667	41.5467	39.3933	41.12	305100.0
2020-11-05	AAP	Stock	157.78	158.84	155.28	156.43	544200.0
2020-11-05	AAT	Stock	22.0	22.05	21.42	21.77	573000.0
2020-11-05	AAU-DELISTED	Stock	1.04	1.19	1.0	1.19	1223022.0
2020-11-05	AAUAF-DELISTED	Stock	1.04	1.19	1.0	1.19	1256512.0
2020-11-05	AAWW-DELISTED	Stock	63.05	65.08	62.14	62.5	828589.0
2020-11-05	AAXJ	Stock	83.9	84.0	83.03	83.69	2815862.0
2020-11-05	AAXN-DELISTED	Stock	106.07	110.4	105.71	108.5	424957.0
2020-11-05	AB	Stock	30.5	31.2	30.46	30.85	679800.0
2020-11-05	ABB-DELISTED	Stock	26.19	26.4	26.17	26.32	1614302.0
2020-11-05	ABBNY-DELISTED	Stock	26.19	26.4	26.17	26.32	1723216.0
2020-11-05	ABBV	Stock	95.36	95.52	93.0	93.69	8013000.0
2020-11-05	ABC-DELISTED	Stock	106.1	109.62	104.005	105.44	935318.0
2020-11-05	ABCB	Stock	28.71	30.5	28.71	30.0	675300.0
2020-11-05	ABCM-DELISTED	Stock	19.96	20.0732	19.51	19.71	114278.0
2020-11-05	ABEO	Stock	26.25	26.5	25.0	26.0	72868.0
2020-11-05	ABEV	Stock	2.36	2.43	2.34	2.43	20251400.0
2020-11-05	ABG	Stock	114.0	117.73	114.0	115.47	158300.0
2020-11-05	ABM	Stock	36.02	37.23	36.02	37.22	287700.0
2020-11-05	ABMD-DELISTED	Stock	271.52	275.8588	267.875	272.81	137206.0
2020-11-05	ABR	Stock	12.85	13.22	12.85	13.01	1638700.0
2020-11-05	ABR.A-DELISTED	Stock	25.62	25.89	25.62	25.89	800.0
2020-11-05	ABR.B-DELISTED	Stock	25.65	25.65	25.62	25.64	660.0
2020-11-05	ABR.C-DELISTED	Stock	26.04	26.132	26.01	26.01	3799.0
2020-11-05	ABST-DELISTED	Stock	11.9	12.14	11.63	12.14	79206.0
2020-11-05	ABT	Stock	113.51	114.84	112.72	113.53	5139900.0

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

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