PREVIEW / stock_daily / 2019-02-26

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-26.parquet
  size:    220 KB
  rows:    6,544
  symbols: 2,632

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-26	AAPL	Stock	43.4275	43.825	43.2925	43.5825	68280800.0
2019-02-26	MSFT	Stock	111.26	113.24	111.17	112.36	21536700.0
2019-02-26	NVDA	Stock	3.9625	4.019	3.8938	3.9275	488464000.0
2019-02-26	AMZN	Stock	81.299	81.9995	80.8065	81.82	53316000.0
2019-02-26	GOOGL	Stock	55.7185	56.3218	55.335	56.1005	35025220.0
2019-02-26	META	Stock	164.34	166.24	163.8	164.13	13784100.0
2019-02-26	TSLA	Stock	19.4813	20.134	19.2513	19.8573	128737500.0
2019-02-26	TLT	Stock	121.73	121.82	121.36	121.81	6028892.0
2019-02-26	ES	Stock	69.5	69.76	68.92	69.66	2623000.0
2019-02-26	CL	Stock	66.65	66.9	66.14	66.49	2922500.0
2019-02-26	A	Stock	79.21	79.27	78.42	78.55	1992600.0
2019-02-26	AA	Stock	30.7	31.27	30.48	30.85	3723600.0
2019-02-26	AABA-DELISTED	Stock	72.88	74.66	72.5977	74.27	3788296.0
2019-02-26	AAC-DELISTED	Stock	3.09	3.14	2.97	3.02	156207.0
2019-02-26	AACG	Stock	1.1	1.15	1.1	1.12	72100.0
2019-02-26	AAIC-DELISTED	Stock	8.16	8.29	8.16	8.23	799504.0
2019-02-26	AAL	Stock	35.9	36.73	35.75	36.25	7565000.0
2019-02-26	AAM.A-DELISTED	Stock	25.069	25.09	25.0	25.05	22759.0
2019-02-26	AAM.B-DELISTED	Stock	24.74	24.74	24.52	24.6	55075.0
2019-02-26	AAMC-DELISTED	Stock	11.4706	11.9971	11.4676	11.5647	16670.0
2019-02-26	AAME	Stock	2.79	2.8	2.79	2.8	1000.0
2019-02-26	AAMI	Stock	14.23	14.28	14.02	14.16	878800.0
2019-02-26	AAOI	Stock	16.82	17.05	16.079	16.53	1008400.0
2019-02-26	AAON	Stock	28.0533	28.0667	27.72	27.8333	182250.0
2019-02-26	AAP	Stock	163.0	165.83	161.48	162.92	2112600.0
2019-02-26	AAT	Stock	43.42	43.85	43.34	43.69	147400.0
2019-02-26	AAU-DELISTED	Stock	0.67	0.6986	0.67	0.6843	210769.0
2019-02-26	AAUAF-DELISTED	Stock	0.67	0.6986	0.67	0.6737	221806.0
2019-02-26	AAWW-DELISTED	Stock	55.39	56.12	54.89	54.9	234261.0
2019-02-26	AAXJ	Stock	70.18	70.66	70.13	70.49	1560322.0
2019-02-26	AAXN-DELISTED	Stock	58.62	60.3	58.52	60.2	1425913.0
2019-02-26	AB	Stock	29.2	29.36	28.74	28.9	303900.0
2019-02-26	ABB-DELISTED	Stock	20.39	20.55	20.38	20.485	4408653.0
2019-02-26	ABBNY-DELISTED	Stock	20.39	20.55	20.38	20.48	4495004.0
2019-02-26	ABBV	Stock	80.2	80.86	80.02	80.51	4283100.0
2019-02-26	ABC-DELISTED	Stock	84.8	84.98	83.88	83.93	661357.0
2019-02-26	ABCB	Stock	41.29	41.67	40.79	40.85	332100.0
2019-02-26	ABDC-DELISTED	Stock	7.03	7.2672	6.98	7.25	38930.0
2019-02-26	ABEO	Stock	181.75	182.75	174.5	176.75	18228.0
2019-02-26	ABEOW-DELISTED	Stock	3.35	3.35	3.35	3.35	1500.0
2019-02-26	ABEV	Stock	4.88	4.92	4.83	4.87	27257500.0
2019-02-26	ABG	Stock	71.13	71.68	70.16	71.38	95800.0
2019-02-26	ABIL-DELISTED	Stock	1.88	1.9186	1.86	1.89	77890.0
2019-02-26	ABM	Stock	36.5	36.69	36.03	36.06	369600.0
2019-02-26	ABMD-DELISTED	Stock	350.72	352.0	337.635	342.86	420555.0
2019-02-26	ABR	Stock	13.06	13.23	13.0	13.06	1369000.0
2019-02-26	ABR.A-DELISTED	Stock	25.65	25.65	25.48	25.55	1855.0
2019-02-26	ABR.B-DELISTED	Stock	25.4999	25.4999	25.27	25.3963	1900.0
2019-02-26	ABR.C-DELISTED	Stock	25.42	25.42	25.4	25.4	450.0
2019-02-26	ABT	Stock	76.58	77.12	76.38	76.75	5295400.0

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

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