PREVIEW / stock_daily / 2018-03-15

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-15.parquet
  size:    217 KB
  rows:    6,475
  symbols: 2,838

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-03-15	AAPL	Stock	44.625	45.06	44.5175	44.6625	90975200.0
2018-03-15	MSFT	Stock	93.53	94.58	92.83	94.18	27611000.0
2018-03-15	NVDA	Stock	6.2323	6.3155	6.191	6.2335	401952000.0
2018-03-15	AMZN	Stock	79.75	79.8455	78.9055	79.116	81394000.0
2018-03-15	GOOGL	Stock	57.4785	58.125	56.783	57.5305	33381880.0
2018-03-15	META	Stock	183.24	184.0	182.19	183.86	15614300.0
2018-03-15	TSLA	Stock	21.9587	22.19	21.4067	21.7067	98472000.0
2018-03-15	TLT	Stock	120.17	120.49	119.93	120.24	6757935.0
2018-03-15	ES	Stock	57.21	57.88	57.08	57.58	2151900.0
2018-03-15	CL	Stock	70.03	70.21	69.3	69.56	3040000.0
2018-03-15	A	Stock	70.09	70.66	69.87	70.18	2530400.0
2018-03-15	AA	Stock	46.45	47.13	45.71	46.93	2998800.0
2018-03-15	AABA-DELISTED	Stock	79.01	80.15	78.53	79.43	7899035.0
2018-03-15	AAC-DELISTED	Stock	12.02	12.9	12.02	12.72	151174.0
2018-03-15	AACG	Stock	5.13	5.38	5.13	5.37	15000.0
2018-03-15	AAIC-DELISTED	Stock	11.87	11.87	11.57	11.59	501174.0
2018-03-15	AAL	Stock	55.35	55.56	54.93	55.17	2980500.0
2018-03-15	AAM.A-DELISTED	Stock	25.3	25.3	25.2187	25.23	35068.0
2018-03-15	AAMC-DELISTED	Stock	18.5147	18.5147	17.9118	17.9118	4189.0
2018-03-15	AAME	Stock	3.3	3.3	3.21	3.3	3600.0
2018-03-15	AAMI	Stock	15.86	15.86	15.57	15.67	584900.0
2018-03-15	AAOI	Stock	28.94	29.16	26.61	26.79	2254200.0
2018-03-15	AAON	Stock	25.7	25.9333	25.6333	25.8667	402450.0
2018-03-15	AAP	Stock	117.54	118.33	115.47	117.1	672600.0
2018-03-15	AAT	Stock	33.21	33.23	32.76	32.9	373900.0
2018-03-15	AAU-DELISTED	Stock	0.85	0.85	0.8152	0.8152	147954.0
2018-03-15	AAUAF-DELISTED	Stock	0.85	0.85	0.8152	0.8152	149600.0
2018-03-15	AAV-DELISTED	Stock	2.8	2.85	2.75	2.8	334528.0
2018-03-15	AAWW-DELISTED	Stock	62.7	63.25	62.163	62.8	175402.0
2018-03-15	AAXJ	Stock	79.88	80.13	79.37	79.64	1274535.0
2018-03-15	AAXN-DELISTED	Stock	38.92	39.02	38.33	38.6	784989.0
2018-03-15	AB	Stock	26.35	26.45	26.15	26.25	164600.0
2018-03-15	ABAC-DELISTED	Stock	2.6	2.61	2.505	2.505	2800.0
2018-03-15	ABAX-DELISTED	Stock	73.73	75.54	73.3	74.37	155388.0
2018-03-15	ABB-DELISTED	Stock	24.11	24.28	24.08	24.13	1751664.0
2018-03-15	ABBNY-DELISTED	Stock	24.11	24.28	24.08	24.13	1858088.0
2018-03-15	ABBV	Stock	119.0	119.5	114.88	114.93	5812400.0
2018-03-15	ABC-DELISTED	Stock	99.05	99.25	97.33	97.36	1119373.0
2018-03-15	ABCB	Stock	56.75	57.0	56.05	56.95	306100.0
2018-03-15	ABCD-DELISTED	Stock	9.9	10.2274	9.2501	9.66	160769.0
2018-03-15	ABDC-DELISTED	Stock	6.75	6.77	6.1507	6.25	427821.0
2018-03-15	ABE-DELISTED	Stock	15.145	15.45	15.14	15.3472	23996.0
2018-03-15	ABEO	Stock	403.75	406.0	378.75	381.25	29816.0
2018-03-15	ABEV	Stock	7.3	7.34	7.18	7.2	23206300.0
2018-03-15	ABG	Stock	69.5	70.3	68.5	68.65	200200.0
2018-03-15	ABIL-DELISTED	Stock	0.385	0.3889	0.3725	0.3848	54679.0
2018-03-15	ABLX-DELISTED	Stock	54.12	54.18	53.81	53.97	233876.0
2018-03-15	ABM	Stock	34.96	35.6	34.09	34.61	2477700.0
2018-03-15	ABMD-DELISTED	Stock	297.01	297.98	293.95	294.52	304726.0
2018-03-15	ABR	Stock	8.85	8.86	8.78	8.83	347300.0

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

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