-
Notifications
You must be signed in to change notification settings - Fork 0
/
Kusama-Addresses-Balances-Limited.sql
163 lines (159 loc) · 1.01 KB
/
Kusama-Addresses-Balances-Limited.sql
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
--year
-- month
-- day
-- unique_addresses
-- unique_assets
-- total_free
-- total_free_raw
SELECT * FROM kusama.balances
h ORDER BY h.ingested_at DESC LIMIT 100
2020
3
9
5720
1
8627215.105717158
2020
3
10
5757
1
8627616.960875742
2020
3
11
5797
1
8628826.469147403
2020
3
12
5777
1
8629342.279705722
2020
3
13
5828
1
8629346.76941681
2020
3
14
5847
1
8631098.037626965
2020
3
15
5870
1
8631526.012082068
2020
3
16
5944
1
8636170.268389413
2020
3
17
5940
1
8637598.890909538
2020
3
18
5941
1
8639351.85379748
2020
3
19
5944
1
8640099.93004671
2020
3
20
5978
1
8641121.356949044
2020
3
21
5983
1
8641768.787848383
2020
3
22
5992
1
8645089.612184964
2020
3
23
6031
1
8649837.48336281
2020
3
24
6047
1
8651585.68022603
2020
3
25
6091
1
8653409.411704358
2020
3
26
6121
1
8654736.656855142
2020
3
27
6144
1
8655715.616669388
2020
3
28
6163
1
8660611.572332297
2020
3
29
6145
1
8662115.81211105
2020
3
30
6155
1
8663620.172349175
2020
3
31
6201
1
8664809.201953953
2020
4
1
6225
1
8670465.821369626
2020
4
2
6247
1
8677713.309752045