PREVIEW / stock_daily / 2018-02-13

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-13.parquet
  size:    216 KB
  rows:    6,475
  symbols: 2,855

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
2018-02-13	AAPL	Stock	40.4875	41.1875	40.4125	41.085	130196800.0
2018-02-13	MSFT	Stock	88.93	90.0	87.8	89.83	26407700.0
2018-02-13	NVDA	Stock	5.664	5.8625	5.6313	5.8158	625524000.0
2018-02-13	AMZN	Stock	69.2965	70.986	69.1765	70.7255	118358000.0
2018-02-13	GOOGL	Stock	52.5	53.061	52.346	52.707	31585160.0
2018-02-13	META	Stock	175.62	175.97	173.1	173.15	21809400.0
2018-02-13	TSLA	Stock	21.0013	21.6127	20.834	21.5773	68403000.0
2018-02-13	TLT	Stock	118.61	119.0101	118.39	118.99	8157569.0
2018-02-13	ES	Stock	57.23	57.79	56.62	57.62	1787800.0
2018-02-13	CL	Stock	69.95	70.45	69.69	70.3	3528600.0
2018-02-13	A	Stock	67.97	68.49	67.66	68.34	1825500.0
2018-02-13	AA	Stock	46.39	47.98	46.12	47.3	2811000.0
2018-02-13	AABA-DELISTED	Stock	70.72	72.44	70.55	71.295	4226672.0
2018-02-13	AAC-DELISTED	Stock	8.05	8.21	7.97	8.19	53518.0
2018-02-13	AACG	Stock	5.55	5.56	5.32	5.56	7100.0
2018-02-13	AAIC-DELISTED	Stock	10.66	10.96	10.62	10.89	622800.0
2018-02-13	AAL	Stock	49.7	50.92	49.64	50.87	3758000.0
2018-02-13	AAM.A-DELISTED	Stock	25.22	25.38	25.15	25.15	59000.0
2018-02-13	AAME	Stock	3.2	3.3	3.2	3.25	1900.0
2018-02-13	AAMI	Stock	15.44	15.8	15.4	15.77	872000.0
2018-02-13	AAOI	Stock	29.3	29.71	28.56	29.51	1388800.0
2018-02-13	AAON	Stock	22.3	22.6667	22.0667	22.6	163650.0
2018-02-13	AAP	Stock	109.17	109.99	105.96	106.22	1392100.0
2018-02-13	AAT	Stock	32.54	33.09	32.32	32.98	147300.0
2018-02-13	AAU-DELISTED	Stock	0.8913	0.93	0.8913	0.9297	157062.0
2018-02-13	AAUAF-DELISTED	Stock	0.8913	0.93	0.8913	0.93	166624.0
2018-02-13	AAV-DELISTED	Stock	3.1	3.1	2.95	2.975	116814.0
2018-02-13	AAWW-DELISTED	Stock	53.05	54.3	53.05	54.0	149032.0
2018-02-13	AAXJ	Stock	75.39	76.09	75.33	75.96	1245442.0
2018-02-13	AAXN-DELISTED	Stock	25.58	27.04	25.52	26.84	803803.0
2018-02-13	AB	Stock	26.7	27.15	26.3	26.35	406600.0
2018-02-13	ABAC-DELISTED	Stock	2.58	2.63	2.47	2.47	34853.0
2018-02-13	ABAX-DELISTED	Stock	65.02	66.11	64.5	65.43	149184.0
2018-02-13	ABB-DELISTED	Stock	24.38	24.445	24.2666	24.35	1625841.0
2018-02-13	ABBNY-DELISTED	Stock	24.38	24.445	24.2666	24.36	1710952.0
2018-02-13	ABBV	Stock	111.54	112.41	110.39	111.86	5316200.0
2018-02-13	ABC-DELISTED	Stock	100.1274	102.0	94.549	96.37	9184816.0
2018-02-13	ABCB	Stock	52.25	52.85	52.05	52.6	150700.0
2018-02-13	ABCD-DELISTED	Stock	6.93	7.2	6.9	7.1989	74936.0
2018-02-13	ABDC-DELISTED	Stock	7.47	7.65	7.42	7.56	18759.0
2018-02-13	ABE-DELISTED	Stock	15.01	15.01	14.84	14.91	7675.0
2018-02-13	ABEO	Stock	315.0	320.0	287.5	297.5	84272.0
2018-02-13	ABEOW-DELISTED	Stock	7.2	7.26	6.8267	7.2	8397.0
2018-02-13	ABEV	Stock	6.65	6.7	6.63	6.67	12747600.0
2018-02-13	ABG	Stock	68.65	69.05	66.95	67.9	108500.0
2018-02-13	ABIL-DELISTED	Stock	0.3988	0.3988	0.3693	0.381	104507.0
2018-02-13	ABLX-DELISTED	Stock	53.9	54.06	53.8201	53.989	48921.0
2018-02-13	ABM	Stock	35.21	35.49	34.95	35.29	337500.0
2018-02-13	ABMD-DELISTED	Stock	230.04	236.14	225.5	234.03	239335.0
2018-02-13	ABR	Stock	8.09	8.28	8.08	8.25	420500.0

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

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