PREVIEW / stock_daily / 2019-02-28

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-28.parquet
  size:    220 KB
  rows:    6,531
  symbols: 2,627

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-02-28	AAPL	Stock	43.58	43.7275	43.23	43.2875	112861600.0
2019-02-28	MSFT	Stock	112.04	112.88	111.73	112.03	29083900.0
2019-02-28	NVDA	Stock	3.875	3.8975	3.834	3.8565	324944000.0
2019-02-28	AMZN	Stock	81.7625	82.5885	81.6915	81.9915	60518000.0
2019-02-28	GOOGL	Stock	55.95	56.6995	55.9205	56.3275	27427100.0
2019-02-28	META	Stock	162.37	163.5	160.86	161.45	11114200.0
2019-02-28	TSLA	Stock	21.2613	21.3333	20.7207	21.3253	157810500.0
2019-02-28	TLT	Stock	120.56	120.62	119.71	120.02	9533457.0
2019-02-28	ES	Stock	69.66	70.11	69.23	69.81	2261400.0
2019-02-28	CL	Stock	66.03	66.19	65.43	65.87	4128700.0
2019-02-28	A	Stock	79.18	79.75	78.89	79.44	1759100.0
2019-02-28	AA	Stock	31.02	31.02	29.33	29.5	3660500.0
2019-02-28	AABA-DELISTED	Stock	74.37	74.95	73.65	74.58	10831008.0
2019-02-28	AAC-DELISTED	Stock	2.81	2.81	2.42	2.55	252861.0
2019-02-28	AACG	Stock	1.14	1.14	1.11	1.14	32200.0
2019-02-28	AAIC-DELISTED	Stock	8.36	8.38	8.28	8.29	625097.0
2019-02-28	AAL	Stock	35.63	35.89	35.17	35.63	7873800.0
2019-02-28	AAM.A-DELISTED	Stock	24.72	24.88	24.64	24.88	30952.0
2019-02-28	AAM.B-DELISTED	Stock	24.33	24.42	24.3011	24.4	41345.0
2019-02-28	AAMC-DELISTED	Stock	10.6324	11.0882	10.6324	11.0735	3424.0
2019-02-28	AAME	Stock	2.89	2.89	2.89	2.89	2200.0
2019-02-28	AAMI	Stock	14.42	14.57	14.14	14.15	597800.0
2019-02-28	AAOI	Stock	14.89	14.95	13.49	13.5	5094000.0
2019-02-28	AAON	Stock	27.3333	28.0	26.3333	26.5733	275400.0
2019-02-28	AAP	Stock	156.72	163.77	156.72	161.78	1717600.0
2019-02-28	AAT	Stock	43.22	43.95	43.09	43.44	227300.0
2019-02-28	AAU-DELISTED	Stock	0.6701	0.6701	0.6301	0.6399	240445.0
2019-02-28	AAUAF-DELISTED	Stock	0.6701	0.6701	0.6301	0.6481	250315.0
2019-02-28	AAWW-DELISTED	Stock	54.53	54.55	53.7	53.7	165931.0
2019-02-28	AAXJ	Stock	69.51	69.51	69.09	69.25	3756142.0
2019-02-28	AAXN-DELISTED	Stock	55.13	55.75	53.55	53.83	625540.0
2019-02-28	AB	Stock	28.9	29.19	28.9	29.13	160300.0
2019-02-28	ABB-DELISTED	Stock	19.84	19.95	19.69	19.72	4230660.0
2019-02-28	ABBNY-DELISTED	Stock	19.84	19.95	19.69	19.71	5143303.0
2019-02-28	ABBV	Stock	79.46	79.71	78.75	79.24	6310800.0
2019-02-28	ABC-DELISTED	Stock	82.86	83.96	82.565	83.24	1446313.0
2019-02-28	ABCB	Stock	40.79	41.18	40.68	40.77	250400.0
2019-02-28	ABDC-DELISTED	Stock	7.1229	7.2	6.98	7.1	34455.0
2019-02-28	ABEO	Stock	177.25	178.75	172.0	175.5	8848.0
2019-02-28	ABEV	Stock	4.66	4.68	4.52	4.53	55413500.0
2019-02-28	ABG	Stock	71.5	72.67	70.24	71.79	105900.0
2019-02-28	ABIL-DELISTED	Stock	1.88	1.88	1.8	1.8	97677.0
2019-02-28	ABM	Stock	35.75	35.9	35.53	35.66	695900.0
2019-02-28	ABMD-DELISTED	Stock	336.43	339.75	332.42	334.51	320906.0
2019-02-28	ABR	Stock	12.76	12.95	12.67	12.94	1340200.0
2019-02-28	ABR.A-DELISTED	Stock	25.4	25.4	25.33	25.4	3162.0
2019-02-28	ABR.B-DELISTED	Stock	25.27	25.27	25.27	25.27	480.0
2019-02-28	ABR.C-DELISTED	Stock	25.4428	25.57	25.4428	25.57	3381.0
2019-02-28	ABT	Stock	77.01	78.06	77.01	77.62	6762700.0
2019-02-28	ABTC	Stock	303300.0	303600.0	301890.0	303000.0	0.29333333333333333

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

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