luisqaCommunity Pool Spends Table copy
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
›
⌄
-- forked from Playwo / Community Pool Spends Table @ https://flipsidecrypto.xyz/Playwo/q/f8jji60wG9li/community-pool-spends-table
WITH gov_spends AS (
SELECT
$1 AS spent_at,
$2 AS proposal_id,
$3 AS amount,
$4 AS currency
FROM (VALUES
(TO_DATE('2021-10-04'), 44, 4000, 'uosmo'),
(TO_DATE('2021-10-25'), 53, 100000, 'uosmo'),
(TO_DATE('2021-10-31'), 57, 60000, 'uosmo'),
(TO_DATE('2021-12-17'), 99, 135000, 'uosmo'),
(TO_DATE('2021-12-23'), 107, 750000, 'uosmo'),
(TO_DATE('2021-12-25'), 110, 20000, 'uosmo'),
(TO_DATE('2022-02-10'), 143, 109375, 'uosmo'),
(TO_DATE('2022-02-18'), 147, 11962, 'uosmo'),
(TO_DATE('2022-03-20'), 176, 6600, 'uosmo'),
(TO_DATE('2022-03-26'), 182, 140000, 'uosmo'),
(TO_DATE('2022-03-26'), 182, 1399507.492800, 'ibc/1DCC8A6CB5689018431323953344A9F6CC4D0BFB261E88C9F7777372C10CD076'),
(TO_DATE('2022-04-09'), 186, 1500000, 'uosmo'),
(TO_DATE('2022-06-01'), 245, 523552, 'uosmo'),
(TO_DATE('2022-06-03'), 246, 7500000, 'uosmo'),
(TO_DATE('2022-06-06'), 251, 650000, 'uosmo'),
(TO_DATE('2022-09-03'), 324, 412170, 'uosmo'),
(TO_DATE('2022-09-23'), 330, 275424, 'uosmo'),
(TO_DATE('2022-09-25'), 332, 741000, 'uosmo'),
(TO_DATE('2022-10-22'), 347, 13750000, 'ibc/E97634A40119F1898989C2A23224ED83FDD0A57EA46B3A094E287288D1672B44'),
(TO_DATE('2022-12-11'), 375, 5468, 'uion'),
(TO_DATE('2022-12-15'), 378, 300563, 'uosmo'),
(TO_DATE('2023-02-02'), 415, 310000, 'uosmo'),
(TO_DATE('2023-02-07'), 420, 52000, 'uosmo'),
(TO_DATE('2023-03-20'), 461, 592820, 'uosmo'),
(TO_DATE('2023-05-13'), 500, 80000, 'uosmo')
)
)
Run a query to Download Data