wollok-ethToken Test Query
Updated 2024-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- SELECT *
-- FROM ethereum.price.dim_asset_metadata -- ethereum.core.dim_contracts
-- WHERE token_address = lower('0x64d91f12ece7362f91a6f8e7940cd55f05060b92') -- $ASH (Burn)
-- Result: asset_id for ASH is 11566
SELECT hour, open, low, high, close
FROM ethereum.price.fact_prices_ohlc_hourly
WHERE asset_id = 11566
-- AND inserted_timestamp::DATE >= CURRENT_DATE - 30
ORDER BY hour DESC
QueryRunArchived: QueryRun has been archived