PREVIEW / stock_daily / 2018-10-24

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-24.parquet
  size:    221 KB
  rows:    6,560
  symbols: 2,736

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-24	AAPL	Stock	55.65	56.0575	53.635	53.7725	163702000.0
2018-10-24	MSFT	Stock	108.41	108.49	101.59	102.32	63897800.0
2018-10-24	NVDA	Stock	5.4878	5.5348	4.9713	4.9853	884288000.0
2018-10-24	AMZN	Stock	88.685	88.8855	82.828	83.21	138568000.0
2018-10-24	GOOGL	Stock	55.75	55.831	52.753	52.856	49285900.0
2018-10-24	META	Stock	154.28	154.65	145.6	146.04	27744600.0
2018-10-24	TSLA	Stock	20.07	20.296	19.0487	19.2333	300874500.0
2018-10-24	TLT	Stock	114.36	114.82	114.24	114.78	16008012.0
2018-10-24	ES	Stock	63.58	65.29	63.24	64.87	1483300.0
2018-10-24	CL	Stock	63.38	65.37	63.37	64.64	6235600.0
2018-10-24	A	Stock	62.92	63.76	61.01	61.13	3481200.0
2018-10-24	AA	Stock	37.12	37.35	34.04	34.2	4897200.0
2018-10-24	AABA-DELISTED	Stock	61.08	61.54	58.87	59.06	5302980.0
2018-10-24	AAC-DELISTED	Stock	6.84	6.99	6.82	6.84	144822.0
2018-10-24	AACG	Stock	1.11	1.38	1.06	1.1	836800.0
2018-10-24	AAIC-DELISTED	Stock	8.12	8.65	8.08	8.27	721098.0
2018-10-24	AAL	Stock	32.48	32.75	30.24	30.34	15348200.0
2018-10-24	AAM.A-DELISTED	Stock	24.17	24.37	24.17	24.33	26551.0
2018-10-24	AAM.B-DELISTED	Stock	24.16	24.35	24.0991	24.32	68357.0
2018-10-24	AAMC-DELISTED	Stock	13.9706	14.5721	13.9706	14.5721	2183.0
2018-10-24	AAME	Stock	2.75	2.99	2.68	2.97	3200.0
2018-10-24	AAMI	Stock	11.62	11.74	11.15	11.16	414000.0
2018-10-24	AAOI	Stock	22.28	22.54	20.51	20.55	963700.0
2018-10-24	AAON	Stock	21.5733	21.9	21.5	21.66	311100.0
2018-10-24	AAP	Stock	163.5	167.02	158.85	159.18	1418200.0
2018-10-24	AAT	Stock	36.55	37.0	36.31	36.63	163900.0
2018-10-24	AAU-DELISTED	Stock	0.579	0.579	0.542	0.5548	69157.0
2018-10-24	AAUAF-DELISTED	Stock	0.579	0.579	0.542	0.5548	76854.0
2018-10-24	AAWW-DELISTED	Stock	51.17	51.76	48.54	48.64	311257.0
2018-10-24	AAXJ	Stock	63.5	63.53	61.77	61.77	583411.0
2018-10-24	AAXN-DELISTED	Stock	58.45	59.0	57.37	57.65	617659.0
2018-10-24	AB	Stock	30.0	30.2	28.52	28.57	630400.0
2018-10-24	ABAC-DELISTED	Stock	1.72	1.78	1.7	1.78	5400.0
2018-10-24	ABB-DELISTED	Stock	20.51	20.56	19.85	19.88	2495870.0
2018-10-24	ABBNY-DELISTED	Stock	20.51	20.56	19.85	19.89	2583774.0
2018-10-24	ABBV	Stock	82.84	83.13	79.26	79.41	8689100.0
2018-10-24	ABC-DELISTED	Stock	89.84	90.19	84.33	84.47	2359261.0
2018-10-24	ABCB	Stock	41.86	41.88	39.34	39.39	362100.0
2018-10-24	ABCD-DELISTED	Stock	14.39	14.4	14.38	14.38	232767.0
2018-10-24	ABDC-DELISTED	Stock	5.88	5.99	5.63	5.76	107041.0
2018-10-24	ABEO	Stock	235.75	241.25	215.5	215.75	26868.0
2018-10-24	ABEOW-DELISTED	Stock	4.62	5.85	4.25	4.25	2700.0
2018-10-24	ABEV	Stock	4.46	4.47	4.19	4.21	47466200.0
2018-10-24	ABG	Stock	66.85	68.58	65.74	65.92	1003200.0
2018-10-24	ABIL-DELISTED	Stock	3.28	3.34	3.12	3.14	93011.0
2018-10-24	ABM	Stock	30.72	30.75	29.61	29.74	599900.0
2018-10-24	ABMD-DELISTED	Stock	369.48	376.8	352.0	352.72	280189.0
2018-10-24	ABR	Stock	11.52	11.85	11.48	11.75	1348500.0
2018-10-24	ABR.A-DELISTED	Stock	25.45	25.84	25.45	25.51	9416.0
2018-10-24	ABR.B-DELISTED	Stock	25.2578	25.45	25.2578	25.3775	2700.0

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

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