PREVIEW / stock_daily / 2018-04-05

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-05.parquet
  size:    216 KB
  rows:    6,467
  symbols: 2,816

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-04-05	AAPL	Stock	43.145	43.5575	43.02	43.2	107732800.0
2018-04-05	MSFT	Stock	92.44	93.07	91.4	92.38	29771900.0
2018-04-05	NVDA	Stock	5.715	5.7282	5.4623	5.5345	701240000.0
2018-04-05	AMZN	Stock	72.0995	72.978	71.3535	72.5875	128270000.0
2018-04-05	GOOGL	Stock	52.3195	52.3355	51.2	51.632	35835220.0
2018-04-05	META	Stock	161.56	161.57	156.65	159.34	41449600.0
2018-04-05	TSLA	Stock	19.2893	20.4173	19.2133	20.3813	286816500.0
2018-04-05	TLT	Stock	120.1	120.27	119.77	119.79	7603733.0
2018-04-05	ES	Stock	59.42	60.21	58.77	60.01	1797100.0
2018-04-05	CL	Stock	71.67	72.16	71.36	71.81	3294400.0
2018-04-05	A	Stock	65.82	66.31	65.5	65.68	2120200.0
2018-04-05	AA	Stock	47.2	48.73	47.15	47.61	2979000.0
2018-04-05	AABA-DELISTED	Stock	70.5	70.9558	69.12	69.39	4576376.0
2018-04-05	AAC-DELISTED	Stock	11.37	11.82	11.37	11.68	45439.0
2018-04-05	AACG	Stock	5.26	5.27	5.26	5.26	7500.0
2018-04-05	AAIC-DELISTED	Stock	11.23	11.33	11.205	11.33	404844.0
2018-04-05	AAL	Stock	52.5	53.08	51.83	52.14	3060900.0
2018-04-05	AAM.A-DELISTED	Stock	24.9648	25.02	24.92	24.96	23533.0
2018-04-05	AAM.B-DELISTED	Stock	24.91	25.0	24.85	24.9	304578.0
2018-04-05	AAMI	Stock	15.53	15.66	15.29	15.35	528100.0
2018-04-05	AAOI	Stock	24.43	25.07	24.105	24.61	791500.0
2018-04-05	AAON	Stock	23.9667	24.2	23.5	23.5667	356550.0
2018-04-05	AAP	Stock	115.46	116.83	113.52	116.39	873500.0
2018-04-05	AAT	Stock	34.75	34.91	34.29	34.9	337000.0
2018-04-05	AAU-DELISTED	Stock	0.7966	0.8093	0.7966	0.8	93120.0
2018-04-05	AAUAF-DELISTED	Stock	0.7966	0.8093	0.7966	0.8	96122.0
2018-04-05	AAV-DELISTED	Stock	3.05	3.25	3.05	3.225	592559.0
2018-04-05	AAWW-DELISTED	Stock	61.6	63.4	60.625	62.95	167516.0
2018-04-05	AAXJ	Stock	77.01	77.36	76.74	77.05	320225.0
2018-04-05	AAXN-DELISTED	Stock	42.38	43.16	42.1	42.87	705980.0
2018-04-05	AB	Stock	26.85	27.0	26.65	26.75	220900.0
2018-04-05	ABAC-DELISTED	Stock	2.35	2.36	2.301	2.351	700.0
2018-04-05	ABAX-DELISTED	Stock	70.68	71.16	69.82	70.9	74808.0
2018-04-05	ABB-DELISTED	Stock	22.52	22.82	22.46	22.7	2537209.0
2018-04-05	ABBNY-DELISTED	Stock	22.52	22.82	22.46	22.69	2621553.0
2018-04-05	ABBV	Stock	93.07	93.27	91.65	92.21	7045000.0
2018-04-05	ABC-DELISTED	Stock	85.6	88.57	85.14	87.38	2813488.0
2018-04-05	ABCB	Stock	53.95	53.95	53.25	53.9	126300.0
2018-04-05	ABCD-DELISTED	Stock	11.58	11.79	11.23	11.32	346890.0
2018-04-05	ABDC-DELISTED	Stock	7.21	7.2303	7.08	7.19	176565.0
2018-04-05	ABE-DELISTED	Stock	14.81	14.92	14.8056	14.9	9416.0
2018-04-05	ABEO	Stock	380.0	380.0	357.5	358.75	17836.0
2018-04-05	ABEV	Stock	7.32	7.35	7.15	7.16	20016500.0
2018-04-05	ABG	Stock	66.85	67.85	66.2	67.8	171100.0
2018-04-05	ABIL-DELISTED	Stock	2.7	2.7135	2.525	2.7	12961.0
2018-04-05	ABLX-DELISTED	Stock	54.6	54.6	54.28	54.36	23083.0
2018-04-05	ABM	Stock	33.5	33.8	33.31	33.54	464700.0
2018-04-05	ABMD-DELISTED	Stock	290.38	297.0	290.315	292.15	237044.0
2018-04-05	ABR	Stock	8.78	8.81	8.75	8.77	487300.0
2018-04-05	ABR.A-DELISTED	Stock	25.4197	25.45	25.4197	25.45	800.0

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

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