SUMMARY.md

Table of contents

🌟 Getting Started

• Welcome to Spice.ai
• Quickstart
  • Step 1 - Portal Login
  • Step 2 - SQL Query
  • Step 3 - Leverage a SDK
  • Next Steps
• FAQ
• Pricing
  • 🆕 Community Edition

🧱 Building Blocks

• Datasets and Views
• 🔥 Spice Firecache
  • DuckDB Export Database
• External Data Sources
• Spice Models
• Community Data

💻 API

• SQL Query API
  • HTTP API
  • Async HTTP API
  • Apache Arrow Flight API
  • Best Practices
• Health API

👨‍💻 Portal

• Apps
  • Connect GitHub repository
  • Transfer an App
  • App API keys
• Organizations
• SQL Query Editor
• Monitoring and Request Logs
• Profile Settings
• Personal Access Tokens

🔗 SDKs

• Python SDK
  • Streaming
• Node.js SDK
  • Streaming
  • API Reference
  • Converting Large Numbers
• Go SDK
• Rust SDK
  • API Reference
• Dotnet SDK
• Java SDK

🔌 Integrations

• GitHub Copilot
• Grafana
  • Grafana Dashboard Examples

🎓 Tutorials

• Data Science

📚 REFERENCE

• Core Concepts
  • Organizations
  • Duration Literals
• SQL Reference
  • Data Types
  • SQL Functions
    • Aggregate
      • APPROX_COUNT_DISTINCT
      • AVG
      • BIT_AND
      • BIT_OR
      • CORR
      • COUNT
      • COVAR_POP
      • COVAR_SAMP
      • HLL
      • LISTAGG
      • MAX
      • MIN
      • NDV
      • STDDEV
      • STDDEV_POP
      • STDDEV_SAMP
      • SUM
      • VAR_POP
      • VAR_SAMP
    • Binary
      • BASE64
      • BIT_LENGTH
      • FROM_HEX
      • HEX
      • TO_HEX
      • UNBASE64
      • UNHEX
    • Bitwise
      • BIT_AND
      • BIT_OR
      • LSHIFT
      • RSHIFT
      • XOR
    • Boolean
      • IS [NOT] DISTINCT FROM
      • ISFALSE
      • IS [NOT] NULL
      • ISNUMERIC
      • ISTRUE
      • IS_MEMBER
    • Conditional
      • BOOL_AND
      • BOOL_OR
      • CASE
      • COALESCE
      • GREATEST
      • LEAST
      • NULLIF
    • Conversion
      • BINARY_STRING
      • CAST
      • CONVERT_FROM
      • CONVERT_REPLACEUTF8
      • CONVERT_TIMEZONE
      • CONVERT_TO
      • FLATTEN
      • FROM_HEX
      • HASH
      • HEX
      • TOASCII
      • TO_CHAR
      • TO_DATE
      • TO_HEX
      • TO_NUMBER
      • TO_TIME
      • TO_TIMESTAMP
      • UNHEX
    • Cryptography
      • AES_DECRYPT
      • AES_ENCRYPT
      • MD5
      • SHA
      • SHA1
      • SHA256
      • SHA512
    • Data Generation
      • RANDOM
    • Datatype
      • IS_BIGINT
      • IS_DATE
      • IS_INT
      • IS_VARCHAR
      • SIZE
      • TYPEOF
    • Date/Time
      • CONVERT_TIMEZONE
      • CURRENT_DATE
      • CURRENT_DATE_UTC
      • CURRENT_TIME
      • CURRENT_TIMESTAMP
      • DATEDIFF
      • DATE_ADD
      • DATE_DIFF
      • DATE_PART
      • DATE_SUB
      • DATE_TRUNC
      • DAY
      • DAYOFMONTH
      • DAYOFWEEK
      • DAYOFYEAR
      • EXTRACT
      • HOUR
      • LAST_DAY
      • MINUTE
      • MONTH
      • MONTHS_BETWEEN
      • NEXT_DAY
      • QUARTER
      • SECOND
      • TIMESTAMPADD
      • TIMESTAMPDIFF
      • TO_DATE
      • TO_TIME
      • TO_TIMESTAMP
      • UNIX_TIMESTAMP
      • WEEK
      • WEEKOFYEAR
      • YEAR
    • Math
      • ABS
      • ACOS
      • ASIN
      • ATAN
      • CBRT
      • CEILING
      • COS
      • COSH
      • COT
      • DEGREES
      • E
      • EXP
      • FLOOR
      • LOG
      • LOG10
      • MOD
      • PI
      • POWER
      • RADIANS
      • ROUND
      • SIGN
      • SIN
      • SINH
      • SQRT
      • STDDEV
      • STDDEV_POP
      • STDDEV_SAMP
      • TAN
      • TANH
      • TRUNCATE
    • Percentile
      • MEDIAN
      • PERCENTILE_CONT
      • PERCENTILE_DISC
    • Regular Expressions
      • REGEXP_EXTRACT
      • REGEXP_LIKE
      • REGEXP_MATCHES
      • REGEXP_REPLACE
      • REGEXP_SPLIT
    • Semistructured Data
      • ARRAY_CONTAINS
      • MAP_KEYS
      • MAP_VALUES
    • String
      • ASCII
      • BASE64
      • BTRIM
      • CHARACTER_LENGTH
      • CHAR_LENGTH
      • CHR
      • COL_LIKE
      • CONCAT
      • CONCAT_WS
      • ENDS_WITH
      • FROM_HEX
      • HEX
      • ILIKE
      • INITCAP
      • INSTR
      • IS_UTF8
      • LCASE
      • LEFT
      • LENGTH
      • LEVENSHTEIN
      • LIKE
      • LOCATE
      • LOWER
      • LPAD
      • LTRIM
      • MASK
      • MASK_FIRST_N
      • MASK_HASH
      • MASK_LAST_N
      • MASK_SHOW_FIRST_N
      • MASK_SHOW_LAST_N
      • OCTET_LENGTH
      • POSITION
      • QUOTE
      • REGEXP_EXTRACT
      • REGEXP_LIKE
      • REGEXP_MATCHES
      • REGEXP_REPLACE
      • REGEXP_SPLIT
      • REPEAT
      • REPEATSTR
      • REPLACE
      • REVERSE
      • RIGHT
      • RPAD
      • RTRIM
      • SIMILAR_TO
      • SOUNDEX
      • SPLIT_PART
      • STARTS_WITH
      • STRPOS
      • SUBSTRING
      • SUBSTRING_INDEX
      • TOASCII
      • TO_HEX
      • TRANSLATE
      • TRIM
      • UCASE
      • UNBASE64
      • UNHEX
      • UPPER
    • Window
      • COUNT
      • COVAR_POP
      • COVAR_SAMP
      • CUME_DIST
      • DENSE_RANK
      • FIRST_VALUE
      • HLL
      • LAG
      • LEAD
      • MAX
      • MIN
      • NDV
      • NTILE
      • PERCENT_RANK
      • RANK
      • ROW_NUMBER
      • SUM
      • VAR_POP
      • VAR_SAMP
  • SQL Commands
    • SELECT
    • USE
    • SHOW
    • DESCRIBE
    • WITH
