PREVIEW / stock_daily / 2017-05-02

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-02.parquet
  size:    215 KB
  rows:    6,465
  symbols: 3,045

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-05-02	AAPL	Stock	36.885	37.0225	36.71	36.8775	181408800.0
2017-05-02	MSFT	Stock	69.71	69.71	69.13	69.3	23906100.0
2017-05-02	NVDA	Stock	2.6388	2.64	2.564	2.587	629972000.0
2017-05-02	AMZN	Stock	47.3325	47.505	47.0705	47.347	76976000.0
2017-05-02	GOOGL	Stock	46.6635	47.1492	46.55	46.8545	35025840.0
2017-05-02	META	Stock	153.34	153.44	151.66	152.78	21870400.0
2017-05-02	TSLA	Stock	21.6	21.844	21.104	21.2593	80742000.0
2017-05-02	TLT	Stock	120.97	121.78	120.94	121.7	6727813.0
2017-05-02	ES	Stock	59.28	59.55	58.82	59.22	1160900.0
2017-05-02	CL	Stock	72.02	72.11	70.75	70.76	4405700.0
2017-05-02	A	Stock	55.85	55.97	55.51	55.93	1693100.0
2017-05-02	AA	Stock	33.31	34.33	33.3	33.33	3912500.0
2017-05-02	AAAP-DELISTED	Stock	37.99	38.39	37.83	38.07	117750.0
2017-05-02	AABA-DELISTED	Stock	48.72	49.3	48.72	49.085	5434462.0
2017-05-02	AAC-DELISTED	Stock	7.16	7.84	7.16	7.82	78872.0
2017-05-02	AACG	Stock	3.74	3.78	3.65	3.7	33200.0
2017-05-02	AAIC-DELISTED	Stock	14.68	14.7	14.375	14.49	416910.0
2017-05-02	AAL	Stock	42.06	43.91	42.05	43.87	9402500.0
2017-05-02	AAM.A-DELISTED	Stock	25.43	25.43	25.33	25.41	69312.0
2017-05-02	AAMC-DELISTED	Stock	22.7206	22.7206	20.7244	21.1029	34864.0
2017-05-02	AAME	Stock	3.65	3.75	3.65	3.7	4800.0
2017-05-02	AAMI	Stock	15.49	15.49	15.14	15.18	294000.0
2017-05-02	AAOI	Stock	49.98	50.3	46.27	47.3	2694000.0
2017-05-02	AAON	Stock	24.9667	25.1333	24.7667	25.0	182550.0
2017-05-02	AAP	Stock	140.44	142.67	139.87	142.55	806400.0
2017-05-02	AAT	Stock	43.19	43.39	42.87	43.0	261300.0
2017-05-02	AAU-DELISTED	Stock	1.41	1.43	1.41	1.43	221423.0
2017-05-02	AAUAF-DELISTED	Stock	1.41	1.44	1.41	1.44	223233.0
2017-05-02	AAV-DELISTED	Stock	6.2	6.25	6.0	6.025	72878.0
2017-05-02	AAWW-DELISTED	Stock	58.1	59.0	57.3	57.85	211992.0
2017-05-02	AAXJ	Stock	64.72	64.94	64.688	64.84	590697.0
2017-05-02	AAXN-DELISTED	Stock	24.66	24.82	24.61	24.78	395931.0
2017-05-02	AB	Stock	22.2	22.21	21.5	21.55	1212800.0
2017-05-02	ABAC-DELISTED	Stock	1.73	1.97	1.7	1.76	133876.0
2017-05-02	ABAX-DELISTED	Stock	45.74	48.94	44.601	46.69	156638.0
2017-05-02	ABB-DELISTED	Stock	24.59	24.71	24.5364	24.695	1526534.0
2017-05-02	ABBNY-DELISTED	Stock	24.59	24.71	24.5364	24.7	1654436.0
2017-05-02	ABBV	Stock	66.51	66.68	66.18	66.63	4342800.0
2017-05-02	ABC-DELISTED	Stock	82.85	82.92	81.158	82.74	1603669.0
2017-05-02	ABCB	Stock	47.45	47.55	46.65	46.8	213600.0
2017-05-02	ABCD-DELISTED	Stock	4.96	5.0	4.92	4.95	52303.0
2017-05-02	ABCO-DELISTED	Stock	50.85	50.925	50.05	50.5	362258.0
2017-05-02	ABDC-DELISTED	Stock	14.21	14.21	14.0001	14.19	35723.0
2017-05-02	ABE-DELISTED	Stock	13.7694	13.8342	13.7592	13.8342	1707.0
2017-05-02	ABEO	Stock	142.5	150.75	141.25	143.75	8432.0
2017-05-02	ABEOW-DELISTED	Stock	3.0	3.0	2.8538	2.8538	500.0
2017-05-02	ABEV	Stock	5.75	5.87	5.74	5.86	30616300.0
2017-05-02	ABG	Stock	62.0	62.0	57.95	58.1	462500.0
2017-05-02	ABIL-DELISTED	Stock	0.7895	0.81	0.76	0.7799	39265.0
2017-05-02	ABM	Stock	43.48	43.7	43.37	43.53	171200.0

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

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