SELECT (close_price - open_price) / open_price as daily_return FROM coin_data WHERE coin_name = 'Bitcoin';

Mon Mar 06 2023 02:19:14 GMT+0000 (Coordinated Universal Time)

Saved by @jpmri

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

SQL

@jpmri

Retrieving the total market capitalization of a cryptocurrency: SELECT (close_price - open_price) / open_price as daily_return FROM coin_data WHERE coin_name = 'Bitcoin'; Retrieving the top 10 cryptocurrencies by market capitalization:

Browse more snippets >>