PREVIEW / stock_daily / 2020-12-18

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-18.parquet
  size:    242 KB
  rows:    7,264
  symbols: 2,648

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-18	AAPL	Stock	128.96	129.1	126.12	126.66	192541500.0
2020-12-18	MSFT	Stock	218.59	219.69	216.02	218.59	63354900.0
2020-12-18	NVDA	Stock	13.379	13.405	13.0705	13.272	342064000.0
2020-12-18	AMZN	Stock	162.1995	162.471	158.58	160.0825	119914000.0
2020-12-18	GOOGL	Stock	87.3085	87.418	85.75	86.311	85256740.0
2020-12-18	META	Stock	275.77	278.0	271.14	276.4	26693200.0
2020-12-18	TSLA	Stock	222.9667	231.6667	209.5133	231.6667	666378600.0
2020-12-18	TLT	Stock	157.12	157.38	156.18	156.33	6505271.0
2020-12-18	ES	Stock	85.35	86.46	84.1	84.71	3406200.0
2020-12-18	CL	Stock	85.66	86.2	84.96	85.93	6089800.0
2020-12-18	A	Stock	119.23	119.86	118.44	119.3	3911800.0
2020-12-18	AA	Stock	22.21	22.61	21.86	22.01	5137200.0
2020-12-18	AACG	Stock	1.16	1.2	1.16	1.2	9900.0
2020-12-18	AACQ-DELISTED	Stock	10.3	10.42	10.3	10.38	321154.0
2020-12-18	AACQU-DELISTED	Stock	10.9	10.98	10.8974	10.98	35735.0
2020-12-18	AACQW-DELISTED	Stock	1.7	1.784	1.6602	1.7	254174.0
2020-12-18	AAIC-DELISTED	Stock	3.73	3.75	3.65	3.75	427516.0
2020-12-18	AAIC.C-DELISTED	Stock	21.2	21.25	21.1454	21.25	2240.0
2020-12-18	AAL	Stock	16.74	16.74	16.29	16.51	74782800.0
2020-12-18	AAM.A-DELISTED	Stock	26.355	26.53	26.355	26.53	15342.0
2020-12-18	AAM.B-DELISTED	Stock	27.2	27.31	27.07	27.31	19917.0
2020-12-18	AAMC-DELISTED	Stock	6.6118	6.6882	6.5176	6.5176	29791.0
2020-12-18	AAME	Stock	2.19	2.22	2.07	2.08	12300.0
2020-12-18	AAMI	Stock	18.77	18.845	18.14	18.81	2098100.0
2020-12-18	AAN-DELISTED	Stock	18.81	18.98	17.52	18.16	1919800.0
2020-12-18	AAOI	Stock	8.56	8.59	8.42	8.51	697500.0
2020-12-18	AAON	Stock	43.4733	43.8267	42.6867	42.88	735600.0
2020-12-18	AAP	Stock	159.97	161.04	158.76	159.99	1478300.0
2020-12-18	AAT	Stock	29.5	29.57	28.05	28.31	1470000.0
2020-12-18	AAU-DELISTED	Stock	0.806	0.806	0.76	0.7603	632290.0
2020-12-18	AAUAF-DELISTED	Stock	0.806	0.806	0.76	0.7702	688837.0
2020-12-18	AAWW-DELISTED	Stock	55.77	56.77	54.52	55.27	597222.0
2020-12-18	AAXJ	Stock	87.89	87.94	87.58	87.85	1062419.0
2020-12-18	AAXN-DELISTED	Stock	121.7	125.8	121.55	125.34	753343.0
2020-12-18	AB	Stock	33.6	33.8	33.16	33.61	343800.0
2020-12-18	ABB-DELISTED	Stock	27.4	27.41	27.15	27.31	1576659.0
2020-12-18	ABBNY-DELISTED	Stock	27.4	27.41	27.15	27.31	1682446.0
2020-12-18	ABBV	Stock	105.03	105.06	103.2	104.45	13906800.0
2020-12-18	ABC-DELISTED	Stock	98.76	99.85	97.51	98.62	1367304.0
2020-12-18	ABCB	Stock	38.62	38.75	37.63	37.8	1521200.0
2020-12-18	ABCL	Stock	49.2	49.8	48.16	49.22	424500.0
2020-12-18	ABCM-DELISTED	Stock	19.57	19.92	19.32	19.735	111835.0
2020-12-18	ABEO	Stock	40.5	40.75	38.5	38.5	86936.0
2020-12-18	ABEV	Stock	3.14	3.17	3.11	3.13	18166900.0
2020-12-18	ABG	Stock	147.51	147.65	142.53	142.6	596000.0
2020-12-18	ABM	Stock	40.77	41.55	39.67	39.93	1003600.0
2020-12-18	ABMD-DELISTED	Stock	282.77	294.48	276.94	293.58	635336.0
2020-12-18	ABNB	Stock	150.45	159.0	150.3	157.3	15954200.0
2020-12-18	ABR	Stock	14.77	14.95	14.18	14.21	4245800.0
2020-12-18	ABR.A-DELISTED	Stock	25.43	25.52	25.33	25.375	7934.0

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

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