PREVIEW / stock_daily / 2018-09-14

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-14.parquet
  size:    218 KB
  rows:    6,529
  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-09-14	AAPL	Stock	56.4375	56.71	55.63	55.96	127997200.0
2018-09-14	MSFT	Stock	113.36	113.73	112.44	113.37	19122300.0
2018-09-14	NVDA	Stock	6.8748	6.9775	6.8375	6.9108	386936000.0
2018-09-14	AMZN	Stock	99.6465	99.6825	97.961	98.5095	72840000.0
2018-09-14	GOOGL	Stock	59.4	59.4	58.676	58.899	24175340.0
2018-09-14	META	Stock	161.72	162.84	160.34	162.32	21770400.0
2018-09-14	TSLA	Stock	19.2507	19.822	19.1013	19.68	101484000.0
2018-09-14	TLT	Stock	118.41	118.91	118.2999	118.55	5579455.0
2018-09-14	ES	Stock	63.34	63.57	62.69	63.53	1120100.0
2018-09-14	CL	Stock	68.19	68.31	67.72	67.99	1843300.0
2018-09-14	A	Stock	69.28	69.41	68.56	68.85	1461100.0
2018-09-14	AA	Stock	41.81	42.91	41.81	42.79	2731400.0
2018-09-14	AABA-DELISTED	Stock	68.47	68.7	67.33	67.68	4114332.0
2018-09-14	AAC-DELISTED	Stock	7.57	7.72	7.32	7.35	139429.0
2018-09-14	AACG	Stock	1.33	1.36	1.27	1.33	81300.0
2018-09-14	AAIC-DELISTED	Stock	10.05	10.12	10.03	10.03	320896.0
2018-09-14	AAL	Stock	39.54	39.97	39.32	39.74	2905100.0
2018-09-14	AAM.A-DELISTED	Stock	25.36	25.39	25.3	25.39	14032.0
2018-09-14	AAM.B-DELISTED	Stock	24.87	24.87	24.765	24.84	24187.0
2018-09-14	AAMC-DELISTED	Stock	17.1029	18.4706	17.1029	18.015	4049.0
2018-09-14	AAME	Stock	2.88	3.0	2.6	2.9	3100.0
2018-09-14	AAMI	Stock	12.45	12.75	12.45	12.65	549300.0
2018-09-14	AAOI	Stock	35.0	35.51	34.03	34.19	1434100.0
2018-09-14	AAON	Stock	26.6	26.9333	26.4	26.8	195750.0
2018-09-14	AAP	Stock	166.95	167.92	165.19	165.45	995800.0
2018-09-14	AAT	Stock	38.93	38.93	37.89	38.28	238500.0
2018-09-14	AAU-DELISTED	Stock	0.621	0.6387	0.62	0.6266	79776.0
2018-09-14	AAUAF-DELISTED	Stock	0.621	0.6387	0.62	0.6266	82704.0
2018-09-14	AAV-DELISTED	Stock	2.55	2.6	2.495	2.55	71977.0
2018-09-14	AAWW-DELISTED	Stock	63.65	64.05	62.7	63.9	183831.0
2018-09-14	AAXJ	Stock	69.98	70.07	69.27	69.59	1468672.0
2018-09-14	AAXN-DELISTED	Stock	72.24	73.61	71.64	73.41	439892.0
2018-09-14	AB	Stock	30.55	31.23	30.55	30.95	492300.0
2018-09-14	ABAC-DELISTED	Stock	2.22	2.29	1.9229	2.1092	36549.0
2018-09-14	ABB-DELISTED	Stock	24.03	24.08	23.89	23.95	1762087.0
2018-09-14	ABBNY-DELISTED	Stock	24.03	24.08	23.89	23.96	2902213.0
2018-09-14	ABBV	Stock	96.29	96.4	94.92	95.68	3446000.0
2018-09-14	ABC-DELISTED	Stock	86.19	87.38	85.64	85.84	1006619.0
2018-09-14	ABCB	Stock	47.4	48.45	47.4	48.1	255800.0
2018-09-14	ABCD-DELISTED	Stock	12.63	12.98	12.57	12.65	47360.0
2018-09-14	ABDC-DELISTED	Stock	6.38	6.45	6.34	6.41	60032.0
2018-09-14	ABEO	Stock	358.75	366.25	352.5	358.75	16796.0
2018-09-14	ABEV	Stock	4.43	4.43	4.31	4.37	26522900.0
2018-09-14	ABG	Stock	71.75	73.45	71.7	73.2	253500.0
2018-09-14	ABIL-DELISTED	Stock	3.2	3.38	3.2	3.375	63401.0
2018-09-14	ABM	Stock	34.36	34.79	34.0	34.69	680400.0
2018-09-14	ABMD-DELISTED	Stock	392.32	399.12	392.0	395.66	278632.0
2018-09-14	ABR	Stock	12.06	12.12	11.99	12.02	717100.0
2018-09-14	ABR.A-DELISTED	Stock	25.9	25.9299	25.82	25.9299	767.0
2018-09-14	ABR.C-DELISTED	Stock	25.7064	25.7064	25.7064	25.7064	200.0

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

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