WITH daily_stats AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS date,

CASE

WHEN SUBSTRING(input, 1, 10) = '0x31d98b3f' THEN 'getPrice'

WHEN SUBSTRING(input, 1, 10) = '0xd47eed45' THEN 'getUpdateFee'

WHEN SUBSTRING(input, 1, 10) = '0x96834ad3' THEN 'getPriceUnsafe'

WHEN SUBSTRING(input, 1, 10) = '0xa4ae35e0' THEN 'getPriceNoOlderThan'

WHEN SUBSTRING(input, 1, 10) = '0xe18910a3' THEN 'getValidTimePeriod'

WHEN SUBSTRING(input, 1, 10) = '0x9474f45b' THEN 'getEmaPriceUnsafe'

WHEN SUBSTRING(input, 1, 10) = '0x711a2e28' THEN 'getEmaPriceNoOlderThan'

WHEN SUBSTRING(input, 1, 10) = '0xe17efd48' THEN 'getUpdateFee'

WHEN SUBSTRING(input, 1, 10) = '0x4c469d8c' THEN 'latestPriceInfoPublishTime'

WHEN SUBSTRING(input, 1, 10) = '0xb5ec0261' THEN 'priceFeedExists'

WHEN SUBSTRING(input, 1, 10) = '0xe3795cc1' THEN 'pythUpgradableMagic'

WHEN SUBSTRING(input, 1, 10) = '0x3659cfe6' THEN 'upgradeTo'

WHEN SUBSTRING(input, 1, 10) = '0xd05f5318' THEN 'addDataSource'

WHEN SUBSTRING(input, 1, 10) = '0x48b6404d' THEN 'singleUpdateFeeInWei'

WHEN SUBSTRING(input, 1, 10) = '0x84acd1bb' THEN 'wormhole'

WHEN SUBSTRING(input, 1, 10) = '0x437209a7' THEN 'isValidDataSource'

WHEN SUBSTRING(input, 1, 10) = '0xef9e5e28' THEN 'updatePriceFeeds'

WHEN SUBSTRING(input, 1, 10) = '0xb9256d28' THEN 'updatePriceFeedsIfNecessary'

WHEN SUBSTRING(input, 1, 10) = '0x785bdda0' THEN 'updateValidTimePeriodSeconds'

WHEN SUBSTRING(input, 1, 10) = '0xf4347f83' THEN 'updateGovernanceDataSource'

WHEN SUBSTRING(input, 1, 10) = '0x4716e9c5' THEN 'parsePriceFeedUpdates'

WHEN SUBSTRING(input, 1, 10) = '0xaccca7f9' THEN 'parsePriceFeedUpdatesUnique'

WHEN SUBSTRING(input, 1, 10) = '0xb6ed701e' THEN 'executeGovernanceInstruction'

WHEN SUBSTRING(input, 1, 10) = '0x60806040' THEN 'Upgraded'

WHEN SUBSTRING(input, 1, 10) = '0x715018a6' THEN 'renounceOwnership'

WHEN SUBSTRING(input, 1, 10) = '0x0d4702e1' THEN 'updateAssetPrices'

WHEN SUBSTRING(input, 1, 10) = '0x631a316c' THEN 'updatePrice'

ELSE 'Unknown'

END AS function_name,