PREVIEW / stock_daily / 2018-05-01

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-01.parquet
  size:    216 KB
  rows:    6,459
  symbols: 2,811

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-05-01	AAPL	Stock	41.6025	42.3	41.3175	42.275	214277600.0
2018-05-01	MSFT	Stock	93.21	95.29	92.79	95.0	31408900.0
2018-05-01	NVDA	Stock	5.6142	5.6812	5.555	5.6785	253788000.0
2018-05-01	AMZN	Stock	78.161	79.25	77.609	79.113	91442000.0
2018-05-01	GOOGL	Stock	50.815	52.0865	50.5305	52.0375	35325120.0
2018-05-01	META	Stock	172.0	174.02	170.23	173.86	26025900.0
2018-05-01	TSLA	Stock	19.5673	20.0547	19.548	19.9947	69384000.0
2018-05-01	TLT	Stock	118.77	118.84	118.23	118.41	7979321.0
2018-05-01	ES	Stock	60.38	60.45	59.58	59.75	2356700.0
2018-05-01	CL	Stock	64.78	65.39	64.63	65.0	4952300.0
2018-05-01	A	Stock	65.63	66.35	65.49	66.24	3135100.0
2018-05-01	AA	Stock	51.04	52.43	50.11	51.99	2526300.0
2018-05-01	AABA-DELISTED	Stock	69.45	70.3	69.34	69.92	7966604.0
2018-05-01	AAC-DELISTED	Stock	11.34	11.52	11.02	11.49	147169.0
2018-05-01	AACG	Stock	5.09	5.19	5.09	5.19	1400.0
2018-05-01	AAIC-DELISTED	Stock	11.43	11.45	11.16	11.31	532616.0
2018-05-01	AAL	Stock	42.86	43.46	42.56	43.36	5341200.0
2018-05-01	AAM.A-DELISTED	Stock	24.36	24.36	24.05	24.18	24297.0
2018-05-01	AAM.B-DELISTED	Stock	24.2	24.2	24.06	24.14	52909.0
2018-05-01	AAMI	Stock	15.2	15.2	14.95	15.06	292000.0
2018-05-01	AAOI	Stock	31.64	32.15	30.1	31.53	1886200.0
2018-05-01	AAON	Stock	22.6	22.8667	22.2333	22.8667	239850.0
2018-05-01	AAP	Stock	113.86	115.7	113.09	115.58	806900.0
2018-05-01	AAT	Stock	33.48	34.2	33.43	33.96	174800.0
2018-05-01	AAU-DELISTED	Stock	0.811	0.85	0.8	0.81	112640.0
2018-05-01	AAUAF-DELISTED	Stock	0.811	0.85	0.8	0.81	115403.0
2018-05-01	AAV-DELISTED	Stock	3.2	3.2	3.05	3.1	224023.0
2018-05-01	AAWW-DELISTED	Stock	63.25	63.9	62.7	63.55	291021.0
2018-05-01	AAXJ	Stock	75.93	76.15	75.19	76.09	615686.0
2018-05-01	AAXN-DELISTED	Stock	41.95	42.14	41.16	41.51	504739.0
2018-05-01	AB	Stock	27.1	27.2	26.75	27.1	286700.0
2018-05-01	ABAC-DELISTED	Stock	2.27	2.2899	2.27	2.2899	342.0
2018-05-01	ABAX-DELISTED	Stock	66.62	67.66	66.3	67.46	87938.0
2018-05-01	ABB-DELISTED	Stock	23.22	23.36	23.05	23.335	1497272.0
2018-05-01	ABBNY-DELISTED	Stock	23.22	23.36	23.05	23.33	1569570.0
2018-05-01	ABBV	Stock	102.1	103.37	101.18	102.07	11910500.0
2018-05-01	ABC-DELISTED	Stock	90.45	90.685	87.69	88.94	1468740.0
2018-05-01	ABCB	Stock	51.7	52.3	50.8	52.0	184700.0
2018-05-01	ABCD-DELISTED	Stock	10.06	10.2	9.53	9.96	289265.0
2018-05-01	ABDC-DELISTED	Stock	6.15	6.24	6.15	6.2	23972.0
2018-05-01	ABEO	Stock	438.75	445.0	427.5	432.5	35656.0
2018-05-01	ABEOW-DELISTED	Stock	12.6	12.6	12.3	12.3	3500.0
2018-05-01	ABEV	Stock	6.6	6.69	6.5	6.57	7910300.0
2018-05-01	ABG	Stock	66.9	68.85	65.7	68.5	162200.0
2018-05-01	ABIL-DELISTED	Stock	2.67	3.1776	2.67	2.84	140120.0
2018-05-01	ABLX-DELISTED	Stock	53.4	53.63	53.4	53.56	57747.0
2018-05-01	ABM	Stock	31.04	31.09	30.26	30.64	856700.0
2018-05-01	ABMD-DELISTED	Stock	301.69	311.6	301.69	310.5	321647.0
2018-05-01	ABR	Stock	8.75	8.77	8.68	8.73	271800.0
2018-05-01	ABR.A-DELISTED	Stock	25.72	25.77	25.6498	25.7624	5717.0

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

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