Spice.ai Documentation
Signup/LoginBlogTwitterDiscordTelegram
Signup/LoginBlogTwitterDiscordTelegram
  • 🌟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
Powered by GitBook