PREVIEW / stock_daily / 2017-07-12

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-12.parquet
  size:    213 KB
  rows:    6,455
  symbols: 2,977

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
2017-07-12	AAPL	Stock	36.4675	36.545	36.205	36.435	99538000.0
2017-07-12	MSFT	Stock	70.69	71.28	70.55	71.15	17750900.0
2017-07-12	NVDA	Stock	3.9575	4.075	3.914	4.0628	1145208000.0
2017-07-12	AMZN	Stock	50.0325	50.4275	49.905	50.3255	72172000.0
2017-07-12	GOOGL	Stock	48.043	48.4815	47.852	48.383	32042300.0
2017-07-12	META	Stock	156.49	159.16	156.2	158.9	22739400.0
2017-07-12	TSLA	Stock	22.0267	22.2067	21.6333	21.968	155191500.0
2017-07-12	TLT	Stock	123.89	124.04	123.49	123.96	7839923.0
2017-07-12	ES	Stock	60.31	60.56	59.95	60.02	1616800.0
2017-07-12	CL	Stock	72.75	72.86	72.22	72.28	2192100.0
2017-07-12	A	Stock	60.33	60.99	60.16	60.73	1439400.0
2017-07-12	AA	Stock	35.25	35.47	34.44	34.6	4334400.0
2017-07-12	AAAP-DELISTED	Stock	39.96	41.3938	39.81	40.245	249278.0
2017-07-12	AABA-DELISTED	Stock	55.66	56.57	55.66	56.28	5179837.0
2017-07-12	AAC-DELISTED	Stock	6.58	6.73	6.36	6.41	80402.0
2017-07-12	AACG	Stock	4.65	4.65	4.46	4.53	12400.0
2017-07-12	AAIC-DELISTED	Stock	13.74	13.9199	13.74	13.82	188061.0
2017-07-12	AAL	Stock	53.12	53.83	52.45	53.8	8348400.0
2017-07-12	AAM.A-DELISTED	Stock	25.8	25.95	25.8	25.85	58289.0
2017-07-12	AAMC-DELISTED	Stock	26.9412	27.0588	26.8971	26.8971	38406.0
2017-07-12	AAME	Stock	3.7	3.7	3.65	3.65	3000.0
2017-07-12	AAMI	Stock	15.38	15.48	15.301	15.35	305600.0
2017-07-12	AAOI	Stock	70.55	72.95	69.8	72.64	2641900.0
2017-07-12	AAON	Stock	25.0333	25.1667	24.7333	25.0333	99300.0
2017-07-12	AAP	Stock	101.03	102.43	100.5	100.94	1997100.0
2017-07-12	AAT	Stock	38.67	39.21	38.67	38.96	162500.0
2017-07-12	AAU-DELISTED	Stock	1.12	1.17	1.12	1.14	235326.0
2017-07-12	AAUAF-DELISTED	Stock	1.12	1.17	1.12	1.16	237117.0
2017-07-12	AAV-DELISTED	Stock	6.7	7.0	6.7	6.85	266755.0
2017-07-12	AAWW-DELISTED	Stock	58.55	59.2	57.075	57.55	697990.0
2017-07-12	AAXJ	Stock	68.83	69.38	68.81	69.33	5801624.0
2017-07-12	AAXN-DELISTED	Stock	25.42	25.71	25.28	25.47	346312.0
2017-07-12	AB	Stock	24.05	24.5	24.05	24.25	243600.0
2017-07-12	ABAC-DELISTED	Stock	2.42	2.66	2.3841	2.6599	32014.0
2017-07-12	ABAX-DELISTED	Stock	52.69	53.94	52.25	52.56	83323.0
2017-07-12	ABB-DELISTED	Stock	25.14	25.32	25.1259	25.27	1891745.0
2017-07-12	ABBNY-DELISTED	Stock	25.14	25.32	25.1259	25.26	1928700.0
2017-07-12	ABBV	Stock	71.51	72.13	71.3	71.88	4860200.0
2017-07-12	ABC-DELISTED	Stock	92.84	93.7	92.61	93.18	538354.0
2017-07-12	ABCB	Stock	47.65	48.2	46.94	47.2	191700.0
2017-07-12	ABCD-DELISTED	Stock	5.03	5.03	4.94	4.95	8271.0
2017-07-12	ABCO-DELISTED	Stock	56.0	57.0	55.75	56.9	425994.0
2017-07-12	ABDC-DELISTED	Stock	13.41	13.49	13.3507	13.47	24438.0
2017-07-12	ABE-DELISTED	Stock	14.66	14.66	13.9668	14.16	5045.0
2017-07-12	ABEO	Stock	223.75	230.0	221.25	225.0	23668.0
2017-07-12	ABEOW-DELISTED	Stock	5.1	5.1	5.0668	5.0668	395.0
2017-07-12	ABEV	Stock	5.74	5.8	5.69	5.78	25063300.0
2017-07-12	ABG	Stock	56.1	57.8	55.4	56.65	217300.0
2017-07-12	ABIL-DELISTED	Stock	1.1	1.1	1.02	1.08	47152.0
2017-07-12	ABM	Stock	41.58	42.9	41.23	41.88	624700.0

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

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