PREVIEW / stock_daily / 2019-03-26

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-26.parquet
  size:    220 KB
  rows:    6,528
  symbols: 2,611

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
2019-03-26	AAPL	Stock	47.915	48.22	46.145	46.6975	199202000.0
2019-03-26	MSFT	Stock	118.62	118.71	116.85	117.91	26097700.0
2019-03-26	NVDA	Stock	4.4873	4.5438	4.365	4.4218	703508000.0
2019-03-26	AMZN	Stock	89.65	90.2885	88.668	89.188	97318000.0
2019-03-26	GOOGL	Stock	60.2595	60.3825	59.088	59.492	30752120.0
2019-03-26	META	Stock	167.35	169.45	166.35	167.68	15437900.0
2019-03-26	TSLA	Stock	17.6293	18.0173	17.6287	17.8513	110263500.0
2019-03-26	TLT	Stock	124.7	125.29	124.62	124.97	7502260.0
2019-03-26	ES	Stock	71.97	72.26	71.54	71.95	1103800.0
2019-03-26	CL	Stock	66.61	67.31	66.47	66.92	2297300.0
2019-03-26	A	Stock	80.39	81.04	80.13	80.65	1428200.0
2019-03-26	AA	Stock	28.14	28.5	27.27	27.54	4287200.0
2019-03-26	AABA-DELISTED	Stock	73.12	73.46	72.13	72.54	3331983.0
2019-03-26	AAC-DELISTED	Stock	2.06	2.0685	1.76	1.82	275334.0
2019-03-26	AACG	Stock	1.0	1.01	1.0	1.0	49100.0
2019-03-26	AAIC-DELISTED	Stock	8.23	8.3	8.2	8.28	494441.0
2019-03-26	AAIC.C-DELISTED	Stock	23.25	23.29	23.02	23.05	9193.0
2019-03-26	AAL	Stock	30.51	30.62	29.97	30.21	4583400.0
2019-03-26	AAM.A-DELISTED	Stock	25.0418	25.0963	25.01	25.066	13705.0
2019-03-26	AAM.B-DELISTED	Stock	24.6482	24.75	24.61	24.72	48521.0
2019-03-26	AAMC-DELISTED	Stock	8.9235	9.6706	7.369	8.9618	120295.0
2019-03-26	AAME	Stock	2.58	2.68	2.55	2.56	3200.0
2019-03-26	AAMI	Stock	12.7	13.06	12.7	12.95	510100.0
2019-03-26	AAOI	Stock	12.43	12.58	12.01	12.35	738900.0
2019-03-26	AAON	Stock	28.9067	29.3933	28.6667	29.0267	160800.0
2019-03-26	AAP	Stock	167.85	168.9	165.81	168.27	961700.0
2019-03-26	AAT	Stock	45.33	45.86	45.21	45.83	160000.0
2019-03-26	AAU-DELISTED	Stock	0.62	0.67	0.605	0.635	326233.0
2019-03-26	AAUAF-DELISTED	Stock	0.62	0.67	0.605	0.6366	342318.0
2019-03-26	AAWW-DELISTED	Stock	46.94	47.75	46.78	47.47	126171.0
2019-03-26	AAXJ	Stock	69.85	70.06	69.53	69.8	1011734.0
2019-03-26	AAXN-DELISTED	Stock	53.47	53.61	52.51	53.36	500985.0
2019-03-26	AB	Stock	27.75	28.24	27.63	28.2	202400.0
2019-03-26	ABB-DELISTED	Stock	18.55	18.685	18.54	18.675	1895021.0
2019-03-26	ABBNY-DELISTED	Stock	18.55	18.685	18.54	18.67	1970723.0
2019-03-26	ABBV	Stock	79.85	81.19	79.8	80.76	4921900.0
2019-03-26	ABC-DELISTED	Stock	77.56	77.93	76.05	76.55	1480220.0
2019-03-26	ABCB	Stock	33.83	34.38	33.43	34.27	433800.0
2019-03-26	ABDC-DELISTED	Stock	7.53	7.75	7.53	7.68	47312.0
2019-03-26	ABEO	Stock	190.25	192.0	184.5	186.75	10020.0
2019-03-26	ABEV	Stock	4.29	4.43	4.2	4.38	54346800.0
2019-03-26	ABG	Stock	68.0	69.4	67.27	68.57	120200.0
2019-03-26	ABIL-DELISTED	Stock	1.91	1.921	1.7	1.7902	309972.0
2019-03-26	ABM	Stock	34.72	35.07	34.52	34.87	361700.0
2019-03-26	ABMD-DELISTED	Stock	314.88	316.0143	284.625	286.0	1577850.0
2019-03-26	ABR	Stock	12.95	13.0	12.93	12.97	420100.0
2019-03-26	ABR.A-DELISTED	Stock	25.6481	25.6513	25.6481	25.6513	375.0
2019-03-26	ABR.B-DELISTED	Stock	25.55	25.55	25.55	25.55	450.0
2019-03-26	ABR.C-DELISTED	Stock	26.0	26.0832	25.99	25.9901	4500.0
2019-03-26	ABT	Stock	78.89	79.51	78.68	79.0	3596400.0

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

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