Sleepyinscriptions by type
Updated 2023-09-01
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with ordinals as (
select
block_timestamp,
tx_id,
fee,
outputs[0]:scriptPubKey:address minter,
hex,
size,
virtual_size,
regexp_instr(hex, '0063036f72640101') starting_point,
substr(hex, starting_point + 16, 2) bytes_pushed,
ethereum.public.udf_hex_to_int(bytes_pushed) content_length,
substr(hex, starting_point + 18, content_length * 2) content_hex,
try_hex_decode_string(content_hex) content,
split_part(content, '/', 1) content_type,
split_part(content, '/', 2) content_subtype
from bitcoin.core.fact_transactions
where block_number > 767429
and block_timestamp::date < current_date
and hex like '%0063036f726401%'
),
-- dates as(
-- select date_day day
-- from ethereum.core.dim_dates
-- where date_day between '2022-12-14' and current_date
-- ),
-- types as(
-- select
-- column1 type
-- from
-- (values
-- ('image'),
-- ('text'),
-- ('application'),
-- ('audio'),
-- ('video'),
Run a query to Download Data