PREVIEW / stock_daily / 2018-08-02

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-02.parquet
  size:    217 KB
  rows:    6,503
  symbols: 2,754

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-08-02	AAPL	Stock	50.145	52.095	50.0875	51.8475	249616000.0
2018-08-02	MSFT	Stock	105.4	108.09	104.84	107.57	26104300.0
2018-08-02	NVDA	Stock	6.0898	6.2695	6.0303	6.2655	269668000.0
2018-08-02	AMZN	Stock	89.4385	91.828	89.3	91.7165	87094000.0
2018-08-02	GOOGL	Stock	60.925	62.2205	60.903	62.0565	34703600.0
2018-08-02	META	Stock	170.68	176.79	170.27	176.37	32400000.0
2018-08-02	TSLA	Stock	21.896	23.3327	21.544	23.3027	348225000.0
2018-08-02	TLT	Stock	118.62	118.74	118.3	118.63	4451078.0
2018-08-02	ES	Stock	59.7	60.27	59.36	60.0	1386400.0
2018-08-02	CL	Stock	66.14	67.43	66.13	67.24	3607800.0
2018-08-02	A	Stock	64.75	65.39	64.5	65.29	2263200.0
2018-08-02	AA	Stock	41.63	42.75	41.46	42.48	2571700.0
2018-08-02	AABA-DELISTED	Stock	71.8	72.22	71.03	72.07	18120267.0
2018-08-02	AAC-DELISTED	Stock	8.55	8.81	7.8	8.65	584341.0
2018-08-02	AACG	Stock	4.5	4.6	4.5	4.5	2300.0
2018-08-02	AAIC-DELISTED	Stock	10.45	10.46	10.36	10.41	287990.0
2018-08-02	AAL	Stock	37.86	38.12	37.35	37.93	5920700.0
2018-08-02	AAM.A-DELISTED	Stock	25.34	25.4152	25.32	25.37	20725.0
2018-08-02	AAM.B-DELISTED	Stock	25.0	25.0	24.9401	24.99	40721.0
2018-08-02	AAMC-DELISTED	Stock	18.4118	18.4118	18.4118	18.4118	2026.0
2018-08-02	AAME	Stock	2.36	2.65	2.36	2.65	900.0
2018-08-02	AAMI	Stock	13.6	13.6	12.36	12.49	2046200.0
2018-08-02	AAOI	Stock	36.39	38.25	35.56	38.14	634300.0
2018-08-02	AAON	Stock	24.8333	25.5333	24.4333	24.7333	614250.0
2018-08-02	AAP	Stock	139.4	143.69	139.4	143.26	654000.0
2018-08-02	AAT	Stock	38.14	38.45	38.01	38.12	108900.0
2018-08-02	AAU-DELISTED	Stock	0.65	0.6529	0.63	0.638	157584.0
2018-08-02	AAUAF-DELISTED	Stock	0.65	0.6529	0.63	0.638	161438.0
2018-08-02	AAV-DELISTED	Stock	3.45	3.49	3.4	3.45	104199.0
2018-08-02	AAWW-DELISTED	Stock	69.25	69.8	63.65	64.65	489808.0
2018-08-02	AAXJ	Stock	70.96	71.45	70.742	71.34	2985810.0
2018-08-02	AAXN-DELISTED	Stock	68.38	70.0	67.93	69.74	406724.0
2018-08-02	AB	Stock	29.6	29.6	28.3	28.3	911800.0
2018-08-02	ABAC-DELISTED	Stock	2.16	2.27	2.12	2.131	11471.0
2018-08-02	ABB-DELISTED	Stock	22.44	22.585	22.39	22.57	1831110.0
2018-08-02	ABBNY-DELISTED	Stock	22.44	22.585	22.39	22.57	1910478.0
2018-08-02	ABBV	Stock	93.58	95.86	93.41	95.12	6023200.0
2018-08-02	ABC-DELISTED	Stock	78.0	79.67	77.28	78.98	3345503.0
2018-08-02	ABCB	Stock	47.25	49.25	47.2	49.15	779900.0
2018-08-02	ABCD-DELISTED	Stock	12.12	12.63	11.96	12.6	199598.0
2018-08-02	ABDC-DELISTED	Stock	6.09	6.15	6.0	6.08	54832.0
2018-08-02	ABEO	Stock	361.25	362.5	352.5	355.0	12252.0
2018-08-02	ABEV	Stock	5.09	5.16	5.08	5.09	24527700.0
2018-08-02	ABG	Stock	70.2	71.95	70.2	71.3	173700.0
2018-08-02	ABIL-DELISTED	Stock	3.05	3.17	2.91	2.91	27669.0
2018-08-02	ABM	Stock	30.98	31.12	30.71	31.12	278300.0
2018-08-02	ABMD-DELISTED	Stock	361.02	373.086	358.0	372.2	567331.0
2018-08-02	ABR	Stock	11.39	11.46	11.36	11.38	1244800.0
2018-08-02	ABR.A-DELISTED	Stock	25.8801	25.9572	25.8801	25.9572	1250.0
2018-08-02	ABR.B-DELISTED	Stock	25.65	25.65	25.65	25.65	257.0

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

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