PREVIEW / stock_daily / 2020-03-03

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-03.parquet
  size:    221 KB
  rows:    6,610
  symbols: 2,373

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-03	AAPL	Stock	75.9175	76.0	71.45	72.33	319475600.0
2020-03-03	MSFT	Stock	173.8	175.0	162.26	164.51	71677000.0
2020-03-03	NVDA	Stock	6.9668	7.0268	6.5615	6.6472	652792000.0
2020-03-03	AMZN	Stock	98.7685	99.8165	94.4045	95.4495	150690000.0
2020-03-03	GOOGL	Stock	69.884	70.4095	66.4621	66.886	56602240.0
2020-03-03	META	Stock	196.22	197.24	183.97	185.89	27984100.0
2020-03-03	TSLA	Stock	53.6667	53.7987	47.7407	49.7007	386760000.0
2020-03-03	TLT	Stock	153.81	159.7	152.36	156.33	38608024.0
2020-03-03	ES	Stock	93.03	95.09	91.6	92.4	2409300.0
2020-03-03	CL	Stock	72.55	74.11	71.24	71.78	7487800.0
2020-03-03	A	Stock	81.89	85.0	79.28	80.32	3017200.0
2020-03-03	AA	Stock	13.67	14.04	12.705	12.94	10024700.0
2020-03-03	AACG	Stock	0.99	1.01	0.97	0.98	40800.0
2020-03-03	AAIC-DELISTED	Stock	5.99	6.18	5.93	6.0	469900.0
2020-03-03	AAIC.C-DELISTED	Stock	22.8	22.8	22.3	22.3	3060.0
2020-03-03	AAL	Stock	19.66	19.79	17.8	17.85	35402500.0
2020-03-03	AAM.A-DELISTED	Stock	26.12	26.3	25.74	25.93	33009.0
2020-03-03	AAM.B-DELISTED	Stock	26.33	26.68	26.05	26.12	29431.0
2020-03-03	AAMC-DELISTED	Stock	5.9609	6.1176	5.8817	5.9175	4740.0
2020-03-03	AAME	Stock	2.61	2.61	2.55	2.57	700.0
2020-03-03	AAMI	Stock	9.09	9.27	8.28	8.37	1425000.0
2020-03-03	AAOI	Stock	9.03	9.47	8.85	9.4	703600.0
2020-03-03	AAON	Stock	38.3733	38.8333	36.58	37.4533	363750.0
2020-03-03	AAP	Stock	131.52	135.66	128.92	130.33	1241000.0
2020-03-03	AAT	Stock	42.9	43.65	41.53	41.95	409100.0
2020-03-03	AAU-DELISTED	Stock	0.4	0.4	0.3724	0.3777	438497.0
2020-03-03	AAUAF-DELISTED	Stock	0.39	0.392	0.3724	0.3777	474804.0
2020-03-03	AAWW-DELISTED	Stock	26.63	27.635	25.74	25.84	579976.0
2020-03-03	AAXJ	Stock	69.29	70.12	68.39	68.89	1910599.0
2020-03-03	AAXN-DELISTED	Stock	82.7	83.48	77.27	78.1	724184.0
2020-03-03	AB	Stock	32.89	33.1	31.0	31.55	923500.0
2020-03-03	ABB-DELISTED	Stock	22.15	22.435	21.51	21.62	2836835.0
2020-03-03	ABBNY-DELISTED	Stock	22.15	22.435	21.51	21.63	3143916.0
2020-03-03	ABBV	Stock	89.44	90.9	85.66	87.57	12660900.0
2020-03-03	ABC-DELISTED	Stock	87.42	88.95	84.45	85.85	1500019.0
2020-03-03	ABCB	Stock	35.03	35.56	34.2	34.65	674600.0
2020-03-03	ABEO	Stock	84.0	87.75	76.5	78.5	47612.0
2020-03-03	ABEV	Stock	3.28	3.38	3.26	3.28	44030700.0
2020-03-03	ABG	Stock	93.25	95.57	90.35	91.61	245500.0
2020-03-03	ABM	Stock	34.92	35.95	33.7	33.94	481600.0
2020-03-03	ABMD-DELISTED	Stock	154.56	158.75	148.01	149.3	517012.0
2020-03-03	ABR	Stock	13.29	13.65	12.54	12.64	2076000.0
2020-03-03	ABR.A-DELISTED	Stock	25.95	25.95	25.4616	25.48	8893.0
2020-03-03	ABR.B-DELISTED	Stock	25.6379	25.6379	25.33	25.4	2145.0
2020-03-03	ABR.C-DELISTED	Stock	25.681	25.885	25.51	25.55	3238.0
2020-03-03	ABT	Stock	81.58	83.5	77.26	77.99	9510600.0
2020-03-03	ABTC	Stock	251100.0	252900.0	217500.0	220800.0	3.7066666666666666
2020-03-03	ABTS	Stock	23.25	23.25	21.6	21.6	280.0
2020-03-03	ABTX-DELISTED	Stock	34.02	34.37	33.06	33.46	88740.0
2020-03-03	ABUS	Stock	2.85	2.86	2.72	2.79	342600.0

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

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