OHLCV data challenge with mplfinance

Ask anything you want about mplfinance usage, project philosophy and/or priorities, or anything else related to mplfinance.

hello, I am new to data processing with pandas and python programming generally, I am working with a large crypto ohlcv dataset from a database. I need to answer some questions from the dataset, questions like

1)which day of the week shows the greatest change in price?
2)which hour of the day shows the greatest change in price?
3)looking at weekly data, to what extent can the Thursday - Sunday price change be predicted based on the movements from Monday - Wednesday?
4)looking at weekly data, does the weekday pricing data provide any predictive clues to what will happen by the end of the weekend?

so far, I've been able to extract the data, set timestamp as index and tried to resample the data,plot the data in mplfinance but I have two challenges, I can't present the data as days of the week eg. Thursday and the picture from the plot doesn't answer my questions.is there a way for me to aswer this questions using the timestamp as it is? I tried the alternative of creating a new data frame with just the variables I need (open, high,low,close,volume,date, time, day of the week) but this data won't plot in mplfinance. I would appreciate any help with this issue
. Thank you

Non viene indicato alcun file di progetto né alcun test. Inizia esaminando l’uso di mplfinance con dati OHLCV indicizzati temporalmente e il resampling di pandas, quindi chiarisci se il risultato desiderato consiste nel tracciare le etichette dei giorni della settimana, rispondere alle domande predittive o documentare come preparare i dati; il risultato completato dovrebbe essere una richiesta riproducibile e specifica del progetto.