# Predicting the block - Boring Sat Night Coding

**Published by:** [evahteev](https://paragraph.com/@evahteev/)
**Published on:** 2023-12-25
**URL:** https://paragraph.com/@evahteev/predicting-the-block-boring-sat-night-coding

## Content

TLDRWas bored on Christmas Eve Saturday night, so faced the problem of predicting block number for new year date (UTC 1704067200). Sniffed around and found that itself interesting problem to tackle applying linear regression to data we have on blocks in Guru Data Warehouse. Created Public API and Warehouse SDK out of it, so prepaired to that feature (block time/number prediction) to be released in Guru Block Explorers from backend side.ProcessFor whatever reason, needed a new year date calculated in blocks on different chains.epoch timestamp: 1704067200` Timestamp in milliseconds: 1704067200000 Date and time (GMT): Monday, January 1, 2024 12:00:00 AM Found that there is no clear UI for thatTried LLAMA API https://defillama.com/docs/api (not working)Defi llama APITried 1704067200000, got results for 1603964988What a hell, let’s hack some codePredictionTo predict blocks in future we need info on blocks in past on each chain, and we have guru warehouse for thatGURU AI Assist: Asked our assist to help me with getting linear regression for block number vs timestamp out of blocks table in warehouse:Unfortunately Guru AI Assist had no clue on Clickhouse Linear Regression functionality :( so needed to figure out myself. Because we are using Clickhouse and we can Utilize Clickhouse Linear Regression For number/timestamp predictions and backwards, so created following query: SELECT simpleLinearRegression(number, timestamp) as lr FROM ( SELECT number, timestamp FROM {{ network }}.blocks FINAL ORDER BY number DESC LIMIT {{ training_set_size }} ) Now set parameter from supported networks and get it as an API:Warehouse SDKThinking a little bit on how I'm going to combine those into meaningful answers with methods like: def get_block_by_timestamp(self, network: str, timestamp: int) -> Optional[BlockModel]: pass def get_block(network: str, block_number: int) -> Optional[BlockModel]: pass I've decided to create Warehouse SDK under dex-guru and created PR there https://github.com/dex-guru/dg-warehouse-sdk/pull/1 Main idea here is to query for linear regression in Warehouse if block/timestamp is in the future, and return one if it's in the past: Example: def get_block_by_timestamp(self, network: str, timestamp: int) -> Optional[BlockModel]: """ Method either predicts or returns block by timestamp :param network: :param timestamp: :return: """ timestamp = self._transform_timestamp(timestamp) last_indexed_block = self.get_last_indexed_block(network) if not last_indexed_block: return None last_indexed_block = last_indexed_block[0] if timestamp > last_indexed_block['timestamp']: # 10% OF ALL BLOCKS training_set_size = round(last_indexed_block['number'] * 0.1) lr_coefficients = self.get_lr_coefficients(network, training_set_size) if not lr_coefficients: return None lr_coefficients = lr_coefficients[0]['lr'] block_number = round((timestamp - lr_coefficients["b"]) // lr_coefficients["k"]) return BlockModel(number=block_number, timestamp=timestamp) else: block_by_timestamp = self.get_indexed_block_by_timestamp(network, timestamp) if not block_by_timestamp: return None block_by_timestamp = block_by_timestamp[0] return BlockModel(**block_by_timestamp) Embedded it into DexGuru Public API free of charge (no API KEY needed):Let's figure out block number for 1704067200(New Year) timestamp:Cool! Next time would put it into Guru Block Explorer to have Etherscan type of page with time prediction there :)

## Publication Information

- [evahteev](https://paragraph.com/@evahteev/): Publication homepage
- [All Posts](https://paragraph.com/@evahteev/): More posts from this publication
- [RSS Feed](https://api.paragraph.com/blogs/rss/@evahteev): Subscribe to updates
- [Twitter](https://twitter.com/evahteev): Follow on Twitter