PREVIEW / stock_daily / 2018-04-18

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-18.parquet
  size:    217 KB
  rows:    6,482
  symbols: 2,826

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-18	AAPL	Stock	44.4525	44.705	44.22	44.46	83018000.0
2018-04-18	MSFT	Stock	96.22	96.72	95.52	96.44	21043300.0
2018-04-18	NVDA	Stock	5.8875	5.9812	5.8192	5.9092	391364000.0
2018-04-18	AMZN	Stock	75.7325	76.69	75.2055	76.392	104550000.0
2018-04-18	GOOGL	Stock	53.9505	54.1	53.5258	53.7695	31125960.0
2018-04-18	META	Stock	166.88	168.12	165.77	166.36	20969600.0
2018-04-18	TSLA	Stock	19.4053	20.016	19.2107	19.5567	98365500.0
2018-04-18	TLT	Stock	121.29	121.34	120.28	120.3	8138401.0
2018-04-18	ES	Stock	60.44	60.82	59.89	59.9	1371500.0
2018-04-18	CL	Stock	72.3	72.61	72.04	72.08	3840600.0
2018-04-18	A	Stock	69.12	70.29	68.65	69.55	2678300.0
2018-04-18	AA	Stock	58.26	60.28	57.25	59.4	8700600.0
2018-04-18	AABA-DELISTED	Stock	71.36	72.5	70.83	72.35	4184555.0
2018-04-18	AAC-DELISTED	Stock	11.2	11.4995	11.19	11.32	106167.0
2018-04-18	AACG	Stock	5.21	5.21	5.21	5.21	200.0
2018-04-18	AAIC-DELISTED	Stock	11.28	11.38	11.24	11.27	289405.0
2018-04-18	AAL	Stock	46.5	48.38	46.05	47.76	9170700.0
2018-04-18	AAM.A-DELISTED	Stock	24.63	24.66	24.38	24.59	58326.0
2018-04-18	AAM.B-DELISTED	Stock	24.59	24.63	24.4	24.45	214929.0
2018-04-18	AAMC-DELISTED	Stock	17.6471	17.6471	16.1765	17.0696	4957.0
2018-04-18	AAME	Stock	3.1	3.12	3.05	3.1	7900.0
2018-04-18	AAMI	Stock	15.03	15.18	14.965	15.02	516400.0
2018-04-18	AAOI	Stock	28.21	28.6	27.6	28.29	1074400.0
2018-04-18	AAON	Stock	23.9333	24.2333	23.8667	24.1	308100.0
2018-04-18	AAP	Stock	108.85	109.72	106.55	107.39	1303600.0
2018-04-18	AAT	Stock	34.17	34.24	33.85	33.93	153400.0
2018-04-18	AAU-DELISTED	Stock	0.82	0.87	0.82	0.852	168145.0
2018-04-18	AAUAF-DELISTED	Stock	0.82	0.87	0.82	0.852	176308.0
2018-04-18	AAV-DELISTED	Stock	3.2	3.35	3.2	3.275	438712.0
2018-04-18	AAWW-DELISTED	Stock	63.65	64.45	63.4	63.85	111901.0
2018-04-18	AAXJ	Stock	77.16	77.66	76.99	77.43	390329.0
2018-04-18	AAXN-DELISTED	Stock	43.26	43.671	42.72	42.73	632482.0
2018-04-18	AB	Stock	26.6	26.8	26.5	26.55	163500.0
2018-04-18	ABAC-DELISTED	Stock	2.61	2.61	2.54	2.54	700.0
2018-04-18	ABAX-DELISTED	Stock	74.0	74.15	73.275	73.49	90617.0
2018-04-18	ABB-DELISTED	Stock	23.19	23.53	23.18	23.47	2037855.0
2018-04-18	ABBNY-DELISTED	Stock	23.22	23.53	23.18	23.46	2339297.0
2018-04-18	ABBV	Stock	94.0	94.6	93.02	94.32	5289700.0
2018-04-18	ABC-DELISTED	Stock	91.53	94.22	91.4	92.76	1847982.0
2018-04-18	ABCB	Stock	51.9	52.2	51.58	51.85	198200.0
2018-04-18	ABCD-DELISTED	Stock	13.03	13.18	12.81	13.13	422678.0
2018-04-18	ABDC-DELISTED	Stock	6.79	6.84	6.69	6.71	44539.0
2018-04-18	ABE-DELISTED	Stock	15.08	15.099	15.08	15.099	1280.0
2018-04-18	ABEO	Stock	490.0	506.25	485.0	495.0	47760.0
2018-04-18	ABEOW-DELISTED	Stock	14.85	14.95	14.85	14.95	2999.0
2018-04-18	ABEV	Stock	6.78	6.93	6.78	6.88	28668700.0
2018-04-18	ABG	Stock	69.2	70.35	68.9	68.95	195800.0
2018-04-18	ABIL-DELISTED	Stock	3.1091	3.23	3.01	3.13	2884.0
2018-04-18	ABLX-DELISTED	Stock	55.06	55.29	55.06	55.24	12501.0
2018-04-18	ABM	Stock	32.58	32.67	32.41	32.52	621500.0

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

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