PREVIEW / stock_daily / 2020-09-11

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-11.parquet
  size:    225 KB
  rows:    6,832
  symbols: 2,434

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-09-11	AAPL	Stock	114.57	115.23	110.0	112.0	180860300.0
2020-09-11	MSFT	Stock	207.2	208.63	201.24	204.03	33620100.0
2020-09-11	NVDA	Stock	12.4855	12.6525	11.8958	12.1645	636928000.0
2020-09-11	AMZN	Stock	160.4345	160.867	154.199	155.811	101880000.0
2020-09-11	GOOGL	Stock	76.4075	76.9348	74.651	75.788	30706740.0
2020-09-11	META	Stock	270.06	271.39	262.64	266.61	18913900.0
2020-09-11	TSLA	Stock	127.3133	127.5	120.1667	124.24	182152500.0
2020-09-11	TLT	Stock	164.31	164.57	164.08	164.48	5458222.0
2020-09-11	ES	Stock	83.63	83.65	81.52	82.16	2086300.0
2020-09-11	CL	Stock	76.74	77.26	76.41	76.75	2736900.0
2020-09-11	A	Stock	98.71	99.62	98.02	98.6	1368600.0
2020-09-11	AA	Stock	13.89	14.28	13.675	13.98	4217300.0
2020-09-11	AACG	Stock	1.08	1.09	1.06	1.06	22700.0
2020-09-11	AACQ-DELISTED	Stock	10.05	10.1	9.92	9.96	47627.0
2020-09-11	AACQU-DELISTED	Stock	10.47	10.5	10.32	10.48	20600.0
2020-09-11	AACQW-DELISTED	Stock	1.99	1.99	1.595	1.6146	316035.0
2020-09-11	AAIC-DELISTED	Stock	2.68	2.69	2.66	2.69	257457.0
2020-09-11	AAIC.C-DELISTED	Stock	19.46	19.95	19.19	19.9499	5994.0
2020-09-11	AAL	Stock	13.08	13.08	12.68	12.95	43916700.0
2020-09-11	AAM.A-DELISTED	Stock	26.52	26.52	26.2713	26.31	6775.0
2020-09-11	AAM.B-DELISTED	Stock	27.205	27.2699	27.0416	27.0416	5370.0
2020-09-11	AAMC-DELISTED	Stock	7.5588	7.5588	6.5971	6.9118	23317.0
2020-09-11	AAME	Stock	2.05	2.05	1.94	1.94	1300.0
2020-09-11	AAMI	Stock	12.94	13.2	12.92	13.12	450800.0
2020-09-11	AAOI	Stock	9.88	10.03	9.58	9.7	531100.0
2020-09-11	AAON	Stock	37.6067	37.9333	37.3333	37.64	330300.0
2020-09-11	AAP	Stock	154.47	155.32	153.08	154.59	493900.0
2020-09-11	AAT	Stock	25.26	25.26	24.52	24.66	489700.0
2020-09-11	AAU-DELISTED	Stock	0.6841	0.767	0.6741	0.76	1123199.0
2020-09-11	AAUAF-DELISTED	Stock	0.6841	0.767	0.6741	0.7663	1134395.0
2020-09-11	AAWW-DELISTED	Stock	57.12	57.425	55.94	56.94	258970.0
2020-09-11	AAXJ	Stock	76.74	77.0	76.15	76.56	963794.0
2020-09-11	AAXN-DELISTED	Stock	84.95	85.26	83.12	84.0	441578.0
2020-09-11	AB	Stock	26.95	27.44	26.59	27.21	481000.0
2020-09-11	ABB-DELISTED	Stock	26.23	26.34	25.995	26.17	1003070.0
2020-09-11	ABBNY-DELISTED	Stock	26.21	26.34	25.995	26.15	1069591.0
2020-09-11	ABBV	Stock	89.81	90.34	89.04	89.7	8385800.0
2020-09-11	ABC-DELISTED	Stock	94.85	94.9	92.84	94.08	466213.0
2020-09-11	ABCB	Stock	23.38	23.51	23.14	23.48	233700.0
2020-09-11	ABEO	Stock	51.5	51.5	47.75	48.0	20336.0
2020-09-11	ABEV	Stock	2.33	2.36	2.26	2.29	17269800.0
2020-09-11	ABG	Stock	108.39	108.98	104.32	104.61	120900.0
2020-09-11	ABM	Stock	37.73	37.73	36.1	36.14	463100.0
2020-09-11	ABMD-DELISTED	Stock	274.76	276.5	266.71	270.03	145713.0
2020-09-11	ABR	Stock	11.5	11.54	11.19	11.41	691900.0
2020-09-11	ABR.A-DELISTED	Stock	25.3	25.83	25.2	25.2	1300.0
2020-09-11	ABR.B-DELISTED	Stock	25.225	25.415	25.225	25.415	900.0
2020-09-11	ABR.C-DELISTED	Stock	25.49	25.59	25.48	25.58	1527.0
2020-09-11	ABT	Stock	105.28	105.7	104.32	104.7	4111000.0
2020-09-11	ABTC	Stock	138300.0	141000.0	136710.0	139500.0	1.24

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

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