ethereum_casino_player_wallets
12 columnsDeposits and withdrawals per wallet and casino on Ethereum, one row per wallet, casino and month.
ethereum/casino_player_wallets<YYYY-MM>.parquetone file per calendar month (ZSTD)Monthly deposits and withdrawals of each wallet at 91 crypto casino brands on Ethereum, Tron and Solana, one row per wallet, casino and month.
Crypto casino player wallets are hard to list from raw transfers, because most casinos give each player a deposit address that forwards the money to a hot wallet. We find those deposit addresses each month, tie every deposit and withdrawal to a casino brand, and roll the transfers up to the wallet that paid or was paid. One row is one wallet at one casino in one calendar month, with the number and USD value of its deposits and withdrawals, the days it was active and how many casinos it paid into. It covers 91 brands on Ethereum, Tron and Solana, from Bitquery's own gambling hot-wallet labels.
Most buyers start by ranking wallets: filter casino to a brand, keep deposits above 0 and sort by deposit_usd. A wallet is not always one player. Exchange and payment-service wallets pay casino deposit addresses for many customers, and they show up with thousands of deposits or a high casinos_used. Join the Address Labels dataset on wallet to remove them, or cap deposits and casinos_used.
Deposits and withdrawals per wallet and casino on Ethereum, one row per wallet, casino and month.
ethereum/casino_player_wallets<YYYY-MM>.parquetone file per calendar month (ZSTD)Deposits and withdrawals per wallet and casino on Tron, one row per wallet, casino and month.
tron/casino_player_wallets<YYYY-MM>.parquetone file per calendar month (ZSTD)Deposits and withdrawals per wallet and casino on Solana, one row per wallet, casino and month.
solana/casino_player_wallets<YYYY-MM>.parquetone file per calendar month (ZSTD)ethereum_casino_player_wallets12 columnsDeposits and withdrawals per wallet and casino on Ethereum, one row per wallet, casino and month.tron_casino_player_wallets12 columnsDeposits and withdrawals per wallet and casino on Tron, one row per wallet, casino and month.solana_casino_player_wallets12 columnsDeposits and withdrawals per wallet and casino on Solana, one row per wallet, casino and month.Send this dataset’s full schema to an assistant and ask it anything. It reads the plain-text brief first, so the answer comes from the real column list rather than a guess.
Opens a new chat with the question filled in. Nothing about you is sent to Bitquery, and the assistant sees only the public brief.
Parquet files in a Requester Pays S3 bucket or a Cloudflare R2 bucket, chosen at checkout. On S3 you download with your own AWS account and AWS bills the transfer; on R2 you download with a read-only API key and pay no egress. Layout:
# ethereum_casino_player_wallets: one file per calendar month (ZSTD) ethereum/casino_player_wallets<YYYY-MM>.parquet # tron_casino_player_wallets: one file per calendar month (ZSTD) tron/casino_player_wallets<YYYY-MM>.parquet # solana_casino_player_wallets: one file per calendar month (ZSTD) solana/casino_player_wallets<YYYY-MM>.parquet
Every window includes all 3 tables and 36 columns. Only the time range changes.
Three Parquet tables, one per chain, with the same 12 columns: chain, month, wallet, casino, deposits, deposit USD, withdrawals, withdrawal USD, active days, first and last time, and casinos used. One row is one wallet at one casino in one calendar month. It is built from the transfers in our Crypto Casino Deposits and Withdrawals dataset.
We have not run a full month yet, so there is no month total to quote. Test runs give the scale: Stake on Solana had 43,230 wallet rows on 10 November 2026 alone, Rollbit on Tron 4,850 the same day, and Shuffle on Ethereum 4,120 over 10 to 12 November. Exact row counts and file sizes arrive with the delivery manifest.
91 brands owned by 89 companies: 73 on Ethereum, 59 on Tron and 75 on Solana, including Stake, Rollbit, Shuffle, Roobet, Rainbet, BC.Game and Gamdom. The list comes from 402 hot wallets in Bitquery's gambling labels, with payment processors such as AlphaPo removed. BSC, Polygon and Base are not in this dataset yet.
Filter casino to the brand and deposits above 0, then sort by deposit_usd. Add casinos_used to see whether the wallet also pays rivals, and withdrawal_usd to see how much came back. Sum across months for a longer ranking.
No. The wallet is whoever sent the deposit or received the withdrawal. When a player deposits straight from an exchange, the wallet is the exchange's hot wallet, and it carries many players' deposits. In a one-day test run on Solana one wallet paid into 40 casinos. Rows with deposits of 0 are wallets that only received money from a casino, which includes moves to exchanges.
A wallet counts as a casino's deposit address in a month when it forwards 80 to 125 percent of what it receives to that brand's hot wallets and has at most 50 senders. Every transfer into it is then a deposit by the sender. Payments straight to a hot wallet count as deposits too. Tokens are the native coin, USDT and USDC, matched by contract or mint, and transfers under $1 are left out.
Each table's query ran on a short window before listing. For Shuffle on Ethereum from 10 to 12 November 2026 the dataset has 3,894 withdrawals worth $12,001,881.79. A separate count of the hot wallet's own transfers gave 3,911 worth $12,002,769.68; the 17 extra are moves into Shuffle's own deposit addresses, which we leave out. Tron and Solana were run for one day. No full month has been run yet.
Deposit addresses are found per month, so a part-month finds fewer of them and its deposit counts are a lower bound. That applies to the first and last month of a purchase and to the sample files. casinos_used counts one chain only, and the same person can use different wallets on different chains. A transfer from one casino's hot wallet into another casino's deposit address counts as a deposit by that hot wallet.
With DuckDB: SELECT wallet, sum(deposit_usd) FROM read_parquet('tron/casino_player_wallets/*.parquet') WHERE casino = 'stake' GROUP BY 1 ORDER BY 2 DESC LIMIT 100. pandas, Polars, Spark and ClickHouse read the same files.
A purchase covers the window up to yesterday, UTC, as flat Parquet files: one prefix per chain and one file per calendar month, with a JSON manifest listing each file and its sha256. We prepare the files within 7 business days of purchase and email you the location. You choose at checkout between a Requester Pays S3 bucket and a Cloudflare R2 bucket with a read-only API key. Files stay available for 7 days from delivery.
Yes. Each table links to a public sample file. Each has 100 real rows. Tron and Solana are from 10 November 2026 and cover 17 and 20 brands. Ethereum is from 10 to 12 November 2026 and covers Shuffle and Winna only. The samples cover days, not a month, so they find fewer deposit addresses than a full month does.
192.6 million address labels on 38 chains, from exchange deposit and hot wallets to casinos, mixers, darknet markets, scams and sanctioned addresses.
Every bonding-curve trade, token creation, migration and pool on Pump.fun, plus per-token OHLCV, decoded and USD-priced.
Every TRX, TRC-10 and TRC-20 transfer on TRON since June 2018, one row per transfer, valued in USD where a price exists.
Tell us the chain, tables and date range.