PREVIEW / stock_daily / 2018-11-01

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-01.parquet
  size:    221 KB
  rows:    6,550
  symbols: 2,725

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-11-01	AAPL	Stock	54.7625	55.59	54.2025	55.555	233292800.0
2018-11-01	MSFT	Stock	107.05	107.32	105.53	105.92	33384200.0
2018-11-01	NVDA	Stock	5.3075	5.4623	5.1798	5.4528	566528000.0
2018-11-01	AMZN	Stock	81.1765	83.5225	79.922	83.2765	162710000.0
2018-11-01	GOOGL	Stock	54.57	54.995	53.891	54.299	40131500.0
2018-11-01	META	Stock	151.52	152.75	149.35	151.75	25640800.0
2018-11-01	TSLA	Stock	22.5507	23.1893	22.3153	22.952	120001500.0
2018-11-01	TLT	Stock	112.85	113.56	112.8399	113.41	6100276.0
2018-11-01	ES	Stock	63.09	63.34	62.52	62.69	1583800.0
2018-11-01	CL	Stock	59.63	60.48	59.32	60.08	4764100.0
2018-11-01	A	Stock	65.07	65.34	64.58	65.22	1882400.0
2018-11-01	AA	Stock	35.44	36.88	35.24	36.78	2756200.0
2018-11-01	AABA-DELISTED	Stock	60.84	63.34	58.93	62.85	7274858.0
2018-11-01	AAC-DELISTED	Stock	5.57	6.22	5.53	6.01	205209.0
2018-11-01	AACG	Stock	1.12	1.28	1.12	1.26	264600.0
2018-11-01	AAIC-DELISTED	Stock	8.44	8.56	8.44	8.52	411247.0
2018-11-01	AAL	Stock	35.3	36.47	35.07	36.37	9643200.0
2018-11-01	AAM.A-DELISTED	Stock	24.72	24.9419	24.72	24.9	25421.0
2018-11-01	AAM.B-DELISTED	Stock	24.6736	24.7657	24.64	24.74	13096.0
2018-11-01	AAMC-DELISTED	Stock	14.75	14.75	14.75	14.75	1639.0
2018-11-01	AAME	Stock	2.67	2.94	2.67	2.71	3400.0
2018-11-01	AAMI	Stock	11.49	12.84	11.49	12.4	1189800.0
2018-11-01	AAOI	Stock	18.67	20.31	18.16	20.14	1711300.0
2018-11-01	AAON	Stock	22.56	26.0933	21.7933	25.48	970800.0
2018-11-01	AAP	Stock	159.96	164.35	158.1	163.51	1018400.0
2018-11-01	AAT	Stock	38.45	38.63	38.03	38.49	284600.0
2018-11-01	AAU-DELISTED	Stock	0.54	0.54	0.52	0.5392	64525.0
2018-11-01	AAUAF-DELISTED	Stock	0.54	0.54	0.52	0.5392	66360.0
2018-11-01	AAWW-DELISTED	Stock	52.0	54.5	49.31	53.76	657078.0
2018-11-01	AAXJ	Stock	63.94	65.24	63.64	65.24	841323.0
2018-11-01	AAXN-DELISTED	Stock	62.09	62.09	59.521	61.4	591666.0
2018-11-01	AB	Stock	29.38	29.5	29.04	29.16	620800.0
2018-11-01	ABAC-DELISTED	Stock	1.68	1.7648	1.68	1.681	10814.0
2018-11-01	ABB-DELISTED	Stock	20.26	20.415	20.1207	20.37	2266965.0
2018-11-01	ABBNY-DELISTED	Stock	20.26	20.415	20.1207	20.37	2510204.0
2018-11-01	ABBV	Stock	77.71	80.65	77.5	80.21	10671700.0
2018-11-01	ABC-DELISTED	Stock	88.44	91.17	88.39	90.93	740230.0
2018-11-01	ABCB	Stock	43.02	43.8	42.97	43.35	221100.0
2018-11-01	ABCD-DELISTED	Stock	14.4	14.4	14.335	14.35	378446.0
2018-11-01	ABDC-DELISTED	Stock	5.62	5.75	5.59	5.75	51319.0
2018-11-01	ABEO	Stock	217.5	231.25	213.5	230.75	29136.0
2018-11-01	ABEOW-DELISTED	Stock	4.39	4.51	4.39	4.51	1000.0
2018-11-01	ABEV	Stock	4.38	4.41	4.3	4.39	30587300.0
2018-11-01	ABG	Stock	65.01	68.23	65.01	68.21	239600.0
2018-11-01	ABIL-DELISTED	Stock	3.06	3.27	2.98	3.12	54736.0
2018-11-01	ABM	Stock	30.8	31.99	30.63	31.78	589000.0
2018-11-01	ABMD-DELISTED	Stock	357.0	378.37	342.0	377.22	1027500.0
2018-11-01	ABR	Stock	12.1	12.1	11.83	11.89	1028600.0
2018-11-01	ABR.A-DELISTED	Stock	25.65	25.7	25.65	25.67	4100.0
2018-11-01	ABR.B-DELISTED	Stock	25.33	25.4272	25.3105	25.4272	2434.0

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

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