BTC Hourly Analyzer v12

Upload your 5-minute Bitcoin OHLCV CSV data

Expected Format

timestamp,open,high,low,close,volume,source

On GitHub Pages, data loads automatically from /data/ folder

β‚Ώ BTC Hourly Analysis

5-Min Data β€’ Level Analysis β€’ Ultimate RSI β€’ Eastern Time
0Days
24Hours
7Cols

Column Filters (rows must match ALL conditions)

Ultimate RSI Settings

Day Total Columns

Years

Months

Year-Month (replaces Year+Month when active)

Days

Day # in Month

Hours (Eastern Time)

Specific Dates

Columns (per Hour)

Range (β†’Orange)
Rank (Orange→)
+/- (Red←→Green)
RSI (β†’Purple)
OB/OS = Overbought/Oversold
Select a Date
to

β‚Ώ 5PM Session Analysis

5PM Previous Day β†’ 4PM Current Day β€’ Cumulative Ranges β€’ Eastern Time
0Days
24Hours
Select an Hour

πŸ“ˆ Day of Week Analysis

β‚Ώ Hour Query Builder

Build complex queries to find hours matching specific criteria
0Matches
0Days

Query Builder

Result Table Columns

πŸ”
No Query Results
Build a query using the Query Builder and click "Run Query" to find matching hours
βš™ Filters & Settings

Years

Months

Year-Month (replaces Year+Month when active)

Days of Week

Day # in Month

Hours (Eastern Time)

Specific Dates

Selected: 0 dates
βš™οΈ Column Settings & Presets β–Ό

Column Presets

Gradient Mode

Bar % Mode

Search Columns

βš™οΈ Day Total Settings & Presets β–Ό

Day Total Presets

Show in Table

Established % Threshold

O-C Close Hour

Search Day Total Columns

Active Column Filters

No active filters

Add New Filter

Hour/Day:
Column:
Operator:
Compare to:
Value:

Quick Actions

Display Options

Gradient Mode:
Bar % Mode:

RSI Settings

RSI Length:
RSI Method:
Signal Length:
Signal Method:
OB Level:
OS Level:

Display Settings

Font Family:
Font Size:
Level Size:

Color Scheme

Orange (Range):
Green (Positive):
Red (Negative):
Purple (RSI):

Customize gradient colors used for different metric types. Changes apply immediately and persist across sessions.

Data Settings

Live Data Updates:

When enabled, fetches latest data from Coinbase API every 5 minutes. When disabled, shows only historical data from last commit.

Backfill Historical Data

GitHub PAT:
Start Date:
End Date:

Triggers the backfill-data.yml GitHub Actions workflow to fetch historical 5-min data for the given date range and commit it to the repo. Requires a GitHub PAT with actions:write scope (or classic repo scope). PAT is stored locally and never sent anywhere except GitHub API.

Analysis Thresholds

rVol Highlight β‰₯:
After Bar β‰₯:
After Bar Minute:
Day Totals Top N:

After Bar Minute: The specific minute for after-bar metrics (BXAH, BXAL, MxBX).
Day Totals Top N: Number of top hourly values to average for TopRng and TopMxR.

Relative Volume Lookback

rVol (Hour):
rVolC (Days):
rVolDOW:

Number of historical bars used for relative volume calculations.
rVol: same hour, rVolC: cumulative days, rVolDOW: same hour + same day of week.

Actions

Export downloads all currently visible table data as a CSV file.

Save Filter Preset

Interval Info

Detailed metrics will appear here.

βœ•

Interval Details

Loading…