PREVIEW / stock_daily / 2018-09-10

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-10.parquet
  size:    218 KB
  rows:    6,513
  symbols: 2,736

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-09-10	AAPL	Stock	55.2375	55.4625	54.1175	54.5825	158066000.0
2018-09-10	MSFT	Stock	108.84	109.64	108.36	109.38	20727900.0
2018-09-10	NVDA	Stock	6.8192	6.8983	6.775	6.8682	220140000.0
2018-09-10	AMZN	Stock	98.55	98.652	96.576	96.9505	90896000.0
2018-09-10	GOOGL	Stock	59.21	59.333	58.5305	58.753	27678760.0
2018-09-10	META	Stock	163.51	165.01	162.16	164.18	20197700.0
2018-09-10	TSLA	Stock	18.2173	19.0687	18.0667	19.0333	214252500.0
2018-09-10	TLT	Stock	119.17	119.6	119.17	119.57	6386352.0
2018-09-10	ES	Stock	62.92	63.54	62.79	63.3	1032400.0
2018-09-10	CL	Stock	67.01	67.64	67.0	67.16	3353200.0
2018-09-10	A	Stock	67.82	68.41	67.72	67.93	2065700.0
2018-09-10	AA	Stock	42.09	42.69	41.64	42.01	3405900.0
2018-09-10	AABA-DELISTED	Stock	63.5	64.44	63.08	63.76	12618224.0
2018-09-10	AAC-DELISTED	Stock	7.79	7.79	7.07	7.14	135731.0
2018-09-10	AACG	Stock	1.72	1.72	1.11	1.44	1383800.0
2018-09-10	AAIC-DELISTED	Stock	10.23	10.26	10.2	10.24	201961.0
2018-09-10	AAL	Stock	38.66	39.49	38.49	39.43	3901000.0
2018-09-10	AAM.A-DELISTED	Stock	25.28	25.44	25.28	25.3922	7075.0
2018-09-10	AAM.B-DELISTED	Stock	25.07	25.07	24.92	25.008	56294.0
2018-09-10	AAME	Stock	3.05	3.05	2.95	3.03	6400.0
2018-09-10	AAMI	Stock	12.68	12.87	12.63	12.65	397000.0
2018-09-10	AAOI	Stock	32.07	33.36	31.9	33.13	752000.0
2018-09-10	AAON	Stock	26.3	26.6	26.1333	26.1667	213750.0
2018-09-10	AAP	Stock	168.47	169.09	166.14	166.93	910200.0
2018-09-10	AAT	Stock	38.54	39.13	38.54	38.86	245800.0
2018-09-10	AAU-DELISTED	Stock	0.66	0.66	0.6327	0.6327	98798.0
2018-09-10	AAUAF-DELISTED	Stock	0.66	0.66	0.6327	0.6327	108118.0
2018-09-10	AAV-DELISTED	Stock	2.5	2.5775	2.4	2.475	89493.0
2018-09-10	AAWW-DELISTED	Stock	61.7	64.0	61.55	63.45	226352.0
2018-09-10	AAXJ	Stock	68.55	68.57	67.95	68.02	1197471.0
2018-09-10	AAXN-DELISTED	Stock	70.96	72.05	70.54	71.89	436880.0
2018-09-10	AB	Stock	30.2	30.7	30.2	30.6	199300.0
2018-09-10	ABAC-DELISTED	Stock	1.79	1.8154	1.65	1.7445	48776.0
2018-09-10	ABB-DELISTED	Stock	23.43	23.465	23.28	23.31	796041.0
2018-09-10	ABBNY-DELISTED	Stock	23.42	23.465	23.28	23.31	837457.0
2018-09-10	ABBV	Stock	94.98	95.17	93.7	93.82	3156800.0
2018-09-10	ABC-DELISTED	Stock	88.71	89.48	88.2	88.34	824530.0
2018-09-10	ABCB	Stock	49.75	49.75	48.05	48.55	390700.0
2018-09-10	ABCD-DELISTED	Stock	12.42	12.61	12.28	12.37	45487.0
2018-09-10	ABDC-DELISTED	Stock	6.14	6.17	6.1001	6.13	11384.0
2018-09-10	ABEO	Stock	342.5	348.75	333.75	337.5	14380.0
2018-09-10	ABEOW-DELISTED	Stock	8.5	8.5	8.5	8.5	1000.0
2018-09-10	ABEV	Stock	4.47	4.5	4.43	4.46	23437400.0
2018-09-10	ABG	Stock	72.55	73.95	72.5	72.75	175600.0
2018-09-10	ABIL-DELISTED	Stock	3.4	3.4095	3.08	3.27	139351.0
2018-09-10	ABM	Stock	33.8	34.65	33.8	33.97	1062900.0
2018-09-10	ABMD-DELISTED	Stock	381.27	389.56	378.5699	388.48	323910.0
2018-09-10	ABR	Stock	12.06	12.12	12.03	12.11	729800.0
2018-09-10	ABR.A-DELISTED	Stock	25.83	25.98	25.83	25.83	1700.0
2018-09-10	ABR.B-DELISTED	Stock	25.46	25.46	25.46	25.46	100.0

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

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