SELECT *
FROM crypto.fact_coin_price_history
WHERE quoteassetname like '%Bitcoin%' limit 10;
Query Title |
Select on crypto.fact_coin_price_history
|
Description |
None
|
Last Execution Results
Nov 16, 19:29 (UTC)
Download
# |
symbol |
baseAsset |
quoteAsset |
baseAssetName |
quoteAssetName |
open |
high |
low |
close |
volume |
dailyQuoteVolume |
parentMarket |
parentMarketName |
circulatingSupply |
ts |
datestr |
1 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
22737.0 |
0.13590 |
BTC |
BTC |
35960643044 |
2024-09-08 02:02:38 |
2024-09-08 |
2 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
44702.0 |
0.27360 |
BTC |
BTC |
35960643044 |
2024-09-08 19:24:32 |
2024-09-08 |
3 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
44762.0 |
0.27400 |
BTC |
BTC |
35960643044 |
2024-09-08 20:00:09 |
2024-09-08 |
4 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
44762.0 |
0.27400 |
BTC |
BTC |
35960643044 |
2024-09-08 21:00:08 |
2024-09-08 |
5 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
44762.0 |
0.27400 |
BTC |
BTC |
35960643044 |
2024-09-08 22:00:09 |
2024-09-08 |
6 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
44762.0 |
0.27400 |
BTC |
BTC |
35960643044 |
2024-09-08 23:00:11 |
2024-09-08 |
7 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
34217.0 |
0.21100 |
BTC |
BTC |
35960643044 |
2024-09-09 00:01:48 |
2024-09-09 |
8 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
36837.0 |
0.22740 |
BTC |
BTC |
35960643044 |
2024-09-09 01:00:09 |
2024-09-09 |
9 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
38163.0 |
0.23610 |
BTC |
BTC |
35960643044 |
2024-09-09 02:00:08 |
2024-09-09 |
10 | ADABTC |
ADA |
BTC |
Cardano |
Bitcoin |
0.0000 |
0.0000 |
0.0000 |
0.0000 |
36166.0 |
0.22400 |
BTC |
BTC |
35960643044 |
2024-09-09 03:00:10 |
2024-09-09 |