PREVIEW / stock_daily / 2018-06-19

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-19.parquet
  size:    219 KB
  rows:    6,513
  symbols: 2,794

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-06-19	AAPL	Stock	46.285	46.5825	45.8625	46.4225	134314000.0
2018-06-19	MSFT	Stock	99.65	101.0	99.5	100.86	28653100.0
2018-06-19	NVDA	Stock	6.523	6.591	6.3755	6.5043	594932000.0
2018-06-19	AMZN	Stock	85.452	86.8055	85.0195	86.739	85802000.0
2018-06-19	GOOGL	Stock	58.5055	59.1405	58.0805	58.9345	47282540.0
2018-06-19	META	Stock	196.24	197.96	193.79	197.49	19994000.0
2018-06-19	TSLA	Stock	24.344	24.6667	23.0833	23.5033	191428500.0
2018-06-19	TLT	Stock	120.97	121.23	120.7	120.97	6133301.0
2018-06-19	ES	Stock	55.23	56.22	54.95	55.76	2132100.0
2018-06-19	CL	Stock	64.01	64.57	63.63	64.0	4580300.0
2018-06-19	A	Stock	64.22	64.45	63.2	63.52	4621400.0
2018-06-19	AA	Stock	44.63	44.63	43.35	44.47	3320100.0
2018-06-19	AABA-DELISTED	Stock	79.78	80.29	78.2	80.14	8116697.0
2018-06-19	AAC-DELISTED	Stock	9.89	10.01	9.69	9.89	97751.0
2018-06-19	AAIC-DELISTED	Stock	10.58	10.74	10.5	10.71	926148.0
2018-06-19	AAL	Stock	42.03	42.21	41.09	41.51	5575300.0
2018-06-19	AAM.A-DELISTED	Stock	25.47	25.47	25.23	25.23	26108.0
2018-06-19	AAM.B-DELISTED	Stock	24.771	24.82	24.71	24.73	44117.0
2018-06-19	AAMC-DELISTED	Stock	21.2795	21.2795	20.0	20.5147	9258.0
2018-06-19	AAME	Stock	2.5	2.55	2.4	2.4	2000.0
2018-06-19	AAMI	Stock	15.6	15.67	15.505	15.65	319500.0
2018-06-19	AAOI	Stock	42.9	43.275	40.63	42.1	1195100.0
2018-06-19	AAON	Stock	22.2667	22.4333	22.1333	22.3333	451350.0
2018-06-19	AAP	Stock	136.9	139.17	136.4	138.3	986100.0
2018-06-19	AAT	Stock	37.53	37.78	36.95	37.0	246700.0
2018-06-19	AAU-DELISTED	Stock	0.73	0.7359	0.73	0.7301	55794.0
2018-06-19	AAUAF-DELISTED	Stock	0.73	0.7359	0.73	0.7301	62696.0
2018-06-19	AAV-DELISTED	Stock	3.1	3.15	3.05	3.1	119627.0
2018-06-19	AAWW-DELISTED	Stock	72.75	74.75	70.75	72.55	228060.0
2018-06-19	AAXJ	Stock	73.15	73.51	72.75	73.46	1636185.0
2018-06-19	AAXN-DELISTED	Stock	65.5	65.66	63.09	65.53	861894.0
2018-06-19	AB	Stock	29.3	29.55	29.15	29.45	214200.0
2018-06-19	ABAC-DELISTED	Stock	2.25	2.28	2.25	2.28	990.0
2018-06-19	ABAX-DELISTED	Stock	83.04	83.15	82.97	83.05	177101.0
2018-06-19	ABB-DELISTED	Stock	22.32	22.51	22.205	22.475	1887447.0
2018-06-19	ABBNY-DELISTED	Stock	22.32	22.51	22.205	22.47	2168877.0
2018-06-19	ABBV	Stock	97.89	98.38	96.93	98.01	5528300.0
2018-06-19	ABC-DELISTED	Stock	90.93	92.18	90.39	92.15	935834.0
2018-06-19	ABCB	Stock	56.25	57.7	56.2	57.35	180200.0
2018-06-19	ABCD-DELISTED	Stock	10.99	10.99	10.71	10.76	56401.0
2018-06-19	ABDC-DELISTED	Stock	6.7	6.81	6.7	6.78	8389.0
2018-06-19	ABEO	Stock	397.5	402.5	387.5	402.5	30504.0
2018-06-19	ABEOW-DELISTED	Stock	10.7	10.7	10.7	10.7	200.0
2018-06-19	ABEV	Stock	4.9	5.08	4.89	5.0	38096700.0
2018-06-19	ABG	Stock	73.43	75.0	73.4	74.95	274600.0
2018-06-19	ABIL-DELISTED	Stock	2.37	2.37	2.17	2.19	72638.0
2018-06-19	ABM	Stock	30.81	30.88	30.38	30.78	646900.0
2018-06-19	ABMD-DELISTED	Stock	438.62	441.68	432.03	439.57	790164.0
2018-06-19	ABR	Stock	10.21	10.24	10.03	10.07	1168100.0
2018-06-19	ABR.A-DELISTED	Stock	25.698	25.99	25.6	25.95	4948.0

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

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