PREVIEW / stock_daily / 2019-02-27

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-27.parquet
  size:    219 KB
  rows:    6,505
  symbols: 2,616

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-27	AAPL	Stock	43.3025	43.75	43.1825	43.7175	111341600.0
2019-02-27	MSFT	Stock	111.69	112.36	110.88	112.17	21487100.0
2019-02-27	NVDA	Stock	3.913	3.9398	3.8278	3.8852	500256000.0
2019-02-27	AMZN	Stock	81.409	82.0905	80.755	82.0545	62976000.0
2019-02-27	GOOGL	Stock	55.7005	56.2865	55.428	56.1445	22097620.0
2019-02-27	META	Stock	162.9	163.93	160.41	162.81	12697500.0
2019-02-27	TSLA	Stock	20.1187	21.0867	20.0367	20.9827	167758500.0
2019-02-27	TLT	Stock	121.12	121.13	120.2799	120.43	7737411.0
2019-02-27	ES	Stock	69.42	69.71	69.17	69.66	1333500.0
2019-02-27	CL	Stock	66.05	66.34	65.76	65.87	3378300.0
2019-02-27	A	Stock	78.25	79.55	78.25	79.42	1254400.0
2019-02-27	AA	Stock	31.07	31.45	30.79	30.98	2880100.0
2019-02-27	AABA-DELISTED	Stock	73.77	74.87	73.62	74.7058	6169971.0
2019-02-27	AAC-DELISTED	Stock	3.05	3.05	2.6376	2.81	296237.0
2019-02-27	AACG	Stock	1.12	1.16	1.11	1.13	129100.0
2019-02-27	AAIC-DELISTED	Stock	8.25	8.3801	8.225	8.34	1173101.0
2019-02-27	AAL	Stock	36.11	36.33	35.27	35.69	5874900.0
2019-02-27	AAM.A-DELISTED	Stock	25.09	25.09	24.9974	25.05	17955.0
2019-02-27	AAM.B-DELISTED	Stock	24.7	24.7199	24.6	24.69	84765.0
2019-02-27	AAMC-DELISTED	Stock	11.5647	11.8029	9.9971	10.7441	24983.0
2019-02-27	AAME	Stock	2.8	2.8	2.8	2.8	100.0
2019-02-27	AAMI	Stock	14.14	14.28	14.11	14.25	342400.0
2019-02-27	AAOI	Stock	16.37	16.81	15.93	16.35	953400.0
2019-02-27	AAON	Stock	27.5733	27.8533	27.16	27.7067	219750.0
2019-02-27	AAP	Stock	162.59	162.78	156.68	158.3	1149800.0
2019-02-27	AAT	Stock	43.44	43.56	42.94	43.32	114800.0
2019-02-27	AAU-DELISTED	Stock	0.67	0.68	0.644	0.6623	212151.0
2019-02-27	AAUAF-DELISTED	Stock	0.67	0.68	0.644	0.6701	213992.0
2019-02-27	AAWW-DELISTED	Stock	54.93	55.26	54.23	54.54	192455.0
2019-02-27	AAXJ	Stock	70.02	70.18	69.71	69.92	968700.0
2019-02-27	AAXN-DELISTED	Stock	55.46	55.65	51.6001	55.46	2257372.0
2019-02-27	AB	Stock	28.8	29.18	28.7	29.07	200200.0
2019-02-27	ABB-DELISTED	Stock	20.33	20.48	20.24	20.43	2712327.0
2019-02-27	ABBNY-DELISTED	Stock	20.33	20.48	20.24	20.43	2838342.0
2019-02-27	ABBV	Stock	80.14	80.14	78.8	79.41	4175500.0
2019-02-27	ABC-DELISTED	Stock	83.67	83.87	82.45	82.81	1753826.0
2019-02-27	ABCB	Stock	40.84	41.39	40.66	41.09	321600.0
2019-02-27	ABDC-DELISTED	Stock	7.3343	7.34	7.06	7.14	21431.0
2019-02-27	ABEO	Stock	175.75	183.25	172.75	177.5	13036.0
2019-02-27	ABEV	Stock	4.87	4.92	4.84	4.89	30379900.0
2019-02-27	ABG	Stock	71.45	72.75	71.45	71.57	158300.0
2019-02-27	ABIL-DELISTED	Stock	1.88	1.8954	1.842	1.87	54902.0
2019-02-27	ABM	Stock	36.03	36.09	35.57	35.73	285300.0
2019-02-27	ABMD-DELISTED	Stock	339.17	345.0	334.53	336.4	316154.0
2019-02-27	ABR	Stock	13.06	13.07	12.9	13.06	1015500.0
2019-02-27	ABR.A-DELISTED	Stock	25.55	25.55	25.4022	25.4022	2227.0
2019-02-27	ABR.B-DELISTED	Stock	25.379	25.379	25.27	25.3737	300.0
2019-02-27	ABR.C-DELISTED	Stock	25.4058	25.53	25.4	25.53	1732.0
2019-02-27	ABT	Stock	76.45	77.33	76.33	77.23	5706500.0
2019-02-27	ABTC	Stock	304200.0	304200.0	302400.0	302760.0	0.43999999999999995

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

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