binhachonCopy of 77. [Hard] Apollo Inflow: User who deposited from 14-16
Updated 2021-10-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- SELECT * FROM (SELECT DATE_TRUNC('Month', BLOCK_TIMESTAMP) AS BLOCKTIME, EVENT_ATTRIBUTES:"3_contract_address"::string as LP_ADDRESS,
-- SUM((EVENT_ATTRIBUTES:"return_amount"::float + EVENT_ATTRIBUTES:"ust returned")/1e6) as USD_AMOUNT FROM terra.msg_events
-- WHERE EVENT_TYPE = 'from_contract'
-- AND EVENT_ATTRIBUTES:"0_action" = 'zap_out_of_strategy'
-- AND EVENT_ATTRIBUTES: "0_contract_address" = 'terra1g7jjjkt5uvkjeyhp8ecdz4e4hvtn83sud3tmh2'
-- AND TX_ID = '5F5FA3440DD90307BF66DA8BC799AEFB86696A0420CB0486EA6C2839FA38102D'
-- GROUP BY BLOCKTIME, LP_ADDRESS)
SELECT * FROM
(SELECT DATE_TRUNC('Month', BLOCK_TIMESTAMP) AS BLOCKTIME, EVENT_ATTRIBUTES:"lp_token"::string as LP_ADDRESS,
SUM(EVENT_ATTRIBUTES:"4_amount"::float/1e6) as LP_AMOUNT, SUM(EVENT_ATTRIBUTES:"0_amount"::float/1e6) as USD_AMOUNT,
SUM(EVENT_ATTRIBUTES:"4_amount"::float/1e6)/SUM(EVENT_ATTRIBUTES:"0_amount"::float/1e6) as LP_PRICE FROM terra.msg_events
WHERE EVENT_TYPE = 'from_contract'
AND TX_ID = '21DE2F3A760CDB85393F2DC47B66614CC68477A2B0390265284AB540AFE8DAD9'
AND EVENT_ATTRIBUTES:"0_action" = 'zap_into_strategy'
AND EVENT_ATTRIBUTES: "0_contract_address" = 'terra1g7jjjkt5uvkjeyhp8ecdz4e4hvtn83sud3tmh2'
GROUP BY BLOCKTIME, LP_ADDRESS)
Run a query to Download Data