const {Sliceup, max, mul, min, count, bar, time, last, sums} = require("sliceup")
const sliceup = new Sliceup('demo.sliceup.co')
// create orders table
await sliceup.create({
'name': 'orders',
'columns': [
{'name': 'time', 'type': 'time'},
{'name': 'qty', 'type': 'int'},
{'name': 'price', 'type': 'float'}
],
'recreate': true
})
// now, let's insert data into our new table
await sliceup.insert({
'name': 'orders',
'rows': [
{'time': '00:00:00', 'qty': 2, 'price': 9.0},
{'time': '00:30:09', 'qty': 2, 'price': 2.0},
{'time': '01:45:01', 'qty': 4, 'price': 1.0},
{'time': '12:10:33', 'qty': 10, 'price': 16.0},
{'time': '16:00:09', 'qty': 4, 'price': 8.0},
{'time': '22:00:00', 'qty': 4, 'price': 23.0},
{'time': '22:31:49', 'qty': 4, 'price': 45.0},
{'time': '22:59:19', 'qty': 4, 'price': 17.0},
]
})
// now query the data
let data = await sliceup.query({
'select': ['time', 'qty', 'price'],
'from': 'orders'
})
data.visualize()
// now query the data for summary statistics
data = await sliceup.query({
'select': [max('time'), min('time'), min('qty'), max('qty'), min('price'), max('price')],
'from': 'orders'
})
data.visualize()
// now slice the data into hour buckets, and take last price in each bucket to create a time series
data = await sliceup.query({
'select': [last('price')],
'by': [bar('time', time(1,0,0))],
'from': 'orders'
})
data.visualize()
// slice and group the quantity by bars of 2 and count how many records in each bucket to create a histogram
data = await sliceup.query({
'select': [count('price')],
'by': [bar('qty', 2)],
'from': 'orders'
})
data.visualize()
// provide cumulative sum of quantities
data = await sliceup.query({
'select': ['time', 'qty', sums('qty')],
'from': 'orders'
})
data.visualize()
no comments
sign in to comment