PREVIEW / stock_daily / 2018-03-13

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-13.parquet
  size:    217 KB
  rows:    6,479
  symbols: 2,836

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-03-13	AAPL	Stock	45.6475	45.875	44.81	44.9925	126774000.0
2018-03-13	MSFT	Stock	97.0	97.24	93.97	94.41	35387800.0
2018-03-13	NVDA	Stock	6.2872	6.3625	6.151	6.1928	619772000.0
2018-03-13	AMZN	Stock	80.798	80.877	78.9005	79.409	130638000.0
2018-03-13	GOOGL	Stock	58.5915	58.9	56.7285	56.9955	43139980.0
2018-03-13	META	Stock	185.61	185.99	181.11	181.88	18067500.0
2018-03-13	TSLA	Stock	21.9073	23.1473	21.7667	22.7893	89487000.0
2018-03-13	TLT	Stock	118.98	119.3678	118.5	119.19	7455302.0
2018-03-13	ES	Stock	57.26	57.45	56.34	56.68	2845700.0
2018-03-13	CL	Stock	71.24	71.4	70.51	70.87	4666500.0
2018-03-13	A	Stock	71.0	71.52	70.42	70.68	1728100.0
2018-03-13	AA	Stock	48.43	49.85	48.43	48.59	2746000.0
2018-03-13	AABA-DELISTED	Stock	77.98	78.05	75.68	75.93	3142611.0
2018-03-13	AAC-DELISTED	Stock	12.25	12.3	11.77	11.93	198644.0
2018-03-13	AACG	Stock	5.15	5.25	5.15	5.25	11500.0
2018-03-13	AAIC-DELISTED	Stock	11.72	11.92	11.72	11.81	353368.0
2018-03-13	AAL	Stock	56.86	57.44	56.03	56.23	4361800.0
2018-03-13	AAM.A-DELISTED	Stock	25.15	25.21	25.12	25.18	72339.0
2018-03-13	AAMC-DELISTED	Stock	19.5588	19.5588	19.1176	19.1176	12519.0
2018-03-13	AAME	Stock	3.35	3.35	3.25	3.3	5700.0
2018-03-13	AAMI	Stock	16.07	16.19	15.85	15.92	1247700.0
2018-03-13	AAOI	Stock	30.84	31.0	28.8	29.51	1906000.0
2018-03-13	AAON	Stock	25.5667	25.9667	25.3667	25.7667	342450.0
2018-03-13	AAP	Stock	118.75	120.1	117.26	119.0	942500.0
2018-03-13	AAT	Stock	32.85	33.36	32.85	33.14	836500.0
2018-03-13	AAU-DELISTED	Stock	0.8812	0.8851	0.8501	0.87	70196.0
2018-03-13	AAUAF-DELISTED	Stock	0.8812	0.8851	0.8501	0.87	72202.0
2018-03-13	AAV-DELISTED	Stock	2.85	2.89	2.8	2.825	393002.0
2018-03-13	AAWW-DELISTED	Stock	61.8	62.6	61.7	62.4	160219.0
2018-03-13	AAXJ	Stock	80.11	80.25	78.95	79.21	2219029.0
2018-03-13	AAXN-DELISTED	Stock	39.56	39.88	38.95	39.35	598057.0
2018-03-13	AB	Stock	27.1	27.17	26.5	26.75	403500.0
2018-03-13	ABAC-DELISTED	Stock	2.46	2.6052	2.46	2.5767	1243.0
2018-03-13	ABAX-DELISTED	Stock	74.47	74.6	72.16	72.66	60476.0
2018-03-13	ABB-DELISTED	Stock	24.59	24.62	24.185	24.23	1185340.0
2018-03-13	ABBNY-DELISTED	Stock	24.59	24.62	24.185	24.23	1263528.0
2018-03-13	ABBV	Stock	119.26	121.45	118.73	119.75	5403200.0
2018-03-13	ABC-DELISTED	Stock	100.44	101.39	100.34	100.61	1340152.0
2018-03-13	ABCB	Stock	57.75	57.75	56.85	57.4	228900.0
2018-03-13	ABCD-DELISTED	Stock	9.15	9.56	8.8236	9.49	208629.0
2018-03-13	ABDC-DELISTED	Stock	7.7	7.8	7.66	7.74	37147.0
2018-03-13	ABE-DELISTED	Stock	15.3	15.4	15.108	15.108	2615.0
2018-03-13	ABEO	Stock	400.0	408.75	373.25	377.5	45212.0
2018-03-13	ABEV	Stock	7.32	7.4	7.24	7.28	24462700.0
2018-03-13	ABG	Stock	69.25	69.7	68.3	68.4	118800.0
2018-03-13	ABIL-DELISTED	Stock	0.42	0.42	0.4005	0.404	50458.0
2018-03-13	ABLX-DELISTED	Stock	54.28	54.41	54.16	54.16	78240.0
2018-03-13	ABM	Stock	38.12	38.37	37.47	37.55	581400.0
2018-03-13	ABMD-DELISTED	Stock	295.73	299.2	290.12	292.94	228300.0
2018-03-13	ABR	Stock	8.88	8.93	8.76	8.77	679400.0

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

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