PREVIEW / stock_daily / 2018-02-08

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-08.parquet
  size:    216 KB
  rows:    6,474
  symbols: 2,850

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-02-08	AAPL	Stock	40.0725	40.25	38.7575	38.7875	217562000.0
2018-02-08	MSFT	Stock	89.71	89.88	84.76	85.01	55628700.0
2018-02-08	NVDA	Stock	5.847	5.8805	5.4378	5.438	1144000000.0
2018-02-08	AMZN	Stock	71.484	71.6875	67.497	67.525	171572000.0
2018-02-08	GOOGL	Stock	52.9935	53.1965	50.235	50.3855	66792020.0
2018-02-08	META	Stock	181.01	181.84	171.48	171.58	38478300.0
2018-02-08	TSLA	Stock	22.8873	23.2413	20.9733	21.0153	154719000.0
2018-02-08	TLT	Stock	118.01	119.18	117.85	118.69	15155094.0
2018-02-08	ES	Stock	56.81	57.15	56.1	56.11	2502600.0
2018-02-08	CL	Stock	70.17	70.29	68.94	68.95	4875200.0
2018-02-08	A	Stock	68.09	68.16	65.03	65.05	4163400.0
2018-02-08	AA	Stock	47.81	48.24	45.53	45.98	3896900.0
2018-02-08	AAAP-DELISTED	Stock	81.68	81.68	81.475	81.515	7560.0
2018-02-08	AABA-DELISTED	Stock	72.55	72.78	69.1	69.22	5115767.0
2018-02-08	AAC-DELISTED	Stock	8.13	8.23	7.94	7.97	111506.0
2018-02-08	AACG	Stock	6.0	6.07	5.8	6.0	36100.0
2018-02-08	AAIC-DELISTED	Stock	10.74	11.0	10.6522	10.8	977634.0
2018-02-08	AAL	Stock	51.44	51.46	48.51	48.6	5995100.0
2018-02-08	AAM.A-DELISTED	Stock	25.58	25.69	25.35	25.52	69995.0
2018-02-08	AAMC-DELISTED	Stock	20.4853	20.4853	20.4853	20.4853	2730.0
2018-02-08	AAME	Stock	3.3	3.3	3.1	3.1	7100.0
2018-02-08	AAMI	Stock	16.5	16.567	15.69	15.69	1570800.0
2018-02-08	AAOI	Stock	31.3	32.58	31.3	32.05	1453600.0
2018-02-08	AAON	Stock	22.4667	22.6333	22.0	22.0333	221700.0
2018-02-08	AAP	Stock	109.93	115.35	109.3	109.63	1549900.0
2018-02-08	AAT	Stock	32.82	32.96	32.03	32.04	331600.0
2018-02-08	AAU-DELISTED	Stock	0.9	0.9	0.875	0.88	221134.0
2018-02-08	AAUAF-DELISTED	Stock	0.9	0.9	0.875	0.88	229853.0
2018-02-08	AAV-DELISTED	Stock	3.2	3.25	2.95	2.95	413663.0
2018-02-08	AAWW-DELISTED	Stock	53.65	53.65	51.7	51.7	180713.0
2018-02-08	AAXJ	Stock	76.15	76.27	73.32	73.32	3224200.0
2018-02-08	AAXN-DELISTED	Stock	25.89	25.97	25.32	25.32	617299.0
2018-02-08	AB	Stock	25.75	25.85	24.6	24.6	381000.0
2018-02-08	ABAC-DELISTED	Stock	2.6	2.69	2.6	2.6854	700.0
2018-02-08	ABAX-DELISTED	Stock	65.18	65.22	62.83	62.84	165880.0
2018-02-08	ABB-DELISTED	Stock	25.04	25.13	24.275	24.29	4685410.0
2018-02-08	ABBNY-DELISTED	Stock	25.04	25.13	24.275	24.29	5345250.0
2018-02-08	ABBV	Stock	113.33	114.0	108.32	108.48	7212400.0
2018-02-08	ABC-DELISTED	Stock	94.56	95.56	91.46	91.58	1387488.0
2018-02-08	ABCB	Stock	52.6	52.6	51.25	51.6	292200.0
2018-02-08	ABCD-DELISTED	Stock	6.98	7.14	6.87	6.9	82155.0
2018-02-08	ABDC-DELISTED	Stock	7.74	7.84	7.45	7.47	36907.0
2018-02-08	ABE-DELISTED	Stock	14.82	14.84	14.51	14.51	9081.0
2018-02-08	ABEO	Stock	457.5	472.5	367.25	388.75	122272.0
2018-02-08	ABEOW-DELISTED	Stock	12.39	12.39	10.49	10.5	10800.0
2018-02-08	ABEV	Stock	6.62	6.64	6.45	6.46	26400500.0
2018-02-08	ABG	Stock	69.1	71.05	67.7	67.75	351800.0
2018-02-08	ABIL-DELISTED	Stock	0.3995	0.3995	0.37	0.3949	67382.0
2018-02-08	ABLX-DELISTED	Stock	53.42	53.47	52.85	52.99	391758.0
2018-02-08	ABM	Stock	35.1	35.41	34.5	34.55	394000.0

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

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