PREVIEW / stock_daily / 2018-08-07

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-07.parquet
  size:    218 KB
  rows:    6,502
  symbols: 2,740

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-08-07	AAPL	Stock	52.33	52.375	51.69	51.7775	102349600.0
2018-08-07	MSFT	Stock	108.56	109.1	108.17	108.88	16080200.0
2018-08-07	NVDA	Stock	6.4	6.4425	6.373	6.4238	258132000.0
2018-08-07	AMZN	Stock	92.7265	93.486	92.3135	93.124	67550000.0
2018-08-07	GOOGL	Stock	62.6005	63.304	62.59	62.792	42505120.0
2018-08-07	META	Stock	186.5	188.3	183.72	183.81	33398600.0
2018-08-07	TSLA	Stock	22.9227	25.8307	22.61	25.3047	463137000.0
2018-08-07	TLT	Stock	119.03	119.1	118.57	118.67	5346872.0
2018-08-07	ES	Stock	61.09	61.22	60.38	60.99	1104100.0
2018-08-07	CL	Stock	67.4	67.4	66.54	67.23	2181100.0
2018-08-07	A	Stock	66.83	67.94	66.63	67.66	2829000.0
2018-08-07	AA	Stock	43.21	43.4	41.9	41.97	2887900.0
2018-08-07	AABA-DELISTED	Stock	71.46	72.45	71.2401	71.51	8243207.0
2018-08-07	AAC-DELISTED	Stock	8.66	9.02	8.62	8.85	148551.0
2018-08-07	AACG	Stock	4.44	4.54	4.2	4.53	19200.0
2018-08-07	AAIC-DELISTED	Stock	10.3	10.33	10.18	10.21	286179.0
2018-08-07	AAL	Stock	38.65	38.74	38.19	38.26	6427100.0
2018-08-07	AAM.A-DELISTED	Stock	25.46	25.46	25.42	25.43	24378.0
2018-08-07	AAM.B-DELISTED	Stock	24.99	25.06	24.9885	25.06	51122.0
2018-08-07	AAMC-DELISTED	Stock	18.7994	18.9265	18.7994	18.9265	2961.0
2018-08-07	AAME	Stock	2.36	2.6	2.2	2.5	9300.0
2018-08-07	AAMI	Stock	12.37	12.755	12.37	12.54	716600.0
2018-08-07	AAOI	Stock	39.29	39.45	36.88	37.23	2884300.0
2018-08-07	AAON	Stock	25.5667	26.0667	25.5667	25.8333	231750.0
2018-08-07	AAP	Stock	145.39	146.31	144.33	145.16	940300.0
2018-08-07	AAT	Stock	38.7	38.7	38.24	38.62	218700.0
2018-08-07	AAU-DELISTED	Stock	0.6623	0.69	0.6501	0.6521	119804.0
2018-08-07	AAUAF-DELISTED	Stock	0.6623	0.69	0.6501	0.6521	123287.0
2018-08-07	AAV-DELISTED	Stock	3.25	3.3	3.1	3.125	571664.0
2018-08-07	AAWW-DELISTED	Stock	63.9	64.05	62.2995	62.3	206389.0
2018-08-07	AAXJ	Stock	72.23	72.439	72.01	72.19	800570.0
2018-08-07	AAXN-DELISTED	Stock	67.01	68.16	66.14	67.63	843248.0
2018-08-07	AB	Stock	28.7	29.5	28.6	29.05	319400.0
2018-08-07	ABAC-DELISTED	Stock	2.18	2.24	2.18	2.2	3458.0
2018-08-07	ABB-DELISTED	Stock	23.21	23.21	23.06	23.105	1249418.0
2018-08-07	ABBNY-DELISTED	Stock	23.21	23.21	23.06	23.1	1289521.0
2018-08-07	ABBV	Stock	97.3	98.35	93.74	94.06	8890900.0
2018-08-07	ABC-DELISTED	Stock	82.01	84.81	81.52	83.44	1361896.0
2018-08-07	ABCB	Stock	48.8	49.2	48.65	48.75	280400.0
2018-08-07	ABCD-DELISTED	Stock	11.81	11.92	11.68	11.74	106517.0
2018-08-07	ABDC-DELISTED	Stock	6.36	6.47	6.02	6.16	175607.0
2018-08-07	ABEO	Stock	368.75	368.75	355.0	368.75	12092.0
2018-08-07	ABEV	Stock	5.17	5.19	5.05	5.05	40517500.0
2018-08-07	ABG	Stock	74.15	74.95	73.95	74.5	203800.0
2018-08-07	ABIL-DELISTED	Stock	2.81	3.138	2.77	2.94	27932.0
2018-08-07	ABM	Stock	31.53	31.77	31.33	31.44	505500.0
2018-08-07	ABMD-DELISTED	Stock	378.94	382.2791	372.89	376.4	334785.0
2018-08-07	ABR	Stock	11.67	11.67	11.38	11.43	2042500.0
2018-08-07	ABR.A-DELISTED	Stock	25.9981	26.05	25.9205	25.9448	2795.0
2018-08-07	ABR.B-DELISTED	Stock	25.64	25.65	25.6399	25.64	1700.0

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

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