PREVIEW / stock_daily / 2018-08-17

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-17.parquet
  size:    219 KB
  rows:    6,496
  symbols: 2,749

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-17	AAPL	Stock	53.36	54.4875	53.29	54.395	141708000.0
2018-08-17	MSFT	Stock	107.36	107.9	106.69	107.58	18061500.0
2018-08-17	NVDA	Stock	6.3235	6.3242	6.0932	6.1205	1143188000.0
2018-08-17	AMZN	Stock	94.29	94.4	92.7775	94.111	82086000.0
2018-08-17	GOOGL	Stock	61.102	61.3477	60.2	60.7925	33092580.0
2018-08-17	META	Stock	174.5	176.22	172.04	173.8	24893200.0
2018-08-17	TSLA	Stock	21.5667	21.7847	20.2353	20.3667	284379000.0
2018-08-17	TLT	Stock	121.09	121.3858	120.75	120.98	3537626.0
2018-08-17	ES	Stock	62.89	63.47	62.77	63.24	1020600.0
2018-08-17	CL	Stock	66.72	67.59	66.43	67.5	3523500.0
2018-08-17	A	Stock	65.48	65.48	64.28	64.66	2449200.0
2018-08-17	AA	Stock	41.42	42.24	41.09	42.03	2264900.0
2018-08-17	AABA-DELISTED	Stock	67.87	68.94	67.04	68.18	12079366.0
2018-08-17	AAC-DELISTED	Stock	10.12	10.27	9.84	9.86	208653.0
2018-08-17	AACG	Stock	6.26	6.6	6.26	6.48	463100.0
2018-08-17	AAIC-DELISTED	Stock	10.12	10.25	10.12	10.2	250787.0
2018-08-17	AAL	Stock	37.99	38.21	37.72	37.79	6364900.0
2018-08-17	AAM.A-DELISTED	Stock	25.5607	25.59	25.5022	25.59	8945.0
2018-08-17	AAM.B-DELISTED	Stock	25.26	25.27	25.16	25.2457	36051.0
2018-08-17	AAMC-DELISTED	Stock	19.4412	19.4412	18.8676	18.8676	1839.0
2018-08-17	AAMI	Stock	12.58	12.75	12.43	12.54	541700.0
2018-08-17	AAOI	Stock	39.91	40.33	39.18	40.16	700500.0
2018-08-17	AAON	Stock	26.7333	27.5667	26.7333	27.4667	177150.0
2018-08-17	AAP	Stock	159.65	160.16	159.01	159.72	965900.0
2018-08-17	AAT	Stock	39.02	39.41	39.02	39.4	177400.0
2018-08-17	AAU-DELISTED	Stock	0.591	0.639	0.591	0.639	168335.0
2018-08-17	AAUAF-DELISTED	Stock	0.591	0.639	0.591	0.6253	176128.0
2018-08-17	AAV-DELISTED	Stock	2.95	3.025	2.9	3.0	58614.0
2018-08-17	AAWW-DELISTED	Stock	59.8	60.3	58.85	60.25	140038.0
2018-08-17	AAXJ	Stock	68.89	69.97	68.7	69.82	530963.0
2018-08-17	AAXN-DELISTED	Stock	62.69	64.18	62.1001	64.15	502482.0
2018-08-17	AB	Stock	29.8	30.05	29.75	29.75	155700.0
2018-08-17	ABAC-DELISTED	Stock	1.89	1.9234	1.7532	1.9116	1750.0
2018-08-17	ABB-DELISTED	Stock	22.32	22.61	22.31	22.54	1097890.0
2018-08-17	ABBNY-DELISTED	Stock	22.32	22.61	22.31	22.54	1361625.0
2018-08-17	ABBV	Stock	98.22	99.15	96.42	98.81	6307300.0
2018-08-17	ABC-DELISTED	Stock	86.38	88.47	86.38	87.72	1095260.0
2018-08-17	ABCB	Stock	49.2	49.6	49.1	49.6	156700.0
2018-08-17	ABCD-DELISTED	Stock	13.13	13.25	12.6497	13.08	204948.0
2018-08-17	ABDC-DELISTED	Stock	6.27	6.37	6.27	6.37	14631.0
2018-08-17	ABEO	Stock	346.25	356.25	325.0	331.25	16060.0
2018-08-17	ABEOW-DELISTED	Stock	8.4	8.4	8.4	8.4	300.0
2018-08-17	ABEV	Stock	4.8	4.93	4.72	4.91	51732700.0
2018-08-17	ABG	Stock	74.45	74.8	74.15	74.75	121300.0
2018-08-17	ABIL-DELISTED	Stock	4.66	4.75	4.501	4.705	190090.0
2018-08-17	ABM	Stock	31.5	31.86	31.37	31.85	159900.0
2018-08-17	ABMD-DELISTED	Stock	369.16	370.23	354.52	358.87	300834.0
2018-08-17	ABR	Stock	11.55	11.64	11.48	11.62	1025400.0
2018-08-17	ABR.A-DELISTED	Stock	25.6	25.65	25.59	25.65	927.0
2018-08-17	ABR.B-DELISTED	Stock	25.45	25.4696	25.45	25.4696	3990.0

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

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