PREVIEW / stock_daily / 2018-04-27

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-27.parquet
  size:    215 KB
  rows:    6,467
  symbols: 2,819

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-04-27	AAPL	Stock	41.0	41.0825	40.1575	40.58	142623200.0
2018-04-27	MSFT	Stock	97.6	97.9	93.91	95.82	48272800.0
2018-04-27	NVDA	Stock	5.7375	5.7575	5.6155	5.6583	400848000.0
2018-04-27	AMZN	Stock	81.7005	81.905	78.3695	78.631	261064000.0
2018-04-27	GOOGL	Stock	52.277	52.5848	51.3795	51.5725	40745260.0
2018-04-27	META	Stock	176.81	177.1	172.6	173.59	29804700.0
2018-04-27	TSLA	Stock	19.0247	19.6313	18.922	19.6053	65469000.0
2018-04-27	TLT	Stock	118.47	118.95	118.44	118.89	5402102.0
2018-04-27	ES	Stock	59.93	60.89	59.77	60.62	1288600.0
2018-04-27	CL	Stock	65.89	67.12	64.84	66.58	6539200.0
2018-04-27	A	Stock	66.34	66.56	65.96	66.28	1189200.0
2018-04-27	AA	Stock	52.56	52.99	51.1	51.6	4355300.0
2018-04-27	AABA-DELISTED	Stock	70.89	71.09	69.52	69.75	8880203.0
2018-04-27	AAC-DELISTED	Stock	10.59	11.05	10.38	11.0	94817.0
2018-04-27	AACG	Stock	5.42	5.42	5.08	5.11	8000.0
2018-04-27	AAIC-DELISTED	Stock	11.34	11.53	11.34	11.48	603001.0
2018-04-27	AAL	Stock	42.55	43.48	42.33	43.4	6955200.0
2018-04-27	AAM.A-DELISTED	Stock	24.15	24.29	24.15	24.28	27935.0
2018-04-27	AAM.B-DELISTED	Stock	24.18	24.23	24.14	24.2	82305.0
2018-04-27	AAME	Stock	3.15	3.25	3.05	3.25	3000.0
2018-04-27	AAMI	Stock	15.15	15.18	14.93	15.01	349600.0
2018-04-27	AAOI	Stock	34.23	34.52	32.71	33.76	1182900.0
2018-04-27	AAON	Stock	23.8333	23.8333	23.3533	23.4	174600.0
2018-04-27	AAP	Stock	113.15	116.61	112.65	116.34	1158600.0
2018-04-27	AAT	Stock	33.09	34.22	33.09	34.06	171500.0
2018-04-27	AAU-DELISTED	Stock	0.81	0.82	0.81	0.81	52423.0
2018-04-27	AAUAF-DELISTED	Stock	0.81	0.82	0.81	0.81	68033.0
2018-04-27	AAV-DELISTED	Stock	3.25	3.275	3.2	3.225	77207.0
2018-04-27	AAWW-DELISTED	Stock	63.2	63.55	62.5	63.4	48566.0
2018-04-27	AAXJ	Stock	76.44	76.56	75.99	76.51	407374.0
2018-04-27	AAXN-DELISTED	Stock	42.87	43.24	41.3708	41.61	689150.0
2018-04-27	AB	Stock	26.4	26.95	26.25	26.9	162500.0
2018-04-27	ABAC-DELISTED	Stock	2.26	2.38	2.26	2.32	703.0
2018-04-27	ABAX-DELISTED	Stock	71.73	73.43	64.96	66.28	408627.0
2018-04-27	ABB-DELISTED	Stock	23.25	23.38	23.16	23.295	1254470.0
2018-04-27	ABBNY-DELISTED	Stock	23.25	23.38	23.16	23.28	1427021.0
2018-04-27	ABBV	Stock	97.44	99.35	96.37	98.73	6117600.0
2018-04-27	ABC-DELISTED	Stock	91.93	93.25	91.725	93.06	944231.0
2018-04-27	ABCB	Stock	52.7	53.25	52.3	52.5	147700.0
2018-04-27	ABCD-DELISTED	Stock	10.15	10.29	9.9	9.92	282651.0
2018-04-27	ABDC-DELISTED	Stock	6.1	6.24	6.06	6.15	26031.0
2018-04-27	ABE-DELISTED	Stock	14.45	14.86	14.45	14.695	7915.0
2018-04-27	ABEO	Stock	446.25	458.75	437.5	445.0	24936.0
2018-04-27	ABEOW-DELISTED	Stock	13.1	13.1	12.9	12.9	1632.0
2018-04-27	ABEV	Stock	6.74	6.75	6.66	6.7	13721700.0
2018-04-27	ABG	Stock	69.15	69.5	68.05	68.75	218800.0
2018-04-27	ABIL-DELISTED	Stock	2.73	2.76	2.56	2.64	10320.0
2018-04-27	ABLX-DELISTED	Stock	54.02	54.44	53.96	54.3	19744.0
2018-04-27	ABM	Stock	31.82	32.03	31.26	31.31	526300.0
2018-04-27	ABMD-DELISTED	Stock	304.69	306.3	297.39	301.74	346267.0

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

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