PREVIEW / stock_daily / 2018-09-07

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-07.parquet
  size:    218 KB
  rows:    6,512
  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-09-07	AAPL	Stock	55.4625	56.3425	55.1775	55.325	150479200.0
2018-09-07	MSFT	Stock	108.23	108.72	107.23	108.21	22498600.0
2018-09-07	NVDA	Stock	6.725	6.9232	6.6798	6.7965	295420000.0
2018-09-07	AMZN	Stock	96.9355	98.76	96.8675	97.6035	97852000.0
2018-09-07	GOOGL	Stock	58.6	59.4273	58.4635	58.8795	32663800.0
2018-09-07	META	Stock	160.31	164.63	160.16	163.04	24300600.0
2018-09-07	TSLA	Stock	17.34	17.89	16.8167	17.5493	337378500.0
2018-09-07	TLT	Stock	119.33	119.4	118.99	119.13	11212607.0
2018-09-07	ES	Stock	63.02	63.36	62.64	62.81	1187800.0
2018-09-07	CL	Stock	66.7	67.06	66.27	67.01	2980200.0
2018-09-07	A	Stock	67.15	67.83	67.03	67.4	1585500.0
2018-09-07	AA	Stock	40.5	41.822	40.1	41.0	5305200.0
2018-09-07	AABA-DELISTED	Stock	64.03	65.63	64.03	64.84	3141804.0
2018-09-07	AAC-DELISTED	Stock	7.98	8.09	7.77	7.78	178771.0
2018-09-07	AACG	Stock	1.93	2.0	1.7	1.72	248200.0
2018-09-07	AAIC-DELISTED	Stock	10.24	10.32	10.15	10.23	253023.0
2018-09-07	AAL	Stock	38.31	39.27	38.15	38.43	4875700.0
2018-09-07	AAM.A-DELISTED	Stock	25.5	25.5	25.2666	25.31	20347.0
2018-09-07	AAM.B-DELISTED	Stock	25.08	25.08	24.87	24.88	50281.0
2018-09-07	AAMC-DELISTED	Stock	17.6618	17.6618	17.6618	17.6618	398.0
2018-09-07	AAME	Stock	2.9	2.98	2.8	2.98	5800.0
2018-09-07	AAMI	Stock	12.55	12.67	12.54	12.66	536400.0
2018-09-07	AAOI	Stock	32.15	33.14	31.65	32.04	1558100.0
2018-09-07	AAON	Stock	26.5333	26.6	26.1333	26.2667	171000.0
2018-09-07	AAP	Stock	167.23	169.22	167.09	167.28	763200.0
2018-09-07	AAT	Stock	38.87	38.87	38.32	38.45	177600.0
2018-09-07	AAU-DELISTED	Stock	0.69	0.69	0.6584	0.66	85597.0
2018-09-07	AAUAF-DELISTED	Stock	0.69	0.69	0.6584	0.66	90000.0
2018-09-07	AAV-DELISTED	Stock	2.4	2.6	2.4	2.525	152799.0
2018-09-07	AAWW-DELISTED	Stock	61.95	62.4	60.8	61.85	105905.0
2018-09-07	AAXJ	Stock	68.72	69.24	68.5	68.68	993297.0
2018-09-07	AAXN-DELISTED	Stock	69.92	71.962	69.28	70.46	438832.0
2018-09-07	AB	Stock	30.25	30.45	30.05	30.2	165500.0
2018-09-07	ABAC-DELISTED	Stock	2.04	2.04	1.66	1.79	145885.0
2018-09-07	ABB-DELISTED	Stock	23.16	23.25	23.065	23.15	926486.0
2018-09-07	ABBNY-DELISTED	Stock	23.16	23.25	23.065	23.15	1399530.0
2018-09-07	ABBV	Stock	93.65	94.35	91.6	94.17	4051700.0
2018-09-07	ABC-DELISTED	Stock	88.3	89.26	87.79	88.64	760751.0
2018-09-07	ABCB	Stock	49.7	49.75	49.25	49.65	202600.0
2018-09-07	ABCD-DELISTED	Stock	12.56	12.66	12.251	12.36	66648.0
2018-09-07	ABDC-DELISTED	Stock	6.14	6.1985	6.14	6.16	22676.0
2018-09-07	ABEO	Stock	341.25	355.0	333.75	341.25	18648.0
2018-09-07	ABEOW-DELISTED	Stock	9.44	9.44	9.44	9.44	300.0
2018-09-07	ABEV	Stock	4.55	4.56	4.45	4.5	15853300.0
2018-09-07	ABG	Stock	71.4	72.3	70.75	71.9	253500.0
2018-09-07	ABIL-DELISTED	Stock	3.45	3.5966	3.4078	3.41	25107.0
2018-09-07	ABM	Stock	32.95	35.06	31.7	33.75	2923800.0
2018-09-07	ABMD-DELISTED	Stock	378.44	388.93	375.2853	377.5	255532.0
2018-09-07	ABR	Stock	12.12	12.15	12.0	12.02	707500.0
2018-09-07	ABR.A-DELISTED	Stock	25.9224	25.9224	25.89	25.89	516.0

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

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