Level 63
In which context do you need to retrieve the new prices every minute ?
Do you want for example to dynamically refresh the view with the new prices ?
2 likes
Jan 12, 2023
5
Level 2
how can get data values within current 1 minutes from database by laravel
i can get price data of today by this codes
$date =Carbon::today()->format('Y-m-d');
$pricelist = Sell::whereDate('created_at', '=', $date)->orderBy('id','asc')->get();
$priceHL = Sell::whereDate('created_at', '=', $date)->orderBy('price','asc')->get();
$openprice = $pricelist->first()->price;
$closeprice = $pricelist->last()->price;
$highprice = $priceHL->last()->price;
$lowprice = $priceHL->first()->price;
by this way , today open price ,close price ,high price and low price can get , but i want to get by 1 minutes, example price data inserted into database within current 1 minutes , I will fetch them as above OHLC data , How can do that.
Level 2
@vincent15000 yes i want to send this data to candlestick chart as 1 minute data
1 like
Level 70
@zwarkyaw What if you try this?
$now = Carbon::now();
$oneMinuteAgo = $now->subMinutes(1);
$pricelist = Sell::whereBetween('created_at', [$oneMinuteAgo, $now])->get();
3 likes
Level 2
@tisuchi when i dd( $now, $oneMinuteAgo ); same time get date: 2023-01-12 16:15:36.125262 UTC (+00:00) date: 2023-01-12 16:15:36.125262 UTC (+00:00)
so no between values in them
2 likes
Level 63
If you want to see the difference, you need to set the $now date as immutable.
$now = CarbonImmutable::now();
$oneMinuteAgo = $now->subMinutes(1);
1 like
Please or to participate in this conversation.