Dune
Dune
  • Видео 96
  • Просмотров 104 361
Dune Partner Spotlight Series EP1: Sei | What is Sei? | Sei Data on Dune
Introducing Dune Partner Spotlight, our brand-new video series where we take a closer look at some of the most exciting partners and projects in the blockchain space. In each video, we’ll dive into what makes these blockchains and protocols special, why Dune collaborates with them, and how you can use Dune to explore their ecosystems like a pro.
In our first episode, we’re shining a light on Sei, the first parallelized EVM chain. Discover what sets Sei apart, how it’s redefining decentralized finance, and how Dune’s tools allow you to explore its onchain data.
Tune in to learn more, and let us know in the comments which partner you'd like to see next!
Get started with Sei's data on Dune dune...
Просмотров: 63

Видео

Dune 101: Searching and Contributing to Spellbook (Curated Tables)
Просмотров 25321 день назад
Spellbook is where the hard work and magic happens - it's our public DBT data pipeline for creating tables like dex.trades Docs: github.com/duneanalytics/spellbook 00:00-1:59 dbt and lineage overview 1:59-4:25 walking through dex.trades example 4:25-5:40 searching and navigating model files 5:40-6:29: bugs/requests and keeping up with changes 6:29-15:31: contributing to spellbook (local setup a...
Dune 101: Welcome
Просмотров 1,1 тыс.21 день назад
Welcome to Dune! You'll be watching a playlist of videos covering different product surfaces on Dune, walking through how to understand and navigate it (with docs).
Dune 101: Decoding Contracts
Просмотров 19721 день назад
Dune lets you submit any contract on EVM and Solana chains to be decoded into easy to query tables. Each function/event gets its own table you can query. Docs: docs.dune.com/web-app/decoding-contracts 00:00-00:49 decoding overview 00:49-2:26 submitting a contract 2:26-2:50 checking decoding status 2:50-5:33 proxies and factories 5:33-6:30 querying decoded tables
Dune 101: Creating Visualizations (Charts)
Просмотров 17121 день назад
Once your queries are complete, you can create beautiful charts on result data (bar, line, area, table, counter, scatter, and more). Docs: docs.dune.com/web-app/visualizations/charts-graphs 00:00-00:55 intro 00:55-3:50 formatting values and axes 3:50-7:11 bar/combination charts and colors 7:11-7:50 descriptions and parameters
Dune 101: SQL API and Developer API
Просмотров 32421 день назад
Pulling data off of Dune is super simple, as you can choose any query you see and have it as an API endpoint. Docs: docs.dune.com/api-reference/overview/introduction 00:00-01:01: Every query is an API 01:00-3:28: Billing and Usage 3:28-3:42: Manage API Keys 3:42-4:32: Query, Execution, and Results APIs 4:32-5:31: Parameters and SDKs 5:31-5:55: Preset Endpoints 5:55-6:58: Uploading Data to Dune ...
Dune 101: Creating and Managing Dashboards
Просмотров 53721 день назад
Dashboards are the critical component of dune, which is comprised of visualizations that are attached to queries. Docs: docs.dune.com/web-app/dashboards 00:00-1:29: Navigate and run dashboards 1:29-2:40: Create and edit dashboards (visualizations markdown) 2:40-2:57: Schedule dashboard refreshes 2:57-3:49: Manging your dashboard 3:49-4:08: Dashboard Docs
Dune 101: Learning DuneSQL and Our Engines
Просмотров 46021 день назад
DuneSQL is our fork of Trino SQL that we run all queries on. Queries are run on three different clusters (engines): free, medium, and large engines. Watch the video to learn how to better your SQL skills and utilize our engines. Docs: docs.dune.com/query-engine/overview 00:00-00:26: Intro 00:26-1:10: Finding DuneSQL Functions 1:10-2:26: Learning the basics 2:26-3:11: Binary/hex functions 3:11-3...
Dune 101: Exploring Queries (Views and Matviews)
Просмотров 32421 день назад
Most of your time as a wizard will be spent writing your own queries and navigating other people's queries. Queries can be chained together like building blocks too. Let's talk about how to best do this. Docs: docs.dune.com/web-app/query-editor/query-window docs.dune.com/query-engine/query-a-query docs.dune.com/query-engine/materialized-views 00:00-00:52 Intro 00:52-1:22 Forking and Creating Qu...
Dune 101: Understanding Tables (Raw, Decoded, Curated/Spellbook, Views, Uploads)
Просмотров 39621 день назад
Dune has many different sources and data transformations. This video walks through how to identify different types of tables and get the most out of them. Docs: docs.dune.com/data-catalog/overview 00:00-1:02: Intro 1:02-1:47: Top tables to know 1:47-2:12: Table schema documentation 2:12-3:57: Explaining data lineage from RPCs 3:57-7:14: Identifying different tables by type (Raw, Decoded, Curate...
Dune 101: Navigation on the App
Просмотров 73521 день назад
Learn to navigate discovery, search, library, user/teams, and settings. Docs: docs.dune.com/web-app/overview 00:00-1:02: Nav Bar 1:02-1:50: Discovery 1:50-2:51: Library 2:51-4:43: Advanced Search 4:43-5:45: Teams/Users and Settings
Filtering Query Results vs. Executing with Params
Просмотров 4114 месяца назад
How to fetch data from Dune API while applying specific conditions Resources: - docs.dune.com/api-reference/executions/execution-object#query-filters-vs-execution-parameters
Optimize Dune API Data Retrieval with Pagination, Filtering and Sorting
Просмотров 1604 месяца назад
How to use Pagination, Filtering, Sorting and Sampling to retrieve data faster and more efficiently via Dune API 📚 *Resources* - Specific feature docs starting with Pagination: docs.dune.com/api-reference/executions/pagination - How to turn any query into an API endpoint: ruclips.net/video/o29ig849qMY/видео.html - Dune API: Core vs. Domain-Specific: docs.dune.com/api-reference/overview/introduc...
Build on Linea with Dune API
Просмотров 2724 месяца назад
Quick tutorial on how to build a Farcaster Frame with Dune API to check LXP balance *Takeaway: there are 2 Dune API groups* 1. Domain Specific APIs (no SQL needed) 2. Core APIs (turned to an API endpoint from a Dune SQL query) *Resources 📚* - Github Repo: github.com/agaperste/dune-linea-frame - Existing tutorial on building a Frame with Dune API: docs.dune.com/learning/how-tos/dune-frames - Rec...
Build with Domain-specific endpoint
Просмотров 904 месяца назад
What are Domain-specific Dune API endpoints & how to start building with them *Resources* - Dune API doc: docs.dune.com/api-reference/overview/introduction - Getting an API key: docs.dune.com/api-reference/overview/authentication
Turn Any Dune Query Into An API Endpoint
Просмотров 3694 месяца назад
Turn Any Dune Query Into An API Endpoint
Roadmap to Becoming a Top Crypto Data Analyst
Просмотров 3,8 тыс.5 месяцев назад
Roadmap to Becoming a Top Crypto Data Analyst
Build a Farcaster Frame using Dune API (Low Latency Queries)
Просмотров 6085 месяцев назад
Build a Farcaster Frame using Dune API (Low Latency Queries)
Find, Track, and Analyze Farcaster Trends (Users, Channels, Words)
Просмотров 1,5 тыс.6 месяцев назад
Find, Track, and Analyze Farcaster Trends (Users, Channels, Words)
Solana Data Analytics 101: An Intro to Tokens, Transfers, and Balances
Просмотров 2,6 тыс.8 месяцев назад
Solana Data Analytics 101: An Intro to Tokens, Transfers, and Balances
Beyond Multisigs: Smart Contract, Accounts, and Account Abstraction - DuneCon23
Просмотров 1148 месяцев назад
Beyond Multisigs: Smart Contract, Accounts, and Account Abstraction - DuneCon23
Building Your Crypto Data Pipeline - DuneCon23
Просмотров 6238 месяцев назад
Building Your Crypto Data Pipeline - DuneCon23
Data Uploads Workshop - DuneCon23
Просмотров 708 месяцев назад
Data Uploads Workshop - DuneCon23
Leveraging the Dune API - DuneCon 2023
Просмотров 1578 месяцев назад
Leveraging the Dune API - DuneCon 2023
Introduction to Dune AI - DuneCon23
Просмотров 1918 месяцев назад
Introduction to Dune AI - DuneCon23
Panel: Data Driven Token Distribution - DuneCon 2023
Просмотров 2919 месяцев назад
Panel: Data Driven Token Distribution - DuneCon 2023
Do airdrops work? - Richard Chen, 1confirmation - DuneCon 2023
Просмотров 1,1 тыс.9 месяцев назад
Do airdrops work? - Richard Chen, 1confirmation - DuneCon 2023
Blockchain Analytics As Public Good - Karim AbdelMawla, 21co - DuneCon 2023
Просмотров 1269 месяцев назад
Blockchain Analytics As Public Good - Karim AbdelMawla, 21co - DuneCon 2023
Transparent Business Strategy from the Blockchain - Olga Fetisova, CoW Protocol - DuneCon 2023
Просмотров 1809 месяцев назад
Transparent Business Strategy from the Blockchain - Olga Fetisova, CoW Protocol - DuneCon 2023
Data in the Superchain Future - Chuxin Huang, OP Labs - DuneCon 2023
Просмотров 2479 месяцев назад
Data in the Superchain Future - Chuxin Huang, OP Labs - DuneCon 2023

Комментарии

  • @Maurice_DeFi
    @Maurice_DeFi 7 часов назад

    Nice content about Sei 🔴💨

  • @Hazan001
    @Hazan001 6 дней назад

    this was more than five minutes tho

  • @hidu8123
    @hidu8123 12 дней назад

    404 Page Not Found or Private pls fix :<<

  • @Dante112_
    @Dante112_ 18 дней назад

    Extremely helpful

  • @yanashvch
    @yanashvch 22 дня назад

    Too fast for beginners…more like a quick run through

  • @DRICTON
    @DRICTON 27 дней назад

    Dune thank you 👏🔴❤️, I know you'd see my reply someday

  • @G4g7743
    @G4g7743 Месяц назад

    I cant thank you enough

  • @andrewashara3017
    @andrewashara3017 Месяц назад

    Just what I need now in my career, I'm trying to get into the web3 space as a Data Analyst. This is really helpful.

  • @defi_idn
    @defi_idn Месяц назад

    Can we get the slide?

  • @neonnuggetchoco
    @neonnuggetchoco Месяц назад

    nice

  • @NWIN-zg3hq
    @NWIN-zg3hq Месяц назад

    No, thanks. I'm gonna use FREE @solana/web3 and Raydium SDK. As all Keynesian frauds know the key to making money is TO NOT SPEND MONEY. Look up 'Money as Debt' documentary on RUclips for more info then you will know to avoid global debt banking system.

  • @phonemark7482
    @phonemark7482 2 месяца назад

    When we calculate the total_usd amount from raw_token amounts by multiplying with p.price, are we using the current USD price of the token or the price of the token at the time the transaction occurred?

  • @Lord_Lamba1
    @Lord_Lamba1 2 месяца назад

    Good day How can I get in touch with you please 🙏

  • @markkelly6755
    @markkelly6755 2 месяца назад

    wish i found this a year ago

  • @marioarabaolaza5852
    @marioarabaolaza5852 3 месяца назад

    Hi, I watched the video and read all the messages. First of all really thanks for the effort and the content. Second I think the feedback from the other comments it's correct a bit fast for a tutorial so sometime even if I can pause the video I have to guess what has been done. But again this resource is awesome! So really thanks

  • @richrich8487
    @richrich8487 3 месяца назад

    Great video for those who have doctorate degree in analysis techniques. How about breaking down the why, benefits, and possible positive outcomes for us dummies. From this video, I have no idea why I am doing this. 101?

  • @zacharydenton2664
    @zacharydenton2664 3 месяца назад

    Dude this is exactly what I was looking for! Thank you!

  • @xrp683
    @xrp683 3 месяца назад

    Scam

  • @sauce1478
    @sauce1478 3 месяца назад

    this is awesome

  • @williamsogoke9412
    @williamsogoke9412 4 месяца назад

    Thank you Mr. Andrew. Its an honour

  • @0xTrish
    @0xTrish 4 месяца назад

    Where have you been my whole life? Thank you

  • @bungdroid7777
    @bungdroid7777 4 месяца назад

    sir url invalid

  • @S.Dadudida
    @S.Dadudida 4 месяца назад

    Ich komme wieder 😉

  • @wxIyz
    @wxIyz 4 месяца назад

    Thank you

  • @WebAIZ
    @WebAIZ 4 месяца назад

    Thank you for sharing, I wish you a happy day Thank you

  • @avuuuu
    @avuuuu 4 месяца назад

    damn loved this! thanks andrew :)

  • @giovannilinger556
    @giovannilinger556 5 месяцев назад

    What I needed 🎉

  • @user-vr8wt9rp2p
    @user-vr8wt9rp2p 5 месяцев назад

    This is one of the most impressive and promising crypto projects I've ever seen

  • @ingyay
    @ingyay 5 месяцев назад

    Awesome. Thank-you. Great point, this is not a checklist but a roadmap to keep coming back as I develop my knowledge and skills.

  • @markgreen2170
    @markgreen2170 5 месяцев назад

    NIce!

  • @cactusliu5069
    @cactusliu5069 5 месяцев назад

    amazing!!!! Thank you!!

  • @tatratrading
    @tatratrading 5 месяцев назад

    Thanks for your work!

  • @TokenDesign
    @TokenDesign 5 месяцев назад

    Always amazing - thanks Andrew!

  • @dinocles
    @dinocles 5 месяцев назад

    🙏 thank you very much

  • @wxIyz
    @wxIyz 5 месяцев назад

    thanks

  • @harpalsinhjadeja2568
    @harpalsinhjadeja2568 5 месяцев назад

    Thank you for this video extremely useful!

  • @alfamingo2520
    @alfamingo2520 5 месяцев назад

    Did you post the solution to the bonus query?

  • @alfamingo2520
    @alfamingo2520 6 месяцев назад

    Killer Presentation! Thank you Andrew

  • @stanleywangg
    @stanleywangg 6 месяцев назад

    Love this! I'm a data analyst aspiring to get into the industry. Starting with 0 knowledge about Crypto but it's reassuring to know the technical skills is transferable. Looking forward to more content like this!

    • @Carnabwth
      @Carnabwth Месяц назад

      Can you do queries on Dune?

  • @mitko_wtf
    @mitko_wtf 7 месяцев назад

    That's wild! In web2 access to social listening tools can cost thousands per month. But we get all that for free!! Building lists for BD/partnerships will also be 100x easier. Love to see it, thank you the Dune team!

  • @TokenDesign
    @TokenDesign 7 месяцев назад

    UPDATE Feb 2024: The exercise query is too expensive to run on the current Dune free-tier query engine. Removing the joins on the 'prices.usd' table (and associated variables is enough to get it to run on free tier, and quite quickly for the time period shown (22-02-19 to 2022-12-19 approx.)

  • @peerthroughportfolio2479
    @peerthroughportfolio2479 7 месяцев назад

    Where'd the dashboard go :(

  • @simonbachmann2120
    @simonbachmann2120 7 месяцев назад

    How do you deal with rebase token?

  • @rammahatra3274
    @rammahatra3274 8 месяцев назад

    Wao

  • @TokenDesign
    @TokenDesign 8 месяцев назад

    EXERCISE UPDATE Jan 2024 - "Query exceeds cluster capacity" error The full CTE-based query developed in the exercise no longer runs on the capacity offered on Dune's free tier (have not tested issue on paid tier yet) - there are 2 solutions: 1) Materialize the data for the 'base' table CTE, using Dune's new "materialize" feature (search Dune docs for more info how to do this, can't paste external links here on YT!). This dumps data locally so it can be referenced without query folding. The table for the entire 'base' query will exceed the storage capacity you get on the 'free' tier, but it should go through if you're not at your limit already. 2) Use the 'dex.trades' spells table alternative shown at 12:02 instead. this appears to be less expensive to run and gets through fine.

  • @owner1927
    @owner1927 8 месяцев назад

    Jackie moves through the instructions extremely quickly without explanation as to what the different tables show, what they mean, or what her thought process is in why she is choosing specific tables over others.

  • @Naghceuz1
    @Naghceuz1 8 месяцев назад

    when will it release ?

  • @Journeybyhenry
    @Journeybyhenry 8 месяцев назад

    Quality Content

  • @reconsulting90
    @reconsulting90 8 месяцев назад

    It’s amazing work dune. I am practicing sql recently and I must say it’s helping me ❤️

  • @greysenpai6749
    @greysenpai6749 8 месяцев назад

    Great content