PREVIEW / stock_daily / 2018-04-02

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-02.parquet
  size:    217 KB
  rows:    6,505
  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-04-02	AAPL	Stock	41.66	42.235	41.1175	41.67	150347200.0
2018-04-02	MSFT	Stock	90.47	90.88	87.51	88.52	48515400.0
2018-04-02	NVDA	Stock	5.7185	5.8663	5.4375	5.5263	922092000.0
2018-04-02	AMZN	Stock	70.881	71.068	67.75	68.5995	209272000.0
2018-04-02	GOOGL	Stock	51.381	51.9765	49.7125	50.6315	65067740.0
2018-04-02	META	Stock	157.81	159.2	154.11	155.39	36796000.0
2018-04-02	TSLA	Stock	17.084	17.3553	16.306	16.832	241710000.0
2018-04-02	TLT	Stock	121.35	122.3573	121.16	121.88	12036489.0
2018-04-02	ES	Stock	59.05	59.75	58.3	58.67	2584100.0
2018-04-02	CL	Stock	71.32	71.67	69.92	70.15	4109300.0
2018-04-02	A	Stock	66.65	66.97	63.73	64.43	3085800.0
2018-04-02	AA	Stock	44.86	46.12	43.8	44.34	2139600.0
2018-04-02	AABA-DELISTED	Stock	73.58	73.76	70.98	71.58	7273500.0
2018-04-02	AAC-DELISTED	Stock	11.29	11.4	11.04	11.07	56668.0
2018-04-02	AACG	Stock	5.18	5.37	5.17	5.37	12300.0
2018-04-02	AAIC-DELISTED	Stock	11.04	11.125	10.8148	10.93	582477.0
2018-04-02	AAL	Stock	51.77	51.95	48.96	49.78	4185800.0
2018-04-02	AAM.A-DELISTED	Stock	25.07	25.07	24.83	24.9	32133.0
2018-04-02	AAM.B-DELISTED	Stock	24.89	24.9362	24.68	24.75	205709.0
2018-04-02	AAME	Stock	3.35	3.35	3.35	3.35	600.0
2018-04-02	AAMI	Stock	15.74	15.91	14.98	15.07	641500.0
2018-04-02	AAOI	Stock	24.87	25.33	24.02	24.02	598000.0
2018-04-02	AAON	Stock	25.9333	26.02	24.5667	24.7667	274650.0
2018-04-02	AAP	Stock	118.61	119.18	110.51	111.93	1581300.0
2018-04-02	AAT	Stock	33.53	34.14	33.37	33.61	686500.0
2018-04-02	AAU-DELISTED	Stock	0.8375	0.8426	0.7975	0.8326	81730.0
2018-04-02	AAUAF-DELISTED	Stock	0.8375	0.8426	0.7975	0.83	87928.0
2018-04-02	AAV-DELISTED	Stock	3.0	3.0	2.85	2.9	121554.0
2018-04-02	AAWW-DELISTED	Stock	59.85	60.3	58.35	58.9	115696.0
2018-04-02	AAXJ	Stock	77.12	77.3284	75.45	76.08	377162.0
2018-04-02	AAXN-DELISTED	Stock	39.35	39.61	38.83	39.48	386107.0
2018-04-02	AB	Stock	26.8	26.85	25.95	26.1	325100.0
2018-04-02	ABAC-DELISTED	Stock	2.28	2.28	2.18	2.2	7318.0
2018-04-02	ABAX-DELISTED	Stock	70.51	71.485	67.8	68.45	104581.0
2018-04-02	ABB-DELISTED	Stock	23.75	23.75	23.22	23.46	1579346.0
2018-04-02	ABBNY-DELISTED	Stock	23.7	23.7474	23.22	23.45	1645630.0
2018-04-02	ABBV	Stock	94.0	94.64	90.3	91.46	7816500.0
2018-04-02	ABC-DELISTED	Stock	86.1	86.59	81.82	82.66	1728819.0
2018-04-02	ABCB	Stock	52.85	53.35	51.65	52.15	174600.0
2018-04-02	ABCD-DELISTED	Stock	11.29	11.32	10.86	11.11	380872.0
2018-04-02	ABDC-DELISTED	Stock	6.95	7.15	6.8844	7.02	65412.0
2018-04-02	ABE-DELISTED	Stock	14.72	14.72	14.61	14.61	2875.0
2018-04-02	ABEO	Stock	351.25	368.75	344.0	356.25	39220.0
2018-04-02	ABEOW-DELISTED	Stock	9.77	9.77	9.77	9.77	400.0
2018-04-02	ABEV	Stock	7.2	7.27	7.1	7.11	11418900.0
2018-04-02	ABG	Stock	67.5	67.7	63.4	63.65	161300.0
2018-04-02	ABIL-DELISTED	Stock	3.2508	3.324	3.01	3.09	25614.0
2018-04-02	ABLX-DELISTED	Stock	54.47	54.79	54.31	54.45	48086.0
2018-04-02	ABM	Stock	33.4	33.53	32.35	32.81	468200.0
2018-04-02	ABMD-DELISTED	Stock	291.43	291.44	276.59	279.11	474550.0

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

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