SYSTEM_CORE_VIEWER
이벤트
Target Object / Identifier
daemon_upbit_user_1h
업비트 1시간봉
플랫폼 유저 테이블을 1시간 단위 복사
Exchange
업비트
Type
이벤트
Form
복사
DB TABLE
daemon_upbit_user_1h
TABLE DAEMON
DB EVENT
ev_upbit_user_1h
[STATUS] INACTIVE
[ID] #16
[TABLE] daemon_upbit_user_1h
[ENGINE] InnoDB
[ROWS] 5,555
DB TABLE
Table Status
| Table Name | daemon_upbit_user_1h |
| Engine | InnoDB |
| Rows | 5,555 |
| Data Length | 1,589,248 bytes |
| Index Length | 540,672 bytes |
| Comment | |
| Created | 2026-04-11 09:29:15 |
| Updated | 2026-04-21 06:00:00 |
| # | Column Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | |
| 2 | currency | varchar(20) | NO | MUL | NULL | ||
| 3 | balance | decimal(36,18) | NO | - | 0.000000000000000000 | ||
| 4 | locked | decimal(36,18) | NO | - | 0.000000000000000000 | ||
| 5 | avg_buy_price | decimal(36,18) | NO | - | 0.000000000000000000 | ||
| 6 | avg_buy_price_modified | decimal(36,18) | NO | - | 0.000000000000000000 | ||
| 7 | unit_currency | varchar(10) | NO | - | NULL | ||
| 8 | collected_at | datetime | NO | MUL | current_timestamp() | ||
| 9 | collected_ms | bigint(20) | NO | - | 0 | ||
| 10 | current_price | decimal(36,18) | YES | - | 0.000000000000000000 | ||
| 11 | evaluation_amount | decimal(36,18) | YES | - | 0.000000000000000000 | ||
| 12 | buy_amount | decimal(36,18) | YES | - | 0.000000000000000000 | ||
| 13 | profit_amount | decimal(36,18) | YES | - | 0.000000000000000000 | ||
| 14 | profit_rate | decimal(20,10) | YES | - | 0.0000000000 | ||
| 15 | total_asset_value | decimal(36,18) | YES | - | 0.000000000000000000 | ||
| 16 | total_profit_amount | decimal(36,18) | YES | - | 0.000000000000000000 | ||
| 17 | total_profit_rate | decimal(20,10) | YES | - | 0.0000000000 | ||
| 18 | cash_balance | decimal(36,18) | YES | - | 0.000000000000000000 |
DB EVENT
Event Scheduler Status (ev_upbit_user_1h)
| Status / Interval | ENABLED | Every 1 HOUR |
| Last Executed | 2026-04-21 06:00:00 |
Event SQL Definition
INSERT INTO daemon_upbit_user_1h (currency, balance, locked, avg_buy_price, avg_buy_price_modified, unit_currency, collected_at, collected_ms, current_price, evaluation_amount, buy_amount, profit_amount, profit_rate, total_asset_value, total_profit_amount, total_profit_rate, cash_balance) SELECT currency, balance, locked, avg_buy_price, avg_buy_price_modified, unit_currency, collected_at, collected_ms, current_price, evaluation_amount, buy_amount, profit_amount, profit_rate, total_asset_value, total_profit_amount, total_profit_rate, cash_balance FROM daemon_upbit_Ticker_user ON DUPLICATE KEY UPDATE balance=VALUES(balance), locked=VALUES(locked), avg_buy_price=VALUES(avg_buy_price), avg_buy_price_modified=VALUES(avg_buy_price_modified), unit_currency=VALUES(unit_currency), collected_at=VALUES(collected_at), current_price=VALUES(current_price), evaluation_amount=VALUES(evaluation_amount), buy_amount=VALUES(buy_amount), profit_amount=VALUES(profit_amount), profit_rate=VALUES(profit_rate), total_asset_value=VALUES(total_asset_value), total_profit_amount=VALUES(total_profit_amount), total_profit_rate=VALUES(total_profit_rate), cash_balance=VALUES(cash_balance)