PREVIEW / stock_daily / 2020-03-25

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-25.parquet
  size:    216 KB
  rows:    6,660
  symbols: 2,400

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-25	AAPL	Stock	62.6875	64.5625	61.075	61.38	303602000.0
2020-03-25	MSFT	Stock	148.91	154.33	144.44	146.92	75638200.0
2020-03-25	NVDA	Stock	6.345	6.5455	6.0915	6.1405	793432000.0
2020-03-25	AMZN	Stock	96.0345	97.513	94.289	94.292	129582000.0
2020-03-25	GOOGL	Stock	56.229	57.3085	54.1505	55.081	90323240.0
2020-03-25	META	Stock	158.92	162.99	153.06	156.21	35184300.0
2020-03-25	TSLA	Stock	36.35	37.1333	34.074	35.95	318340500.0
2020-03-25	TLT	Stock	163.59	166.68	161.62	162.54	10750564.0
2020-03-25	ES	Stock	70.24	74.55	68.01	71.9	2181000.0
2020-03-25	CL	Stock	60.76	62.22	59.01	59.89	10375500.0
2020-03-25	A	Stock	67.12	71.79	65.11	69.0	2628100.0
2020-03-25	AA	Stock	7.93	7.99	7.01	7.09	12619300.0
2020-03-25	AACG	Stock	0.81	0.96	0.8	0.91	8800.0
2020-03-25	AAIC-DELISTED	Stock	2.1	2.705	2.01	2.55	1275952.0
2020-03-25	AAIC.C-DELISTED	Stock	9.2	13.05	9.2	11.75	47773.0
2020-03-25	AAL	Stock	16.69	16.99	14.31	15.39	93795100.0
2020-03-25	AAM.A-DELISTED	Stock	20.58	24.55	20.2401	22.19	65637.0
2020-03-25	AAM.B-DELISTED	Stock	20.58	23.75	20.58	21.85	95775.0
2020-03-25	AAMC-DELISTED	Stock	3.2441	4.2206	3.1529	3.9771	63543.0
2020-03-25	AAME	Stock	2.3	2.3	2.12	2.12	1100.0
2020-03-25	AAMI	Stock	5.25	6.11	5.14	5.65	675000.0
2020-03-25	AAOI	Stock	7.78	8.15	7.34	7.45	495700.0
2020-03-25	AAON	Stock	30.2933	31.6333	28.34	28.5	603900.0
2020-03-25	AAP	Stock	87.33	96.61	85.07	90.37	1173700.0
2020-03-25	AAT	Stock	23.7	25.19	21.93	22.88	1040000.0
2020-03-25	AAU-DELISTED	Stock	0.301	0.34	0.3	0.325	754755.0
2020-03-25	AAUAF-DELISTED	Stock	0.301	0.34	0.3	0.325	810868.0
2020-03-25	AAWW-DELISTED	Stock	23.74	25.6899	22.61	22.75	545327.0
2020-03-25	AAXJ	Stock	58.71	60.02	58.1644	59.39	3566000.0
2020-03-25	AAXN-DELISTED	Stock	69.84	74.09	66.59	71.02	587915.0
2020-03-25	AB	Stock	17.57	19.01	16.53	18.02	1200200.0
2020-03-25	ABB-DELISTED	Stock	17.33	18.15	16.88	17.64	4284351.0
2020-03-25	ABBNY-DELISTED	Stock	17.33	18.15	16.88	17.65	4518911.0
2020-03-25	ABBV	Stock	67.92	70.68	65.55	67.91	20017300.0
2020-03-25	ABC-DELISTED	Stock	79.54	81.47	75.11	75.45	1852963.0
2020-03-25	ABCB	Stock	22.17	22.94	20.7	21.56	590600.0
2020-03-25	ABEO	Stock	52.75	58.75	50.25	54.25	68564.0
2020-03-25	ABEV	Stock	2.26	2.43	2.19	2.37	27219800.0
2020-03-25	ABG	Stock	53.82	61.19	53.34	58.67	528000.0
2020-03-25	ABM	Stock	21.02	22.26	20.11	21.01	1208900.0
2020-03-25	ABMD-DELISTED	Stock	144.01	152.0	140.02	146.79	310477.0
2020-03-25	ABR	Stock	4.57	5.69	4.4	5.05	4891600.0
2020-03-25	ABR.A-DELISTED	Stock	13.18	18.2343	12.5811	17.16	13108.0
2020-03-25	ABR.B-DELISTED	Stock	11.48	16.7465	11.48	16.4	18109.0
2020-03-25	ABR.C-DELISTED	Stock	13.72	19.18	12.76	17.995	8520.0
2020-03-25	ABT	Stock	68.95	72.63	68.15	70.75	9351000.0
2020-03-25	ABTC	Stock	125400.0	164400.0	120300.0	151200.0	5.226666666666667
2020-03-25	ABTS	Stock	13.35	15.45	13.35	13.65	420.0
2020-03-25	ABTX-DELISTED	Stock	24.76	24.925	23.28	23.75	79663.0
2020-03-25	ABUS	Stock	1.95	2.24	1.91	2.15	273400.0

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

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