PREVIEW / stock_daily / 2018-08-13

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-13.parquet
  size:    219 KB
  rows:    6,549
  symbols: 2,776

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-13	AAPL	Stock	52.3275	52.7375	51.925	52.2175	103563600.0
2018-08-13	MSFT	Stock	109.24	109.58	108.1	108.21	18472500.0
2018-08-13	NVDA	Stock	6.3785	6.525	6.3768	6.403	375208000.0
2018-08-13	AMZN	Stock	94.925	96.25	94.6835	94.81	110630000.0
2018-08-13	GOOGL	Stock	62.56	63.2985	62.3515	62.432	27617640.0
2018-08-13	META	Stock	180.1	182.61	178.9	180.05	17423300.0
2018-08-13	TSLA	Stock	24.0753	24.2127	23.268	23.7607	156958500.0
2018-08-13	TLT	Stock	120.25	120.7	120.21	120.41	7923199.0
2018-08-13	ES	Stock	61.48	61.78	61.23	61.75	1617200.0
2018-08-13	CL	Stock	65.47	65.77	65.01	65.55	2725100.0
2018-08-13	A	Stock	66.44	66.99	65.67	65.94	2983100.0
2018-08-13	AA	Stock	44.95	44.95	44.01	44.45	4337600.0
2018-08-13	AABA-DELISTED	Stock	71.14	71.2024	70.08	70.14	11908485.0
2018-08-13	AAC-DELISTED	Stock	9.11	9.53	9.08	9.41	72361.0
2018-08-13	AACG	Stock	5.99	6.26	5.99	6.15	326100.0
2018-08-13	AAIC-DELISTED	Stock	10.15	10.27	10.13	10.18	275658.0
2018-08-13	AAL	Stock	37.29	37.33	36.68	36.79	4051800.0
2018-08-13	AAM.A-DELISTED	Stock	25.52	25.52	25.44	25.48	19795.0
2018-08-13	AAM.B-DELISTED	Stock	25.06	25.08	25.031	25.08	26082.0
2018-08-13	AAMC-DELISTED	Stock	19.9412	19.9632	18.2647	19.6324	5664.0
2018-08-13	AAME	Stock	2.4	2.65	2.4	2.4	1400.0
2018-08-13	AAMI	Stock	12.45	12.5	12.36	12.39	864600.0
2018-08-13	AAOI	Stock	42.19	43.35	41.53	42.28	849200.0
2018-08-13	AAON	Stock	25.9	26.2	25.7333	26.0	198000.0
2018-08-13	AAP	Stock	147.0	147.84	144.5	144.84	1407000.0
2018-08-13	AAT	Stock	38.6	38.6	38.17	38.31	90500.0
2018-08-13	AAU-DELISTED	Stock	0.645	0.645	0.605	0.6062	331663.0
2018-08-13	AAUAF-DELISTED	Stock	0.645	0.645	0.605	0.6062	347726.0
2018-08-13	AAV-DELISTED	Stock	3.1	3.2	3.1	3.2	191992.0
2018-08-13	AAWW-DELISTED	Stock	60.7	60.95	59.5	60.15	248910.0
2018-08-13	AAXJ	Stock	70.73	70.83	70.11	70.18	706325.0
2018-08-13	AAXN-DELISTED	Stock	61.21	62.585	60.57	60.98	448484.0
2018-08-13	AB	Stock	29.25	29.6	29.2	29.4	224800.0
2018-08-13	ABAC-DELISTED	Stock	2.28	2.28	2.2358	2.2358	3001.0
2018-08-13	ABB-DELISTED	Stock	22.62	22.72	22.48	22.53	1197814.0
2018-08-13	ABBNY-DELISTED	Stock	22.62	22.72	22.48	22.53	1321781.0
2018-08-13	ABBV	Stock	96.0	97.58	95.81	96.78	5920000.0
2018-08-13	ABC-DELISTED	Stock	82.0	83.27	81.9	83.05	1067663.0
2018-08-13	ABCB	Stock	48.85	48.95	48.45	48.55	257600.0
2018-08-13	ABCD-DELISTED	Stock	12.0	12.14	11.5	11.69	98654.0
2018-08-13	ABDC-DELISTED	Stock	6.12	6.22	6.1	6.21	25982.0
2018-08-13	ABEO	Stock	340.0	352.0	321.25	322.5	30420.0
2018-08-13	ABEOW-DELISTED	Stock	8.15	8.15	7.9986	8.0	1500.0
2018-08-13	ABEV	Stock	4.8	4.93	4.79	4.89	31245000.0
2018-08-13	ABG	Stock	75.3	75.3	74.4	74.55	227300.0
2018-08-13	ABIL-DELISTED	Stock	6.8	8.3	5.9207	5.9854	9273477.0
2018-08-13	ABM	Stock	30.87	30.87	30.58	30.75	406800.0
2018-08-13	ABMD-DELISTED	Stock	377.67	383.55	367.68	368.02	244234.0
2018-08-13	ABR	Stock	11.49	11.58	11.44	11.48	1704800.0
2018-08-13	ABR.A-DELISTED	Stock	26.0	26.0	25.968	26.0	1800.0

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

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