PREVIEW / stock_daily / 2018-08-22

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-22.parquet
  size:    218 KB
  rows:    6,513
  symbols: 2,750

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-08-22	AAPL	Stock	53.525	54.09	53.46	53.7625	76072400.0
2018-08-22	MSFT	Stock	105.85	107.34	105.78	107.06	18000600.0
2018-08-22	NVDA	Stock	6.3	6.5755	6.2965	6.5705	749856000.0
2018-08-22	AMZN	Stock	93.832	95.29	93.832	95.245	61610000.0
2018-08-22	GOOGL	Stock	60.711	61.3265	60.661	61.0875	22296640.0
2018-08-22	META	Stock	172.21	174.24	172.13	173.64	16894100.0
2018-08-22	TSLA	Stock	21.3913	21.592	20.978	21.4427	89190000.0
2018-08-22	TLT	Stock	122.0	122.0535	121.58	121.86	5309599.0
2018-08-22	ES	Stock	62.92	63.08	62.09	62.36	1195800.0
2018-08-22	CL	Stock	67.4	67.45	66.99	66.99	2099900.0
2018-08-22	A	Stock	64.74	65.87	64.55	65.65	2565600.0
2018-08-22	AA	Stock	43.2	43.79	43.12	43.22	2037900.0
2018-08-22	AABA-DELISTED	Stock	70.29	70.7	69.43	70.29	4014736.0
2018-08-22	AAC-DELISTED	Stock	9.66	9.76	9.64	9.7	169417.0
2018-08-22	AACG	Stock	6.43	6.51	6.36	6.46	147700.0
2018-08-22	AAIC-DELISTED	Stock	10.22	10.275	10.15	10.15	199168.0
2018-08-22	AAL	Stock	40.08	40.19	39.14	39.19	5593100.0
2018-08-22	AAM.A-DELISTED	Stock	25.685	25.83	25.685	25.77	14020.0
2018-08-22	AAM.B-DELISTED	Stock	25.33	25.33	25.26	25.31	33137.0
2018-08-22	AAMC-DELISTED	Stock	19.0147	19.0294	18.9779	19.0294	8473.0
2018-08-22	AAME	Stock	2.65	2.65	2.65	2.65	700.0
2018-08-22	AAMI	Stock	12.6	12.73	12.55	12.72	392600.0
2018-08-22	AAOI	Stock	40.65	41.86	40.15	41.83	764400.0
2018-08-22	AAON	Stock	28.4	28.7	28.2	28.6	219900.0
2018-08-22	AAP	Stock	160.54	161.97	160.3	160.73	804200.0
2018-08-22	AAT	Stock	39.48	39.68	39.3	39.41	347500.0
2018-08-22	AAU-DELISTED	Stock	0.63	0.6332	0.5875	0.6198	226465.0
2018-08-22	AAUAF-DELISTED	Stock	0.63	0.6332	0.5875	0.6198	228980.0
2018-08-22	AAV-DELISTED	Stock	3.0	3.1	3.0	3.025	83657.0
2018-08-22	AAWW-DELISTED	Stock	62.15	62.5601	60.65	60.75	140146.0
2018-08-22	AAXJ	Stock	71.11	71.56	71.11	71.39	415709.0
2018-08-22	AAXN-DELISTED	Stock	63.5	64.97	63.1	64.35	364284.0
2018-08-22	AB	Stock	29.9	30.15	29.8	30.05	179000.0
2018-08-22	ABAC-DELISTED	Stock	1.74	1.8212	1.74	1.7962	7058.0
2018-08-22	ABB-DELISTED	Stock	23.1	23.1	22.96	23.0	839178.0
2018-08-22	ABBNY-DELISTED	Stock	23.08	23.1	22.96	23.01	877870.0
2018-08-22	ABBV	Stock	97.84	98.32	97.13	97.64	2963300.0
2018-08-22	ABC-DELISTED	Stock	87.93	88.38	87.03	88.14	423892.0
2018-08-22	ABCB	Stock	49.9	50.25	49.7	49.9	266300.0
2018-08-22	ABCD-DELISTED	Stock	13.67	13.87	13.22	13.4	118127.0
2018-08-22	ABDC-DELISTED	Stock	6.27	6.34	6.25	6.28	45873.0
2018-08-22	ABEO	Stock	353.75	363.75	348.75	357.5	16060.0
2018-08-22	ABEV	Stock	4.68	4.71	4.61	4.67	37170200.0
2018-08-22	ABG	Stock	77.5	77.75	76.2	76.95	157000.0
2018-08-22	ABIL-DELISTED	Stock	4.4	4.4	4.1948	4.2081	103682.0
2018-08-22	ABM	Stock	32.91	33.2	32.71	32.98	375600.0
2018-08-22	ABMD-DELISTED	Stock	362.11	371.42	362.11	368.32	186805.0
2018-08-22	ABR	Stock	11.72	11.82	11.68	11.82	1407200.0
2018-08-22	ABR.A-DELISTED	Stock	25.98	26.0	25.97	25.99	1100.0
2018-08-22	ABR.B-DELISTED	Stock	25.45	25.45	25.45	25.45	100.0

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

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