PREVIEW / stock_daily / 2018-11-07

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-07.parquet
  size:    221 KB
  rows:    6,552
  symbols: 2,709

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-07	AAPL	Stock	51.4925	52.515	51.0325	52.4875	133697600.0
2018-11-07	MSFT	Stock	109.44	112.24	109.4	111.96	37901700.0
2018-11-07	NVDA	Stock	5.3438	5.4352	5.2795	5.3448	483812000.0
2018-11-07	AMZN	Stock	83.65	87.9615	83.204	87.7745	163844000.0
2018-11-07	GOOGL	Stock	54.1745	55.4965	54.0295	55.412	43387840.0
2018-11-07	META	Stock	151.57	153.01	149.83	151.53	21877400.0
2018-11-07	TSLA	Stock	22.8893	23.412	22.72	23.2107	110617500.0
2018-11-07	TLT	Stock	113.19	113.4	112.409	112.52	9313311.0
2018-11-07	ES	Stock	63.76	64.46	63.5	64.38	1150000.0
2018-11-07	CL	Stock	60.79	61.44	60.27	61.33	5777500.0
2018-11-07	A	Stock	66.51	68.38	66.28	68.26	2700600.0
2018-11-07	AA	Stock	36.74	37.33	36.12	36.83	3267900.0
2018-11-07	AABA-DELISTED	Stock	62.77	63.66	62.46	63.58	4738622.0
2018-11-07	AAC-DELISTED	Stock	3.26	3.64	2.97	2.98	1271415.0
2018-11-07	AACG	Stock	1.21	1.38	1.15	1.19	482700.0
2018-11-07	AAIC-DELISTED	Stock	8.6	8.735	8.565	8.73	230753.0
2018-11-07	AAL	Stock	35.57	37.39	35.48	36.97	10904000.0
2018-11-07	AAM.A-DELISTED	Stock	24.66	24.66	24.58	24.58	17866.0
2018-11-07	AAM.B-DELISTED	Stock	24.46	24.54	24.3687	24.42	44445.0
2018-11-07	AAME	Stock	3.14	3.57	2.91	3.5	10000.0
2018-11-07	AAMI	Stock	12.98	13.28	12.94	13.22	1057700.0
2018-11-07	AAOI	Stock	20.0	20.0	18.567	19.38	2371100.0
2018-11-07	AAON	Stock	28.1	28.8467	27.7933	28.8067	462000.0
2018-11-07	AAP	Stock	169.21	170.56	167.08	170.51	888700.0
2018-11-07	AAT	Stock	38.51	38.92	38.28	38.85	149100.0
2018-11-07	AAU-DELISTED	Stock	0.544	0.55	0.52	0.5214	163275.0
2018-11-07	AAUAF-DELISTED	Stock	0.544	0.55	0.52	0.5214	165972.0
2018-11-07	AAWW-DELISTED	Stock	55.15	57.7	54.8	57.09	245764.0
2018-11-07	AAXJ	Stock	66.27	66.92	66.05	66.87	685161.0
2018-11-07	AAXN-DELISTED	Stock	54.8	56.0	49.64	50.7	1946473.0
2018-11-07	AB	Stock	29.23	30.06	29.01	30.02	423400.0
2018-11-07	ABAC-DELISTED	Stock	1.66	1.71	1.6573	1.71	5075.0
2018-11-07	ABB-DELISTED	Stock	20.54	20.64	20.4	20.635	1576774.0
2018-11-07	ABBNY-DELISTED	Stock	20.54	20.64	20.4	20.63	1642277.0
2018-11-07	ABBV	Stock	84.15	87.22	84.14	86.96	10378000.0
2018-11-07	ABC-DELISTED	Stock	84.4	87.37	84.4	86.51	1699420.0
2018-11-07	ABCB	Stock	43.74	44.03	42.89	43.88	136700.0
2018-11-07	ABCD-DELISTED	Stock	14.42	14.44	14.4	14.43	236279.0
2018-11-07	ABDC-DELISTED	Stock	6.36	6.67	6.331	6.67	123018.0
2018-11-07	ABEO	Stock	227.0	230.5	214.5	219.0	28808.0
2018-11-07	ABEOW-DELISTED	Stock	4.78	4.84	4.7	4.7	5624.0
2018-11-07	ABEV	Stock	4.4	4.43	4.32	4.37	27120100.0
2018-11-07	ABG	Stock	67.06	68.59	66.17	67.83	170300.0
2018-11-07	ABIL-DELISTED	Stock	3.42	3.42	3.1	3.26	124916.0
2018-11-07	ABM	Stock	32.1	32.8	31.58	32.7	283700.0
2018-11-07	ABMD-DELISTED	Stock	410.6	427.6975	402.0	411.94	601261.0
2018-11-07	ABR	Stock	12.2	12.24	12.06	12.13	1156400.0
2018-11-07	ABR.A-DELISTED	Stock	25.55	25.64	25.46	25.47	16600.0
2018-11-07	ABR.B-DELISTED	Stock	25.45	25.78	25.3283	25.4	6544.0
2018-11-07	ABR.C-DELISTED	Stock	25.68	25.68	25.62	25.65	8700.0

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

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