PREVIEW / stock_daily / 2018-11-27

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-27.parquet
  size:    221 KB
  rows:    6,557
  symbols: 2,702

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-11-27	AAPL	Stock	42.8775	43.6925	42.72	43.56	165549600.0
2018-11-27	MSFT	Stock	106.27	107.33	105.36	107.14	29124500.0
2018-11-27	NVDA	Stock	3.8	3.9252	3.7638	3.8432	738060000.0
2018-11-27	AMZN	Stock	78.7995	79.8825	77.9005	79.071	115664000.0
2018-11-27	GOOGL	Stock	52.567	53.338	52.275	52.614	33048660.0
2018-11-27	META	Stock	135.75	136.61	133.71	135.0	20750300.0
2018-11-27	TSLA	Stock	22.67	23.1307	22.3667	22.928	95374500.0
2018-11-27	TLT	Stock	114.81	115.25	114.76	115.01	5967245.0
2018-11-27	ES	Stock	66.91	67.47	66.7	67.45	2282200.0
2018-11-27	CL	Stock	62.73	63.31	62.51	63.24	3708900.0
2018-11-27	A	Stock	68.87	69.52	68.7	69.36	2533600.0
2018-11-27	AA	Stock	32.14	32.35	30.95	31.19	2964900.0
2018-11-27	AABA-DELISTED	Stock	63.79	65.1	63.6105	64.16	6095835.0
2018-11-27	AAC-DELISTED	Stock	1.99	2.01	1.94	2.0	232771.0
2018-11-27	AACG	Stock	1.06	1.1	1.04	1.09	22400.0
2018-11-27	AAIC-DELISTED	Stock	8.37	8.45	8.35	8.36	196223.0
2018-11-27	AAL	Stock	38.21	38.77	37.81	38.29	8143000.0
2018-11-27	AAM.A-DELISTED	Stock	24.09	24.167	23.9003	23.97	20359.0
2018-11-27	AAM.B-DELISTED	Stock	23.82	24.11	23.81	24.02	78971.0
2018-11-27	AAMC-DELISTED	Stock	13.2647	14.1176	13.2647	14.1176	19550.0
2018-11-27	AAME	Stock	2.8	2.89	2.61	2.82	3200.0
2018-11-27	AAMI	Stock	12.87	12.925	12.61	12.66	218600.0
2018-11-27	AAOI	Stock	20.18	20.87	19.83	20.0	447600.0
2018-11-27	AAON	Stock	25.2667	25.4867	24.9267	25.0467	199050.0
2018-11-27	AAP	Stock	176.65	181.42	176.6	179.27	701700.0
2018-11-27	AAT	Stock	39.57	40.15	39.37	40.12	202800.0
2018-11-27	AAU-DELISTED	Stock	0.5	0.5483	0.5	0.5242	202788.0
2018-11-27	AAUAF-DELISTED	Stock	0.5	0.5483	0.5	0.5242	220942.0
2018-11-27	AAWW-DELISTED	Stock	51.33	51.82	50.47	51.22	128962.0
2018-11-27	AAXJ	Stock	65.43	65.94	65.2	65.94	1308786.0
2018-11-27	AAXN-DELISTED	Stock	46.68	47.4	46.4	46.52	384742.0
2018-11-27	AB	Stock	29.85	29.95	29.67	29.85	206100.0
2018-11-27	ABAC-DELISTED	Stock	1.53	1.53	1.451	1.48	7040.0
2018-11-27	ABB-DELISTED	Stock	20.01	20.0899	19.93	20.01	1960716.0
2018-11-27	ABBNY-DELISTED	Stock	20.01	20.0899	19.93	20.02	2038257.0
2018-11-27	ABBV	Stock	86.22	87.7	85.5	87.68	4338300.0
2018-11-27	ABC-DELISTED	Stock	89.009	89.75	88.47	89.74	1130785.0
2018-11-27	ABCB	Stock	42.9	43.16	42.21	42.27	189700.0
2018-11-27	ABCD-DELISTED	Stock	14.45	14.495	14.44	14.45	276067.0
2018-11-27	ABDC-DELISTED	Stock	6.37	6.48	6.21	6.37	91848.0
2018-11-27	ABEO	Stock	207.75	208.0	190.25	195.0	34692.0
2018-11-27	ABEOW-DELISTED	Stock	3.79	3.79	3.79	3.79	1000.0
2018-11-27	ABEV	Stock	4.07	4.26	4.04	4.22	27254300.0
2018-11-27	ABG	Stock	71.02	72.3	69.93	70.1	133000.0
2018-11-27	ABIL-DELISTED	Stock	2.94	2.9447	2.75	2.82	652344.0
2018-11-27	ABM	Stock	30.14	30.3	29.59	30.17	474800.0
2018-11-27	ABMD-DELISTED	Stock	309.3	318.525	304.56	314.0	833168.0
2018-11-27	ABR	Stock	12.15	12.26	11.99	12.24	1004100.0
2018-11-27	ABR.A-DELISTED	Stock	25.36	25.362	25.36	25.36	1505.0
2018-11-27	ABR.B-DELISTED	Stock	24.9627	24.9627	24.9627	24.9627	2000.0

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

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