PREVIEW / stock_daily / 2018-01-29

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-29.parquet
  size:    217 KB
  rows:    6,508
  symbols: 2,880

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-01-29	AAPL	Stock	42.54	42.54	41.7675	41.99	202561600.0
2018-01-29	MSFT	Stock	95.14	95.45	93.72	93.92	31569900.0
2018-01-29	NVDA	Stock	6.0685	6.2028	6.0153	6.1713	455116000.0
2018-01-29	AMZN	Stock	70.459	71.5695	70.022	70.884	114038000.0
2018-01-29	GOOGL	Stock	59.4	59.9	59.203	59.324	31494160.0
2018-01-29	META	Stock	188.75	188.84	185.63	185.98	20453200.0
2018-01-29	TSLA	Stock	22.6567	23.39	22.552	23.302	71206500.0
2018-01-29	TLT	Stock	122.97	122.97	122.3	122.73	12223038.0
2018-01-29	ES	Stock	63.52	63.84	62.2	62.44	2827100.0
2018-01-29	CL	Stock	73.41	74.4	72.83	73.79	8636800.0
2018-01-29	A	Stock	74.48	75.0	74.3	74.53	1321900.0
2018-01-29	AA	Stock	53.89	54.63	53.52	54.49	4648600.0
2018-01-29	AAAP-DELISTED	Stock	81.95	82.05	81.95	82.01	18240.0
2018-01-29	AABA-DELISTED	Stock	80.0	80.43	78.97	79.34	7843543.0
2018-01-29	AAC-DELISTED	Stock	9.17	9.78	9.17	9.49	164049.0
2018-01-29	AACG	Stock	5.06	5.1	5.0	5.02	11300.0
2018-01-29	AAIC-DELISTED	Stock	11.17	11.17	10.7499	10.84	762234.0
2018-01-29	AAL	Stock	52.79	53.16	52.59	52.68	5953700.0
2018-01-29	AAM.A-DELISTED	Stock	25.3801	25.46	25.1	25.26	66653.0
2018-01-29	AAME	Stock	3.6	3.85	3.6	3.8	8800.0
2018-01-29	AAMI	Stock	18.3	18.37	18.15	18.19	509500.0
2018-01-29	AAOI	Stock	34.63	34.88	33.05	33.33	1725400.0
2018-01-29	AAON	Stock	24.0667	24.2	23.9	24.0333	438900.0
2018-01-29	AAP	Stock	123.52	123.63	122.72	122.89	1403700.0
2018-01-29	AAT	Stock	35.63	35.63	34.88	35.02	274100.0
2018-01-29	AAU-DELISTED	Stock	0.91	0.9123	0.8803	0.895	357448.0
2018-01-29	AAUAF-DELISTED	Stock	0.91	0.9123	0.8803	0.895	372861.0
2018-01-29	AAV-DELISTED	Stock	3.6	3.6	3.425	3.425	247708.0
2018-01-29	AAWW-DELISTED	Stock	59.65	60.35	58.95	59.05	115847.0
2018-01-29	AAXJ	Stock	82.65	82.71	82.25	82.31	2691806.0
2018-01-29	AAXN-DELISTED	Stock	27.4	27.63	27.205	27.41	482345.0
2018-01-29	AB	Stock	27.85	28.0	27.45	27.7	237000.0
2018-01-29	ABAC-DELISTED	Stock	2.9	2.96	2.851	2.95	7747.0
2018-01-29	ABAX-DELISTED	Stock	75.75	78.53	75.03	76.0	391472.0
2018-01-29	ABB-DELISTED	Stock	28.36	28.42	28.03	28.06	2006373.0
2018-01-29	ABBNY-DELISTED	Stock	28.36	28.42	28.03	28.06	2115822.0
2018-01-29	ABBV	Stock	121.5	124.15	118.98	122.31	10182700.0
2018-01-29	ABC-DELISTED	Stock	105.14	106.27	104.865	105.09	1234892.0
2018-01-29	ABCB	Stock	55.35	55.5	54.75	55.1	210700.0
2018-01-29	ABCD-DELISTED	Stock	7.3	7.3	7.14	7.2	117908.0
2018-01-29	ABDC-DELISTED	Stock	8.25	8.288	8.1	8.12	60155.0
2018-01-29	ABE-DELISTED	Stock	15.66	15.72	15.6	15.7	11389.0
2018-01-29	ABEO	Stock	425.0	461.25	405.0	407.5	91664.0
2018-01-29	ABEOW-DELISTED	Stock	12.0	13.255	11.39	11.845	7957.0
2018-01-29	ABEV	Stock	6.84	6.88	6.79	6.82	15060400.0
2018-01-29	ABG	Stock	75.3	75.85	74.75	75.35	192700.0
2018-01-29	ABIL-DELISTED	Stock	0.48	0.4879	0.45	0.4552	75955.0
2018-01-29	ABLX-DELISTED	Stock	54.33	54.54	53.015	53.64	1885198.0
2018-01-29	ABM	Stock	38.59	39.02	38.51	38.71	426500.0
2018-01-29	ABMD-DELISTED	Stock	239.0	239.92	235.87	236.64	235701.0

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

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