PREVIEW / stock_daily / 2019-02-19

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-19.parquet
  size:    220 KB
  rows:    6,534
  symbols: 2,625

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-02-19	AAPL	Stock	42.4275	42.86	42.3725	42.7325	75891200.0
2019-02-19	MSFT	Stock	107.79	108.66	107.78	108.17	18038500.0
2019-02-19	NVDA	Stock	3.9228	3.9972	3.9035	3.916	551892000.0
2019-02-19	AMZN	Stock	80.05	81.7	80.028	81.379	73634000.0
2019-02-19	GOOGL	Stock	55.832	56.482	55.832	56.3255	21985180.0
2019-02-19	META	Stock	160.5	164.15	160.33	162.29	14345400.0
2019-02-19	TSLA	Stock	20.4373	20.7693	20.3647	20.376	62526000.0
2019-02-19	TLT	Stock	122.42	122.54	121.95	122.29	5872819.0
2019-02-19	ES	Stock	70.17	70.51	69.81	70.4	1472500.0
2019-02-19	CL	Stock	66.44	67.0	66.12	66.72	4584000.0
2019-02-19	A	Stock	78.0	78.32	77.41	77.52	2968000.0
2019-02-19	AA	Stock	28.21	28.4	28.1	28.21	3029500.0
2019-02-19	AABA-DELISTED	Stock	67.78	69.53	67.71	69.17	5026324.0
2019-02-19	AAC-DELISTED	Stock	2.97	3.02	2.94	2.975	86929.0
2019-02-19	AACG	Stock	1.06	1.08	1.03	1.06	10800.0
2019-02-19	AAIC-DELISTED	Stock	8.7	8.76	8.3208	8.7	822096.0
2019-02-19	AAL	Stock	35.03	35.9	35.0	35.47	6436100.0
2019-02-19	AAM.A-DELISTED	Stock	24.97	24.98	24.8763	24.97	34102.0
2019-02-19	AAM.B-DELISTED	Stock	24.75	24.781	24.6773	24.77	47597.0
2019-02-19	AAME	Stock	2.73	2.73	2.73	2.73	200.0
2019-02-19	AAMI	Stock	13.78	13.89	13.76	13.77	813100.0
2019-02-19	AAOI	Stock	15.04	15.08	14.1	14.93	1598300.0
2019-02-19	AAON	Stock	26.1	26.9133	24.9333	26.9133	184950.0
2019-02-19	AAP	Stock	169.93	178.69	166.42	167.14	3369200.0
2019-02-19	AAT	Stock	44.03	44.46	43.66	43.89	125600.0
2019-02-19	AAU-DELISTED	Stock	0.71	0.7697	0.708	0.76	279749.0
2019-02-19	AAUAF-DELISTED	Stock	0.71	0.7697	0.708	0.757	296094.0
2019-02-19	AAWW-DELISTED	Stock	57.32	59.935	56.005	58.38	744714.0
2019-02-19	AAXJ	Stock	68.19	69.02	68.1279	68.85	778842.0
2019-02-19	AAXN-DELISTED	Stock	55.43	56.08	55.21	55.82	335557.0
2019-02-19	AB	Stock	30.05	30.38	29.75	30.16	603300.0
2019-02-19	ABB-DELISTED	Stock	19.56	19.91	19.56	19.86	3114850.0
2019-02-19	ABBNY-DELISTED	Stock	19.56	19.91	19.56	19.86	3205779.0
2019-02-19	ABBV	Stock	80.5	81.52	80.23	80.52	5674700.0
2019-02-19	ABC-DELISTED	Stock	86.4	87.32	86.0	86.88	1295370.0
2019-02-19	ABCB	Stock	39.6	40.71	39.36	40.62	340800.0
2019-02-19	ABDC-DELISTED	Stock	7.3	7.3	7.04	7.21	30773.0
2019-02-19	ABEO	Stock	172.75	172.75	163.75	167.0	15544.0
2019-02-19	ABEV	Stock	4.86	4.95	4.85	4.88	18923300.0
2019-02-19	ABG	Stock	70.65	72.0	69.85	70.8	150300.0
2019-02-19	ABIL-DELISTED	Stock	1.88	1.9	1.86	1.8801	93792.0
2019-02-19	ABM	Stock	36.05	36.53	36.05	36.35	315300.0
2019-02-19	ABMD-DELISTED	Stock	361.77	364.31	358.06	359.4	207299.0
2019-02-19	ABR	Stock	12.41	12.78	12.34	12.72	2809500.0
2019-02-19	ABR.A-DELISTED	Stock	25.37	25.37	25.31	25.3409	1300.0
2019-02-19	ABR.C-DELISTED	Stock	25.348	25.348	25.24	25.24	6998.0
2019-02-19	ABT	Stock	75.16	75.57	74.72	75.0	4503500.0
2019-02-19	ABTC	Stock	304800.0	304800.0	303600.0	304170.0	0.8799999999999999
2019-02-19	ABTS	Stock	36.75	36.75	34.5	35.925	173.0
2019-02-19	ABTX-DELISTED	Stock	38.5	38.83	38.12	38.7027	47479.0

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

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