Nige7777Copy of OfferAceptoors
Updated 2021-12-04
99
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
›
⌄
select origin_address, count(distinct tx_id || event_id) as count , event_name from ethereum.udm_events where 1=1
and contract_address = '0x999e88075692bcee3dbc07e7e64cd32f39a1d3ab'
group by event_name, origin_address
order by count desc
-- select * from ethereum.udm_events where tx_id ='0xb9308db6fc0dff748ff23e30dfdddb8071283a36a8ad896bd0e87e95b41cccb1'
-- and block_timestamp > CURRENT_DATE() - 5
--select * from ethereum.transactions where tx_id = '0x679a570f3642ef4ad96f7690c467d99dd8f2fed602741e325c18e201c5fbb6e2'
--select * from ethereum.nft_events e where contract_address = lower('0x999e88075692bCeE3dBC07e7E64cD32f39A1D3ab')
--select * from ethereum.nft_events where tx_id = '0x5232da11150432d6ba317583e81aa934c6edf6b522c12b4a9a4526b453eff796'
--'0xd19626d02acb60569e51ad79baf3bcd5b469284a3961eb3a2eec362246958a5c'--'0xcebce48c0be316c2002d297c0112f37d3c008ab0d54fa21dbe53dc5dd5372cc5'
--select * from ethereum.udm_events where tx_id = '0x679a570f3642ef4ad96f7690c467d99dd8f2fed602741e325c18e201c5fbb6e2' -- offer accepted with weth
-- select * from ethereum.udm_events where tx_id in ( '0xa26a0f25c0f717f52747f1ddd668e881ee03d6244e3653e4aad2ef291a71d202','0xcebce48c0be316c2002d297c0112f37d3c008ab0d54fa21dbe53dc5dd5372cc5')
-- order by block_id
-- 0x7be8076f4ea4a4ad08075c2508e481d6c946d12b
-- -- get the WETH tx's to OS wallet
-- --WITH CTE_Get_Weth_sales AS (
-- SELECT
-- UE.TX_ID,
-- EE.Event_inputs,
-- NE.contract_address,
-- NE.Token_id,
-- NE.Event_from AS SellerAddress,
-- NE.BLOCK_TIMESTAMP,
-- NE.Project_Name,
Run a query to Download Data