PREVIEW / stock_daily / 2019-05-17

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-17.parquet
  size:    219 KB
  rows:    6,510
  symbols: 2,565

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
2019-05-17	AAPL	Stock	46.7325	47.725	46.69	47.25	131516400.0
2019-05-17	MSFT	Stock	128.31	130.46	127.92	128.07	25770500.0
2019-05-17	NVDA	Stock	3.9625	4.0928	3.8735	3.9132	1022068000.0
2019-05-17	AMZN	Stock	94.6525	95.5265	93.3665	93.45	94732000.0
2019-05-17	GOOGL	Stock	58.7915	59.3145	58.321	58.439	25361000.0
2019-05-17	META	Stock	184.84	187.58	184.28	185.3	10485400.0
2019-05-17	TSLA	Stock	14.7973	14.816	13.928	14.0687	266800500.0
2019-05-17	TLT	Stock	126.28	126.3	125.69	125.99	4747076.0
2019-05-17	ES	Stock	72.6	73.8	72.53	73.53	1139900.0
2019-05-17	CL	Stock	71.96	72.35	71.72	71.97	2764200.0
2019-05-17	A	Stock	68.44	69.87	68.19	69.11	3935700.0
2019-05-17	AA	Stock	24.6	25.0	24.35	24.5	3227200.0
2019-05-17	AABA-DELISTED	Stock	69.0	69.35	67.77	68.09	5323629.0
2019-05-17	AAC-DELISTED	Stock	1.65	1.6955	1.44	1.455	426931.0
2019-05-17	AACG	Stock	2.37	2.4	2.3	2.38	236500.0
2019-05-17	AAIC-DELISTED	Stock	7.54	7.54	7.34	7.37	602994.0
2019-05-17	AAIC.C-DELISTED	Stock	23.45	23.62	22.99	23.62	17730.0
2019-05-17	AAL	Stock	32.03	32.36	31.69	31.74	4751600.0
2019-05-17	AAM.A-DELISTED	Stock	25.63	25.78	25.63	25.78	25437.0
2019-05-17	AAM.B-DELISTED	Stock	25.8	25.8	25.7519	25.79	13790.0
2019-05-17	AAMC-DELISTED	Stock	5.9765	6.4265	5.9765	6.4265	1438.0
2019-05-17	AAMI	Stock	12.16	12.39	12.11	12.11	452900.0
2019-05-17	AAOI	Stock	9.57	9.624	9.16	9.17	997700.0
2019-05-17	AAON	Stock	30.5667	31.0533	30.4267	30.6067	172950.0
2019-05-17	AAP	Stock	155.92	159.67	155.68	157.97	1146200.0
2019-05-17	AAT	Stock	46.33	46.54	45.95	46.17	164300.0
2019-05-17	AAU-DELISTED	Stock	0.45	0.472	0.45	0.4658	76126.0
2019-05-17	AAUAF-DELISTED	Stock	0.45	0.472	0.45	0.4658	85946.0
2019-05-17	AAWW-DELISTED	Stock	40.72	41.35	39.89	39.92	113975.0
2019-05-17	AAXJ	Stock	66.42	66.79	66.23	66.38	3360107.0
2019-05-17	AAXN-DELISTED	Stock	67.71	68.79	67.35	68.0	842466.0
2019-05-17	AB	Stock	29.29	29.6	28.96	28.99	173700.0
2019-05-17	ABB-DELISTED	Stock	19.09	19.16	18.97	18.975	1536705.0
2019-05-17	ABBNY-DELISTED	Stock	19.09	19.16	18.97	18.98	1626814.0
2019-05-17	ABBV	Stock	78.53	80.08	78.02	79.46	4756400.0
2019-05-17	ABC-DELISTED	Stock	76.84	78.83	76.43	77.75	936124.0
2019-05-17	ABCB	Stock	35.91	36.54	35.83	35.96	197000.0
2019-05-17	ABDC-DELISTED	Stock	8.55	8.6013	8.495	8.51	49836.0
2019-05-17	ABEO	Stock	184.0	189.75	182.5	186.0	24908.0
2019-05-17	ABEOW-DELISTED	Stock	2.9911	2.9911	2.9911	2.9911	100.0
2019-05-17	ABEV	Stock	4.11	4.17	4.01	4.05	38060800.0
2019-05-17	ABG	Stock	79.05	80.29	78.49	78.57	116700.0
2019-05-17	ABIL-DELISTED	Stock	1.24	1.3	1.23	1.3	89471.0
2019-05-17	ABM	Stock	38.04	38.45	37.85	37.86	181400.0
2019-05-17	ABMD-DELISTED	Stock	260.74	262.95	256.0	260.63	368630.0
2019-05-17	ABR	Stock	12.95	13.19	12.92	13.1	2724000.0
2019-05-17	ABR.A-DELISTED	Stock	25.9	25.9	25.81	25.81	3150.0
2019-05-17	ABR.B-DELISTED	Stock	25.63	25.7443	25.63	25.7104	1900.0
2019-05-17	ABR.C-DELISTED	Stock	26.11	26.3	26.11	26.3	1300.0
2019-05-17	ABT	Stock	76.29	77.21	75.96	75.97	5169300.0

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

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