PREVIEW / stock_daily / 2015-09-02

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-02.parquet
  size:    223 KB
  rows:    6,674
  symbols: 3,470

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
2015-09-02	AAPL	Stock	27.5575	28.085	27.2825	28.085	247555200.0
2015-09-02	MSFT	Stock	42.36	43.38	41.88	43.36	37671500.0
2015-09-02	NVDA	Stock	0.5538	0.5555	0.5445	0.5552	344044000.0
2015-09-02	AMZN	Stock	25.2545	25.543	24.886	25.5275	74142000.0
2015-09-02	GOOGL	Stock	31.9	32.2528	31.532	32.2455	37629780.0
2015-09-02	META	Stock	88.81	89.89	87.63	89.89	27190500.0
2015-09-02	TSLA	Stock	16.3533	16.5253	15.9853	16.5127	69438000.0
2015-09-02	TLT	Stock	121.42	121.98	120.86	120.98	9515229.0
2015-09-02	ES	Stock	46.54	46.62	45.88	46.15	2330800.0
2015-09-02	CL	Stock	62.0	62.22	61.53	62.18	3402200.0
2015-09-02	A	Stock	35.33	35.53	34.88	35.53	2118300.0
2015-09-02	AA.B-DELISTED	Stock	34.51	34.92	34.0	34.8	47373.0
2015-09-02	AABA-DELISTED	Stock	31.99	32.03	31.38	31.77	14940830.0
2015-09-02	AAC-DELISTED	Stock	22.34	25.57	22.07	25.01	978212.0
2015-09-02	AACG	Stock	2.38	2.87	2.35	2.36	28100.0
2015-09-02	AAIC-DELISTED	Stock	16.39	16.5	16.13	16.22	150241.0
2015-09-02	AAL	Stock	39.97	41.51	39.8	41.51	19316800.0
2015-09-02	AAMC-DELISTED	Stock	11.7118	12.6735	11.0294	11.4706	56046.0
2015-09-02	AAME	Stock	3.6	3.6	3.47	3.52	3100.0
2015-09-02	AAMI	Stock	16.39	16.7	16.02	16.37	265000.0
2015-09-02	AAOI	Stock	20.04	20.48	19.68	20.47	295900.0
2015-09-02	AAON	Stock	13.3733	13.5333	13.2	13.42	223500.0
2015-09-02	AAP	Stock	173.72	176.11	172.77	175.25	444300.0
2015-09-02	AAT	Stock	38.12	38.47	37.56	38.17	225300.0
2015-09-02	AAU-DELISTED	Stock	0.5601	0.5702	0.5321	0.5599	23678.0
2015-09-02	AAUAF-DELISTED	Stock	0.56	0.5701	0.5321	0.5599	24024.0
2015-09-02	AAV-DELISTED	Stock	5.37	5.39	5.17	5.31	74895.0
2015-09-02	AAVL-DELISTED	Stock	10.36	10.6633	10.1	10.64	286152.0
2015-09-02	AAWW-DELISTED	Stock	39.21	39.33	38.05	38.87	281773.0
2015-09-02	AAXJ	Stock	52.28	52.29	51.81	52.22	2495478.0
2015-09-02	AAXN-DELISTED	Stock	23.19	24.18	22.97	23.87	1943859.0
2015-09-02	AB	Stock	26.4	26.65	25.74	26.05	221900.0
2015-09-02	ABAC-DELISTED	Stock	0.79	0.82	0.79	0.8	4713.0
2015-09-02	ABAX-DELISTED	Stock	47.39	47.5	46.68	47.43	147382.0
2015-09-02	ABB-DELISTED	Stock	18.92	18.94	18.61	18.81	1701767.0
2015-09-02	ABBNY-DELISTED	Stock	18.92	18.94	18.61	18.81	1800021.0
2015-09-02	ABBV	Stock	61.56	61.6	60.28	60.98	12044500.0
2015-09-02	ABC-DELISTED	Stock	101.77	101.77	99.1	100.27	1324397.0
2015-09-02	ABCB	Stock	26.68	26.89	26.19	26.7	188700.0
2015-09-02	ABCD-DELISTED	Stock	4.97	5.16	4.72	5.095	119048.0
2015-09-02	ABCO-DELISTED	Stock	48.03	49.27	47.56	49.15	238782.0
2015-09-02	ABCW-DELISTED	Stock	40.49	40.72	39.615	40.61	8754.0
2015-09-02	ABDC-DELISTED	Stock	12.89	13.0099	12.62	12.9797	32105.0
2015-09-02	ABE-DELISTED	Stock	11.1	11.14	10.83	10.83	13836.0
2015-09-02	ABEO	Stock	120.75	122.0	117.0	120.5	4328.0
2015-09-02	ABEOW-DELISTED	Stock	2.0	2.0	1.66	1.67	1343.0
2015-09-02	ABEV	Stock	5.03	5.11	4.99	5.09	27124300.0
2015-09-02	ABG	Stock	79.65	80.71	78.9	80.33	237900.0
2015-09-02	ABGB-DELISTED	Stock	5.36	5.36	5.195	5.27	29803.0
2015-09-02	ABIL-DELISTED	Stock	10.05	10.05	10.05	10.05	200.0

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

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