# source the data
t_EB = db.t("LearnDeephaven", "StockTrades")\
.where("Date = `2017-08-23`", "USym = `GOOG`")\
.updateView("TimeBin=upperBin(Timestamp, 20 * MINUTE)")\
.where("isBusinessTime(TimeBin)")
# calculate standard deviations for the upper and lower error values
t_EB_StdDev = t_EB.by(
caf.AggCombo(caf.AggAvg("AvgPrice = Last"), caf.AggStd("StdPrice = Last")),
"TimeBin")
# plot the data
ebY_Trades = Plot.errorBarY("Trades: GOOG", t_EB_StdDev.update("AvgPriceLow = AvgPrice - StdPrice",
"AvgPriceHigh = AvgPrice + StdPrice"),
"TimeBin", "AvgPrice", "AvgPriceLow", "AvgPriceHigh")\
.show()
# PLOTBY WITH PLOTSTYLE - STACKED AREA
t_pb = db.t("LearnDeephaven", "EODTrades")\
.where("ImportDate = `2017-11-01`", "Ticker in `GOOG`,`AMZN`,`AAPL`, `MSFT`")\
.update("DateString = EODTimestamp.toDateString(TZ_NY)")\
.where("inRange(DateString, `2016-11-01`, `2016-12-01`)")
plotByExampleStackedArea = Plot.plotBy("TradesByDay", t_pb, "EODTimestamp", "Volume", "Ticker")\
.chartTitle("Trades Per Day By Ticker")\
.xLabel("Date")\
.yLabel("Volume")\
.plotStyle("stacked_area")\
.show()
import deephaven.Plot as plt
t = tt.emptyTable(50)\
.update("X = i + 5", "XLow = X -1", "XHigh = X + 1", "Y = Math.random() * 5", "YLow = Y - 1", "YHigh = Y + 1", "USym = i % 2 == 0 ? `AAPL` : `MSFT`")
p = plt.plot("S1", t, "X", "Y").lineColor("black").show()
p2 = plt.plot("S1", t, "X", "Y").plotStyle("bar").gradientVisible(True).show()
p3 = plt.plot(
"S1", t, "X",
"Y").plotStyle("scatter").pointColor("black").pointSize(2).show()
p4 = plt.plot("S1", t, "X", "Y").plotStyle("area").seriesColor("red").show()
p4 = plt.plot3d("S1", t, "X", "X", "Y").show()
pBy = plt.plotBy("S1", t, "X", "Y", "USym").show()
pBy = plt.plot3dBy("S1", t, "X", "X", "Y", "USym").show()
cp = plt.catPlot("S1", t, "X", "Y").lineColor("black").show()
cp2 = plt.catPlot("S1", t, "X",
"Y").plotStyle("bar").gradientVisible(True).show()
cp3 = plt.catPlot(
"S1", t, "X",
"Y").plotStyle("scatter").pointColor("black").pointSize(2).show()
cp4 = plt.catPlot("S1", t, "X",
"Y").plotStyle("area").seriesColor("red").show()
cp = plt.catPlot3d("S1", t, "X", "X", "Y").show()
cpBy = plt.catPlotBy("S1", t, "X", "Y", "USym").show()