PREVIEW / stock_daily / 2018-10-30

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-30.parquet
  size:    221 KB
  rows:    6,562
  symbols: 2,718

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-10-30	AAPL	Stock	52.7875	53.795	52.3175	53.325	146640000.0
2018-10-30	MSFT	Stock	103.66	104.38	100.11	103.73	65350900.0
2018-10-30	NVDA	Stock	4.6638	5.085	4.6405	5.075	807192000.0
2018-10-30	AMZN	Stock	74.308	77.0495	73.818	76.521	249202000.0
2018-10-30	GOOGL	Stock	51.0005	52.545	50.6985	52.4755	59768360.0
2018-10-30	META	Stock	139.94	146.64	139.74	146.22	50528300.0
2018-10-30	TSLA	Stock	21.8927	22.5267	21.484	21.9933	136900500.0
2018-10-30	TLT	Stock	114.26	114.54	114.02	114.16	9939616.0
2018-10-30	ES	Stock	64.28	64.4	63.15	64.03	1459000.0
2018-10-30	CL	Stock	58.31	60.31	57.94	60.19	8210200.0
2018-10-30	A	Stock	62.35	63.72	61.68	63.64	3076700.0
2018-10-30	AA	Stock	33.65	34.48	33.413	34.15	2193400.0
2018-10-30	AABA-DELISTED	Stock	55.81	57.93	55.76	57.92	6303007.0
2018-10-30	AAC-DELISTED	Stock	6.6	6.6	5.3801	5.45	446423.0
2018-10-30	AACG	Stock	1.12	1.2	1.09	1.1	185600.0
2018-10-30	AAIC-DELISTED	Stock	8.4	8.54	8.25	8.39	394981.0
2018-10-30	AAL	Stock	32.44	34.78	32.33	34.66	13067600.0
2018-10-30	AAM.A-DELISTED	Stock	24.8	24.86	24.6	24.78	22362.0
2018-10-30	AAM.B-DELISTED	Stock	24.689	24.74	24.43	24.64	47608.0
2018-10-30	AAMC-DELISTED	Stock	11.9118	12.4265	11.6941	12.3529	38899.0
2018-10-30	AAME	Stock	2.72	3.1	2.72	3.1	3000.0
2018-10-30	AAMI	Stock	11.46	11.48	11.23	11.38	767000.0
2018-10-30	AAOI	Stock	20.22	20.3	19.07	20.04	1026100.0
2018-10-30	AAON	Stock	21.8733	22.9267	21.5867	22.9	336300.0
2018-10-30	AAP	Stock	165.16	165.62	163.18	164.97	1020000.0
2018-10-30	AAT	Stock	37.85	38.61	37.38	38.2	294900.0
2018-10-30	AAU-DELISTED	Stock	0.57	0.57	0.51	0.5295	175089.0
2018-10-30	AAUAF-DELISTED	Stock	0.57	0.57	0.51	0.5295	176762.0
2018-10-30	AAWW-DELISTED	Stock	49.38	50.59	48.3	48.76	330799.0
2018-10-30	AAXJ	Stock	61.43	62.16	61.28	62.16	766815.0
2018-10-30	AAXN-DELISTED	Stock	55.75	58.08	55.1134	57.91	443548.0
2018-10-30	AB	Stock	28.42	29.34	28.27	28.81	365400.0
2018-10-30	ABAC-DELISTED	Stock	1.68	1.73	1.64	1.685	3900.0
2018-10-30	ABB-DELISTED	Stock	19.46	19.835	19.38	19.825	5112807.0
2018-10-30	ABBNY-DELISTED	Stock	19.46	19.835	19.38	19.81	5609895.0
2018-10-30	ABBV	Stock	81.93	82.88	80.13	81.59	5243100.0
2018-10-30	ABC-DELISTED	Stock	86.34	87.68	85.81	87.56	913467.0
2018-10-30	ABCB	Stock	42.43	42.81	41.29	42.71	212300.0
2018-10-30	ABCD-DELISTED	Stock	14.4	14.45	14.36	14.38	409034.0
2018-10-30	ABDC-DELISTED	Stock	5.93	5.93	5.63	5.63	172624.0
2018-10-30	ABEO	Stock	217.5	227.25	213.0	220.0	26004.0
2018-10-30	ABEOW-DELISTED	Stock	4.4958	4.4958	4.2	4.2	1917.0
2018-10-30	ABEV	Stock	4.17	4.31	4.16	4.29	52930000.0
2018-10-30	ABG	Stock	64.95	65.92	64.06	65.09	654300.0
2018-10-30	ABIL-DELISTED	Stock	2.9	2.9	2.6789	2.75	73580.0
2018-10-30	ABM	Stock	30.35	31.09	30.3	31.06	427300.0
2018-10-30	ABMD-DELISTED	Stock	320.15	333.67	315.34	331.22	430818.0
2018-10-30	ABR	Stock	11.8	12.02	11.76	12.01	862500.0
2018-10-30	ABR.A-DELISTED	Stock	25.5	25.51	25.5	25.51	2235.0
2018-10-30	ABR.B-DELISTED	Stock	25.45	25.45	25.45	25.45	1200.0

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

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