PREVIEW / stock_daily / 2018-09-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-12.parquet
  size:    218 KB
  rows:    6,521
  symbols: 2,747

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-12	AAPL	Stock	56.235	56.25	54.96	55.2675	197114800.0
2018-09-12	MSFT	Stock	111.43	111.85	110.51	111.71	18891100.0
2018-09-12	NVDA	Stock	6.7798	6.7995	6.548	6.705	419092000.0
2018-09-12	AMZN	Stock	99.7	100.0	98.122	99.5	88280000.0
2018-09-12	GOOGL	Stock	59.1	59.5347	58.308	58.58	35716660.0
2018-09-12	META	Stock	163.25	164.49	161.8	162.0	24078100.0
2018-09-12	TSLA	Stock	18.7627	19.5	18.5767	19.3693	150231000.0
2018-09-12	TLT	Stock	119.05	119.17	118.9	118.94	3347210.0
2018-09-12	ES	Stock	63.24	63.75	63.15	63.21	1276100.0
2018-09-12	CL	Stock	67.08	68.1	67.07	67.98	2623100.0
2018-09-12	A	Stock	67.6	68.01	67.25	67.91	1125400.0
2018-09-12	AA	Stock	41.31	42.04	40.32	42.02	4466900.0
2018-09-12	AABA-DELISTED	Stock	64.59	66.97	64.37	66.55	11622663.0
2018-09-12	AAC-DELISTED	Stock	7.35	7.61	7.2	7.58	151955.0
2018-09-12	AACG	Stock	1.5	1.52	1.35	1.36	157200.0
2018-09-12	AAIC-DELISTED	Stock	10.21	10.22	9.95	10.07	541024.0
2018-09-12	AAL	Stock	40.26	40.4	39.23	39.26	6103400.0
2018-09-12	AAM.A-DELISTED	Stock	25.34	25.42	25.34	25.36	22987.0
2018-09-12	AAM.B-DELISTED	Stock	24.99	24.99	24.866	24.87	45152.0
2018-09-12	AAME	Stock	2.75	3.0	2.75	3.0	1600.0
2018-09-12	AAMI	Stock	12.42	12.61	12.42	12.51	735300.0
2018-09-12	AAOI	Stock	32.86	33.963	32.37	33.66	669200.0
2018-09-12	AAON	Stock	26.5667	26.9667	26.1333	26.6667	201750.0
2018-09-12	AAP	Stock	167.14	168.69	166.29	167.1	1119600.0
2018-09-12	AAT	Stock	38.64	38.97	38.42	38.78	150400.0
2018-09-12	AAU-DELISTED	Stock	0.6172	0.6371	0.61	0.6301	129755.0
2018-09-12	AAUAF-DELISTED	Stock	0.6172	0.6371	0.61	0.6301	147342.0
2018-09-12	AAV-DELISTED	Stock	2.55	2.575	2.45	2.5	96089.0
2018-09-12	AAWW-DELISTED	Stock	63.95	65.05	63.9	64.45	221682.0
2018-09-12	AAXJ	Stock	67.93	68.87	67.64	68.54	1978895.0
2018-09-12	AAXN-DELISTED	Stock	72.8	73.3	70.35	70.36	577425.0
2018-09-12	AB	Stock	30.45	30.55	30.3	30.45	162600.0
2018-09-12	ABAC-DELISTED	Stock	1.52	1.89	1.511	1.8799	118425.0
2018-09-12	ABB-DELISTED	Stock	23.59	23.69	23.51	23.61	1665105.0
2018-09-12	ABBNY-DELISTED	Stock	23.59	23.69	23.51	23.61	1723692.0
2018-09-12	ABBV	Stock	92.39	93.94	92.04	93.24	3304700.0
2018-09-12	ABC-DELISTED	Stock	83.73	85.43	83.39	85.21	1118306.0
2018-09-12	ABCB	Stock	48.5	48.83	47.15	47.3	274600.0
2018-09-12	ABCD-DELISTED	Stock	12.65	12.79	12.415	12.7	119067.0
2018-09-12	ABDC-DELISTED	Stock	6.15	6.27	6.15	6.25	40008.0
2018-09-12	ABEO	Stock	358.75	367.5	352.5	362.5	16208.0
2018-09-12	ABEOW-DELISTED	Stock	9.5	9.5	9.5	9.5	1000.0
2018-09-12	ABEV	Stock	4.41	4.5	4.4	4.46	31007600.0
2018-09-12	ABG	Stock	72.9	72.9	71.45	71.7	263100.0
2018-09-12	ABIL-DELISTED	Stock	3.5	3.5	3.27	3.37	37918.0
2018-09-12	ABM	Stock	34.0	34.78	33.57	34.7	458300.0
2018-09-12	ABMD-DELISTED	Stock	397.0	398.91	380.39	392.93	354873.0
2018-09-12	ABR	Stock	12.17	12.19	12.0	12.04	716400.0
2018-09-12	ABR.A-DELISTED	Stock	25.98	25.98	25.8918	25.8918	579.0
2018-09-12	ABR.B-DELISTED	Stock	25.64	25.68	25.525	25.68	5450.0

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

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