PREVIEW / stock_daily / 2018-02-07

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-07.parquet
  size:    217 KB
  rows:    6,484
  symbols: 2,872

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-07	AAPL	Stock	40.7725	40.85	39.7675	39.885	206434400.0
2018-02-07	MSFT	Stock	90.49	91.77	89.2	89.61	41107600.0
2018-02-07	NVDA	Stock	5.7395	5.8742	5.6675	5.72	802932000.0
2018-02-07	AMZN	Stock	72.45	73.0495	70.7575	70.839	143254000.0
2018-02-07	GOOGL	Stock	54.2485	54.3265	52.731	52.7705	51941880.0
2018-02-07	META	Stock	184.15	185.08	179.95	180.18	27601900.0
2018-02-07	TSLA	Stock	22.5993	23.0667	22.3773	23.0	104538000.0
2018-02-07	TLT	Stock	120.13	120.33	118.56	118.82	16271063.0
2018-02-07	ES	Stock	57.55	58.21	56.88	56.89	3236300.0
2018-02-07	CL	Stock	70.4	71.04	70.02	70.17	4413200.0
2018-02-07	A	Stock	68.19	69.08	67.91	68.06	1988100.0
2018-02-07	AA	Stock	49.23	49.42	47.67	47.7	3176800.0
2018-02-07	AAAP-DELISTED	Stock	81.3	81.6	81.3	81.5	12171.0
2018-02-07	AABA-DELISTED	Stock	73.16	74.19	72.1	72.15	2742972.0
2018-02-07	AAC-DELISTED	Stock	8.26	8.35	8.05	8.11	78800.0
2018-02-07	AACG	Stock	5.99	6.11	5.6	6.0	93000.0
2018-02-07	AAIC-DELISTED	Stock	10.95	11.0	10.64	10.73	1082356.0
2018-02-07	AAL	Stock	50.91	51.98	50.89	51.4	4845800.0
2018-02-07	AAM.A-DELISTED	Stock	25.5	25.6	25.3898	25.57	12007.0
2018-02-07	AAMI	Stock	16.47	16.72	16.4	16.51	861300.0
2018-02-07	AAOI	Stock	33.86	33.86	30.85	31.53	2218400.0
2018-02-07	AAON	Stock	22.3667	22.7	22.0	22.5	190950.0
2018-02-07	AAP	Stock	112.09	114.58	109.9	109.93	2163500.0
2018-02-07	AAT	Stock	32.83	33.63	32.77	32.8	148300.0
2018-02-07	AAU-DELISTED	Stock	0.9	0.9175	0.87	0.8811	296582.0
2018-02-07	AAUAF-DELISTED	Stock	0.9	0.9175	0.87	0.8811	308672.0
2018-02-07	AAV-DELISTED	Stock	3.25	3.3	3.06	3.175	516245.0
2018-02-07	AAWW-DELISTED	Stock	53.6	55.1	53.3	53.4	189939.0
2018-02-07	AAXJ	Stock	76.74	77.4249	75.74	75.74	1682570.0
2018-02-07	AAXN-DELISTED	Stock	25.2	26.07	25.2	25.95	446329.0
2018-02-07	AB	Stock	25.9	26.0	25.6	25.6	213400.0
2018-02-07	ABAC-DELISTED	Stock	2.6399	2.69	2.61	2.63	2507.0
2018-02-07	ABAX-DELISTED	Stock	65.5	66.555	64.65	64.97	176753.0
2018-02-07	ABB-DELISTED	Stock	26.22	26.37	25.97	26.14	3270994.0
2018-02-07	ABBNY-DELISTED	Stock	26.22	26.37	25.97	26.14	3389011.0
2018-02-07	ABBV	Stock	111.52	116.85	111.38	113.62	10030800.0
2018-02-07	ABC-DELISTED	Stock	91.6	95.34	91.1	94.22	2076427.0
2018-02-07	ABCB	Stock	51.95	52.75	51.65	52.4	112200.0
2018-02-07	ABCD-DELISTED	Stock	6.86	7.07	6.79	6.99	57308.0
2018-02-07	ABDC-DELISTED	Stock	7.66	7.85	7.57	7.74	102062.0
2018-02-07	ABE-DELISTED	Stock	14.94	14.9477	14.51	14.76	5990.0
2018-02-07	ABEO	Stock	405.0	472.5	402.75	455.0	118992.0
2018-02-07	ABEOW-DELISTED	Stock	11.24	13.65	11.24	13.65	3490.0
2018-02-07	ABEV	Stock	6.63	6.75	6.54	6.54	24157000.0
2018-02-07	ABG	Stock	68.55	69.5	67.7	68.5	283000.0
2018-02-07	ABIL-DELISTED	Stock	0.385	0.4006	0.37	0.389	155189.0
2018-02-07	ABLX-DELISTED	Stock	53.85	53.99	52.8903	53.25	336997.0
2018-02-07	ABM	Stock	34.66	35.27	34.54	35.13	299200.0
2018-02-07	ABMD-DELISTED	Stock	232.11	240.14	232.11	239.01	411478.0
2018-02-07	ABR	Stock	8.05	8.14	8.01	8.06	292900.0

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

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