PREVIEW / stock_daily / 2018-04-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-26.parquet
  size:    217 KB
  rows:    6,498
  symbols: 2,846

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-26	AAPL	Stock	41.03	41.4325	40.8425	41.055	111852000.0
2018-04-26	MSFT	Stock	93.55	95.15	93.1	94.26	42529000.0
2018-04-26	NVDA	Stock	5.58	5.6388	5.5132	5.6305	375824000.0
2018-04-26	AMZN	Stock	74.2505	76.471	73.925	75.898	176022000.0
2018-04-26	GOOGL	Stock	51.661	52.601	51.0225	52.1655	50926640.0
2018-04-26	META	Stock	173.22	176.27	170.8	174.16	77556900.0
2018-04-26	TSLA	Stock	18.5833	19.0527	18.4333	19.032	65340000.0
2018-04-26	TLT	Stock	117.73	118.13	117.59	117.98	6528572.0
2018-04-26	ES	Stock	59.41	60.17	59.03	60.02	1640400.0
2018-04-26	CL	Stock	66.39	66.88	66.24	66.59	4860500.0
2018-04-26	A	Stock	66.22	66.76	65.9	66.37	1978600.0
2018-04-26	AA	Stock	54.25	55.08	52.401	52.94	5842600.0
2018-04-26	AABA-DELISTED	Stock	68.9	69.8843	68.8301	69.82	3048640.0
2018-04-26	AAC-DELISTED	Stock	10.98	11.0	10.5037	10.57	72392.0
2018-04-26	AACG	Stock	5.15	5.16	5.15	5.16	500.0
2018-04-26	AAIC-DELISTED	Stock	11.15	11.39	11.13	11.34	611158.0
2018-04-26	AAL	Stock	43.49	43.8	40.65	42.37	20517300.0
2018-04-26	AAM.A-DELISTED	Stock	24.3	24.3	24.1551	24.25	22834.0
2018-04-26	AAM.B-DELISTED	Stock	24.33	24.33	24.1201	24.18	62850.0
2018-04-26	AAMC-DELISTED	Stock	17.9118	19.1176	17.9118	19.1176	5409.0
2018-04-26	AAME	Stock	3.3	3.3	3.21	3.25	5100.0
2018-04-26	AAMI	Stock	14.91	15.28	14.725	15.21	389100.0
2018-04-26	AAOI	Stock	32.63	33.89	32.19	33.84	801300.0
2018-04-26	AAON	Stock	23.9	24.0	23.4333	23.8	211500.0
2018-04-26	AAP	Stock	112.02	115.12	110.08	113.18	1672500.0
2018-04-26	AAT	Stock	32.82	33.4	32.72	33.17	154400.0
2018-04-26	AAU-DELISTED	Stock	0.82	0.82	0.81	0.811	56908.0
2018-04-26	AAUAF-DELISTED	Stock	0.82	0.82	0.81	0.811	59962.0
2018-04-26	AAV-DELISTED	Stock	3.3	3.3301	3.21	3.3	111922.0
2018-04-26	AAWW-DELISTED	Stock	63.95	63.95	61.85	63.05	91612.0
2018-04-26	AAXJ	Stock	75.38	76.05	75.38	76.02	425203.0
2018-04-26	AAXN-DELISTED	Stock	44.3	44.749	42.6	42.73	813867.0
2018-04-26	AB	Stock	26.25	26.45	25.95	26.25	428900.0
2018-04-26	ABAC-DELISTED	Stock	2.27	2.2721	2.27	2.2721	400.0
2018-04-26	ABAX-DELISTED	Stock	71.05	73.395	70.37	73.13	130168.0
2018-04-26	ABB-DELISTED	Stock	23.53	23.54	23.32	23.395	1774530.0
2018-04-26	ABBNY-DELISTED	Stock	23.53	23.54	23.32	23.39	1983314.0
2018-04-26	ABBV	Stock	94.0	98.55	93.58	97.44	12594400.0
2018-04-26	ABC-DELISTED	Stock	91.85	92.82	91.12	92.08	946055.0
2018-04-26	ABCB	Stock	52.7	52.85	52.2	52.45	132000.0
2018-04-26	ABCD-DELISTED	Stock	10.45	10.61	10.02	10.08	246888.0
2018-04-26	ABDC-DELISTED	Stock	6.03	6.209	6.02	6.15	51159.0
2018-04-26	ABE-DELISTED	Stock	14.7	14.7	14.66	14.66	4001.0
2018-04-26	ABEO	Stock	430.0	442.5	408.75	441.25	36848.0
2018-04-26	ABEOW-DELISTED	Stock	11.8003	12.5	11.8003	12.5	235.0
2018-04-26	ABEV	Stock	6.6	6.7	6.6	6.66	13219400.0
2018-04-26	ABG	Stock	75.0	75.0	68.1	69.2	177400.0
2018-04-26	ABIL-DELISTED	Stock	2.9	2.9	2.555	2.66	41966.0
2018-04-26	ABLX-DELISTED	Stock	54.56	54.62	53.4811	54.09	11942.0
2018-04-26	ABM	Stock	32.11	32.13	31.71	31.84	443800.0

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

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