PREVIEW / stock_daily / 2018-08-23

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-23.parquet
  size:    218 KB
  rows:    6,510
  symbols: 2,746

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-23	AAPL	Stock	53.6625	54.2625	53.65	53.8725	75532800.0
2018-08-23	MSFT	Stock	107.15	108.18	106.87	107.56	18167700.0
2018-08-23	NVDA	Stock	6.5315	6.737	6.5175	6.671	720684000.0
2018-08-23	AMZN	Stock	95.3585	95.975	95.038	95.145	71260000.0
2018-08-23	GOOGL	Stock	60.994	61.7585	60.9674	61.058	24666940.0
2018-08-23	META	Stock	173.09	175.55	172.83	172.9	18053600.0
2018-08-23	TSLA	Stock	21.276	21.8213	21.2067	21.34	77209500.0
2018-08-23	TLT	Stock	122.0	122.13	121.78	122.05	5329024.0
2018-08-23	ES	Stock	62.34	62.75	62.25	62.43	727800.0
2018-08-23	CL	Stock	66.72	67.1	66.47	66.57	2460400.0
2018-08-23	A	Stock	65.69	65.99	65.53	65.69	2287700.0
2018-08-23	AA	Stock	42.5	42.73	41.89	42.02	2813000.0
2018-08-23	AABA-DELISTED	Stock	72.51	73.15	68.14	68.19	23331247.0
2018-08-23	AAC-DELISTED	Stock	9.69	9.77	9.58	9.76	625939.0
2018-08-23	AACG	Stock	6.46	6.55	6.44	6.52	91000.0
2018-08-23	AAIC-DELISTED	Stock	10.14	10.19	10.13	10.14	267886.0
2018-08-23	AAL	Stock	39.19	39.39	38.72	38.83	3931900.0
2018-08-23	AAM.A-DELISTED	Stock	25.7866	25.82	25.7104	25.82	7429.0
2018-08-23	AAM.B-DELISTED	Stock	25.17	25.33	25.17	25.33	12737.0
2018-08-23	AAME	Stock	2.6	2.6	2.6	2.6	700.0
2018-08-23	AAMI	Stock	12.65	12.73	12.41	12.44	306700.0
2018-08-23	AAOI	Stock	41.72	43.37	41.72	42.79	1142400.0
2018-08-23	AAON	Stock	28.6667	28.8667	27.4533	27.5667	306300.0
2018-08-23	AAP	Stock	161.26	163.36	160.95	163.26	891300.0
2018-08-23	AAT	Stock	39.37	39.63	39.28	39.29	120900.0
2018-08-23	AAU-DELISTED	Stock	0.625	0.625	0.58	0.5875	81465.0
2018-08-23	AAUAF-DELISTED	Stock	0.625	0.625	0.58	0.5875	85592.0
2018-08-23	AAV-DELISTED	Stock	3.05	3.05	2.95	3.05	44103.0
2018-08-23	AAWW-DELISTED	Stock	60.7	61.4	60.2753	61.35	167907.0
2018-08-23	AAXJ	Stock	71.25	71.35	70.44	70.5	607292.0
2018-08-23	AAXN-DELISTED	Stock	64.4	65.39	63.71	64.0	382135.0
2018-08-23	AB	Stock	30.15	30.35	29.7	29.95	311300.0
2018-08-23	ABAC-DELISTED	Stock	1.761	1.8037	1.761	1.8012	4426.0
2018-08-23	ABB-DELISTED	Stock	22.98	23.53	22.97	23.31	5918500.0
2018-08-23	ABBNY-DELISTED	Stock	22.98	23.53	22.97	23.31	6059454.0
2018-08-23	ABBV	Stock	97.69	97.85	96.89	97.15	2137500.0
2018-08-23	ABC-DELISTED	Stock	88.23	88.59	87.52	88.28	720486.0
2018-08-23	ABCB	Stock	49.85	50.08	49.6	50.0	211500.0
2018-08-23	ABCD-DELISTED	Stock	13.39	13.45	13.0	13.11	76376.0
2018-08-23	ABDC-DELISTED	Stock	6.32	6.32	6.09	6.2	55412.0
2018-08-23	ABEO	Stock	358.75	360.75	349.5	351.25	12448.0
2018-08-23	ABEV	Stock	4.69	4.74	4.58	4.59	45450300.0
2018-08-23	ABG	Stock	76.95	77.0	75.45	75.75	120400.0
2018-08-23	ABIL-DELISTED	Stock	4.15	4.23	4.0	4.0	232079.0
2018-08-23	ABM	Stock	31.75	32.31	29.9	30.35	1587100.0
2018-08-23	ABMD-DELISTED	Stock	368.57	378.92	368.57	376.91	276289.0
2018-08-23	ABR	Stock	11.84	11.96	11.84	11.94	1265600.0
2018-08-23	ABR.A-DELISTED	Stock	25.98	25.9999	25.8334	25.9999	2380.0
2018-08-23	ABR.B-DELISTED	Stock	25.4762	25.5	25.4762	25.5	200.0
2018-08-23	ABR.C-DELISTED	Stock	26.22	26.22	25.9684	25.9684	682.0

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

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