PREVIEW / stock_daily / 2018-05-03

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-03.parquet
  size:    215 KB
  rows:    6,446
  symbols: 2,793

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
2018-05-03	AAPL	Stock	43.97	44.375	43.61	44.2225	136272800.0
2018-05-03	MSFT	Stock	92.96	94.93	92.45	94.07	31142500.0
2018-05-03	NVDA	Stock	5.69	5.8512	5.6443	5.8248	443144000.0
2018-05-03	AMZN	Stock	78.0005	78.74	77.301	78.604	85038000.0
2018-05-03	GOOGL	Stock	51.2685	51.5345	50.3945	51.315	39281320.0
2018-05-03	META	Stock	175.13	176.12	172.12	174.02	24026100.0
2018-05-03	TSLA	Stock	18.586	19.2027	18.3487	18.9633	260281500.0
2018-05-03	TLT	Stock	118.84	119.31	118.68	118.81	6345335.0
2018-05-03	ES	Stock	59.15	59.53	58.52	58.87	1777400.0
2018-05-03	CL	Stock	63.05	63.75	62.84	63.32	6479800.0
2018-05-03	A	Stock	65.77	66.46	64.86	66.34	2365900.0
2018-05-03	AA	Stock	52.83	53.76	52.634	53.28	4050800.0
2018-05-03	AABA-DELISTED	Stock	70.62	70.65	68.08	70.4	6467317.0
2018-05-03	AAC-DELISTED	Stock	12.38	12.38	10.87	11.7	270052.0
2018-05-03	AACG	Stock	5.4	5.4	5.11	5.11	4500.0
2018-05-03	AAIC-DELISTED	Stock	11.27	11.33	11.0	11.23	1035502.0
2018-05-03	AAL	Stock	42.25	42.49	41.54	42.11	4700500.0
2018-05-03	AAM.A-DELISTED	Stock	24.1044	24.26	24.08	24.25	38623.0
2018-05-03	AAM.B-DELISTED	Stock	24.15	24.24	24.06	24.24	58218.0
2018-05-03	AAMI	Stock	14.79	15.39	14.79	15.04	779800.0
2018-05-03	AAOI	Stock	30.6	32.17	30.47	32.14	1051000.0
2018-05-03	AAON	Stock	21.7333	21.8	20.9733	21.1	553500.0
2018-05-03	AAP	Stock	115.58	116.61	114.54	115.43	711400.0
2018-05-03	AAT	Stock	32.99	34.01	32.99	33.91	462500.0
2018-05-03	AAU-DELISTED	Stock	0.85	0.85	0.8021	0.8021	161654.0
2018-05-03	AAUAF-DELISTED	Stock	0.85	0.85	0.8021	0.8021	163158.0
2018-05-03	AAV-DELISTED	Stock	3.2	3.25	3.0	3.025	300015.0
2018-05-03	AAWW-DELISTED	Stock	63.3	68.0	63.3	67.35	890965.0
2018-05-03	AAXJ	Stock	75.52	75.76	74.58	75.53	496760.0
2018-05-03	AAXN-DELISTED	Stock	41.99	41.99	41.1	41.44	1131113.0
2018-05-03	AB	Stock	27.0	27.1	26.45	26.9	591300.0
2018-05-03	ABAC-DELISTED	Stock	2.422	2.4785	2.4182	2.4182	2200.0
2018-05-03	ABAX-DELISTED	Stock	67.01	67.2198	65.92	66.98	86029.0
2018-05-03	ABB-DELISTED	Stock	23.28	23.4	23.1104	23.32	1073366.0
2018-05-03	ABBNY-DELISTED	Stock	23.28	23.4	23.1104	23.31	1142930.0
2018-05-03	ABBV	Stock	100.2	100.77	98.77	100.28	7699500.0
2018-05-03	ABC-DELISTED	Stock	89.25	89.49	85.27	85.37	2981185.0
2018-05-03	ABCB	Stock	51.95	52.35	51.2	52.05	187300.0
2018-05-03	ABCD-DELISTED	Stock	10.04	10.13	9.64	10.08	175226.0
2018-05-03	ABDC-DELISTED	Stock	6.25	6.28	6.15	6.17	38518.0
2018-05-03	ABEO	Stock	460.0	475.0	447.5	452.5	29004.0
2018-05-03	ABEOW-DELISTED	Stock	13.0	13.0	13.0	13.0	500.0
2018-05-03	ABEV	Stock	6.37	6.42	6.32	6.34	16084100.0
2018-05-03	ABG	Stock	68.7	69.65	68.0	69.5	199500.0
2018-05-03	ABIL-DELISTED	Stock	3.0	3.197	2.75	2.835	45332.0
2018-05-03	ABLX-DELISTED	Stock	53.54	53.77	53.47	53.76	23816.0
2018-05-03	ABM	Stock	30.46	30.61	30.16	30.25	646500.0
2018-05-03	ABMD-DELISTED	Stock	310.0	341.89	307.99	335.5	1362293.0
2018-05-03	ABR	Stock	8.77	8.78	8.7	8.78	535200.0
2018-05-03	ABR.A-DELISTED	Stock	25.6894	25.6894	25.6894	25.6894	1000.0

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

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