PREVIEW / stock_daily / 2018-07-25

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-25.parquet
  size:    218 KB
  rows:    6,495
  symbols: 2,770

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-07-25	AAPL	Stock	48.265	48.7125	48.1075	48.705	66839600.0
2018-07-25	MSFT	Stock	107.96	111.15	107.6	110.83	30702100.0
2018-07-25	NVDA	Stock	6.2273	6.3095	6.1688	6.2968	319112000.0
2018-07-25	AMZN	Stock	91.465	93.192	91.132	93.1805	74764000.0
2018-07-25	GOOGL	Stock	62.631	63.912	62.4525	63.797	51508740.0
2018-07-25	META	Stock	215.72	218.62	214.27	217.5	58954200.0
2018-07-25	TSLA	Stock	19.7827	20.6413	19.6333	20.5827	106131000.0
2018-07-25	TLT	Stock	120.02	120.26	119.26	119.49	7357068.0
2018-07-25	ES	Stock	58.92	59.54	58.73	59.34	2129000.0
2018-07-25	CL	Stock	65.31	66.08	65.26	65.95	3334800.0
2018-07-25	A	Stock	65.14	66.04	64.84	65.96	2925800.0
2018-07-25	AA	Stock	42.1	43.245	41.645	43.11	5502300.0
2018-07-25	AABA-DELISTED	Stock	74.29	77.72	74.29	77.56	5928873.0
2018-07-25	AAC-DELISTED	Stock	9.62	10.05	9.61	10.01	70601.0
2018-07-25	AACG	Stock	4.65	4.65	4.65	4.65	300.0
2018-07-25	AAIC-DELISTED	Stock	10.08	10.37	10.01	10.35	814920.0
2018-07-25	AAL	Stock	37.32	38.34	37.32	38.19	7336300.0
2018-07-25	AAM.A-DELISTED	Stock	25.4518	25.4518	25.32	25.3401	52930.0
2018-07-25	AAM.B-DELISTED	Stock	25.02	25.06	24.981	25.0599	24368.0
2018-07-25	AAMC-DELISTED	Stock	18.6324	18.7794	18.6324	18.7794	2577.0
2018-07-25	AAME	Stock	2.4	2.4	2.4	2.4	1000.0
2018-07-25	AAMI	Stock	14.05	14.18	14.05	14.08	429700.0
2018-07-25	AAOI	Stock	38.26	39.401	37.22	38.3	1115700.0
2018-07-25	AAON	Stock	24.2	24.2333	23.9333	24.1	239550.0
2018-07-25	AAP	Stock	139.4	140.65	138.67	140.47	794700.0
2018-07-25	AAT	Stock	37.34	37.81	37.19	37.45	187100.0
2018-07-25	AAU-DELISTED	Stock	0.7	0.7	0.6833	0.69	113910.0
2018-07-25	AAUAF-DELISTED	Stock	0.7	0.7	0.68	0.68	114920.0
2018-07-25	AAV-DELISTED	Stock	3.5	3.56	3.425	3.525	158335.0
2018-07-25	AAWW-DELISTED	Stock	67.8	68.95	67.15	67.7	363286.0
2018-07-25	AAXJ	Stock	72.76	73.69	72.72	73.69	880687.0
2018-07-25	AAXN-DELISTED	Stock	71.06	72.96	68.3678	72.88	968407.0
2018-07-25	AB	Stock	30.35	30.5	30.0	30.1	464200.0
2018-07-25	ABAC-DELISTED	Stock	2.17	2.23	2.17	2.1701	9600.0
2018-07-25	ABAX-DELISTED	Stock	83.11	83.33	83.1	83.19	50074.0
2018-07-25	ABB-DELISTED	Stock	22.46	22.71	22.27	22.685	2033016.0
2018-07-25	ABBNY-DELISTED	Stock	22.46	22.71	22.27	22.69	2104174.0
2018-07-25	ABBV	Stock	91.08	93.51	91.08	93.12	7494300.0
2018-07-25	ABC-DELISTED	Stock	84.23	85.2	83.75	84.77	1111106.0
2018-07-25	ABCB	Stock	50.95	51.05	49.55	49.9	305400.0
2018-07-25	ABCD-DELISTED	Stock	12.46	12.99	12.39	12.94	188439.0
2018-07-25	ABDC-DELISTED	Stock	6.39	6.39	6.24	6.32	38346.0
2018-07-25	ABEO	Stock	328.75	340.0	315.0	317.5	27092.0
2018-07-25	ABEV	Stock	5.08	5.12	5.0	5.09	29581400.0
2018-07-25	ABG	Stock	69.95	70.45	67.8	68.65	486800.0
2018-07-25	ABIL-DELISTED	Stock	4.49	4.56	4.3801	4.4048	30128.0
2018-07-25	ABM	Stock	29.85	30.38	29.81	30.38	490200.0
2018-07-25	ABMD-DELISTED	Stock	423.8	431.82	422.7	430.16	415595.0
2018-07-25	ABR	Stock	11.07	11.23	11.06	11.17	947600.0
2018-07-25	ABR.A-DELISTED	Stock	25.82	26.05	25.82	26.05	652.0

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

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