PREVIEW / stock_daily / 2018-09-20

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-20.parquet
  size:    219 KB
  rows:    6,555
  symbols: 2,762

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-09-20	AAPL	Stock	55.06	55.57	54.7875	55.0075	106435200.0
2018-09-20	MSFT	Stock	112.28	113.8	111.93	113.57	23714500.0
2018-09-20	NVDA	Stock	6.6762	6.719	6.6025	6.657	430584000.0
2018-09-20	AMZN	Stock	96.929	97.75	96.6125	97.215	63098000.0
2018-09-20	GOOGL	Stock	59.0335	59.7	58.8125	59.5785	29249100.0
2018-09-20	META	Stock	164.5	166.45	164.47	166.02	18936000.0
2018-09-20	TSLA	Stock	20.2373	20.3987	19.5553	19.8887	110241000.0
2018-09-20	TLT	Stock	116.58	117.3	116.47	117.15	8657325.0
2018-09-20	ES	Stock	61.41	61.8	61.04	61.77	1265500.0
2018-09-20	CL	Stock	68.3	69.05	68.22	68.79	3428700.0
2018-09-20	A	Stock	69.73	71.16	69.7	71.13	2865600.0
2018-09-20	AA	Stock	43.39	43.58	42.38	42.93	4026300.0
2018-09-20	AABA-DELISTED	Stock	68.45	68.84	67.92	68.36	5567567.0
2018-09-20	AAC-DELISTED	Stock	6.78	7.23	6.78	7.18	305244.0
2018-09-20	AACG	Stock	1.25	1.25	0.99	1.12	552500.0
2018-09-20	AAIC-DELISTED	Stock	10.1	10.14	10.05	10.12	333745.0
2018-09-20	AAL	Stock	41.82	42.17	41.19	41.89	6865600.0
2018-09-20	AAM.A-DELISTED	Stock	25.13	25.19	25.08	25.13	13453.0
2018-09-20	AAM.B-DELISTED	Stock	24.7	24.8	24.631	24.7	57669.0
2018-09-20	AAMC-DELISTED	Stock	17.5588	17.9559	17.5588	17.9066	2016.0
2018-09-20	AAME	Stock	2.9	2.93	2.48	2.75	20300.0
2018-09-20	AAMI	Stock	12.88	13.04	12.865	12.91	235600.0
2018-09-20	AAOI	Stock	31.01	32.9	30.43	32.87	1434000.0
2018-09-20	AAON	Stock	26.1667	26.9	26.1667	26.8333	167100.0
2018-09-20	AAP	Stock	170.14	170.75	167.01	169.55	879900.0
2018-09-20	AAT	Stock	37.13	37.64	36.94	37.61	236800.0
2018-09-20	AAU-DELISTED	Stock	0.66	0.66	0.62	0.6274	122533.0
2018-09-20	AAUAF-DELISTED	Stock	0.66	0.66	0.62	0.6274	137048.0
2018-09-20	AAV-DELISTED	Stock	2.55	2.575	2.45	2.45	136633.0
2018-09-20	AAWW-DELISTED	Stock	64.0	65.15	63.95	64.45	325504.0
2018-09-20	AAXJ	Stock	70.8	71.02	70.55	70.95	924843.0
2018-09-20	AAXN-DELISTED	Stock	67.78	68.0382	64.96	65.46	511336.0
2018-09-20	AB	Stock	30.75	31.0	30.6	30.65	156000.0
2018-09-20	ABAC-DELISTED	Stock	2.1	2.24	2.1	2.2	14074.0
2018-09-20	ABB-DELISTED	Stock	24.24	24.34	24.19	24.32	1228935.0
2018-09-20	ABBNY-DELISTED	Stock	24.24	24.34	24.19	24.32	1380557.0
2018-09-20	ABBV	Stock	91.43	93.12	90.62	92.68	5991200.0
2018-09-20	ABC-DELISTED	Stock	89.79	91.45	89.79	91.07	873123.0
2018-09-20	ABCB	Stock	47.5	49.9	47.5	49.15	921500.0
2018-09-20	ABCD-DELISTED	Stock	12.0	12.2	11.92	12.16	59080.0
2018-09-20	ABDC-DELISTED	Stock	6.2	6.29	6.2	6.29	44777.0
2018-09-20	ABEO	Stock	348.75	351.25	338.75	350.0	12972.0
2018-09-20	ABEV	Stock	4.62	4.63	4.57	4.62	22732200.0
2018-09-20	ABG	Stock	72.3	72.65	71.9	72.6	135300.0
2018-09-20	ABIL-DELISTED	Stock	3.71	3.71	3.46	3.68	126415.0
2018-09-20	ABM	Stock	33.88	34.26	33.69	33.88	360000.0
2018-09-20	ABMD-DELISTED	Stock	377.75	382.1	372.19	381.84	326205.0
2018-09-20	ABR	Stock	11.71	11.76	11.46	11.57	1615800.0
2018-09-20	ABR.A-DELISTED	Stock	25.65	25.66	25.62	25.63	1229.0
2018-09-20	ABR.B-DELISTED	Stock	25.5164	25.5164	25.5164	25.5164	333.0

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

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