PREVIEW / stock_daily / 2018-09-27

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-27.parquet
  size:    218 KB
  rows:    6,517
  symbols: 2,736

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-27	AAPL	Stock	55.955	56.61	55.885	56.2375	120724800.0
2018-09-27	MSFT	Stock	114.78	114.91	114.2	114.41	19091300.0
2018-09-27	NVDA	Stock	6.7085	6.73	6.6532	6.685	214428000.0
2018-09-27	AMZN	Stock	99.662	100.808	99.429	100.649	86588000.0
2018-09-27	GOOGL	Stock	60.0	60.843	59.9025	60.368	36273040.0
2018-09-27	META	Stock	167.55	171.77	167.21	168.84	27266900.0
2018-09-27	TSLA	Stock	20.86	20.9973	20.4607	20.5013	127636500.0
2018-09-27	TLT	Stock	117.24	117.65	117.1	117.58	5758577.0
2018-09-27	ES	Stock	60.4	61.0	60.23	60.56	1072400.0
2018-09-27	CL	Stock	67.05	67.35	66.68	66.73	2498600.0
2018-09-27	A	Stock	70.58	70.85	70.1	70.8	1581700.0
2018-09-27	AA	Stock	40.38	40.81	40.08	40.5	2842800.0
2018-09-27	AABA-DELISTED	Stock	68.43	68.73	68.05	68.5	6893780.0
2018-09-27	AAC-DELISTED	Stock	7.19	7.41	7.1	7.27	457040.0
2018-09-27	AACG	Stock	1.01	1.1	1.0	1.03	108900.0
2018-09-27	AAIC-DELISTED	Stock	9.68	9.77	9.59	9.61	669905.0
2018-09-27	AAL	Stock	41.23	42.2	41.15	41.5	5654600.0
2018-09-27	AAM.A-DELISTED	Stock	24.99	25.03	24.86	24.86	16775.0
2018-09-27	AAM.B-DELISTED	Stock	24.72	24.7695	24.61	24.63	51609.0
2018-09-27	AAMC-DELISTED	Stock	17.5	17.8088	17.5	17.8088	3220.0
2018-09-27	AAME	Stock	2.58	2.58	2.3	2.5	9800.0
2018-09-27	AAMI	Stock	12.65	12.65	12.37	12.46	976900.0
2018-09-27	AAOI	Stock	28.18	28.52	26.712	28.36	4045300.0
2018-09-27	AAON	Stock	25.3	25.44	24.7333	24.8333	462600.0
2018-09-27	AAP	Stock	169.42	170.92	169.17	169.79	739700.0
2018-09-27	AAT	Stock	36.85	37.15	36.78	36.85	103000.0
2018-09-27	AAU-DELISTED	Stock	0.65	0.65	0.61	0.64	50747.0
2018-09-27	AAUAF-DELISTED	Stock	0.65	0.65	0.61	0.6338	52281.0
2018-09-27	AAWW-DELISTED	Stock	63.4	63.9	63.25	63.6	97656.0
2018-09-27	AAXJ	Stock	70.93	71.23	70.82	71.01	2360300.0
2018-09-27	AAXN-DELISTED	Stock	66.75	67.9399	66.4	67.61	282833.0
2018-09-27	AB	Stock	30.6	30.95	30.5	30.55	165300.0
2018-09-27	ABAC-DELISTED	Stock	2.1	2.246	2.0227	2.033	14500.0
2018-09-27	ABB-DELISTED	Stock	23.71	23.825	23.67	23.71	1620151.0
2018-09-27	ABBNY-DELISTED	Stock	23.71	23.825	23.67	23.71	1671743.0
2018-09-27	ABBV	Stock	94.35	94.89	93.96	94.14	3028600.0
2018-09-27	ABC-DELISTED	Stock	90.34	91.49	90.34	91.15	808197.0
2018-09-27	ABCB	Stock	46.1	46.45	45.2	45.3	219800.0
2018-09-27	ABCD-DELISTED	Stock	11.65	11.92	11.55	11.8097	59287.0
2018-09-27	ABDC-DELISTED	Stock	6.05	6.16	5.94	6.0	171705.0
2018-09-27	ABEO	Stock	326.25	331.25	321.25	325.0	11152.0
2018-09-27	ABEV	Stock	4.67	4.78	4.62	4.63	30249100.0
2018-09-27	ABG	Stock	70.2	70.2	69.55	70.0	116100.0
2018-09-27	ABIL-DELISTED	Stock	3.58	3.66	3.25	3.37	155782.0
2018-09-27	ABM	Stock	32.72	33.02	32.27	32.3	376700.0
2018-09-27	ABMD-DELISTED	Stock	445.5	451.79	437.095	442.89	447326.0
2018-09-27	ABR	Stock	11.25	11.39	11.23	11.33	627300.0
2018-09-27	ABR.A-DELISTED	Stock	25.6	25.6	25.5	25.5	800.0
2018-09-27	ABR.B-DELISTED	Stock	25.55	25.6	25.51	25.6	1400.0
2018-09-27	ABR.C-DELISTED	Stock	26.21	26.21	26.1859	26.21	400.0

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

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