PREVIEW / stock_daily / 2018-02-21

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-21.parquet
  size:    217 KB
  rows:    6,485
  symbols: 2,850

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-21	AAPL	Stock	43.2075	43.53	42.7525	42.7675	149886400.0
2018-02-21	MSFT	Stock	92.98	93.36	91.49	91.49	26922500.0
2018-02-21	NVDA	Stock	6.2922	6.2993	6.034	6.0378	892292000.0
2018-02-21	AMZN	Stock	74.25	75.1745	73.946	74.146	126088000.0
2018-02-21	GOOGL	Stock	55.455	56.81	55.3755	55.6875	41486420.0
2018-02-21	META	Stock	176.71	181.27	176.4	177.91	23200800.0
2018-02-21	TSLA	Stock	22.402	22.646	22.2113	22.22	48294000.0
2018-02-21	TLT	Stock	118.24	118.29	116.51	116.74	12054315.0
2018-02-21	ES	Stock	58.11	58.64	57.34	57.36	1900700.0
2018-02-21	CL	Stock	69.98	70.45	69.14	69.14	2749100.0
2018-02-21	A	Stock	71.12	72.7	70.97	71.25	1995600.0
2018-02-21	AA	Stock	48.21	48.95	47.23	47.55	3194900.0
2018-02-21	AABA-DELISTED	Stock	75.26	76.71	75.04	75.12	6509361.0
2018-02-21	AAC-DELISTED	Stock	8.13	8.71	8.13	8.38	97161.0
2018-02-21	AACG	Stock	5.36	5.57	5.35	5.57	9700.0
2018-02-21	AAIC-DELISTED	Stock	11.26	11.44	11.22	11.28	542120.0
2018-02-21	AAL	Stock	51.96	53.86	51.83	52.78	5396700.0
2018-02-21	AAM.A-DELISTED	Stock	25.4	25.5	25.28	25.3	32337.0
2018-02-21	AAME	Stock	3.45	3.47	3.4	3.47	1300.0
2018-02-21	AAMI	Stock	15.61	16.05	15.61	15.69	567300.0
2018-02-21	AAOI	Stock	33.66	34.98	32.31	34.55	2319700.0
2018-02-21	AAON	Stock	22.9333	23.4333	22.9	22.9667	168750.0
2018-02-21	AAP	Stock	116.96	119.3	113.23	114.0	5545200.0
2018-02-21	AAT	Stock	32.06	32.42	31.86	31.88	347900.0
2018-02-21	AAU-DELISTED	Stock	0.92	0.9293	0.9047	0.9104	88434.0
2018-02-21	AAUAF-DELISTED	Stock	0.92	0.9293	0.9047	0.9182	98776.0
2018-02-21	AAV-DELISTED	Stock	2.85	3.05	2.85	2.95	375356.0
2018-02-21	AAWW-DELISTED	Stock	55.1	56.25	55.0	55.25	277569.0
2018-02-21	AAXJ	Stock	78.55	79.39	77.87	77.89	503610.0
2018-02-21	AAXN-DELISTED	Stock	28.16	28.71	28.06	28.1	408844.0
2018-02-21	AB	Stock	27.8	28.15	27.7	27.85	575400.0
2018-02-21	ABAC-DELISTED	Stock	2.23	2.434	2.1807	2.3	10509.0
2018-02-21	ABAX-DELISTED	Stock	67.67	69.37	67.3801	68.5	104530.0
2018-02-21	ABB-DELISTED	Stock	25.06	25.305	24.93	24.93	1784523.0
2018-02-21	ABBNY-DELISTED	Stock	25.07	25.305	24.93	24.93	1862407.0
2018-02-21	ABBV	Stock	118.49	121.3	117.85	117.91	5122500.0
2018-02-21	ABC-DELISTED	Stock	99.82	99.96	98.34	98.61	2330865.0
2018-02-21	ABCB	Stock	53.95	55.15	53.75	54.45	230500.0
2018-02-21	ABCD-DELISTED	Stock	7.27	7.38	7.17	7.2	33523.0
2018-02-21	ABDC-DELISTED	Stock	7.63	7.8	7.6	7.77	47546.0
2018-02-21	ABE-DELISTED	Stock	15.15	15.27	15.1	15.14	6655.0
2018-02-21	ABEO	Stock	287.5	310.0	285.0	292.5	39168.0
2018-02-21	ABEOW-DELISTED	Stock	8.17	8.17	6.91	7.01	8504.0
2018-02-21	ABEV	Stock	6.95	6.96	6.78	6.81	32421900.0
2018-02-21	ABG	Stock	68.25	69.6	67.4	67.5	179500.0
2018-02-21	ABIL-DELISTED	Stock	0.392	0.392	0.371	0.3805	40349.0
2018-02-21	ABLX-DELISTED	Stock	54.09	54.17	53.83	53.84	53728.0
2018-02-21	ABM	Stock	36.93	37.1	36.21	36.21	639300.0
2018-02-21	ABMD-DELISTED	Stock	271.99	273.9999	267.78	268.25	381412.0
2018-02-21	ABR	Stock	8.39	8.47	8.36	8.41	437600.0

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

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