PREVIEW / stock_daily / 2020-03-27

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-27.parquet
  size:    215 KB
  rows:    6,647
  symbols: 2,397

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-03-27	AAPL	Stock	63.1875	63.9675	61.7625	61.935	204216800.0
2020-03-27	MSFT	Stock	151.75	154.89	149.2	149.7	57042300.0
2020-03-27	NVDA	Stock	6.25	6.578	6.217	6.3182	638828000.0
2020-03-27	AMZN	Stock	96.543	96.9895	94.996	95.005	107758000.0
2020-03-27	GOOGL	Stock	56.3735	57.5525	55.2001	55.513	62793220.0
2020-03-27	META	Stock	158.2	160.09	154.75	156.79	24879900.0
2020-03-27	TSLA	Stock	33.6667	35.0533	32.9353	34.2907	215661000.0
2020-03-27	TLT	Stock	165.52	168.25	164.59	167.7	12550007.0
2020-03-27	ES	Stock	76.43	83.63	75.42	80.96	1749800.0
2020-03-27	CL	Stock	64.03	66.63	63.36	65.26	6366500.0
2020-03-27	A	Stock	71.55	73.21	70.28	70.91	1829800.0
2020-03-27	AA	Stock	6.51	6.79	6.05	6.55	10075400.0
2020-03-27	AACG	Stock	1.02	1.02	0.95	0.96	4300.0
2020-03-27	AAIC-DELISTED	Stock	3.06	3.13	2.47	2.66	1169583.0
2020-03-27	AAIC.C-DELISTED	Stock	15.42	15.96	15.0052	15.6	21292.0
2020-03-27	AAL	Stock	14.98	15.22	13.91	14.04	50783500.0
2020-03-27	AAM.A-DELISTED	Stock	23.25	23.9	22.5	23.0137	41309.0
2020-03-27	AAM.B-DELISTED	Stock	22.91	23.5829	22.5	22.65	23414.0
2020-03-27	AAMC-DELISTED	Stock	4.0456	4.155	4.0456	4.1381	3298.0
2020-03-27	AAME	Stock	2.25	2.25	2.21	2.25	500.0
2020-03-27	AAMI	Stock	6.12	6.67	6.09	6.09	781800.0
2020-03-27	AAOI	Stock	6.76	8.04	6.32	7.48	1425900.0
2020-03-27	AAON	Stock	31.1267	31.98	30.0867	30.84	342900.0
2020-03-27	AAP	Stock	93.1	100.21	91.4	95.6	761500.0
2020-03-27	AAT	Stock	23.48	25.28	23.08	24.69	473000.0
2020-03-27	AAU-DELISTED	Stock	0.285	0.326	0.285	0.3008	199543.0
2020-03-27	AAUAF-DELISTED	Stock	0.285	0.326	0.285	0.3008	208658.0
2020-03-27	AAWW-DELISTED	Stock	23.06	23.73	21.99	21.99	644917.0
2020-03-27	AAXJ	Stock	58.33	59.18	58.02	58.29	1237136.0
2020-03-27	AAXN-DELISTED	Stock	73.08	77.23	71.94	74.21	637214.0
2020-03-27	AB	Stock	19.16	19.61	18.6	18.72	650100.0
2020-03-27	ABB-DELISTED	Stock	18.14	18.6432	17.85	18.22	2704346.0
2020-03-27	ABBNY-DELISTED	Stock	18.14	18.6432	17.85	18.22	2873084.0
2020-03-27	ABBV	Stock	71.63	75.06	70.71	72.67	12293300.0
2020-03-27	ABC-DELISTED	Stock	80.94	84.06	80.18	81.82	1282188.0
2020-03-27	ABCB	Stock	21.86	23.35	21.4	22.52	466600.0
2020-03-27	ABEO	Stock	51.5	55.0	48.5	51.5	34376.0
2020-03-27	ABEV	Stock	2.4	2.63	2.38	2.51	21862700.0
2020-03-27	ABG	Stock	57.77	58.94	53.82	55.5	342000.0
2020-03-27	ABM	Stock	21.21	23.62	21.0	21.99	1455700.0
2020-03-27	ABMD-DELISTED	Stock	146.35	146.52	141.62	145.27	312861.0
2020-03-27	ABR	Stock	6.5	7.05	6.23	6.84	2544800.0
2020-03-27	ABR.A-DELISTED	Stock	19.2008	19.8134	17.01	19.8134	9864.0
2020-03-27	ABR.B-DELISTED	Stock	19.55	20.0	18.4001	19.0	3649.0
2020-03-27	ABR.C-DELISTED	Stock	18.45	19.6	17.666	19.05	8483.0
2020-03-27	ABT	Stock	77.5	77.5	73.61	74.56	8360600.0
2020-03-27	ABTC	Stock	168600.0	170400.0	150300.0	160500.0	4.319999999999999
2020-03-27	ABTS	Stock	12.54	12.54	11.7	11.91	113.0
2020-03-27	ABTX-DELISTED	Stock	24.45	25.86	23.445	23.69	70997.0
2020-03-27	ABUS	Stock	2.0	2.0	1.12	1.21	8028600.0

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

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