PREVIEW / stock_daily / 2018-12-31

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-31.parquet
  size:    221 KB
  rows:    6,619
  symbols: 2,723

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-12-31	AAPL	Stock	39.6325	39.84	39.12	39.435	140014000.0
2018-12-31	MSFT	Stock	101.29	102.4	100.44	101.57	33173800.0
2018-12-31	NVDA	Stock	3.385	3.4178	3.3065	3.3375	465140000.0
2018-12-31	AMZN	Stock	75.54	76.038	74.35	75.0985	139090000.0
2018-12-31	GOOGL	Stock	52.8915	53.1495	51.6519	52.248	33110080.0
2018-12-31	META	Stock	134.45	134.64	129.95	131.09	24625300.0
2018-12-31	TSLA	Stock	22.5193	22.614	21.684	22.1867	94534500.0
2018-12-31	TLT	Stock	120.65	121.56	120.46	121.51	17408971.0
2018-12-31	ES	Stock	64.65	65.05	63.99	65.04	1492100.0
2018-12-31	CL	Stock	59.34	59.87	58.9	59.52	4271300.0
2018-12-31	A	Stock	66.34	67.48	66.34	67.46	1572100.0
2018-12-31	AA	Stock	26.75	27.07	25.95	26.58	2402600.0
2018-12-31	AABA-DELISTED	Stock	59.21	59.21	57.47	57.94	4251909.0
2018-12-31	AAC-DELISTED	Stock	1.45	1.51	1.39	1.39	512396.0
2018-12-31	AACG	Stock	0.95	0.98	0.9	0.92	92700.0
2018-12-31	AAIC-DELISTED	Stock	7.52	7.5227	7.12	7.24	643609.0
2018-12-31	AAL	Stock	32.09	32.62	31.68	32.11	5334700.0
2018-12-31	AAM.A-DELISTED	Stock	22.15	22.7899	22.0201	22.5	52999.0
2018-12-31	AAM.B-DELISTED	Stock	22.49	22.49	21.85	22.18	57112.0
2018-12-31	AAMC-DELISTED	Stock	11.6735	11.6735	8.2353	8.7324	171244.0
2018-12-31	AAME	Stock	2.4	2.42	2.39	2.41	5900.0
2018-12-31	AAMI	Stock	10.57	10.93	10.5	10.68	689700.0
2018-12-31	AAOI	Stock	15.11	15.54	14.41	15.43	774100.0
2018-12-31	AAON	Stock	23.3267	23.3933	22.86	23.3733	232200.0
2018-12-31	AAP	Stock	156.05	157.68	154.99	157.46	752500.0
2018-12-31	AAT	Stock	40.47	40.47	39.51	40.17	217300.0
2018-12-31	AAU-DELISTED	Stock	0.63	0.67	0.63	0.67	249349.0
2018-12-31	AAUAF-DELISTED	Stock	0.63	0.67	0.63	0.67	272432.0
2018-12-31	AAWW-DELISTED	Stock	41.82	42.42	40.8801	42.2	211914.0
2018-12-31	AAXJ	Stock	64.21	64.21	63.3276	63.53	1324439.0
2018-12-31	AAXN-DELISTED	Stock	43.58	44.26	43.13	43.75	591998.0
2018-12-31	AB	Stock	26.82	27.62	26.82	27.32	583800.0
2018-12-31	ABAC-DELISTED	Stock	0.8601	0.93	0.8601	0.87	6078.0
2018-12-31	ABB-DELISTED	Stock	18.98	19.05	18.79	19.01	2043511.0
2018-12-31	ABBNY-DELISTED	Stock	18.99	19.05	18.79	19.01	2109981.0
2018-12-31	ABBV	Stock	91.6	92.99	91.23	92.19	5722100.0
2018-12-31	ABC-DELISTED	Stock	74.09	75.08	73.365	74.4	878965.0
2018-12-31	ABCB	Stock	31.58	31.75	30.94	31.67	389900.0
2018-12-31	ABDC-DELISTED	Stock	6.37	6.55	6.36	6.48	67588.0
2018-12-31	ABEO	Stock	177.25	180.75	173.75	178.5	21108.0
2018-12-31	ABEOW-DELISTED	Stock	3.0571	3.1	2.68	3.1	2000.0
2018-12-31	ABEV	Stock	3.87	3.93	3.83	3.92	10870200.0
2018-12-31	ABG	Stock	65.97	66.76	65.07	66.66	111100.0
2018-12-31	ABIL-DELISTED	Stock	1.97	1.9969	1.82	1.87	656449.0
2018-12-31	ABM	Stock	31.34	32.14	31.25	32.11	978400.0
2018-12-31	ABMD-DELISTED	Stock	320.3	329.91	320.3	325.19	354795.0
2018-12-31	ABR	Stock	10.28	10.3	9.98	10.07	1529600.0
2018-12-31	ABR.A-DELISTED	Stock	25.2445	25.2445	25.2	25.2	895.0
2018-12-31	ABR.B-DELISTED	Stock	24.75	25.3465	24.6096	25.3	1998.0
2018-12-31	ABR.C-DELISTED	Stock	26.22	26.22	25.97	26.15	1695.0

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

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