PREVIEW / stock_daily / 2016-03-18

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-18.parquet
  size:    220 KB
  rows:    6,595
  symbols: 3,338

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
2016-03-18	AAPL	Stock	26.585	26.625	26.2975	26.48	176820800.0
2016-03-18	MSFT	Stock	54.92	54.97	53.45	53.49	67625500.0
2016-03-18	NVDA	Stock	0.8302	0.8562	0.825	0.8452	545512000.0
2016-03-18	AMZN	Stock	28.047	28.1165	27.3045	27.604	145938000.0
2016-03-18	GOOGL	Stock	38.0815	38.107	37.591	37.7705	56230360.0
2016-03-18	META	Stock	111.56	112.42	110.27	111.45	36256900.0
2016-03-18	TSLA	Stock	15.2733	15.632	15.204	15.516	70677000.0
2016-03-18	TLT	Stock	129.04	129.51	128.7	129.06	8198622.0
2016-03-18	ES	Stock	57.82	58.07	57.18	57.19	3055300.0
2016-03-18	CL	Stock	69.98	70.5	69.66	70.48	7731800.0
2016-03-18	A	Stock	39.33	40.48	39.27	40.19	2504400.0
2016-03-18	AA.B-DELISTED	Stock	33.15	33.5499	32.59	33.19	18032.0
2016-03-18	AAAP-DELISTED	Stock	35.0	39.66	34.35	39.66	31891.0
2016-03-18	AABA-DELISTED	Stock	34.47	35.21	34.384	35.16	19758303.0
2016-03-18	AAC-DELISTED	Stock	18.03	21.69	17.76	19.76	1953162.0
2016-03-18	AACG	Stock	5.5	5.5	5.32	5.32	1100.0
2016-03-18	AAIC-DELISTED	Stock	13.66	13.71	13.36	13.59	470222.0
2016-03-18	AAL	Stock	42.31	43.53	41.75	43.44	13746000.0
2016-03-18	AAMC-DELISTED	Stock	4.1	4.2647	3.9471	4.1912	169735.0
2016-03-18	AAME	Stock	4.18	4.49	4.12	4.38	12600.0
2016-03-18	AAMI	Stock	12.63	12.87	12.46	12.76	137600.0
2016-03-18	AAOI	Stock	17.76	17.93	17.32	17.56	193600.0
2016-03-18	AAON	Stock	17.88	18.3267	17.78	18.1067	571650.0
2016-03-18	AAP	Stock	158.27	158.5	156.66	157.47	854200.0
2016-03-18	AAT	Stock	38.87	38.99	38.3	38.33	274200.0
2016-03-18	AAU-DELISTED	Stock	0.753	0.753	0.72	0.7212	83276.0
2016-03-18	AAUAF-DELISTED	Stock	0.753	0.753	0.72	0.73	85476.0
2016-03-18	AAV-DELISTED	Stock	5.67	5.7	5.43	5.48	97964.0
2016-03-18	AAVL-DELISTED	Stock	5.03	5.25	4.83	5.205	377923.0
2016-03-18	AAWW-DELISTED	Stock	41.87	42.54	41.35	42.2	257527.0
2016-03-18	AAXJ	Stock	54.18	54.52	54.18	54.32	628432.0
2016-03-18	AAXN-DELISTED	Stock	18.98	19.21	18.94	19.08	1307700.0
2016-03-18	AB	Stock	23.27	23.74	23.11	23.37	207200.0
2016-03-18	ABAC-DELISTED	Stock	0.699	0.699	0.5551	0.6536	1030.0
2016-03-18	ABAX-DELISTED	Stock	42.01	42.06	41.66	41.99	253811.0
2016-03-18	ABB-DELISTED	Stock	19.48	19.53	19.38	19.44	2058724.0
2016-03-18	ABBNY-DELISTED	Stock	19.48	19.53	19.38	19.45	2104101.0
2016-03-18	ABBV	Stock	55.59	56.6	54.8	56.57	11029800.0
2016-03-18	ABC-DELISTED	Stock	86.12	87.78	85.41	87.47	3405260.0
2016-03-18	ABCB	Stock	29.3	29.83	29.27	29.43	487000.0
2016-03-18	ABCD-DELISTED	Stock	4.42	4.46	4.27	4.39	52262.0
2016-03-18	ABCO-DELISTED	Stock	29.28	30.82	28.72	30.25	596140.0
2016-03-18	ABCW-DELISTED	Stock	44.3	44.59	44.0	44.27	89343.0
2016-03-18	ABDC-DELISTED	Stock	10.85	10.85	10.69	10.8299	56593.0
2016-03-18	ABE-DELISTED	Stock	11.45	11.5	11.45	11.5	2450.0
2016-03-18	ABEO	Stock	70.5	73.0	69.25	72.5	2184.0
2016-03-18	ABEOW-DELISTED	Stock	0.9	0.9	0.9	0.9	100.0
2016-03-18	ABEV	Stock	5.14	5.15	5.04	5.09	24624200.0
2016-03-18	ABG	Stock	59.41	60.4	59.38	59.85	896600.0
2016-03-18	ABGB-DELISTED	Stock	1.453	1.48	1.33	1.33	37418.0

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

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