PREVIEW / stock_daily / 2019-01-24

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-24.parquet
  size:    218 KB
  rows:    6,506
  symbols: 2,641

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-24	AAPL	Stock	38.5275	38.62	37.935	38.175	101766000.0
2019-01-24	MSFT	Stock	106.86	107.0	105.34	106.2	23164800.0
2019-01-24	NVDA	Stock	3.8175	3.9638	3.8128	3.946	708972000.0
2019-01-24	AMZN	Stock	82.0535	82.863	81.589	82.7465	81798000.0
2019-01-24	GOOGL	Stock	54.1255	54.4	53.501	54.2	29118960.0
2019-01-24	META	Stock	144.64	146.44	142.52	145.83	20955500.0
2019-01-24	TSLA	Stock	18.8687	19.5787	18.6187	19.434	120183000.0
2019-01-24	TLT	Stock	120.91	121.26	120.71	121.11	7121480.0
2019-01-24	ES	Stock	68.52	68.57	67.76	68.46	1582100.0
2019-01-24	CL	Stock	62.17	62.25	61.27	62.2	6024300.0
2019-01-24	A	Stock	71.46	72.2	71.39	72.18	1509600.0
2019-01-24	AA	Stock	28.15	28.53	27.66	27.96	3022000.0
2019-01-24	AABA-DELISTED	Stock	62.64	64.2	62.64	64.06	5646566.0
2019-01-24	AAC-DELISTED	Stock	2.53	2.53	2.24	2.26	208809.0
2019-01-24	AACG	Stock	0.98	0.99	0.96	0.98	34600.0
2019-01-24	AAIC-DELISTED	Stock	8.15	8.2	8.055	8.16	197326.0
2019-01-24	AAL	Stock	34.26	34.35	32.83	33.66	15531100.0
2019-01-24	AAM.A-DELISTED	Stock	24.52	24.52	24.4	24.4769	34575.0
2019-01-24	AAM.B-DELISTED	Stock	24.33	24.45	24.25	24.45	25909.0
2019-01-24	AAMC-DELISTED	Stock	7.8982	7.9353	7.7912	7.7912	3516.0
2019-01-24	AAME	Stock	2.7	2.82	2.58	2.82	3800.0
2019-01-24	AAMI	Stock	12.22	12.53	12.22	12.33	446400.0
2019-01-24	AAOI	Stock	16.34	16.81	16.11	16.72	520900.0
2019-01-24	AAON	Stock	24.18	24.7533	24.18	24.5267	143100.0
2019-01-24	AAP	Stock	164.5	164.97	155.64	156.31	1298000.0
2019-01-24	AAT	Stock	40.69	41.06	40.33	40.82	148300.0
2019-01-24	AAU-DELISTED	Stock	0.72	0.7264	0.71	0.7147	76325.0
2019-01-24	AAUAF-DELISTED	Stock	0.72	0.7264	0.71	0.7147	78670.0
2019-01-24	AAWW-DELISTED	Stock	49.84	50.99	49.72	50.8	143455.0
2019-01-24	AAXJ	Stock	66.29	66.84	66.28	66.82	2027230.0
2019-01-24	AAXN-DELISTED	Stock	48.11	48.49	47.13	48.41	511271.0
2019-01-24	AB	Stock	29.75	30.25	29.75	30.01	268900.0
2019-01-24	ABB-DELISTED	Stock	19.02	19.19	18.93	18.96	3241419.0
2019-01-24	ABBNY-DELISTED	Stock	19.02	19.19	18.93	18.95	3406975.0
2019-01-24	ABBV	Stock	88.33	88.44	85.1	85.88	8372600.0
2019-01-24	ABC-DELISTED	Stock	79.3	79.95	78.3	78.67	548439.0
2019-01-24	ABCB	Stock	35.42	35.75	34.77	35.27	168100.0
2019-01-24	ABDC-DELISTED	Stock	6.72	6.78	6.72	6.74	8636.0
2019-01-24	ABEO	Stock	168.75	173.25	164.25	172.75	10260.0
2019-01-24	ABEV	Stock	4.49	4.56	4.46	4.48	29604600.0
2019-01-24	ABG	Stock	69.33	69.7	68.21	68.92	247500.0
2019-01-24	ABIL-DELISTED	Stock	2.13	2.15	2.07	2.12	224184.0
2019-01-24	ABM	Stock	34.65	34.65	33.62	33.96	469600.0
2019-01-24	ABMD-DELISTED	Stock	337.5	349.34	334.95	348.52	593913.0
2019-01-24	ABR	Stock	11.22	11.31	11.19	11.28	462900.0
2019-01-24	ABR.A-DELISTED	Stock	25.4491	25.7	25.4491	25.5	4304.0
2019-01-24	ABR.B-DELISTED	Stock	25.21	25.3462	25.21	25.3462	1400.0
2019-01-24	ABR.C-DELISTED	Stock	25.75	25.75	25.75	25.75	500.0
2019-01-24	ABT	Stock	70.0	71.0	69.32	70.86	6437600.0
2019-01-24	ABTC	Stock	305700.0	305700.0	302100.0	304500.0	2.6533333333333333

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

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