PREVIEW / stock_daily / 2019-01-25

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-25.parquet
  size:    219 KB
  rows:    6,519
  symbols: 2,640

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-01-25	AAPL	Stock	38.87	39.5325	38.58	39.44	134142000.0
2019-01-25	MSFT	Stock	107.24	107.88	106.2	107.17	31225600.0
2019-01-25	NVDA	Stock	3.886	4.022	3.7825	4.0038	1154572000.0
2019-01-25	AMZN	Stock	83.525	84.174	83.0805	83.5285	98918000.0
2019-01-25	GOOGL	Stock	54.7115	55.168	54.5901	55.0755	23275760.0
2019-01-25	META	Stock	147.48	149.83	146.54	149.01	22237200.0
2019-01-25	TSLA	Stock	19.626	19.9013	19.3033	19.8027	108744000.0
2019-01-25	TLT	Stock	120.59	120.75	120.32	120.53	6460820.0
2019-01-25	ES	Stock	68.24	68.58	67.21	67.28	1236300.0
2019-01-25	CL	Stock	60.96	63.6	60.96	61.84	8478900.0
2019-01-25	A	Stock	72.79	73.73	72.56	73.65	2215300.0
2019-01-25	AA	Stock	28.42	29.515	28.16	29.02	6607500.0
2019-01-25	AABA-DELISTED	Stock	64.87	65.87	64.72	65.23	6530626.0
2019-01-25	AAC-DELISTED	Stock	2.31	2.505	2.31	2.38	131623.0
2019-01-25	AACG	Stock	0.98	1.11	0.98	1.07	262000.0
2019-01-25	AAIC-DELISTED	Stock	8.22	8.37	8.2	8.34	330550.0
2019-01-25	AAL	Stock	33.94	35.5	33.76	34.98	15811300.0
2019-01-25	AAM.A-DELISTED	Stock	24.46	24.57	24.38	24.4701	29210.0
2019-01-25	AAM.B-DELISTED	Stock	24.44	24.5	24.407	24.49	15783.0
2019-01-25	AAME	Stock	2.55	2.68	2.53	2.66	5900.0
2019-01-25	AAMI	Stock	12.34	12.44	12.26	12.37	383600.0
2019-01-25	AAOI	Stock	16.76	17.739	16.71	17.45	804400.0
2019-01-25	AAON	Stock	24.7267	25.0067	23.7133	23.8067	277800.0
2019-01-25	AAP	Stock	156.83	156.83	150.24	153.22	1800700.0
2019-01-25	AAT	Stock	40.95	41.44	40.95	41.35	95100.0
2019-01-25	AAU-DELISTED	Stock	0.77	0.8	0.72	0.7647	154078.0
2019-01-25	AAUAF-DELISTED	Stock	0.77	0.8	0.72	0.7647	161961.0
2019-01-25	AAWW-DELISTED	Stock	51.19	51.99	50.955	51.265	101422.0
2019-01-25	AAXJ	Stock	67.62	68.06	67.57	67.85	2348543.0
2019-01-25	AAXN-DELISTED	Stock	48.83	49.58	48.31	49.1	273161.0
2019-01-25	AB	Stock	30.25	30.61	30.08	30.15	341600.0
2019-01-25	ABB-DELISTED	Stock	19.42	19.565	19.41	19.5	1835050.0
2019-01-25	ABBNY-DELISTED	Stock	19.42	19.565	19.41	19.49	1978955.0
2019-01-25	ABBV	Stock	82.51	82.61	79.43	80.54	21308600.0
2019-01-25	ABC-DELISTED	Stock	79.21	80.53	78.97	79.66	769091.0
2019-01-25	ABCB	Stock	36.2	36.79	34.79	36.51	855400.0
2019-01-25	ABDC-DELISTED	Stock	6.78	6.8578	6.7701	6.83	7580.0
2019-01-25	ABEO	Stock	173.25	178.0	166.25	176.0	18300.0
2019-01-25	ABEV	Stock	4.57	4.59	4.49	4.53	18543400.0
2019-01-25	ABG	Stock	69.47	70.39	69.04	69.88	93500.0
2019-01-25	ABIL-DELISTED	Stock	2.13	2.17	2.05	2.11	295459.0
2019-01-25	ABM	Stock	34.05	34.41	34.01	34.01	708000.0
2019-01-25	ABMD-DELISTED	Stock	349.99	353.92	346.46	349.26	301967.0
2019-01-25	ABR	Stock	11.34	11.53	11.3	11.47	787500.0
2019-01-25	ABR.A-DELISTED	Stock	25.6	25.6	25.5515	25.5901	3788.0
2019-01-25	ABR.B-DELISTED	Stock	25.4	25.7	25.35	25.69	26143.0
2019-01-25	ABR.C-DELISTED	Stock	25.91	25.92	25.759	25.92	3440.0
2019-01-25	ABT	Stock	71.27	71.77	70.79	71.15	4824100.0
2019-01-25	ABTC	Stock	305100.0	305100.0	303300.0	304800.0	3.0933333333333333
2019-01-25	ABTS	Stock	54.75	58.425	52.5	52.5	1316.0

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

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