PREVIEW / stock_daily / 2017-01-30

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-30.parquet
  size:    216 KB
  rows:    6,522
  symbols: 3,111

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
2017-01-30	AAPL	Stock	30.2325	30.4075	30.165	30.4075	121510000.0
2017-01-30	MSFT	Stock	65.69	65.79	64.8	65.13	31651400.0
2017-01-30	NVDA	Stock	2.773	2.7753	2.6978	2.7505	496004000.0
2017-01-30	AMZN	Stock	41.65	41.675	40.819	41.519	74946000.0
2017-01-30	GOOGL	Stock	41.853	41.8615	41.0515	41.1915	70338660.0
2017-01-30	META	Stock	131.58	131.58	129.6	130.98	18956100.0
2017-01-30	TSLA	Stock	16.8353	17.0193	16.4733	16.7087	57016500.0
2017-01-30	TLT	Stock	119.44	119.875	119.2	119.27	6569509.0
2017-01-30	ES	Stock	54.4	54.62	54.12	54.43	1240500.0
2017-01-30	CL	Stock	64.29	64.85	63.95	64.53	7992400.0
2017-01-30	A	Stock	48.48	48.55	47.39	47.67	2266500.0
2017-01-30	AA	Stock	36.48	36.59	35.77	36.55	3002400.0
2017-01-30	AAAP-DELISTED	Stock	31.69	31.69	30.95	31.57	63490.0
2017-01-30	AABA-DELISTED	Stock	44.22	44.22	43.705	43.92	6449274.0
2017-01-30	AAC-DELISTED	Stock	8.05	8.15	7.91	7.95	197321.0
2017-01-30	AACG	Stock	3.05	3.09	2.97	2.97	3600.0
2017-01-30	AAIC-DELISTED	Stock	15.12	15.146	14.984	15.09	246898.0
2017-01-30	AAL	Stock	45.62	45.92	43.86	44.9	16786100.0
2017-01-30	AAMC-DELISTED	Stock	18.111	18.6434	17.3166	18.3088	16228.0
2017-01-30	AAME	Stock	3.71	3.75	3.7	3.7	4500.0
2017-01-30	AAMI	Stock	13.92	13.955	13.74	13.89	233100.0
2017-01-30	AAOI	Stock	31.32	31.445	29.54	30.41	491200.0
2017-01-30	AAON	Stock	23.0667	23.1	22.5667	22.6	208500.0
2017-01-30	AAP	Stock	165.35	165.35	162.89	164.63	727000.0
2017-01-30	AAT	Stock	42.53	42.53	41.66	42.26	267700.0
2017-01-30	AAU-DELISTED	Stock	1.04	1.04	1.0	1.005	89900.0
2017-01-30	AAUAF-DELISTED	Stock	1.04	1.04	1.0	1.02	91698.0
2017-01-30	AAV-DELISTED	Stock	6.5	6.5	6.3	6.45	151664.0
2017-01-30	AAWW-DELISTED	Stock	53.9	54.05	52.5	53.4	206274.0
2017-01-30	AAXJ	Stock	58.71	58.83	58.6	58.8	1626454.0
2017-01-30	AAXN-DELISTED	Stock	24.62	24.99	24.33	24.88	523764.0
2017-01-30	AB	Stock	23.15	23.47	23.0	23.3	256700.0
2017-01-30	ABAC-DELISTED	Stock	3.65	3.6536	3.5	3.5	6200.0
2017-01-30	ABAX-DELISTED	Stock	48.98	49.89	47.1	49.87	174782.0
2017-01-30	ABB-DELISTED	Stock	23.63	23.81	23.575	23.8	2349800.0
2017-01-30	ABBNY-DELISTED	Stock	23.63	23.81	23.575	23.8	2626126.0
2017-01-30	ABBV	Stock	59.91	60.47	59.27	60.43	7792700.0
2017-01-30	ABC-DELISTED	Stock	82.55	83.75	80.82	83.63	2308912.0
2017-01-30	ABCB	Stock	44.7	44.95	44.05	44.75	239500.0
2017-01-30	ABCD-DELISTED	Stock	5.13	5.15	5.0201	5.14	54567.0
2017-01-30	ABCO-DELISTED	Stock	45.05	45.15	44.1	45.05	507182.0
2017-01-30	ABDC-DELISTED	Stock	12.13	12.14	11.88	12.1	37608.0
2017-01-30	ABE-DELISTED	Stock	11.62	11.68	11.6	11.6	15503.0
2017-01-30	ABEO	Stock	120.0	120.0	112.5	115.0	8076.0
2017-01-30	ABEV	Stock	5.45	5.47	5.36	5.4	11859000.0
2017-01-30	ABG	Stock	64.45	65.75	63.4	64.9	286300.0
2017-01-30	ABIL-DELISTED	Stock	3.37	3.44	3.26	3.28	15450.0
2017-01-30	ABM	Stock	41.21	41.33	40.51	40.59	661200.0
2017-01-30	ABMD-DELISTED	Stock	108.0	108.01	105.38	106.15	493762.0
2017-01-30	ABR	Stock	7.47	7.48	7.36	7.39	64800.0

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

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