PREVIEW / stock_daily / 2018-08-21

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-21.parquet
  size:    219 KB
  rows:    6,523
  symbols: 2,755

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-08-21	AAPL	Stock	54.2	54.2975	53.5075	53.76	104639200.0
2018-08-21	MSFT	Stock	106.92	107.35	105.85	105.98	22881900.0
2018-08-21	NVDA	Stock	6.2125	6.3375	6.1925	6.333	673988000.0
2018-08-21	AMZN	Stock	94.0	94.8875	93.7205	94.171	62112000.0
2018-08-21	GOOGL	Stock	61.151	61.638	60.7515	60.8705	23081860.0
2018-08-21	META	Stock	172.81	174.17	171.39	172.62	19578500.0
2018-08-21	TSLA	Stock	20.7073	21.6527	20.6	21.46	197583000.0
2018-08-21	TLT	Stock	121.37	121.53	121.065	121.38	4695004.0
2018-08-21	ES	Stock	63.08	63.08	62.56	62.81	954600.0
2018-08-21	CL	Stock	67.56	67.69	67.03	67.4	2323800.0
2018-08-21	A	Stock	64.74	65.4	64.62	64.93	2982800.0
2018-08-21	AA	Stock	41.88	43.22	41.88	43.03	3095900.0
2018-08-21	AABA-DELISTED	Stock	69.67	70.69	69.61	70.25	3073143.0
2018-08-21	AAC-DELISTED	Stock	9.75	10.0	9.69	9.72	306885.0
2018-08-21	AACG	Stock	6.35	6.55	6.31	6.39	261600.0
2018-08-21	AAIC-DELISTED	Stock	10.18	10.28	10.18	10.24	361361.0
2018-08-21	AAL	Stock	39.98	40.71	39.84	40.33	6491800.0
2018-08-21	AAM.A-DELISTED	Stock	25.61	25.78	25.61	25.751	14926.0
2018-08-21	AAM.B-DELISTED	Stock	25.25	25.29	25.2	25.29	21970.0
2018-08-21	AAME	Stock	2.68	2.68	2.45	2.55	2200.0
2018-08-21	AAMI	Stock	12.54	12.8	12.53	12.71	463800.0
2018-08-21	AAOI	Stock	40.45	41.14	40.146	40.61	531700.0
2018-08-21	AAON	Stock	28.2333	28.8	28.1333	28.5	389850.0
2018-08-21	AAP	Stock	161.22	161.71	159.35	160.15	1193800.0
2018-08-21	AAT	Stock	39.64	39.73	39.42	39.62	206200.0
2018-08-21	AAU-DELISTED	Stock	0.639	0.639	0.615	0.6233	71442.0
2018-08-21	AAUAF-DELISTED	Stock	0.639	0.639	0.615	0.6233	73975.0
2018-08-21	AAV-DELISTED	Stock	2.95	3.05	2.95	3.0	55277.0
2018-08-21	AAWW-DELISTED	Stock	61.35	62.65	61.35	62.2	154177.0
2018-08-21	AAXJ	Stock	70.78	71.25	70.77	71.08	544883.0
2018-08-21	AAXN-DELISTED	Stock	64.15	64.77	63.72	63.8	414249.0
2018-08-21	AB	Stock	30.1	30.25	29.95	30.0	252200.0
2018-08-21	ABAC-DELISTED	Stock	1.9	1.9399	1.7952	1.7952	15243.0
2018-08-21	ABB-DELISTED	Stock	23.02	23.05	22.925	22.98	1064114.0
2018-08-21	ABBNY-DELISTED	Stock	23.02	23.05	22.925	22.98	1171192.0
2018-08-21	ABBV	Stock	97.86	98.05	96.8	97.74	3528400.0
2018-08-21	ABC-DELISTED	Stock	88.35	88.831	87.93	88.0	521370.0
2018-08-21	ABCB	Stock	49.65	50.35	49.65	50.05	276900.0
2018-08-21	ABCD-DELISTED	Stock	13.38	13.98	13.38	13.62	291218.0
2018-08-21	ABDC-DELISTED	Stock	6.33	6.35	6.2601	6.27	19184.0
2018-08-21	ABEO	Stock	343.75	357.5	343.75	355.0	16836.0
2018-08-21	ABEV	Stock	4.85	4.85	4.71	4.72	28189900.0
2018-08-21	ABG	Stock	76.25	77.75	76.25	77.4	155000.0
2018-08-21	ABIL-DELISTED	Stock	4.49	4.52	4.26	4.34	185950.0
2018-08-21	ABM	Stock	32.56	33.44	32.39	32.95	574300.0
2018-08-21	ABMD-DELISTED	Stock	364.07	369.99	361.9568	364.1	263519.0
2018-08-21	ABR	Stock	11.69	11.79	11.64	11.74	1064900.0
2018-08-21	ABR.A-DELISTED	Stock	25.91	25.9418	25.869	25.9416	1660.0
2018-08-21	ABR.B-DELISTED	Stock	25.5	25.5	25.46	25.46	868.0
2018-08-21	ABR.C-DELISTED	Stock	26.1	26.22	26.1	26.14	2502.0

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

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