PREVIEW / stock_daily / 2018-11-23

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-23.parquet
  size:    212 KB
  rows:    6,388
  symbols: 2,594

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-11-23	AAPL	Stock	43.735	44.15	43.025	43.0725	94496000.0
2018-11-23	MSFT	Stock	102.17	103.81	102.0	103.07	13823100.0
2018-11-23	NVDA	Stock	3.5828	3.7398	3.5698	3.625	411968000.0
2018-11-23	AMZN	Stock	75.85	76.81	75.0905	75.103	54152000.0
2018-11-23	GOOGL	Stock	51.675	52.15	51.426	51.505	14177180.0
2018-11-23	META	Stock	133.65	134.5	131.26	131.73	11886100.0
2018-11-23	TSLA	Stock	22.29	22.5	21.7033	21.722	63039000.0
2018-11-23	TLT	Stock	115.67	115.76	115.09	115.14	3027861.0
2018-11-23	ES	Stock	66.57	66.94	66.1	66.82	1142800.0
2018-11-23	CL	Stock	61.85	62.22	61.54	61.78	1367700.0
2018-11-23	A	Stock	67.04	68.61	67.04	68.21	1374300.0
2018-11-23	AA	Stock	32.05	32.58	31.63	32.31	1346600.0
2018-11-23	AABA-DELISTED	Stock	61.31	62.77	61.31	62.39	1844438.0
2018-11-23	AAC-DELISTED	Stock	2.0	2.24	1.98	2.0	420080.0
2018-11-23	AACG	Stock	0.98	1.03	0.98	1.03	11900.0
2018-11-23	AAIC-DELISTED	Stock	8.36	8.4201	8.255	8.29	133538.0
2018-11-23	AAL	Stock	36.66	38.27	36.66	37.95	6121300.0
2018-11-23	AAM.A-DELISTED	Stock	24.057	24.1904	23.97	23.97	10431.0
2018-11-23	AAM.B-DELISTED	Stock	23.97	24.0698	23.97	24.05	4154.0
2018-11-23	AAMC-DELISTED	Stock	13.5294	13.7947	13.3824	13.3824	7657.0
2018-11-23	AAME	Stock	2.85	3.03	2.85	2.94	1700.0
2018-11-23	AAMI	Stock	12.65	13.1	12.65	12.96	120100.0
2018-11-23	AAOI	Stock	20.14	20.98	20.12	20.33	250900.0
2018-11-23	AAON	Stock	24.2733	25.2333	24.0467	24.9867	115950.0
2018-11-23	AAP	Stock	173.7	178.53	173.66	177.24	325700.0
2018-11-23	AAT	Stock	39.39	39.74	39.22	39.42	47100.0
2018-11-23	AAU-DELISTED	Stock	0.5	0.53	0.5	0.52	25640.0
2018-11-23	AAUAF-DELISTED	Stock	0.5	0.53	0.5	0.52	26562.0
2018-11-23	AAWW-DELISTED	Stock	49.9	52.17	49.0155	50.66	91231.0
2018-11-23	AAXJ	Stock	64.45	64.85	64.31	64.45	405743.0
2018-11-23	AAXN-DELISTED	Stock	46.2	47.5	46.2	46.59	198772.0
2018-11-23	AB	Stock	29.8	30.32	29.7	29.99	134900.0
2018-11-23	ABAC-DELISTED	Stock	1.48	1.501	1.48	1.501	921.0
2018-11-23	ABB-DELISTED	Stock	19.79	19.895	19.79	19.82	958339.0
2018-11-23	ABBNY-DELISTED	Stock	19.79	19.895	19.79	19.82	988845.0
2018-11-23	ABBV	Stock	85.6	86.55	84.9	85.63	1612800.0
2018-11-23	ABC-DELISTED	Stock	87.18	88.0	86.46	87.66	290265.0
2018-11-23	ABCB	Stock	42.19	42.96	42.19	42.49	63300.0
2018-11-23	ABCD-DELISTED	Stock	14.45	14.48	14.44	14.45	121855.0
2018-11-23	ABDC-DELISTED	Stock	6.38	6.5	6.34	6.455	9112.0
2018-11-23	ABEO	Stock	197.5	211.25	197.0	202.0	17920.0
2018-11-23	ABEV	Stock	4.26	4.26	4.17	4.17	12053300.0
2018-11-23	ABG	Stock	68.0	70.65	68.0	69.9	48400.0
2018-11-23	ABIL-DELISTED	Stock	3.42	3.5	2.95	3.02	2496674.0
2018-11-23	ABM	Stock	30.12	30.7	30.12	30.23	131300.0
2018-11-23	ABMD-DELISTED	Stock	299.88	305.7	298.2498	299.58	148731.0
2018-11-23	ABR	Stock	11.89	12.02	11.86	11.98	330700.0
2018-11-23	ABR.B-DELISTED	Stock	24.5663	25.11	24.5663	25.11	1967.0
2018-11-23	ABR.C-DELISTED	Stock	25.23	25.2894	25.23	25.23	700.0
2018-11-23	ABT	Stock	67.94	68.68	67.83	68.11	3262200.0

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

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