• SQL Query Tables
  • TPC-H
  • Bitcoin
    • btc.blocks
    • btc.transactions
    • btc.transaction_inputs
    • btc.transaction_outputs
  • Ethereum
    • Core Tables
      • eth.blocks
      • eth.transactions
      • eth.logs
      • eth.contracts
      • eth.traces
      • eth.withdrawals
    • Beacon Chain Tables
      • eth.beacon.validators
      • eth.beacon.slots
      • eth.beacon.attestations
      • eth.beacon.deposits
      • eth.beacon.voluntary_exits
      • eth.beacon.attester_slashings
      • eth.beacon.proposer_slashings
      • eth.beacon.bls_to_execution_changes
      • eth.beacon.withdrawals
    • Token Tables
      • eth.tokens
      • eth.token_transfers
      • eth.recent_token_transfers
      • eth.tokens_erc20
      • eth.token_transfers_erc20
      • eth.tokens_erc721
      • eth.token_transfers_erc721
      • eth.tokens_erc1155
      • eth.token_transfers_erc1155
      • eth.token_mints
    • NFT Tables
      • eth.nfts
      • eth.nft_contracts
      • eth.nft_transfers
      • eth.nft_owners
      • eth.recent_nft_transfers
      • eth.nft_airdrop_transfers
    • Wallet Balances
      • eth.wallet_balances
      • eth.wallet_lst_balances
    • ENS Tables
      • ens.domains
    • Uniswap V2 Tables
      • eth.uniswap_v2.pools
      • eth.uniswap_v2.pool_stats
      • eth.uniswap_v2.pool_stats_detailed
      • eth.uniswap_v2.event_mints
      • eth.uniswap_v2.event_burns
      • eth.uniswap_v2.event_swaps
      • eth.uniswap_v2.event_syncs
    • Uniswap V3 Tables
      • eth.uniswap_v3.pools
      • eth.uniswap_v3.pool_stats
      • eth.uniswap_v3.event_burns
      • eth.uniswap_v3.event_mints
      • eth.uniswap_v3.event_swaps
      • eth.uniswap_v3.event_set_fee_protocols
      • eth.uniswap_v3.event_collects
      • eth.uniswap_v3.event_collect_protocols
      • eth.uniswap_v3.event_flashes
      • eth.uniswap_v3.event_increase_observation_cardinality_nexts
      • eth.uniswap_v3.event_initializes
    • Sushiswap Tables
      • eth.sushiswap.pools
      • eth.sushiswap.pool_stats
      • eth.sushiswap.pool_stats_detailed
      • eth.sushiswap.event_mints
      • eth.sushiswap.event_burns
      • eth.sushiswap.event_swaps
      • eth.sushiswap.event_syncs
    • Chainlink Tables
      • Prices Tables
        • eth.chainlink.prices
    • Aave V2 Tables
      • eth.aave_v2.loans
      • eth.aave_v2.collateral
    • EigenLayer Tables
      • eth.eigenlayer.eigenpod_balances
      • eth.eigenlayer.withdrawal_router_created
      • eth.eigenlayer.strategy_manager_withdrawal_completed
      • eth.eigenlayer.withdrawal_router_claimed
      • eth.eigenlayer.withdrawal_router_balances
      • eth.eigenlayer.strategy_manager_added_to_deposit_whitelist
      • eth.eigenlayer.strategy_manager_withdrawal_delay_blocks_set
      • eth.eigenlayer.strategy_manager_withdrawal_queued
      • eth.eigenlayer.eigenpods
      • eth.eigenlayer.strategy_manager_deposits
      • eth.eigenlayer.strategy_manager_strategy_whitelister_changed
      • eth.eigenlayer.strategy_manager_removed_from_deposit_whitelist
      • eth.eigenlayer.strategy_manager_share_withdrawal_queued
      • eth.eigenlayer.delegation_manager_operator_details_modified
      • eth.eigenlayer.delegation_manager_operator_metadata_uri_updated
      • eth.eigenlayer.delegation_manager_operator_registered
      • eth.eigenlayer.delegation_manager_operator_shares_decreased
      • eth.eigenlayer.delegation_manager_operator_shares_increased
      • eth.eigenlayer.delegation_manager_staker_delegated
      • eth.eigenlayer.delegation_manager_staker_force_undelegated
      • eth.eigenlayer.delegation_manager_staker_undelegated
      • eth.eigenlayer.delegation_manager_strategy_withdrawal_delay_blocks_set
      • eth.eigenlayer.delegation_manager_withdrawal_queued
      • eth.eigenlayer.delegation_manager_withdrawal_completed
      • eth.eigenlayer.delegation_manager_withdrawal_migrated
      • eth.eigenlayer.eigenpod_validators
• Specifications
  • Dataset & View YAML Specification
    • Firecache
  • Models YAML Specification
    • Model Type Specification
• Limitations
• Release Notes
• Samples and Examples
  • Example Ethereum (EVM) SQL Queries
    • Blocks
    • Gas & Fees
    • Transactions
    • NFTs
    • Tokens
    • Logs
    • ENS Domains
    • Wallet Balances
    • Blobs
  • Example Ethereum Beacon SQL Queries
    • Slots
    • Attestations
    • Voluntary Exits
    • Deposits
    • Attester Slashings
    • BLS To Execution Changes
    • Withdrawals
    • Validators
  • Example DEX Queries
    • Uniswap
    • Sushiswap
    • Cross-DEX
  • Example Bitcoin Queries
    • Blocks
    • Transaction Fees
    • Transactions
    • Transaction Inputs/Outputs
  • Example Cross-Chain Queries
  • Arrow Flight Samples
  • Kaggle Notebooks

🆘 Support

• Support

🔐 Security

• Security at Spice AI
• Report a vulnerability

⚖️ Legal

• Privacy Policy
• Website Terms of Use
• Terms of Service
• End User License Agreement